ERROR ONLINE AUCTIONS :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( sale_status NOT IN ( 6 ) OR (sale_status IN ( 6 ) AND display_removed =1)' at line 3
SELECT COUNT(id) FROM `auction_items`
WHERE auction_id =
AND ( sale_status NOT IN ( 6 ) OR (sale_status IN ( 6 ) AND display_removed =1) )
ERROR ONLINE AUCTIONS :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (
auction_items.sale_status NOT IN ( 6 ) OR
(
auction_items.sa' at line 7
SELECT auction_items. * , auction_cat_priority.sorder, auction_cat_priority.sorder IS NULL as isnull
FROM `auction_items`
JOIN `online_categories` ON ( auction_items.category_id=online_categories.id )
LEFT JOIN `auction_cat_priority` ON (auction_items.category_id=auction_cat_priority.category_id AND auction_items.auction_id=auction_cat_priority.auction_id)
WHERE auction_items.auction_id =
AND (
auction_items.sale_status NOT IN ( 6 ) OR
(
auction_items.sale_status IN ( 6 ) AND auction_items.display_removed =1
)
)
ORDER BY isnull ASC, auction_cat_priority.sorder ASC, online_categories.name ASC, auction_items.sort_order ASC LIMIT 0, 50
No Further details Available