SELECT * from wm_products AS products
LEFT JOIN wm_products_description AS products_description ON products.product_id = products_description.product_id
WHERE products.status > 0 AND products_description.language = 'en'
ORDER BY feature_tag DESC,sort_order ASC,hits DESC
Vacuum Interrupter,Vacuum Contactors,Vacuum Circuit Breaker,Embedded Poles-Sunway Hanguang Electric Manufacturing Limited - Sunway Hanguang Electric Manufacturing Limited
