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 ('10131','10122','9072','8068','6977','6142','5207','1485','1180') )
)
) 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