Pendants
Flawlessly designed to perfection, our striking range of fashion pendants combines style and class for the woman of today. Our beautiful collection of fashion pendants are available in exclusive designs & are competitively priced. We design & manufacture exclusive range of designer pendants which includes metal pendants & faceted and cab stones pendants available in different designs & colors.
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 pd.products_name desc limit 100, 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 = '5' order by p.products_visible_sm desc, if(p.products_quantity=0,2,1), order by pd.products_name desc limit 100, 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 = '5' order by p.products_visible_sm desc, if(p.products_quantity=0,2,1), order by pd.products_name desc limit 100, 20
[TEP STOP]