SELECT SQL_CALC_FOUND_ROWS sato_posts.ID
FROM sato_posts LEFT JOIN sato_term_relationships ON (sato_posts.ID = sato_term_relationships.object_id) INNER JOIN sato_postmeta ON ( sato_posts.ID = sato_postmeta.post_id )
WHERE 1=1 AND (
sato_term_relationships.term_taxonomy_id IN (49)
) AND (
( sato_postmeta.meta_key = 'tags' AND sato_postmeta.meta_value LIKE '{86ce5fd8c9ada39b29f99e096d5e7d04f6e698aa70e7406397ff92ef86926c02}\"1754\"{86ce5fd8c9ada39b29f99e096d5e7d04f6e698aa70e7406397ff92ef86926c02}' )
OR
( sato_postmeta.meta_key = 'post_meta_title' AND sato_postmeta.meta_value LIKE '{86ce5fd8c9ada39b29f99e096d5e7d04f6e698aa70e7406397ff92ef86926c02}Warehouse{86ce5fd8c9ada39b29f99e096d5e7d04f6e698aa70e7406397ff92ef86926c02}' )
) AND sato_posts.post_type = 'product' AND ((sato_posts.post_status = 'publish'))
GROUP BY sato_posts.ID
ORDER BY sato_posts.post_title ASC
LIMIT 0, 15