SELECT imageFilename,imageAlt FROM mp_productsImages WHERE productId='2600' 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 Alligator (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 round badge displays a green alligator with a its mouth open and it's sharp teeth on display. The 'gator's n tail on the right and head on the left.
SELECT price,discount,discountStart,discountEnd FROM mp_products WHERE productId='2600'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='2600' AND ('2020-07-07' BETWEEN c.discount_start_date AND c.discount_end_date)

Price: $ 1.50 CAD

Alligator (Iron On)

Item No: E828
Dimensions: 2" w x 2" h

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

Reviews

They arrived and they are wonderful!! I can't wait for the girls and leaders to see them on Sunday at the end of camp. Thanks so much for all your help.

--Daniela E.
Surrey, BC

We received so many wonderful comments from our guests who loved the patches!

--Denine Peterson
Regina, SK

This company you have developed is incredibly amazing! You have an easy ordering system, speedy delivery, reasonable prices and more selection than Girl Guides will ever have! You take the dedication to hand sign the receipts and even bundle everything together. With both of these orders I have been incredibly impressed! My last order I placed consisted of 80 pieces, and you had them in stock and in my hands within days! Due to your valued and incredible service, I will be telling all of my fellow guiders [of] your website and my unending recommendations for them to order crests! Thank you for your dedicated work! I look forward to ordering from you again shortly!

--Melanie King 7th Waterloo Girl Guides Leader

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='2600' 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='2101'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='1678'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='2320'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='2526'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='2656'SELECT itemno AS alsoItemno, product AS alsoProduct, image AS alsoImage, alt_info AS alsoAltInfo, productFolder AS alsoProductFolder FROM mp_products WHERE productId='1963'

Customers who bought Alligator also purchased

E665
ES1377
E708
E786
E848
E594
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