SELECT SQL_CALC_FOUND_ROWS mrml52_posts.ID
FROM mrml52_posts INNER JOIN mrml52_postmeta ON ( mrml52_posts.ID = mrml52_postmeta.post_id )
WHERE 1=1 AND (
(
( mrml52_postmeta.meta_key = 'professionnel_correspondant' AND mrml52_postmeta.meta_value IN ('10706','9517','5049') )
)
) AND mrml52_posts.post_type = 'product' AND ((mrml52_posts.post_status = 'publish'))
GROUP BY mrml52_posts.ID
ORDER BY mrml52_posts.post_title ASC
LIMIT 0, 21