henry here - Law Office of Warren Nguyen in San Jose, California
(408) 603-9751
(855) TAI-NAN-1
24 hr Injury Help
Trợ giúp Tiếng Việt
SELECT p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_style, pd.products_name, p.products_shipping, p.products_weight, p.products_id, 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 from products p LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_to_categories p2c ON (p.products_id = p2c.products_id) LEFT JOIN specials_retail_prices s ON (p.products_id = s.products_id) where p.products_status = '1' and pd.language_id = '5' and p.manufacturers_id = '0' and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access = "G") GROUP BY p.products_id ORDER BY p.products_date_added desc
test 2
test 2