*See delivery times for details
Invalid Query: SELECT DISTINCT p.title, p.base_price, p.sale_price_diff, p.pagename, p.thumbnail_id, (p.base_price - p.sale_price_diff) actual_price, co.list_order, co.list_order_present FROM product p JOIN category_intersect ci ON (ci.product_id = p.product_id) LEFT JOIN category_order co on (co.product_id = p.product_id && co.category_id = "") LEFT JOIN seasonal_dates_intersect sdi on sdi.product_id = p.product_id LEFT JOIN seasonal_dates sd on sd.seasonal_dates_id = sdi.seasonal_dates_id WHERE ci.category_id = "" && p.extras = 0 && p.deleted = 0 && sd.currently_inactive is NULL && manual_inactive = 0 ORDER BY list_order_present desc, list_order, title LIMIT 0, 16