SELECT p.shop_id,p.product_id
			FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
			LEFT JOIN os38h_shops sh ON (p.shop_id = sh.shop_id)
			LEFT JOIN os38h_product_to_category ptc ON (p.product_id = ptc.product_id)
			 LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE  p.status = '1'  AND p2c.category_id IN (25) AND p.active = 1 AND sh.shop_id IN (0,5189,44348,44349,61266,112712,154741,179383,183939,214566,217642,223440) GROUP BY p.shop_id ORDER BY sh.shop_openbase DESC, sh.shop_order ASC, LCASE(sh.shop_name) ASC LIMIT 0,12