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 '{4acd4ae19cfe05e91142c6de4346baec4ea4b00c597d22336556ebcbcf1b460e}\"1428\"{4acd4ae19cfe05e91142c6de4346baec4ea4b00c597d22336556ebcbcf1b460e}' )
OR
( sato_postmeta.meta_key = 'post_meta_title' AND sato_postmeta.meta_value LIKE '{4acd4ae19cfe05e91142c6de4346baec4ea4b00c597d22336556ebcbcf1b460e}SOS{4acd4ae19cfe05e91142c6de4346baec4ea4b00c597d22336556ebcbcf1b460e}' )
) 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
Asia Pacific 
中文 (繁體) 
