SELECT SQL_CALC_FOUND_ROWS py_posts.ID FROM py_posts INNER JOIN py_postmeta ON ( py_posts.ID = py_postmeta.post_id ) WHERE 1=1 AND ( ( py_postmeta.meta_key = '_yith_wcbm_product_meta' AND py_postmeta.meta_value LIKE '{de7c40cb403db4a6352d383e1898ffe28dd232472c09fe2458b7375c8368c079}1629{de7c40cb403db4a6352d383e1898ffe28dd232472c09fe2458b7375c8368c079}' ) ) AND py_posts.post_type = 'product' AND ((py_posts.post_status = 'publish')) GROUP BY py_posts.ID ORDER BY py_posts.post_date DESC LIMIT 0, 30