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 (14,14, 15, 16, 17, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46) 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 (14,14, 15, 16, 17, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46) GROUP BY p.classified_id ORDER BY IF(customer_id = 0,0,1) DESC, sort_title ASC, price ASC