Joker-jar
30.07.2007, 05:50
select p.products_id from products p inner join products_topsite t on (p.products_id = t.products_id and t.status = '1' and t.expires_date >= now()) inner join products_variants pv on (p.products_id = pv.products_id and pv.products_status = 1 and ((pv.products_quantity != 0 or pv.products_store_quantity != 0) or ((pv.products_quantity = 0 or pv.products_store_quantity = 0) and pv.products_reorder_quantity > 0) or RIGHT(pv.products_store_bin,2) = 'al' or RIGHT(pv.products_store_bin,2) = '34' or RIGHT(pv.products_store_bin,2) = '59')) inner join products_to_categories p2c on (p.products_id = p2c.products_id and p2c.categories_id IN ($_GET["cat"])) group by p.products_id order by rand()
Есть у кого какие идеи?
Есть у кого какие идеи?