| Query SQL | : SELECT a.id,a.alias,a.category_id,a.category_alias, a.name ,a.summary_auto, a.image, a.price,a.price_old,a.discount,a.types,a.manufactory_image,a.manufactory_name,a.manufactory_alias,a.published_double,a.warranty ,a.image_double,a.summary,a.is_hotdeal,a.date_end,a.date_start,a.promotion_price,a.promotion_main ,a.hits,a.region_price FROM fs_products AS a
WHERE a.published = 1 AND a.category_published = 1 AND a.manufactory_published = 1 AND a.is_trash = 0 and ( a.manufactory_alias like '%fakoma%' or a.manufactory_alias like '%fakoma%' or a.manufactory_alias like '%modelux%' or a.manufactory_alias like '%berjaya%' ) and ( a.origin_alias like '%kangaroo%' or a.origin_alias like '%kangaroo%' ) AND a.category_id_wrapper like "%,236,%" ORDER BY a.name asc LIMIT 0,12 |