Cacher is the code snippet organizer for pro developers

SELECT p.`ID`, p.`post_title`, p.`post_excerpt`, p.`post_content`
  , GROUP_CONCAT( m.`meta_value` order by `m`.`meta_key` SEPARATOR ',' ) AS `meta`  
FROM `wp_posts` p 
LEFT JOIN `wp_postmeta` m  ON p.ID = m.post_id 
  AND m.`meta_key` IN ('_product_info_subtitle', '_product_specification_ip_cam', '_product_specification_ip_cam_group', '_product_icons_function')
LEFT JOIN `wp_term_relationships` tr ON p.ID = tr.object_id
LEFT JOIN `wp_term_taxonomy` tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
LEFT JOIN `wp_terms` t ON tt.term_id = t.term_id 
WHERE  p.post_type = 'product'
GROUP BY p.`ID`