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 ( 0 = 1 OR sm_term_relationships.term_taxonomy_id IN (2273) ) 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, 20WP_Query Object ( [query] => Array ( [product_tag] => work-in-covid-19-time ) [query_vars] => Array ( [product_tag] => work-in-covid-19-time [error] => [m] => [p] => 0 [post_parent] => [subpost] => [subpost_id] => [attachment] => [attachment_id] => 0 [name] => [pagename] => [page_id] => 0 [second] => [minute] => [hour] => [day] => 0 [monthnum] => 0 [year] => 0 [w] => 0 [category_name] => [tag] => [cat] => [tag_id] => [author] => [author_name] => [feed] => [tb] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [category__in] => Array ( ) [category__not_in] => Array ( ) [category__and] => Array ( ) [post__in] => Array ( ) [post__not_in] => Array ( ) [post_name__in] => Array ( ) [tag__in] => Array ( ) [tag__not_in] => Array ( ) [tag__and] => Array ( ) [tag_slug__in] => Array ( ) [tag_slug__and] => Array ( ) [post_parent__in] => Array ( ) [post_parent__not_in] => Array ( ) [author__in] => Array ( ) [author__not_in] => Array ( ) [orderby] => rand [order] => [meta_query] => Array ( [0] => Array ( [key] => _for_sale [value] => yes [compare] => = ) ) [tax_query] => Array ( [relation] => OR [0] => Array ( [taxonomy] => product_tag [field] => id [terms] => Array ( [0] => [1] => ) [operator] => IN ) ) [wc_query] => product_query [posts_per_page] => 20 [post_type] => product [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [lazy_load_term_meta] => 1 [update_post_meta_cache] => 1 [nopaging] => [comments_per_page] => 50 [no_found_rows] => ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [relation] => OR [0] => Array ( [taxonomy] => product_tag [terms] => Array ( [0] => [1] => ) [field] => id [operator] => IN [include_children] => 1 ) [1] => Array ( [taxonomy] => product_tag [terms] => Array ( [0] => work-in-covid-19-time ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => OR [table_aliases:protected] => Array ( [0] => sm_term_relationships ) [queried_terms] => Array ( [product_tag] => Array ( [terms] => Array ( [0] => [1] => ) [field] => id ) ) [primary_table] => sm_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [key] => _for_sale [value] => yes [compare] => = ) [relation] => OR ) [relation] => AND [meta_table] => sm_postmeta [meta_id_column] => post_id [primary_table] => sm_posts [primary_id_column] => ID [table_aliases:protected] => Array ( [0] => sm_postmeta ) [clauses:protected] => Array ( [sm_postmeta] => Array ( [key] => _for_sale [value] => yes [compare] => = [alias] => sm_postmeta [cast] => CHAR ) ) [has_or_relation:protected] => ) [date_query] => [queried_object] => WP_Term Object ( [term_id] => 2273 [name] => work in covid-19 time [slug] => work-in-covid-19-time [term_group] => 0 [term_taxonomy_id] => 2273 [taxonomy] => product_tag [description] => [parent] => 0 [count] => 1 [filter] => raw ) [queried_object_id] => 2273 [request] => 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 ( 0 = 1 OR sm_term_relationships.term_taxonomy_id IN (2273) ) 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 [post_count] => 0 [current_post] => -1 [in_the_loop] => [comment_count] => 0 [current_comment] => -1 [found_posts] => 0 [max_num_pages] => 0 [max_num_comment_pages] => 0 [is_single] => [is_preview] => [is_page] => [is_archive] => 1 [is_date] => [is_year] => [is_month] => [is_day] => [is_time] => [is_author] => [is_category] => [is_tag] => [is_tax] => 1 [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_404] => [is_embed] => [is_paged] => [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_posts_page] => [is_post_type_archive] => [query_vars_hash:WP_Query:private] => b1bacb620b61a1a50110c5f344084faf [query_vars_changed:WP_Query:private] => 1 [thumbnails_cached] => [stopwords:WP_Query:private] => [compat_fields:WP_Query:private] => Array ( [0] => query_vars_hash [1] => query_vars_changed ) [compat_methods:WP_Query:private] => Array ( [0] => init_query_flags [1] => parse_tax_query ) )
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 ( 0 = 1 OR sm_term_relationships.term_taxonomy_id IN (2273) ) 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