string(775) "SELECT SQL_CALC_FOUND_ROWS hp_posts.ID FROM hp_posts LEFT JOIN hp_term_relationships ON (hp_posts.ID = hp_term_relationships.object_id) INNER JOIN hp_postmeta ON ( hp_posts.ID = hp_postmeta.post_id ) INNER JOIN hp_postmeta AS mt1 ON ( hp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
hp_posts.ID NOT IN (
SELECT object_id
FROM hp_term_relationships
WHERE term_taxonomy_id IN (7,9)
)
AND
hp_term_relationships.term_taxonomy_id IN (105)
) AND (
( hp_postmeta.meta_key = 'product_status' AND hp_postmeta.meta_value = '0' )
AND
mt1.meta_key = 'bump_date'
) AND hp_posts.post_type = 'product' AND (hp_posts.post_status = 'publish' OR hp_posts.post_status = 'acf-disabled') GROUP BY hp_posts.ID ORDER BY CAST(mt1.meta_value AS CHAR) DESC LIMIT 0, 12"