SELECT a.id, a.`name`, a.is_new, a.alias, a.category_id, a.category_id_wrapper,a.image, a.rating_sum, a.discount_buy_multi, a.number_multi_from, a.number_multi_to,a.tag_same_price, a.model, a.price FROM fs_products as a INNER JOIN fs_products_sub as b ON
a.id = b.product_id AND ( a.category_id = 12
OR a.category_id_wrapper like "%,12,%" OR a.multi_categories like "%,12,%")
AND a.published = 1 GROUP BY b.product_id ORDER BY a.created_time desc, a.ordering desc