Bug report
Bug: results containing anomalous citations
e.g.
Place: Pylus
Char: Abas (1)
Cite: Apollodorus 1.9.9
Problem: Abas doesn't actually show up in 1.9.9
Also, in tracking this down I notice that when I look at the view (in phpMyAdmin) I get data that's cut off. Are the fields too short? How? Why?
Here's the view:
CREATE VIEW `view_characters_places` AS select
`view_events_characters`.`character_name` AS `character_name`,
`view_events_characters`.`character_id` AS `character_id`,
group_concat(distinct `view_events_places`.`place_name` order by `view_events_places`.`place_name` ASC separator ', ') AS `place_name`,
group_concat(distinct cast(`view_events_places`.`place_id` as char(20) charset utf8) order by `view_events_places`.`place_name` ASC separator ', ') AS `place_id`,
group_concat(distinct cast(`Places`.`latitude` as char(20) charset utf8) order by `view_events_places`.`place_name` ASC separator ', ') AS `latitude`,
group_concat(distinct cast(`Places`.`longitude` as char(20) charset utf8) order by `view_events_places`.`place_name` ASC separator ', ') AS `longitude`,
group_concat(distinct `view_events_places`.`citation` order by `view_events_places`.`place_name` ASC separator ', ') AS `citation`
from (
(`view_events_characters` join `view_events_places`) join `Places`
)
where (
(`view_events_places`.`event_id` = `view_events_characters`.`event_id`)
and (`Places`.`place_id` = `view_events_places`.`place_id`)
)
group by `view_events_characters`.`character_name` order by `view_events_characters`.`character_name`;