!!Sorry, an error on the page occured. Please contact us or try again later. SELECT * FROM (SELECT AppearDate, trailer_url, PreviewXML_PHP, contentgroup.Id as id, AppearDate as date, Title as title, Directory as path, (select category from category_contentgroup WHERE category_contentgroup.contentgroup = contentgroup.Id AND category NOT IN (26) limit 1 ) category FROM contentgroup JOIN plg_tour_contentgroup ON (contentgroup.Id = plg_tour_contentgroup.contentgroup AND TourId = 1 ) WHERE AppearDate < now() AND trailer_url <> '' ) a WHERE 1=1 AND category NOT IN (26) ORDER BY contentgroup.Id Error: 1054 Unknown column 'contentgroup.Id' in 'order clause' Time: 2015-02-28, 09:49:54 Url: