Earrings
Our fine collection of fashion jewelry earrings presents you a range of extremely beautiful designs that are specially made to beautify the woman who wants to beautify herself. All our pieces of fashion earrings are beautifully handcrafted by our skilled craftsman & presents high level of excellent craftsmanship. High quality threads, beads, stones are used to make these fashion earring thus making them all the more desirable.
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by final_price desc, pd.products_name limit 0, 20' at line 1
select pd.products_name, p.products_image, p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, 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, p.products_quantity as in_stock 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_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by p.products_visible_sm desc, if(p.products_quantity=0,2,1), order by final_price desc, pd.products_name limit 0, 20
[TEP STOP]
select pd.products_name, p.products_image, p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, 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, p.products_quantity as in_stock 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_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by p.products_visible_sm desc, if(p.products_quantity=0,2,1), order by final_price desc, pd.products_name limit 0, 20
[TEP STOP]