mysql Σφάλμα [1054] : EXECUTE
URI: index.php?option=com_content&task=section&id=19&Itemid=0
Message: Unknown column 'a.created' in 'order clause'
SELECT a.*, COUNT( b.id ) AS numitems FROM sth_categories a
LEFT JOIN sth_content b ON b.catid = a.id
AND a.published = '1' AND b.state = '1'
AND ( b.publish_up = '1979-12-19 00:00:00' OR b.publish_up <= '2012-02-06 03:40:06' )
AND ( b.publish_down = '2060-01-01 00:00:00' OR b.publish_down >= '2012-02-06 03:40:06' )
AND ((a.language IS NULL) OR (a.language LIKE '%greek%'))
AND ((b.language IS NULL) OR (b.language LIKE '%greek%'))
AND a.access IN (29) AND b.access IN (29)
WHERE a.section = '19'
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.created DESC