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 = '4873' or p2c.categories_id = '4958' or p2c.categories_id = '4902' or p2c.categories_id = '4915' or p2c.categories_id = '4919' or p2c.categories_id = '4922' or p2c.categories_id = '4929' or p2c.categories_id = '4935' or p2c.categories_id = '4874' or p2c.categories_id = '4875' or p2c.categories_id = '4980' or p2c.categories_id = '4984' or p2c.categories_id = '4894' or p2c.categories_id = '4897' or p2c.categories_id = '4923' or p2c.categories_id = '4876' or p2c.categories_id = '4877' or p2c.categories_id = '4879' or p2c.categories_id = '4880' or p2c.categories_id = '4881' or p2c.categories_id = '4882' or p2c.categories_id = '4883' or p2c.categories_id = '4884' or p2c.categories_id = '4885' or p2c.categories_id = '4886' or p2c.categories_id = '4887' or p2c.categories_id = '4888' or p2c.categories_id = '4889' or p2c.categories_id = '4948' or p2c.categories_id = '4950' or p2c.categories_id = '4952' or p2c.categories_id = '4955' or p2c.categories_id = '4956' or p2c.categories_id = '4961' or p2c.categories_id = '4963' or p2c.categories_id = '4973' or p2c.categories_id = '4974' or p2c.categories_id = '4914' or p2c.categories_id = '4934' or p2c.categories_id = '4940' or p2c.categories_id = '4941' or p2c.categories_id = '4945' or p2c.categories_id = '4891' or p2c.categories_id = '4957' or p2c.categories_id = '4962' or p2c.categories_id = '4964' or p2c.categories_id = '4967' or p2c.categories_id = '4970' or p2c.categories_id = '4975' or p2c.categories_id = '4986' or p2c.categories_id = '4892' or p2c.categories_id = '4896' or p2c.categories_id = '4898' or p2c.categories_id = '4901' or p2c.categories_id = '4903' or p2c.categories_id = '4916' or p2c.categories_id = '4920' or p2c.categories_id = '4924' or p2c.categories_id = '4930' or p2c.categories_id = '4936' or p2c.categories_id = '4946' or p2c.categories_id = '4899' or p2c.categories_id = '4953' or p2c.categories_id = '4959' or p2c.categories_id = '4965' or p2c.categories_id = '4968' or p2c.categories_id = '4971' or p2c.categories_id = '4976' or p2c.categories_id = '4981' or p2c.categories_id = '4987' or p2c.categories_id = '4991' or p2c.categories_id = '4900' or p2c.categories_id = '4904' or p2c.categories_id = '4917' or p2c.categories_id = '4921' or p2c.categories_id = '4925' or p2c.categories_id = '4931' or p2c.categories_id = '4937' or p2c.categories_id = '4943' or p2c.categories_id = '4944' or p2c.categories_id = '4947' or p2c.categories_id = '4905' or p2c.categories_id = '4951' or p2c.categories_id = '4954' or p2c.categories_id = '4960' or p2c.categories_id = '4979' or p2c.categories_id = '4982' or p2c.categories_id = '4989' or p2c.categories_id = '4992' or p2c.categories_id = '4906' or p2c.categories_id = '4918' or p2c.categories_id = '4938' or p2c.categories_id = '4939' or p2c.categories_id = '4942' or p2c.categories_id = '4908' or p2c.categories_id = '4985' or p2c.categories_id = '4990' or p2c.categories_id = '4994' or p2c.categories_id = '4909' or p2c.categories_id = '4910' or p2c.categories_id = '4983' or p2c.categories_id = '4988' or p2c.categories_id = '4993' or p2c.categories_id = '4911' or p2c.categories_id = '4912' or p2c.categories_id = '4966' or p2c.categories_id = '4969' or p2c.categories_id = '4972' or p2c.categories_id = '4977' or p2c.categories_id = '4913' or p2c.categories_id = '4926' or p2c.categories_id = '4932' or p2c.categories_id = '4927' or p2c.categories_id = '4978' or p2c.categories_id = '4928' or p2c.categories_id = '4933' or p2c.categories_id = '4871' or p2c.categories_id = '4872' or p2c.categories_id = '4878' or p2c.categories_id = '4949' or p2c.categories_id = '4890' or p2c.categories_id = '4893' or p2c.categories_id = '4895' or p2c.categories_id = '4907' or p2c.categories_id = '') order by p.sort_order, p.products_model, pd.products_name limit 0, 6

[TEP STOP]