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 ('11434','10140','10104','6580','8243','7911','7902','7818','7570','4987','6335','5043','5000','4006','4004','3976','2363','1413','1309') )
)
) 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
