Array
(
    [where] =>  AND ( 
  tgs_term_relationships.term_taxonomy_id IN (761,762,763,764,765,766,767,768,769,770,771,1857,2179,2180,2181,2286,2291,2292,2293,2330,2331,2332,2527,2565,2566,2590,2639,2640,2676,2678,2752,2754,2755,2989,2990,3337) 
  AND 
  tt1.term_taxonomy_id IN (2779,3105,2935,979,1714,3122,3388) 
  AND 
  tgs_posts.ID NOT IN (
				SELECT object_id
				FROM tgs_term_relationships
				WHERE term_taxonomy_id IN (8)
			) 
  AND 
  tt2.term_taxonomy_id IN (761,762,763,764,765,766,767,768,769,770,771,1857,2179,2180,2181,2286,2291,2292,2293,2330,2331,2332,2527,2565,2566,2590,2639,2640,2676,2678,2752,2754,2755,2989,2990,3337)
) AND ((tgs_posts.post_type = 'product' AND (tgs_posts.post_status = 'publish' OR tgs_posts.post_status = 'acf-disabled' OR tgs_posts.post_status = 'unread' OR tgs_posts.post_status = 'read')))
    [groupby] => tgs_posts.ID
    [join] =>  LEFT JOIN tgs_term_relationships ON (tgs_posts.ID = tgs_term_relationships.object_id)  LEFT JOIN tgs_term_relationships AS tt1 ON (tgs_posts.ID = tt1.object_id)  LEFT JOIN tgs_term_relationships AS tt2 ON (tgs_posts.ID = tt2.object_id)
        LEFT JOIN tgs_term_relationships AS sub_tr 
            ON tgs_posts.ID = sub_tr.object_id
        LEFT JOIN tgs_term_taxonomy AS sub_tt 
            ON sub_tr.term_taxonomy_id = sub_tt.term_taxonomy_id
            AND sub_tt.taxonomy = 'product_cat'
            AND sub_tt.parent = 761
    
    [orderby] => 
        CASE 
            WHEN sub_tt.term_id = 2292 THEN 0 WHEN sub_tt.term_id = 766 THEN 1 WHEN sub_tt.term_id = 762 THEN 2 WHEN sub_tt.term_id = 2565 THEN 3 WHEN sub_tt.term_id = 769 THEN 4 WHEN sub_tt.term_id = 2180 THEN 5 WHEN sub_tt.term_id = 2331 THEN 6
            ELSE 999 
        END,
        tgs_posts.menu_order ASC
    
    [distinct] => 
    [fields] => tgs_posts.*
    [limits] => LIMIT 0, 36
)