SELECT   wp_posts.* FROM wp_posts  INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id)
INNER JOIN wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id)
INNER JOIN wp_postmeta AS mt5 ON (wp_posts.ID = mt5.post_id)
INNER JOIN wp_postmeta AS mt6 ON (wp_posts.ID = mt6.post_id)
INNER JOIN wp_postmeta AS mt7 ON (wp_posts.ID = mt7.post_id)
INNER JOIN wp_postmeta AS mt8 ON (wp_posts.ID = mt8.post_id)
INNER JOIN wp_postmeta AS mt9 ON (wp_posts.ID = mt9.post_id)
INNER JOIN wp_postmeta AS mt10 ON (wp_posts.ID = mt10.post_id) WHERE 1=1  AND wp_posts.post_type = 'wp-types-group' AND (wp_posts.post_status = 'publish') AND ( (wp_postmeta.meta_key = '_wp_types_group_terms' AND CAST(wp_postmeta.meta_value AS CHAR) = 'all')
OR  (mt1.meta_key = '_wp_types_group_terms' AND CAST(mt1.meta_value AS CHAR) LIKE '%,7,%')
OR  (mt2.meta_key = '_wp_types_group_terms' AND CAST(mt2.meta_value AS CHAR) LIKE '%,49,%')
OR  (mt3.meta_key = '_wp_types_group_terms' AND CAST(mt3.meta_value AS CHAR) LIKE '%,45,%')
OR  (mt4.meta_key = '_wp_types_group_terms' AND CAST(mt4.meta_value AS CHAR) LIKE '%,46,%')
OR  (mt5.meta_key = '_wp_types_group_terms' AND CAST(mt5.meta_value AS CHAR) LIKE '%,43,%')
OR  (mt6.meta_key = '_wp_types_group_terms' AND CAST(mt6.meta_value AS CHAR) LIKE '%,47,%')
OR  (mt7.meta_key = '_wp_types_group_terms' AND CAST(mt7.meta_value AS CHAR) LIKE '%,50,%')
OR  (mt8.meta_key = '_wp_types_group_terms' AND CAST(mt8.meta_value AS CHAR) LIKE '%,48,%')
OR  (mt9.meta_key = '_wp_types_group_terms' AND CAST(mt9.meta_value AS CHAR) LIKE '%,44,%')
OR  (mt10.meta_key = '_wp_types_group_terms' AND CAST(mt10.meta_value AS CHAR) LIKE '%,51,%') ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC;