SELECT c.*, lc.*, IF(lc.cat_page_header!='', lc.cat_page_header, lc.cat_name) cat_name FROM category c, lng_cat lc WHERE c.catID=lc.catID AND c.catID='334' AND lc.lngID='1' AND c.is_active='1' AND c.cat_page_url='zchina-products-cat-334.html' ZChina Products Jewelry at LoveBrightJewelry.com
Live Chat Support Software