| 1 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 9) AND (`type` = 'A'))) OR (((`series_id` = 10) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 2 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'C'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 3 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'L'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 4 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'J'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 5 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'G'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 6 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 7 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'R'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 8 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'E'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 10 |
| 9 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'C'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 11 |
| 10 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'L'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 11 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'J'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 10 |
| 12 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'G'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 10 |
| 13 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 14 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'R'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 15 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'E'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 10 |
| 16 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'C'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 17 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'L'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 10 |
| 18 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'J'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 19 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'G'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 20 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 21 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'R'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 10 |
| 22 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'E'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 23 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'C'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 24 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'L'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 11 |
| 25 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'J'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 2 | 2 | 11 |
| 26 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'G'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 27 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 2 | 2 | 11 |
| 28 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'R'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 11 |
| 29 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'E'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 30 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'L'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 31 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'J'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 2 | 2 | 11 |
| 32 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'G'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 33 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 1 | 1 | 11 |
| 34 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'R'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 1 | 1 | 11 |
| 35 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'E'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 11 |
| 36 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'L'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 37 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'J'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 38 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'G'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 11 |
| 39 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 40 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'R'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 41 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'E'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 42 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 11 |
| 43 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 44 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 45 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 46 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 33) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 47 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'N'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 48 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'V'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 49 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z007'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 50 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z001'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 51 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'T'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 52 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z009'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 53 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z011'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 54 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z005'))) OR (((`series_id` = 17) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 55 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'N'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 56 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'V'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 11 |
| 57 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z007'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 58 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z001'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 59 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'T'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 12 |
| 60 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z009'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 16 |
| 61 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z011'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 13 |
| 62 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z005'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 12 |
| 63 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'N'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 64 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'V'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 11 |
| 65 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z007'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 66 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z001'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 67 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'T'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 10 |
| 68 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z009'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 69 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z011'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 70 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z005'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 71 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'N'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 2 | 2 | 11 |
| 72 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'V'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 73 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z007'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 11 |
| 74 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z001'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 10 |
| 75 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'T'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 10 |
| 76 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z009'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 10 |
| 77 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z011'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 10 |
| 78 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z005'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 10 |
| 79 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z007'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 10 |
| 80 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z001'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 10 |
| 81 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'T'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 10 |
| 82 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z009'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 83 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z011'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 84 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'Z005'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 10 |
| 85 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z13'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 86 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z16'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 87 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z14'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 88 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z59'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 89 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z15'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 90 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z18'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 91 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z09'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 92 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z14'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 10 |
| 93 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z07'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 94 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z18'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 95 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z21'))) OR (((`series_id` = 466) AND (`type` = 'Z09')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 96 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z13'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 97 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z16'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 1 | 1 | 11 |
| 98 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z14'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 99 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z59'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 1 | 1 | 11 |
| 100 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z15'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 101 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 465) AND (`type` = 'Z18'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 1 | 1 | 11 |
| 102 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z21'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 1 | 1 | 11 |
| 103 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z09'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 11 |
| 104 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z14'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 105 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z07'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 2 | 2 | 17 |
| 106 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 497) AND (`type` = 'Z18'))) OR (((`series_id` = 466) AND (`type` = 'Z15')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 11 |
| 107 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 483) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 108 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 483) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 109 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 491) AND (`type` = 'Z05')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 11 |
| 110 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 491) AND (`type` = 'Z04')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 11 |
| 111 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 112 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 481) AND (`type` = 'M')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 13 |
| 113 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 11 |
| 114 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 485) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 9 | 9 | 10 |
| 115 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 116 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 489) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 10 |
| 117 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 10 |
| 118 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'P'))) OR (((`series_id` = 493) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 11 |
| 119 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 483) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 10 |
| 120 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 483) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 13 |
| 121 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 491) AND (`type` = 'Z05')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 13 |
| 122 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 491) AND (`type` = 'Z04')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 11 |
| 123 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 124 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 481) AND (`type` = 'M')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 125 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 126 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 485) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 5 | 5 | 13 |
| 127 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 6 | 6 | 13 |
| 128 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 489) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 10 |
| 129 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 10 |
| 130 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'M'))) OR (((`series_id` = 493) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 7 | 7 | 11 |
| 131 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 483) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 132 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 483) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 11 |
| 133 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 491) AND (`type` = 'Z05')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 9 | 9 | 11 |
| 134 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 491) AND (`type` = 'Z04')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 9 | 9 | 11 |
| 135 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 14 |
| 136 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 481) AND (`type` = 'M')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 12 |
| 137 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 9 | 9 | 11 |
| 138 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 485) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 9 | 9 | 10 |
| 139 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 13 |
| 140 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 489) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 10 | 10 | 10 |
| 141 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 8 | 8 | 11 |
| 142 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 482) AND (`type` = 'N'))) OR (((`series_id` = 493) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 9 | 9 | 11 |
| 143 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 486) AND (`type` = 'Z06'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 144 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 486) AND (`type` = 'Z06'))) OR (((`series_id` = 481) AND (`type` = 'M')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 15 |
| 145 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 486) AND (`type` = 'Z06'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 146 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 486) AND (`type` = 'Z06'))) OR (((`series_id` = 485) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 147 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 486) AND (`type` = 'Z06'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 148 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 486) AND (`type` = 'Z06'))) OR (((`series_id` = 489) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 149 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 486) AND (`type` = 'Z06'))) OR (((`series_id` = 493) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 14 |
| 150 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 486) AND (`type` = 'Z06'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 151 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 483) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 152 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 483) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 10 |
| 153 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 491) AND (`type` = 'Z05')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 14 |
| 154 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 491) AND (`type` = 'Z04')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 155 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 156 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 481) AND (`type` = 'M')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 157 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 158 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 485) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 15 |
| 159 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 22 |
| 160 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 489) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 161 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 12 |
| 162 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 490) AND (`type` = 'Z12'))) OR (((`series_id` = 493) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 12 |
| 163 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 488) AND (`type` = 'D'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 164 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 488) AND (`type` = 'D'))) OR (((`series_id` = 481) AND (`type` = 'M')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 165 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 488) AND (`type` = 'D'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 13 |
| 166 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 488) AND (`type` = 'D'))) OR (((`series_id` = 485) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 167 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 488) AND (`type` = 'D'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 168 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 488) AND (`type` = 'D'))) OR (((`series_id` = 489) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 169 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 488) AND (`type` = 'D'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 170 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 488) AND (`type` = 'D'))) OR (((`series_id` = 493) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 171 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 483) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 172 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 483) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 173 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 491) AND (`type` = 'Z05')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 174 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 491) AND (`type` = 'Z04')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 13 |
| 175 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 176 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 481) AND (`type` = 'M')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 13 | 13 | 11 |
| 177 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 13 |
| 178 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 485) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 179 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 180 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 489) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 12 |
| 181 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 12 | 12 | 11 |
| 182 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 492) AND (`type` = 'Z14'))) OR (((`series_id` = 493) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 11 | 11 | 11 |
| 183 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 23) AND (`type` = 'Z02'))) OR (((`series_id` = 24) AND (`type` = 'Z10')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 15 |
| 184 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 23) AND (`type` = 'Z04'))) OR (((`series_id` = 24) AND (`type` = 'Z10')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 185 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 23) AND (`type` = 'Z02'))) OR (((`series_id` = 24) AND (`type` = 'Z14')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 11 |
| 186 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 23) AND (`type` = 'Z04'))) OR (((`series_id` = 24) AND (`type` = 'Z14')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 187 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 23) AND (`type` = 'Z02'))) OR (((`series_id` = 24) AND (`type` = 'Z16')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 3 | 3 | 11 |
| 188 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 23) AND (`type` = 'Z04'))) OR (((`series_id` = 24) AND (`type` = 'Z16')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 189 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 23) AND (`type` = 'Z02'))) OR (((`series_id` = 24) AND (`type` = 'Z18')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 190 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 23) AND (`type` = 'Z04'))) OR (((`series_id` = 24) AND (`type` = 'Z18')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 4 | 4 | 11 |
| 191 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 16) AND (`type` = 'C'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | | 2 | 2 | 12 |
| 192 | SELECT `Mating`.`id`, `Mating`.`type`, `Mating`.`height`, `Mating`.`mating_min`, `Mating`.`mating_max`, `Mating`.`series_id1`, `Mating`.`series_id2`, `Mating`.`type1`, `Mating`.`type2`, `Mating`.`created`, `Mating`.`modified` FROM `irisoweb_test`.`matings` AS `Mating` WHERE id = (164) | | 1 | 1 | 1 |
| 193 | SELECT `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE 嵌合部ピッチ = '0.635' AND 販売分類 = 'Preferred' AND ((((`series_id` = 16) AND (`type` = 'J'))) OR (((`series_id` = 17) AND (`type` = 'L')))) GROUP BY 極数 ORDER BY CAST(極数 as signed) ASC, `Product`.`odr` DESC | | 2 | 2 | 11 |
| 194 | SELECT `Product`.`id`, `Product`.`status`, `Product`.`name`, `Product`.`y_name`, `Product`.`series_id`, `Product`.`type`, `Product`.`html`, `Product`.`html_en`, `Product`.`html_zh`, `Product`.`html_ko`, `Product`.`title`, `Product`.`title_en`, `Product`.`title_zh`, `Product`.`title_ko`, `Product`.`description`, `Product`.`description_en`, `Product`.`description_zh`, `Product`.`description_ko`, `Product`.`keyword_en`, `Product`.`keyword_zh`, `Product`.`keyword_ko`, `Product`.`file_title1`, `Product`.`file_title2`, `Product`.`file_title3`, `Product`.`file_title4`, `Product`.`file_title5`, `Product`.`file_title6`, `Product`.`file_title7`, `Product`.`file_title8`, `Product`.`file_role1`, `Product`.`file_role2`, `Product`.`file_role3`, `Product`.`file_role4`, `Product`.`file_role5`, `Product`.`file_role6`, `Product`.`file_role7`, `Product`.`file_role8`, `Product`.`file_count1`, `Product`.`file_count2`, `Product`.`file_count3`, `Product`.`file_count4`, `Product`.`file_count5`, `Product`.`file_count6`, `Product`.`file_count7`, `Product`.`file_count8`, `Product`.`alternative`, `Product`.`combination`, `Product`.`ambiguous`, `Product`.`buy_url1`, `Product`.`buy_url2`, `Product`.`buy_url3`, `Product`.`buy_url4`, `Product`.`buy_text1`, `Product`.`buy_text2`, `Product`.`buy_text3`, `Product`.`buy_text4`, `Product`.`odr`, `Product`.`created`, `Product`.`modified`, `Product`.`販売分類`, `Product`.`コネクタ形状`, `Product`.`嵌合方向`, `Product`.`基板実装部ピッチ`, `Product`.`接点部めっき`, `Product`.`めっき厚`, `Product`.`本体長さ（ピッチ方向）`, `Product`.`本体幅（奥行き）`, `Product`.`インピーダンス整合`, `Product`.`接触抵抗`, `Product`.`使用温度範囲（Min）`, `Product`.`RoHS2`, `Product`.`ハロゲンフリー`, `Product`.`2点接点`, `Product`.`位置決めボス`, `Product`.`グランド`, `Product`.`ワイドスライダー`, `Product`.`誘い込み用フランジ`, `Product`.`吸着用キャップ`, `Product`.`吸着用テープ`, `Product`.`可動量X`, `Product`.`可動量Y`, `Product`.`有効嵌合長Z`, `Product`.`振幅許容範囲`, `Product`.`挿抜回数`, `Product`.`ロック方式`, `Product`.`カード抜け防止機能`, `Product`.`梱包形態`, `Product`.`梱包数量`, `Product`.`基板実装方法`, `Product`.`嵌合形状`, `Product`.`実装形態`, `Product`.`接点方向`, `Product`.`嵌合部ピッチ`, `Product`.`極数`, `Product`.`伝送規格`, `Product`.`本体高さ`, `Product`.`定格電圧（AC）`, `Product`.`定格電圧（DC）`, `Product`.`定格電流`, `Product`.`耐電圧`, `Product`.`使用温度範囲（Max）`, `Product`.`抜け上寸法`, `Product`.`抜け下寸法`, `Product`.`配列`, `Product`.`フローティング機能`, `Product`.`伝送速度（代表参考値）`, `Product`.`共振振幅量`, (CONCAT_WS( " ", IFNULL(`Product`.`name`,""), IFNULL(`Product`.`y_name`,""), IFNULL(`Product`.`file_title1`,""), IFNULL(`Product`.`file_title2`,""), IFNULL(`Product`.`file_title3`,""), IFNULL(`Product`.`file_title4`, ""), IFNULL(`Product`.`file_title5`, ""), IFNULL(`Product`.`file_title6`, ""), IFNULL(`Product`.`file_title7`, ""), IFNULL(`Product`.`file_title8`, ""), IFNULL(`Product`.`alternative`,""), IFNULL(`Product`.`combination`,""), IFNULL(`Product`.`ambiguous`,""))) AS `Product__keyword`, `Series`.`id`, `Series`.`name` FROM `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE ((((`Product`.`series_id` = 16) AND (`Product`.`type` = 'J'))) OR (((`Product`.`series_id` = 17) AND (`Product`.`type` = 'L')))) AND 嵌合部ピッチ = '0.635' AND 販売分類 = 'Preferred' AND 極数 = '30' GROUP BY `Product`.`series_id` ORDER BY CAST(極数 as signed) ASC LIMIT 2 | | 1 | 1 | 48 |
| 195 | SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb_test`.`downloads` AS `Download` WHERE `user_id` IS NULL AND `type` = 'FAV' AND `Download`.`product_id` = (153) | | 0 | 0 | 6 |
| 196 | SELECT `AddField`.`id`, `AddField`.`name_ko` FROM `irisoweb_test`.`add_fields` AS `AddField` WHERE 1 = 1 ORDER BY `odr` ASC | | 48 | 48 | 3 |
| 197 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (153) | | 2 | 2 | 6 |
| 198 | SELECT `Product`.`id`, `Product`.`status`, `Product`.`name`, `Product`.`y_name`, `Product`.`series_id`, `Product`.`type`, `Product`.`html`, `Product`.`html_en`, `Product`.`html_zh`, `Product`.`html_ko`, `Product`.`title`, `Product`.`title_en`, `Product`.`title_zh`, `Product`.`title_ko`, `Product`.`description`, `Product`.`description_en`, `Product`.`description_zh`, `Product`.`description_ko`, `Product`.`keyword_en`, `Product`.`keyword_zh`, `Product`.`keyword_ko`, `Product`.`file_title1`, `Product`.`file_title2`, `Product`.`file_title3`, `Product`.`file_title4`, `Product`.`file_title5`, `Product`.`file_title6`, `Product`.`file_title7`, `Product`.`file_title8`, `Product`.`file_role1`, `Product`.`file_role2`, `Product`.`file_role3`, `Product`.`file_role4`, `Product`.`file_role5`, `Product`.`file_role6`, `Product`.`file_role7`, `Product`.`file_role8`, `Product`.`file_count1`, `Product`.`file_count2`, `Product`.`file_count3`, `Product`.`file_count4`, `Product`.`file_count5`, `Product`.`file_count6`, `Product`.`file_count7`, `Product`.`file_count8`, `Product`.`alternative`, `Product`.`combination`, `Product`.`ambiguous`, `Product`.`buy_url1`, `Product`.`buy_url2`, `Product`.`buy_url3`, `Product`.`buy_url4`, `Product`.`buy_text1`, `Product`.`buy_text2`, `Product`.`buy_text3`, `Product`.`buy_text4`, `Product`.`odr`, `Product`.`created`, `Product`.`modified`, `Product`.`販売分類`, `Product`.`コネクタ形状`, `Product`.`嵌合方向`, `Product`.`基板実装部ピッチ`, `Product`.`接点部めっき`, `Product`.`めっき厚`, `Product`.`本体長さ（ピッチ方向）`, `Product`.`本体幅（奥行き）`, `Product`.`インピーダンス整合`, `Product`.`接触抵抗`, `Product`.`使用温度範囲（Min）`, `Product`.`RoHS2`, `Product`.`ハロゲンフリー`, `Product`.`2点接点`, `Product`.`位置決めボス`, `Product`.`グランド`, `Product`.`ワイドスライダー`, `Product`.`誘い込み用フランジ`, `Product`.`吸着用キャップ`, `Product`.`吸着用テープ`, `Product`.`可動量X`, `Product`.`可動量Y`, `Product`.`有効嵌合長Z`, `Product`.`振幅許容範囲`, `Product`.`挿抜回数`, `Product`.`ロック方式`, `Product`.`カード抜け防止機能`, `Product`.`梱包形態`, `Product`.`梱包数量`, `Product`.`基板実装方法`, `Product`.`嵌合形状`, `Product`.`実装形態`, `Product`.`接点方向`, `Product`.`嵌合部ピッチ`, `Product`.`極数`, `Product`.`伝送規格`, `Product`.`本体高さ`, `Product`.`定格電圧（AC）`, `Product`.`定格電圧（DC）`, `Product`.`定格電流`, `Product`.`耐電圧`, `Product`.`使用温度範囲（Max）`, `Product`.`抜け上寸法`, `Product`.`抜け下寸法`, `Product`.`配列`, `Product`.`フローティング機能`, `Product`.`伝送速度（代表参考値）`, `Product`.`共振振幅量`, (CONCAT_WS( " ", IFNULL(`Product`.`name`,""), IFNULL(`Product`.`y_name`,""), IFNULL(`Product`.`file_title1`,""), IFNULL(`Product`.`file_title2`,""), IFNULL(`Product`.`file_title3`,""), IFNULL(`Product`.`file_title4`, ""), IFNULL(`Product`.`file_title5`, ""), IFNULL(`Product`.`file_title6`, ""), IFNULL(`Product`.`file_title7`, ""), IFNULL(`Product`.`file_title8`, ""), IFNULL(`Product`.`alternative`,""), IFNULL(`Product`.`combination`,""), IFNULL(`Product`.`ambiguous`,""))) AS `Product__keyword`, `Series`.`id`, `Series`.`name` FROM `irisoweb_test`.`products` AS `Product` LEFT JOIN `irisoweb_test`.`series` AS `Series` ON (`Product`.`series_id` = `Series`.`id`) WHERE ((((`Product`.`series_id` = 16) AND (`Product`.`type` = 'J'))) OR (((`Product`.`series_id` = 17) AND (`Product`.`type` = 'L')))) AND 嵌合部ピッチ = '0.635' AND 販売分類 = 'Preferred' AND 極数 = '40' GROUP BY `Product`.`series_id` ORDER BY CAST(極数 as signed) ASC LIMIT 2 | | 1 | 1 | 49 |
| 199 | SELECT `Download`.`id`, `Download`.`type`, `Download`.`user_id`, `Download`.`series_id`, `Download`.`product_id`, `Download`.`field`, `Download`.`ip_address`, `Download`.`domain`, `Download`.`created`, `Download`.`modified` FROM `irisoweb_test`.`downloads` AS `Download` WHERE `user_id` IS NULL AND `type` = 'FAV' AND `Download`.`product_id` = (79) | | 0 | 0 | 6 |
| 200 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `irisoweb_test`.`attachments` AS `Attachment` WHERE `model` = 'Product' AND model_id = (79) | | 3 | 3 | 6 |
