SELECT SQL_CALC_FOUND_ROWS
product.ID as id,
product.post_title as title,
product.type_id,
product_meta.meta_value as product_view
FROM wp_posts as product LEFT JOIN wp_term_relationships as term_rel ON product.ID = term_rel.object_id left join wp_postmeta as product_meta on product_meta.post_id = product.ID and product_meta.meta_key = 'product_view' WHERE product.post_type = 'product' AND product.post_status = 'publish' and product.type_id in (1) AND term_rel.term_taxonomy_id IN (143) GROUP BY product.ID ORDER BY product.post_date DESC LIMIT 0,60