SELECT imageFilename,imageAlt FROM mp_productsImages WHERE productId='2058' ORDER BY imageOrderSELECT notice_desc FROM jl_notice WHERE notice_start <=CURDATE() AND notice_end >=CURDATE() ORDER BY notice_start DESCSELECT category_id FROM jl_category WHERE parent_id='0' AND (category_type = 'All' OR category_type = 'Embroidered Patch') AND display='Yes' ORDER BY category_folderSELECT productId FROM mp_products WHERE crestLocation='157' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='157' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='12' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='12' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='17' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='17' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='1' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='1' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='28' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='28' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='177' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='177' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='164' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='164' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='21' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='21' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='2' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='2' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='82' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='82' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='40' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='40' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='54' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='54' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='3' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='3' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='33' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='33' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='29' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='29' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='22' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='22' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='36' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='36' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='59' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='59' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='141' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='141' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='160' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='160' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='37' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='37' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='35' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='35' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='172' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='172' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='39' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='39' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='109' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='109' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='5' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='5' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='4' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='4' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='27' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='27' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='13' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='13' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='6' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='6' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='7' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='7' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='61' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='61' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='197' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='197' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='178' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='178' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='32' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='32' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='167' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='167' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='169' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='169' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='58' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='58' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='110' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='110' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='25' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='25' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='180' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='180' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='16' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='16' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='8' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='8' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='24' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='24' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='135' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='135' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='52' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='52' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='18' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='18' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='70' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='70' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='168' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='168' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='158' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='158' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='19' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='19' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='68' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='68' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='189' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='189' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='9' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='9' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='14' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='14' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='20' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='20' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='10' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='10' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='69' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='69' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='44' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='44' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='15' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='15' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='193' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='193' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='23' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='23' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='30' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='30' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='190' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='190' AND p.pactive='1'SELECT productId FROM mp_products WHERE crestLocation='179' AND pactive!=2SELECT p.productId FROM mp_productsCategories AS c LEFT JOIN mp_products AS p USING (productId) WHERE c.category_id='179' AND p.pactive='1'SELECT category_id,category_name,category_folder FROM jl_category WHERE parent_id='0' AND (category_type = 'All' OR category_type = 'Embroidered Patch') AND display='Yes' AND category_id IN (157,12,17,1,28,177,164,21,2,82,40,54,3,33,29,22,36,59,141,160,37,35,172,39,109,5,4,27,13,6,7,61,197,178,32,167,169,58,110,25,180,16,8,24,135,52,18,70,168,158,19,68,189,9,14,20,10,69,44,15,193,23,30,190,179) ORDER BY category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='157' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='12' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='17' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='1' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='28' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='177' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='164' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='21' AND display='Yes' ORDER BY category_name,category_folderSELECT productId FROM mp_products WHERE crestLocation='185' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='186' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='187' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='188' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='183' AND pactive!=2SELECT category_id as subCategoryId,category_name as subCategory,category_folder as subCategoryFolder FROM jl_category WHERE category_id IN (185,186,187,188,183) AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='2' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='82' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='40' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='54' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='3' AND display='Yes' ORDER BY category_name,category_folderSELECT productId FROM mp_products WHERE crestLocation='56' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='55' AND pactive!=2SELECT category_id as subCategoryId,category_name as subCategory,category_folder as subCategoryFolder FROM jl_category WHERE category_id IN (56,55) AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='33' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='29' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='22' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='36' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='59' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='141' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='160' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='37' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='35' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='172' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='39' AND display='Yes' ORDER BY category_name,category_folderSELECT productId FROM mp_products WHERE crestLocation='182' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='107' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='51' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='38' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='53' AND pactive!=2SELECT category_id as subCategoryId,category_name as subCategory,category_folder as subCategoryFolder FROM jl_category WHERE category_id IN (182,107,51,38) AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='109' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='5' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='4' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='27' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='13' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='6' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='7' AND display='Yes' ORDER BY category_name,category_folderSELECT productId FROM mp_products WHERE crestLocation='46' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='45' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='48' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='139' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='184' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='47' AND pactive!=2SELECT productId FROM mp_products WHERE crestLocation='173' AND pactive!=2SELECT category_id as subCategoryId,category_name as subCategory,category_folder as subCategoryFolder FROM jl_category WHERE category_id IN (46,45,48,139,184,47,173) AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='61' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='197' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='178' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='32' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='167' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='169' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='58' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='110' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='25' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='180' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='16' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='8' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='24' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='135' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='52' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='18' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='70' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='168' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='158' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='19' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='68' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='189' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='9' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='14' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='20' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='10' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='69' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='44' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='15' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='193' AND display='Yes' ORDER BY category_name,category_folderSELECT productId FROM mp_products WHERE crestLocation='194' AND pactive!=2SELECT category_id as subCategoryId,category_name as subCategory,category_folder as subCategoryFolder FROM jl_category WHERE category_id IN (194) AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='23' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='30' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='190' AND display='Yes' ORDER BY category_name,category_folderSELECT category_id as subCategoryId FROM jl_category WHERE parent_id='179' AND display='Yes' ORDER BY category_name,category_folder Rainbow Letter - S (Iron On) Embroidered Patch by E-Patches & Crests
SELECT notice_desc FROM jl_notice WHERE notice_start <=CURDATE() AND notice_end >=CURDATE() ORDER BY notice_start DESC

