SELECT *, 'd' AS gal_source FROM gallery LEFT OUTER JOIN sizes ON size_id = gal_size LEFT OUTER JOIN leadtimes ON lead_id = gal_leadtime LEFT OUTER JOIN groups ON grp_id = gal_group LEFT OUTER JOIN group_types ON grp_gt = gt_id WHERE gal_active = 'true' AND ( OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '43') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '27') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '5') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '1') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '2') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '3') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '32') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '41') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '4') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '45') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '46') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '25') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '37') (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '36') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '7') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '9') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '15') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '13') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '26') ) AND (gal_group = '36' OR gal_group = '37' OR gal_group = '41' OR gal_group = '45' OR gal_group = '46' OR gal_group = '25' OR gal_group = '3' OR gal_group = '32' OR gal_group = '5' OR gal_group = '27' OR gal_group = '43' OR gal_group = '1' OR gal_group = '2' OR gal_group = '7' OR gal_group = '13' OR gal_group = '4' OR gal_group = '9' OR gal_group = '15' OR gal_group = '26') ORDER BY gal_id DESC,gal_title DESC SELECT DISTINCT gal_size, size_name, size_name_metric, size_id FROM gallery INNER JOIN groups ON grp_id = gal_group INNER JOIN sizes ON size_id = gal_size WHERE gal_active = 'true' AND (size_dist = 'classic') AND ( OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '43') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '27') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '5') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '1') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '2') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '3') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '32') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '41') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '4') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '45') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '46') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '25') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '37') (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '36') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '7') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '9') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '15') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '13') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '26') ) AND (gal_group = '36' OR gal_group = '37' OR gal_group = '41' OR gal_group = '45' OR gal_group = '46' OR gal_group = '25' OR gal_group = '3' OR gal_group = '32' OR gal_group = '5' OR gal_group = '27' OR gal_group = '43' OR gal_group = '1' OR gal_group = '2' OR gal_group = '7' OR gal_group = '13' OR gal_group = '4' OR gal_group = '9' OR gal_group = '15' OR gal_group = '26') ORDER BY size_name;