SELECT *,CONVERT(`value`,unsigned integer) as `price` from `post`
INNER JOIN `post_meta` on `post`.`post_id`=`post_meta`.`post_id`
INNER JOIN `tag_relationships` on `post`.`post_id` = `tag_relationships`.`object_id`
INNER JOIN `tag` ON `tag`.`tag_id` = `tag_relationships`.`tag_id`
INNER JOIN `tag_meta` ON `tag_meta`.`tag_id` = `tag`.`tag_id`
WHERE `post_type` = 'product' AND `post_status` = 'publish'
AND `post`.`post_id` IN (947,958,,971)
GROUP BY `post`.`post_id`
