Refine By
Our Style Stories
1 - Can't create/write to file '/tmp/#sql_611_0.MYI' (Errcode: 28)

select distinct p.products_image, p.products_model, pd.products_name, p.products_image,gt.garmenttype_id, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id ,products_to_gatmenttype gt ,products_to_categories p2c where p.products_status = '1' and gt.garmenttype_id=1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and (p2c.categories_id = '4484' or p2c.categories_id = '4540' or p2c.categories_id = '4532' or p2c.categories_id = '4485' or p2c.categories_id = '4545' or p2c.categories_id = '4548' or p2c.categories_id = '4551' or p2c.categories_id = '4486' or p2c.categories_id = '4498' or p2c.categories_id = '4503' or p2c.categories_id = '4506' or p2c.categories_id = '4487' or p2c.categories_id = '4470' or p2c.categories_id = '4538' or p2c.categories_id = '4531' or p2c.categories_id = '4526' or p2c.categories_id = '4491' or p2c.categories_id = '4494' or p2c.categories_id = '4497' or p2c.categories_id = '4502' or p2c.categories_id = '4505' or p2c.categories_id = '4489' or p2c.categories_id = '4471' or p2c.categories_id = '4474' or p2c.categories_id = '4478' or p2c.categories_id = '4543' or p2c.categories_id = '4546' or p2c.categories_id = '4549' or p2c.categories_id = '4511' or p2c.categories_id = '4513' or p2c.categories_id = '4516' or p2c.categories_id = '4479' or p2c.categories_id = '4533' or p2c.categories_id = '4527' or p2c.categories_id = '4517' or p2c.categories_id = '4493' or p2c.categories_id = '4480' or p2c.categories_id = '4541' or p2c.categories_id = '4544' or p2c.categories_id = '4547' or p2c.categories_id = '4550' or p2c.categories_id = '4514' or p2c.categories_id = '4482' or p2c.categories_id = '4536' or p2c.categories_id = '4534' or p2c.categories_id = '4483' or p2c.categories_id = '4542' or p2c.categories_id = '4552' or p2c.categories_id = '4442' or p2c.categories_id = '4539' or p2c.categories_id = '4492' or p2c.categories_id = '4481' or p2c.categories_id = '4443' or p2c.categories_id = '4449' or p2c.categories_id = '4458' or p2c.categories_id = '4463' or p2c.categories_id = '4465' or p2c.categories_id = '4468' or p2c.categories_id = '4444' or p2c.categories_id = '4507' or p2c.categories_id = '4476' or p2c.categories_id = '4445' or p2c.categories_id = '4535' or p2c.categories_id = '4472' or p2c.categories_id = '4446' or p2c.categories_id = '4464' or p2c.categories_id = '4467' or p2c.categories_id = '4447' or p2c.categories_id = '4529' or p2c.categories_id = '4528' or p2c.categories_id = '4523' or p2c.categories_id = '4524' or p2c.categories_id = '4522' or p2c.categories_id = '4521' or p2c.categories_id = '4520' or p2c.categories_id = '4518' or p2c.categories_id = '4519' or p2c.categories_id = '4495' or p2c.categories_id = '4499' or p2c.categories_id = '4500' or p2c.categories_id = '4508' or p2c.categories_id = '4509' or p2c.categories_id = '4448' or p2c.categories_id = '4450' or p2c.categories_id = '4451' or p2c.categories_id = '4452' or p2c.categories_id = '4453' or p2c.categories_id = '4454' or p2c.categories_id = '4455' or p2c.categories_id = '4456' or p2c.categories_id = '4457' or p2c.categories_id = '4461' or p2c.categories_id = '4462' or p2c.categories_id = '4512' or p2c.categories_id = '4459' or p2c.categories_id = '4530' or p2c.categories_id = '4525' or p2c.categories_id = '4496' or p2c.categories_id = '4501' or p2c.categories_id = '4504' or p2c.categories_id = '4510' or p2c.categories_id = '4488' or p2c.categories_id = '4490' or p2c.categories_id = '4469' or p2c.categories_id = '4473' or p2c.categories_id = '4475' or p2c.categories_id = '4477' or p2c.categories_id = '4460' or p2c.categories_id = '4466' or p2c.categories_id = '4537' or p2c.categories_id = '4515' or p2c.categories_id = '') order by p.sort_order, p.products_model, pd.products_name limit 18, 6

[TEP STOP]