New Products

There are currently no products matching your selection.

CLEAR ALL FILTERS
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'new_status' AND CAST(wp_postmeta.meta_value AS CHAR) LIKE '%
NEW
%' ) AND ( mt1.meta_key = 'product_new_from' AND CAST(mt1.meta_value AS DATE) <= '2016-12-05' ) AND ( mt2.meta_key = 'product_new_to' AND CAST(mt2.meta_value AS DATE) >= '2016-12-05' ) ) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') AND wp_posts.id NOT IN (SELECT post_id FROM wp_wpfront_ure_post_type_permissions WHERE role IN ('wpfront-guest-role-1') AND enable_permissions = 1 AND has_read = 0 GROUP BY post_id HAVING COUNT(*) = 1) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 24