During July and August, we will be shipping orders Tuesday's and Thursday's. If you have an urgent request, please give us a call and we'll do our best to accommodate.

Canada Post is behind with their deliveries so shipping times have been extended to what's listed on our shipping page. If you require an urgent shipment, please either add a Comment to your order or call our office at 1-887-335-8904. Learn about our COVID-19 procedures. We wish everyone good health!

We also stand in support of racial equality and against brutality in all its forms.

This patch is the alphabet letter S. From top down the colour changes from red to orange to yellow to light green to dark green to light blue to dark blue to purple.
SELECT price,discount,discountStart,discountEnd FROM mp_products WHERE productId='2058'SELECT promoDiscountAmount FROM dg_promos WHERE promocode='0'SELECT c.discount FROM jl_category As c LEFT JOIN mp_productsCategories AS pc ON pc.category_id=c.category_id WHERE pc.productId='2058' AND ('2020-07-07' BETWEEN c.discount_start_date AND c.discount_end_date)

Price: $ 1.50 CAD

Rainbow Letter - S (Iron On)

Item No: ES2200RB-S
Dimensions: 1.8" w x 2" h

A, B, C’s and 1, 2, 3’s! Collect our Rainbow Letters and Numbers patches to spell out your name, add a group, troop or unit numbers, or create fun words, the possibilities are endless! These are perfect for labeling and customizing any camp blanket or poncho.

SELECT linkedProducts FROM mp_productsProducts WHERE productId='2058'SELECT review,reviewerName,numStars FROM ec_reviews WHERE approved='Yes' AND productId='2058'SELECT review,reviewerName,reviewerAddress FROM ec_reviews WHERE approved='Yes' AND productId='0' ORDER BY RAND() LIMIT 3

Reviews

Cool store! I liked how helpful the staff are, [they] helped us right out.

--William Moore

We've just received our: Diabetes Awareness x2 March/December Fluffy Owl Girl Guiding UK Campfire Flame Thank you so much for the fast delivery and the great badge choices. I'm definitely ordering from you again as your prices are very cheap and I want to get your business badge for myself. (We have two blankets as we have two guiders). I will definitely recommend you in the future.

--Zoe Merrylees
Hull - Yorkshire

Thanks so much for sending the order with Kathy. That so made my day. The Sparks are off to the Stettler train this Sat. They will be receiving 5 crests on this trip. It will be so exciting. They love getting the crests. Thanks so much for an amazing site to purchase crests.

--Joanne S
Innisfail, AB

Add Your Review

 

SELECT DISTINCT(p2.productId) AS foundProductId FROM mp_ordersProducts AS p1 JOIN mp_ordersProducts AS p2 ON p1.orderId = p2.orderId AND p1.productId <> p2.productId AND p1.productId='2058' LEFT JOIN mp_products AS p ON p.productId=p2.productId WHERE p.pactive='1' ORDER BY RAND() LIMIT 0,6SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='1981'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='2466'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='2615'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='438'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='1327'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='2055'

Customers who bought Rainbow Letter - S also purchased

E603
E754
E834
S2299
ES1310
ES2200RB-P
Share Your Idea

Can't Find it?

Do you have something that you would like see on a badge? Add your crest design suggestions to our wish list.

Suggest a Patch

Total

Checkout