select name_en as name, subtitle_en as subtitle, seo_title, image, image2, price_normal, price, rating from product p where 1 and category_id='1' and subcategory_id='11' order by p.priority asc, p.id desc
Product

Distributes and Provides Services of industrial machinery, test and measurement products in Indonesia.

Get Interesting News & Updates From us
PT. Surya Citra Raya
Greenlake City, Crown A No.36 Petir, Cipondoh,
Tangerang - Banten Tangerang Kota 15147
Indonesia
021 2230 2714