بنر حراج پوشاک

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 (130) GROUP BY product.ID ORDER BY product.post_date DESC LIMIT 0,60