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 (312) AND p.active = 1 AND sh.shop_id IN (0,1143,3621,4425,4483,6464,6883,10621,10871,19637,19704,20607,21793,29683,29978,34630,36060,36917,37961,40908,41053,41534,42272,45124,52201,56432,58459,61064,61066,62731,65504,69691,70412,75394,82012,85548,90395,90602,93863,95316,96075,96196,96360,96364,96387,96924,101672,105775,105805,110859,140939,145580,145876,156775,158184,158840,159745,162679,162821,162974,164646,165890,168166,168413,168798,169179,169744,169829,170799,172524,173176,173422,176139,176482,176581,176763,177654,178159,179313,179948,185584,186278,186302,187158,187311,190026,191748,191790,191910,193328,193993,194883,196547,196949,196951,201559,201584,201804,203538,203995,204646,205550,205789,207173,207806,207847,209289,209733,209744,210393,213327,213352,213359,213361,213366,213367,213369,216279,216346,216886,217612,222725,224794,227642,227752,229507,229788,231508,232696) AND sh.shop_openbase = 1  GROUP BY p.shop_id ORDER BY sh.shop_openbase DESC, sh.shop_order ASC, LCASE(sh.shop_name) ASC LIMIT 0,12