0001 SELECT DISTINCT (i_product_name)
0002 FROM item i1
0003 WHERE i_manufact_id BETWEEN 738 AND 738 + 40
0004 AND (SELECT count(*) AS item_cnt
0005 FROM item
0006 WHERE (i_manufact = i1.i_manufact AND
0007 ((i_category = 'Women' AND
0008 (i_color = 'powder' OR i_color = 'khaki') AND
0009 (i_units = 'Ounce' OR i_units = 'Oz') AND
0010 (i_size = 'medium' OR i_size = 'extra large')
0011 ) OR
0012 (i_category = 'Women' AND
0013 (i_color = 'brown' OR i_color = 'honeydew') AND
0014 (i_units = 'Bunch' OR i_units = 'Ton') AND
0015 (i_size = 'N/A' OR i_size = 'small')
0016 ) OR
0017 (i_category = 'Men' AND
0018 (i_color = 'floral' OR i_color = 'deep') AND
0019 (i_units = 'N/A' OR i_units = 'Dozen') AND
0020 (i_size = 'petite' OR i_size = 'large')
0021 ) OR
0022 (i_category = 'Men' AND
0023 (i_color = 'light' OR i_color = 'cornflower') AND
0024 (i_units = 'Box' OR i_units = 'Pound') AND
0025 (i_size = 'medium' OR i_size = 'extra large')
0026 ))) OR
0027 (i_manufact = i1.i_manufact AND
0028 ((i_category = 'Women' AND
0029 (i_color = 'midnight' OR i_color = 'snow') AND
0030 (i_units = 'Pallet' OR i_units = 'Gross') AND
0031 (i_size = 'medium' OR i_size = 'extra large')
0032 ) OR
0033 (i_category = 'Women' AND
0034 (i_color = 'cyan' OR i_color = 'papaya') AND
0035 (i_units = 'Cup' OR i_units = 'Dram') AND
0036 (i_size = 'N/A' OR i_size = 'small')
0037 ) OR
0038 (i_category = 'Men' AND
0039 (i_color = 'orange' OR i_color = 'frosted') AND
0040 (i_units = 'Each' OR i_units = 'Tbl') AND
0041 (i_size = 'petite' OR i_size = 'large')
0042 ) OR
0043 (i_category = 'Men' AND
0044 (i_color = 'forest' OR i_color = 'ghost') AND
0045 (i_units = 'Lb' OR i_units = 'Bundle') AND
0046 (i_size = 'medium' OR i_size = 'extra large')
0047 )))) > 0
0048 ORDER BY i_product_name
0049 LIMIT 100