Languages:   German English Dutch
Currency: Euro
Shopping Cart
Value 0 items
Contact UsUser Guide Terms & conditions
  Products  
 
     
Shop By Price more
 
Under . 10,00
From . 10,00 to . 25,00
From . 25,00 to . 50,00
From . 50,00 to . 100,00
Above . 100,00
 
Manufacturers more
 
Passion
Pleaser
 
Information more
 
Payment methode
Contact Us
Privacy
Returns
User Guide
Size Chart
Terms & conditions
 
Thongs
Let's See What We Have Here
Displaying 1 to 12 (of 71 products) Result Pages:  1  2  3  4  5  6  [Next >>] 
1030 - Got error 122 from storage engine

select p.products_image, m.manufacturers_name, p.products_model, p.products_quantity, if(length(pd1.products_name), pd1.products_name, pd.products_name) as products_name, p.products_weight, if(length(pd1.products_description_short), pd1.products_description_short, pd.products_description_short) as products_description_short, 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, pd.products_description from products_description pd, products_to_categories p2c, products p LEFT join products_to_affiliates p2a on p.products_id = p2a.products_id and p2a.affiliate_id = '18' left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='1' and pd1.affiliate_id = '18' left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '0' and pp.currencies_id = '0' where p.products_status = 1 and if(pp.products_group_price is null, 1, pp.products_group_price != -1 ) and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and pd.affiliate_id = 0 and p2a.affiliate_id is not null and p2c.categories_id = '252' order by p.sort_order, products_name limit 0, 12

Filename: includes/modules/product_listing_col.php
Line: 22