{"status":true,"query":"SELECT pp.product_pins_id, pp.product_pins_title, pp.product_pins_descriptor, pa.product_amperage_title, pa.product_amperage_descriptor, pd.product_device_type_title, pd.product_device_type_descriptor, pg.product_ground_position_title, pg.product_ground_position_descriptor, pir.product_ip_rating_title, pir.product_ip_rating_descriptor FROM product AS p LEFT JOIN product_to_category as ptc ON p.product_id = ptc.product_id LEFT JOIN product_category as pc ON pc.product_category_id = ptc.product_category_id LEFT JOIN product_pins as pp ON pp.product_pins_id = p.product_pins_id LEFT JOIN product_amperage as pa ON pa.product_amperage_id = p.product_amperage_id LEFT JOIN product_device_type as pd ON pd.product_device_type_id = p.product_device_type_id LEFT JOIN product_ground_position as pg ON pg.product_ground_position_id = p.product_ground_position_id LEFT JOIN product_ip_rating as pir ON pir.product_ip_rating_id = p.product_ip_rating_id WHERE p.product_active = 1 AND pc.product_category_part_builder = 1 ","parts":{"pins":[{"title":"3","desc":""},{"title":"4","desc":""},{"title":"5","desc":""}],"amps":[{"title":"20","desc":"amp"},{"title":"30","desc":"amp"},{"title":"32","desc":"amp"},{"title":"60","desc":"amp"},{"title":"63","desc":"amp"},{"title":"100","desc":"amp"}],"type":[{"title":"B","desc":"Flanged Inlet"},{"title":"C","desc":"Connector"},{"title":"I","desc":"Wall Mount Inlet"},{"title":"MI","desc":"Mechanical Interlock"},{"title":"P","desc":"Plug"},{"title":"R","desc":"Flanged Receptacle"},{"title":"RA","desc":"Angled Receptacle"},{"title":"W","desc":"Wall Mount Receptacle"}],"ground":[{"title":"3","desc":"h"},{"title":"4","desc":"h"},{"title":"5","desc":"h"},{"title":"6","desc":"h"},{"title":"7","desc":"h"},{"title":"9","desc":"h"},{"title":"12","desc":"h"}],"rating":[{"title":"-","desc":"IP44"},{"title":"W","desc":"IP67"}]}}