*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, category_intersect ci, category c 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 c.merchant_id = '1' && c.category_id = ci.category_id && ci.product_id = p.product_id && (p.base_price - p.sale_price_diff) <= '99.99' && (p.base_price - p.sale_price_diff) >= '75' && p.extras = 0 && p.deleted = 0 && sd.currently_inactive is NULL && p.manual_inactive = 0 ORDER BY actual_price, list_order_present desc, list_order, title LIMIT 0, 16