SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,847,%' OR a.category_id_wrapper1 like '%,847,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,1152,%' OR a.category_id_wrapper1 like '%,1152,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,193,%' OR a.category_id_wrapper1 like '%,193,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,630,%' OR a.category_id_wrapper1 like '%,630,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,338,%' OR a.category_id_wrapper1 like '%,338,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,625,%' OR a.category_id_wrapper1 like '%,625,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,138,%' OR a.category_id_wrapper1 like '%,138,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,246,%' OR a.category_id_wrapper1 like '%,246,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,142,%' OR a.category_id_wrapper1 like '%,142,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,191,%' OR a.category_id_wrapper1 like '%,191,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,141,%' OR a.category_id_wrapper1 like '%,141,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,139,%' OR a.category_id_wrapper1 like '%,139,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,293,%' OR a.category_id_wrapper1 like '%,293,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,240,%' OR a.category_id_wrapper1 like '%,240,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,1004,%' OR a.category_id_wrapper1 like '%,1004,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC SELECT a.name, a.alias, a.id, a.image, a.category_alias, a.category_id,a.price,a.price_old,a.discount, a.new_prd, a.h_price,a.h_price_old,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price, a.link_orther,a.text_old,a.is_renew, a.is_autumn,a.is_card, a.is_installment, a.is_km3, a.image_sticker_oldprd,a.note_oldprd,a.show_price7, b.fdate,b.tdate, sub.price_1 FROM fs_products AS a LEFT JOIN fs_sales_categories as b ON a.sale_id = b.id LEFT JOIN ( SELECT product_id, price_h, price_1 FROM fs_products_sub WHERE published = 1 GROUP BY product_id, price_h ) as sub ON (a.id = sub.product_id AND a.h_price = sub.price_h) WHERE (a.category_id_wrapper like '%,192,%' OR a.category_id_wrapper1 like '%,192,%') AND a.published = 1 AND a.show_cat = 0 ORDER BY a.ordering ASC, a.id DESC