SELECT DISTINCT p.post_name AS slug FROM wp_posts p INNER JOIN wp_term_relationships tr ON tr.object_id = p.ID INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy IN ('product_cat','sc_category','category','sc_product_category') INNER JOIN wp_terms t ON t.term_id = tt.term_id AND t.slug IN ('classic-literature-coloring-books','coloring-books-for-kids') WHERE p.post_type = 'sc_product' AND p.post_status = 'publish' ORDER BY RAND() LIMIT 1