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<br>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
        )

)