SELECT c.note as Komentář, c.page, c.sourceID, c.eventID, p.personID, p.lastname, p.firstname, p.gedcom FROM tng_citations AS c LEFT JOIN tng_people AS p ON (c.persfamID=p.personID AND c.gedcom=p.gedcom) WHERE c.sourceID='S75' ORDER BY c.sourceID, CAST(SUBSTRING(c.page, 5) AS UNSIGNED)
Ukázka výstupu:
Pokud při zápisu citace nevyužíváte pole Komentář, ale horní pole pro zápis textu, bude fungovat tato podoba SQL:
SELECT c.description, c.page, c.sourceID, c.eventID, p.personID, p.lastname, p.firstname, p.gedcom FROM tng_citations AS c LEFT JOIN tng_people AS p ON (c.persfamID=p.personID AND c.gedcom=p.gedcom) WHERE c.sourceID='S75' ORDER BY c.sourceID, CAST(SUBSTRING(c.page, 5) AS UNSIGNED)
Ať se dílo daří!