QuickAdd Item No: 1BR-5350 $73.95 Dri-Duck Dri-Duck Adult Motion Soft-Shell Jacket QuickAdd Item No: 1EW-CCDC $13.25 Pinnacle Textile Male Double Breasted Pearl Button Chef Coat QuickAdd Item No: 1F-48014 $165.95 5.11 Tactical Reversible High-Vis Parka QuickAdd Item No: 1F-48033 $259.95 5.11 Tactical 3-in-1 Reversible High-Vis Parka QuickAdd Item No: 1F-48037 $192.99 5.11 Tactical Hi-Vis Reversible Jacket QuickAdd Item No: 1F-48073 $302.99 5.11 Tactical Men's Responder Parka Hi Vis QuickAdd Item No: 1F-48125 $152.99 5.11 Tactical Long Reversible High Vis Rain Coat - ANSI Class 3 QuickAdd Item No: 1F-49022 $42.99 5.11 Tactical 5 Point Breakaway Vest QuickAdd Item No: 1HR-90211 $125.00 Harmony Raincoat All Weather Cotton/Poly QuickAdd Item No: 1PA-SRJ754 $62.00 Challenger Safety Challenger Jacket with Reflective Taping QuickAdd Item No: 2-BIKEH $25.00 Brainy Deal Bike Helmet QuickAdd Item No: 2311 $9.95 W. Alboum Co. Inc. Rain Caps

SELECT `Products`.* FROM `ProductsSearch` inner JOIN `Products` ON `Products`.`ID` = `ProductsSearch`.`ID_Products` WHERE (`ID_Categories` = '28' Or `ID_Categories` = '29' Or `ID_Categories` = '30' Or `ID_Categories` = '31' Or `ID_Categories` = '32') AND (`Products`.`Availability` = 1) GROUP BY `ProductsSearch`.`ID_Products` ORDER BY `Products`.`ProductID` Asc