Sorry but this article is no longer available.

    My jewelry items are unique and as soon as they are sold, they are no longer visible on the site.

    

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY RAND()' at line 15

select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_quantity, p.products_last_modified, p.manufacturers_id, pd.products_name, p2c.categories_id, (select customers_group_price from products_groups where products_id = p.products_id AND customers_group_id = '0' LIMIT 1) as customers_group_price, (select specials_new_products_price FROM specials where products_id = p.products_id AND customers_group_id = '0' AND status=1 LIMIT 1) as specials_new_products_price, (select threshold FROM free_gifts where products_id = p.products_id AND customers_group_id = '0' LIMIT 1) as threshold, (select IF(status =1 AND expires_date>now(),1,0) as st FROM specials where products_id = p.products_id AND customers_group_id = '0' LIMIT 1) as specstat from products p LEFT JOIN products_to_categories p2c ON (p.products_id = p2c.products_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN categories c ON (p2c.categories_id = c.categories_id) LEFT JOIN categories_description cd ON (cd.categories_id = c.categories_id) WHERE p.products_status = 1 AND pd.products_name > '' AND pd.language_id = 1 AND cd.language_id = 1 and c.categories_id = 148 AND p.products_id != ORDER BY RAND()

[TEP STOP]