TOP Products

Sale price
$57.99 $57.99
Sale price
$150.99 $150.99
Sale price
$20.99 $20.99
Sale price
$85.90 $85.90
Sale price
$50.00 $50.00
Sale price
$76.93 $76.93

New Products

Sale price
$159.99 $159.99
Sale price
$102.00 $102.00
Sale price
$80.99 $80.99
Sale price
$76.00 $76.00
Sale price
$59.99 $59.99
Sale price
$72.00 $72.00
Sale price
$79.90 $79.90
1226 - User 'pd9gucec_usrGlog' has exceeded the 'max_questions' resource (current value: 1)

select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' ORDER BY RAND() desc limit 8

[TEP STOP]