WITH my_fav_ledy AS (
SELECT                nails        AS my_fav_naughty_fingers,
                      lipstick     AS sexy_limps,
                      dress        AS undressed_it_for_me,
                      heeled_shoes AS you_are_so_sexy_babe
FROM                  ll.outlook
MAKE(colour='RED') IN (
                      my_fav_naughty_fingers,
                      sexy_limps,
                      undressed_it_for_me,
                      you_are_so_sexy_babe
                      )
UNDER JOIN            ll.underwear AS you_are_so_gorgeous ON 
                                      ll.whatever_und_colour = my.bananza_goes_up
                    )
SELECT   * AS ':*',
         ll.lovely_smile
FROM     my_fav_ledy        
WHERE    CAST(my_fav_ledy AS she_makes_me_crazy) IN (dance_with_me AND strong_hot_hugs)
GROUP BY my_fav_ledy.fav_places
LIMIT    (bedroom,
          table,
          floor)