|
 |
Product Listing
|
|
|
|
| style | | | | | | | | | neckline | | | | | | | | | back style | | | | | | | | | | | | | sleeve | | | | | | | accessories | | | | | | | | fabric | | | | | | | | | floater | | | | | | |
| Also refine by... style neckline back style sleeve accessories fabric floater |
|
|
|
|
|
|
Sort by: |
|
Product(s) |
Price+ |
Newest |
Popularity |
|
|
1 - Can't create/write to file '/tmp/#sql_1904_0.MYI' (Errcode: 28)
select /*columns_start*/ distinct if(isnull(feat.featured_id),2,1) as featstat, p.products_qty_threshold, p.products_hot_qty, p.products_ordered, pd.products_label1,pd.products_label2,pd.products_label3,pd.products_label4, p.products_image, p.product_free_shipping , p.products_image, p.product_free_shipping _med, p.products_image, p.product_free_shipping _lrg, p.products_image, p.product_free_shipping _sm_1, p.products_image, p.product_free_shipping _xl_1, p.products_image, p.product_free_shipping _sm_2, p.products_image, p.product_free_shipping _xl_2, p.products_image, p.product_free_shipping _sm_3, p.products_image, p.product_free_shipping _xl_3, p.products_image, p.product_free_shipping _sm_4, p.products_image, p.product_free_shipping _xl_4, p.products_image, p.product_free_shipping _sm_5, p.products_image, p.product_free_shipping _xl_5, p.products_image, p.product_free_shipping _sm_6, p.products_image, p.product_free_shipping _xl_6, p.products_image, p.product_free_shipping _alt_1, p.products_image, p.product_free_shipping _alt_2, p.products_image, p.product_free_shipping _alt_3, p.products_image, p.product_free_shipping _alt_4, p.products_image, p.product_free_shipping _alt_5, p.products_image, p.product_free_shipping _alt_6, if(length(pd1.products_description_short), pd1.products_description_short, pd.products_description_short) as products_description_short , m.manufacturers_id, p.products_id, if(length(pd1.products_name), pd1.products_name, pd.products_name) as products_name, IF(pp.products_group_price='-2', p.products_price * 1,pp.products_group_price) as products_price, p.products_tax_class_id, IF(s.status, IF(sp.specials_new_products_price='-2',s.specials_new_products_price*1,sp.specials_new_products_price), NULL) as specials_new_products_price, IF(s.status, IF(sp.specials_new_products_price='-2',s.specials_new_products_price*1,sp.specials_new_products_price), IF(pp.products_group_price='-2', p.products_price * 1,pp.products_group_price) ) as final_price /*columns_end*/ from products_description pd, products p left join featured feat on feat.products_id=p.products_id and feat.status=1 left join manufacturers m on m.manufacturers_id=p.manufacturers_id left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='1' and pd1.affiliate_id = '0' left join specials s on p.products_id = s.products_id left join products_to_categories p2c on p.products_id = p2c.products_id left join categories c on p2c.categories_id = c.categories_id left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '0' and pp.currencies_id = '11' left join specials_prices sp on s.specials_id = sp.specials_id and sp.groups_id = '0' and sp.currencies_id = '11' where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = '1' and (c.categories_status = 1 or c.categories_status is NULL) and if(pp.products_group_price is null, 1, pp.products_group_price != -1 ) and pd.affiliate_id = 0 and IF(s.status, if(sp.specials_new_products_price is NULL, 1, sp.specials_new_products_price != -1 ), 1) order by featstat, final_price , products_name limit 0, 21
[TEP STOP]
|
