You are currently not logged in to the members area.
07.11.2011
It's been relatively quiet here at The Caravan Community, stay tuned for some major updates in the c
Classifieds
Unknown column 'p.classified_id' in 'on clause'
SELECT p.classified_id,p.title as sort_title FROM classifieds p, classifieds_to_categories, categories LEFT JOIN classified_to_attributes pta ON (p.classified_id = pta.classified_id) WHERE p.classified_id = classifieds_to_categories.classified_id AND classifieds_to_categories.category_id = categories.category_id AND p.deleted = 'N' AND p.active = 'Y' AND categories.active = 'Y' AND categories.deleted = 'N' AND p.awaiting_authorisation = 'N' AND classifieds_to_categories.category_id IN (41,41) GROUP BY p.classified_id ORDER BY IF(customer_id = 0,0,1) DESC, sort_title ASC, price ASC
SELECT p.classified_id,p.title as sort_title FROM classifieds p, classifieds_to_categories, categories LEFT JOIN classified_to_attributes pta ON (p.classified_id = pta.classified_id) WHERE p.classified_id = classifieds_to_categories.classified_id AND classifieds_to_categories.category_id = categories.category_id AND p.deleted = 'N' AND p.active = 'Y' AND categories.active = 'Y' AND categories.deleted = 'N' AND p.awaiting_authorisation = 'N' AND classifieds_to_categories.category_id IN (41,41) GROUP BY p.classified_id ORDER BY IF(customer_id = 0,0,1) DESC, sort_title ASC, price ASC