Error #1066 : Not unique table/alias: 'sec1584'
query=SELECT doc.name, doc.ID, sdurl.data AS url, sdtitle.data AS title FROM seriesEntry doc
LEFT JOIN seriesField sfurl
ON sfurl.ID = '3'
AND sfurl.seriesID = doc.seriesID
LEFT JOIN seriesData sdurl
ON sdurl.seriesFieldID = sfurl.ID
AND sdurl.seriesEntryID = doc.ID
LEFT JOIN seriesField sftitle
ON sftitle.ID = '13'
AND sftitle.seriesID = doc.seriesID
LEFT JOIN seriesData sdtitle
ON sdtitle.seriesFieldID = sftitle.ID
AND sdtitle.seriesEntryID = doc.ID
LEFT JOIN seriesField sfstartdate
ON sfstartdate.ID = '56'
AND sfstartdate.seriesID = doc.seriesID
LEFT JOIN seriesData sdstartdate
ON sdstartdate.seriesFieldID = sfstartdate.ID
AND sdstartdate.seriesEntryID = doc.ID
LEFT JOIN seriesField sfenddate
ON sfenddate.ID = '57'
AND sfenddate.seriesID = doc.seriesID
LEFT JOIN seriesData sdenddate
ON sdenddate.seriesFieldID = sfenddate.ID
AND sdenddate.seriesEntryID = doc.ID
INNER JOIN seriesEntryCategory sec1584
ON sec1584.seriesCategoryId = '5'
AND sec1584.seriesEntryID = doc.ID
AND sec1584.seriesEntryCategoryID = '1584' INNER JOIN seriesEntryCategory sec1584
ON sec1584.seriesCategoryId = '5'
AND sec1584.seriesEntryID = doc.ID
AND sec1584.seriesEntryCategoryID = '1584' WHERE doc.seriesID='5' AND active='1' AND NOW() BETWEEN CAST(sdstartdate.data AS DATE) AND CAST(sdenddate.data AS DATE)