SELECT SQL_CALC_FOUND_ROWS sm_posts.* FROM sm_posts LEFT JOIN sm_term_relationships ON (sm_posts.ID = sm_term_relationships.object_id) INNER JOIN sm_postmeta ON ( sm_posts.ID = sm_postmeta.post_id ) WHERE 1=1 AND ( sm_term_relationships.term_taxonomy_id IN (2119) OR sm_term_relationships.term_taxonomy_id IN (2119) ) AND ( ( sm_postmeta.meta_key = '_for_sale' AND sm_postmeta.meta_value = 'yes' ) ) AND sm_posts.post_type = 'product' AND (sm_posts.post_status = 'publish' OR sm_posts.post_status = 'acf-disabled') GROUP BY sm_posts.ID ORDER BY RAND() LIMIT 0, 20
Array ( [0] => stdClass Object ( [ID] => 9276 [post_author] => 18 [post_date] => 2020-03-19 16:06:04 [post_date_gmt] => 2020-03-19 16:06:04 [post_content] => empty shelves,store,food,coronavirus,market [post_title] => 1584627237098-5E73862898633-Thu-Mar19202014-48-08-UTC [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => 1584627237098-5e73862898633-thu-mar19202014-48-08-utc [to_ping] => [pinged] => [post_modified] => 2020-03-20 00:14:02 [post_modified_gmt] => 2020-03-20 00:14:02 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.snapmediaapp.com/product/1584627237098-5e73862898633-thu-mar19202014-48-08-utc/ [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 ) [1] => stdClass Object ( [ID] => 9690 [post_author] => 18 [post_date] => 2020-03-30 14:21:06 [post_date_gmt] => 2020-03-30 14:21:06 [post_content] => Basket, Mammal, Pet, Prison, Shopping Basket, Shopping Cart, store, walmart [post_title] => 1585577141757-5E81FD9DF103B-Mon-Mar30202014-09-33-UTC [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => 1585577141757-5e81fd9df103b-mon-mar30202014-09-33-utc [to_ping] => [pinged] => [post_modified] => 2020-03-31 17:57:02 [post_modified_gmt] => 2020-03-31 17:57:02 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.snapmediaapp.com/product/1585577141757-5e81fd9df103b-mon-mar30202014-09-33-utc/ [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 ) )