Kimber

select * from tb_web_taxonomy with (nolock) where upper(web_url)=? and site = 'sportsman'

SELECT distinct b.style_id
    FROM tb_term_sale_entries b with (nolock) LEFT JOIN tb_term_sales a with (nolock) ON (a.term_sale_id=b.term_sale_id)
    WHERE b.start_date<= '2024-05-20 14:00:00' AND b.end_date >= '2024-05-20 14:00:00' AND b.store_id=10

SELECT * 
	FROM tb_mfg_promo.dbo.tb_pkg a with (nolock)
	INNER JOIN tb_mfg_promo.dbo.tb_pkg_main_items b WITH (NOLOCK)
		ON (a.pkg_id = b.pkg_id) 
	WHERE 
	b.main_id is not NULL 
	and a.start_date<= '05/20/2024 23:59:00' and a.end_date >= '05/20/2024'
	
	and a.site='sportsman'

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock)

SELECT a.styles_web_taxonomy_id,max(a.style_id) as style_id,max(a.style) as style,max(a.web_style) as web_style,max(a.description) as web_desc,max(a.web_desc) as web_description,max(a.web_long_desc) as web_long_desc,max(a.picture_id) as picture_id,max(a.sort_position) as prod_sort_position,max(a.dept) as dept,max(a.typ) as typ,max(a.subtyp_1) as subtyp_1,max(a.subtyp_2) as subtyp_2,max(a.subtyp_3) as subtyp_3,max(a.category_style) as category_style,max(a.web_url) as web_url,max(a.sort_position) as sort_position,max(a.web_taxonomy_id) as web_taxonomy_id,max(a.brand) as brand,max(a.date_entered) as date_entered,max(a.non_invt) as non_invt,max(a.overnight_required) as overnight_required,max(a.is_firearm) as is_firearm,max(a.of1) as of1,max(a.of2) as of2,max(a.of3) as of3,max(a.of4) as of4,max(a.of5) as of5,max(a.of6) as of6,max(a.of7) as of7,max(a.of8) as of8,max(a.of9) as of9,max(a.of10) as of10,max(a.of11) as of11,max(a.of12) as of12,max(a.of13) as of13,max(a.of14) as of14,max(a.of15) as of15,max(a.of16) as of16,max(a.of17) as of17,max(a.of18) as of18,max(a.of19) as of19,max(a.of20) as of20
,min(c.price) as min_price,min(c.store_price) as store_price,max(c.sugg_price) as max_price,min(c.wholesale_price) as vipprice,max(c.qoh) as qoh,max(c.qc) as qc,max(c.qs) as qs,sum(qoh + qc) as available,sum(c.qs - c.qc) as sold,max(c.sugg_price) AS max_sugg_price,avg(CASE WHEN qq.of9 IS NULL OR qq.of9 = '' THEN 0 ELSE c.price / qq.of9 END) as round
	
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
	
	
 WHERE a.style_id > 0 and (a.of20='SPORTS' or a.of20='BOTH' or a.of20 = 'SPORTSOUTDOORS') and a.picture_id > 0
and qq.web_product='Y' and c.store_id=10 
	 and a.brand='KIMBER'
	
	group by a.styles_web_taxonomy_id

select
		distinct
		(style_id) as style_id
		, max(picture_id)
			,	min(min_price) as min_price
			,	max(max_price) as max_price
			,	min(vipprice) as vipprice
			,	max(web_style) as web_style
            ,	max(style) as style
			,	max(web_desc) as web_desc
            ,	max(web_description) as web_description
			,	max(picture_id) as picture_id
            ,	max(web_long_desc) as web_long_desc
			,   max(dept) as dept
			,   max(qoh) as qoh
			,	max(qc) as qc
			,	max(qs) as qs
			,	max(of18) as of18
			,	max(of17) as of17
			,	max(of15) as of15
            ,	max(of12) as of12
    		,	max(of10) as of10
    		,	max(of9) as of9
    		,	max(of8) as of8
			,	max(of7) as of7
    		,	max(of6) as of6
    		,	max(of5) as of5
            ,	max(of4) as of4
    		,	max(of3) as of3
            ,	max(of2) as of2
            ,	max(of1) as of1
			,	max(available) as available
            ,	max(available) as sold
			,   max(typ) as typ
            ,	max(round) as round
            ,	max(non_invt) as non_invt
			,	max(overnight_required) as overnight_required
			,   max(subtyp_1) as subtyp_1
			,   max(subtyp_2) as subtyp_2
			,   max(subtyp_3) as subtyp_3
			,   max(category_style) as category_style
		     ,   max(sort_position) as sort_position
		     ,max(brand) as brand
	,	MAX(max_sugg_price) AS max_sugg_price
    

		from grandgetproducts
		where
		 style_id is not null
            
				and brand='KIMBER'
			


group by Style_id order by

 	available desc, non_invt desc

select * from grandgetproducts
		where
		 picture_id is not null
            
			
				and brand='KIMBER'
			


order by

min_price

select dept, web_url ,sort_position, category_style from tb_web_taxonomy with (nolock) where typ='EMPTY' and dept<>'EMPTY' and dept='' and site = 'sportsman' order by sort_position

select distinct(brand) as brand from GetProducts

select distinct a.spec_value from tb_mfg_promo.dbo.item_spec_values a left join tb_mfg_promo.dbo.item_spec_names b on (a.spec_id=b.spec_id) left join tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id) where b.spec_name = 'Product Line' and c.style_id in (28310,28288,72158,133561,306887,28292,28308,152488,296918,305507,306882,269936,169806,292215,305498,169803,305511,305510,28313,169810,305496,189122,306881,296130,28291,189124,225909,305502,75255,189101,189112,189115,189129,216289,291179,205676,78565,78567,169801,169807,169808,169811,169812,169813,169814,189110,189123,189125,193529,202517,210166,210167,214586,214587,216290,225908,291181,292213,305503,305504,305506,169815,172949,189102,189105,198208,202506,202509,202519,216298,248960,248961,273512,278706,305505,89338,248946,282975,289999,290009,291176,291178,291180,292214,293461,296921,296922,296926,296934,305497,305499,28294,28299,28312,28320,28321,28357,28358,28359,28360,28361,28363,28370,28371,28372,28373,28374,28376,28378,28379,28380,28386,28390,28391,28392,28394,28398,28399,28401,28402,28403,28406,28409,28410,28411,28412,28413,28414,28415,28417,28418,28419,28421,28424,28465,63723,77169,78044,78568,85097,89322,90008,90009,90416,90749,90912,91958,94385,100180,100442,106970,108406,108930,109808,110579,110757,114177,122138,123004,127957,129009,129287,130639,134183,134654,135770,137940,140044,141380,143406,143735,147452,147460,147461,149840,151401,152106,152487,152489,152490,152491,152492,152493,152494,152495,152496,152497,152498,152499,152500,152501,158092,158093,158094,158095,158096,158104,158105,158106,159077,159199,159200,159201,163756,169802,169804,169805,169809,169817,169818,169819,169823,169825,169827,169829,169830,169833,169834,169840,169843,169845,169846,169849,169850,169852,169853,169872,169875,169942,169943,172950,172953,175603,175604,175606,176395,181479,181481,181482,181483,181484,181485,181486,181487,181489,182210,183873,183874,188529,189095,189096,189097,189098,189099,189100,189103,189104,189106,189107,189113,189118,189119,189120,189121,189126,189130,189131,193530,193869,195748,196218,196829,196887,197102,197103,197105,197106,197107,197108,198207,198514,200028,200029,201186,202481,202501,202502,202503,202507,202508,202510,202512,202513,202514,202515,202516,202518,202520,202521,202522,202523,202524,202525,202526,202527,202528,202529,202530,202531,202532,202533,202534,202536,202537,202538,205677,205678,205679,210169,210170,210171,210172,210173,210174,210175,211574,213025,213027,213028,213029,213030,213031,213297,213298,213299,213726,214582,214583,216282,216284,216287,216291,216294,216296,216297,216299,216300,217377,225904,225905,225906,225907,225910,231804,231806,231807,231808,245693,245694,245695,248938,248940,248941,248944,248945,248948,248949,248950,248952,248955,248956,248957,248959,248962,249060,249061,249132,249133,251118,253878,264116,264117,266522,268506,268627,269918,269919,269920,269921,273510,277874,278705,278707,280007,281296,281719,282351,282867,282868,282963,282968,282969,282976,282977,282978,290008,290010,290012,290014,290015,290016,290526,291047,291177,291962,292683,294931,296919,296923,296924,296928,296930,296932,296933,296935,297383,297788,297789,299086,300587)

select distinct (dept) as dept from getproducts1 where brand='KIMBER' group by dept

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='California Guns' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 792 and c.style_id in (28310,28288,72158,133561,306887,28292,28308,152488,296918,305507,306882,269936,169806,292215,305498,169803,305511,305510,28313,169810,305496,189122,306881,296130,28291,189124,225909,305502,75255,189101,189112,189115,189129,216289,291179,205676,78565,78567,169801,169807,169808,169811,169812,169813,169814,189110,189123,189125,193529,202517,210166,210167,214586,214587,216290,225908,291181,292213,305503,305504,305506,169815,172949,189102,189105,198208,202506,202509,202519,216298,248960,248961,273512,278706,305505,89338,248946,282975,289999,290009,291176,291178,291180,292214,293461,296921,296922,296926,296934,305497,305499,28294,28299,28312,28320,28321,28357,28358,28359,28360,28361,28363,28370,28371,28372,28373,28374,28376,28378,28379,28380,28386,28390,28391,28392,28394,28398,28399,28401,28402,28403,28406,28409,28410,28411,28412,28413,28414,28415,28417,28418,28419,28421,28424,28465,63723,77169,78044,78568,85097,89322,90008,90009,90416,90749,90912,91958,94385,100180,100442,106970,108406,108930,109808,110579,110757,114177,122138,123004,127957,129009,129287,130639,134183,134654,135770,137940,140044,141380,143406,143735,147452,147460,147461,149840,151401,152106,152487,152489,152490,152491,152492,152493,152494,152495,152496,152497,152498,152499,152500,152501,158092,158093,158094,158095,158096,158104,158105,158106,159077,159199,159200,159201,163756,169802,169804,169805,169809,169817,169818,169819,169823,169825,169827,169829,169830,169833,169834,169840,169843,169845,169846,169849,169850,169852,169853,169872,169875,169942,169943,172950,172953,175603,175604,175606,176395,181479,181481,181482,181483,181484,181485,181486,181487,181489,182210,183873,183874,188529,189095,189096,189097,189098,189099,189100,189103,189104,189106,189107,189113,189118,189119,189120,189121,189126,189130,189131,193530,193869,195748,196218,196829,196887,197102,197103,197105,197106,197107,197108,198207,198514,200028,200029,201186,202481,202501,202502,202503,202507,202508,202510,202512,202513,202514,202515,202516,202518,202520,202521,202522,202523,202524,202525,202526,202527,202528,202529,202530,202531,202532,202533,202534,202536,202537,202538,205677,205678,205679,210169,210170,210171,210172,210173,210174,210175,211574,213025,213027,213028,213029,213030,213031,213297,213298,213299,213726,214582,214583,216282,216284,216287,216291,216294,216296,216297,216299,216300,217377,225904,225905,225906,225907,225910,231804,231806,231807,231808,245693,245694,245695,248938,248940,248941,248944,248945,248948,248949,248950,248952,248955,248956,248957,248959,248962,249060,249061,249132,249133,251118,253878,264116,264117,266522,268506,268627,269918,269919,269920,269921,273510,277874,278705,278707,280007,281296,281719,282351,282867,282868,282963,282968,282969,282976,282977,282978,290008,290010,290012,290014,290015,290016,290526,291047,291177,291962,292683,294931,296919,296923,296924,296928,296930,296932,296933,296935,297383,297788,297789,299086,300587)

select distinct typ from getproducts1 where dept='California Guns' and brand='KIMBER' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='California Guns' and typ='California Handguns' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 17 and c.style_id in (28310,28288,72158,133561,306887,28292,28308,152488,296918,305507,306882,269936,169806,292215,305498,169803,305511,305510,28313,169810,305496,189122,306881,296130,28291,189124,225909,305502,75255,189101,189112,189115,189129,216289,291179,205676,78565,78567,169801,169807,169808,169811,169812,169813,169814,189110,189123,189125,193529,202517,210166,210167,214586,214587,216290,225908,291181,292213,305503,305504,305506,169815,172949,189102,189105,198208,202506,202509,202519,216298,248960,248961,273512,278706,305505,89338,248946,282975,289999,290009,291176,291178,291180,292214,293461,296921,296922,296926,296934,305497,305499,28294,28299,28312,28320,28321,28357,28358,28359,28360,28361,28363,28370,28371,28372,28373,28374,28376,28378,28379,28380,28386,28390,28391,28392,28394,28398,28399,28401,28402,28403,28406,28409,28410,28411,28412,28413,28414,28415,28417,28418,28419,28421,28424,28465,63723,77169,78044,78568,85097,89322,90008,90009,90416,90749,90912,91958,94385,100180,100442,106970,108406,108930,109808,110579,110757,114177,122138,123004,127957,129009,129287,130639,134183,134654,135770,137940,140044,141380,143406,143735,147452,147460,147461,149840,151401,152106,152487,152489,152490,152491,152492,152493,152494,152495,152496,152497,152498,152499,152500,152501,158092,158093,158094,158095,158096,158104,158105,158106,159077,159199,159200,159201,163756,169802,169804,169805,169809,169817,169818,169819,169823,169825,169827,169829,169830,169833,169834,169840,169843,169845,169846,169849,169850,169852,169853,169872,169875,169942,169943,172950,172953,175603,175604,175606,176395,181479,181481,181482,181483,181484,181485,181486,181487,181489,182210,183873,183874,188529,189095,189096,189097,189098,189099,189100,189103,189104,189106,189107,189113,189118,189119,189120,189121,189126,189130,189131,193530,193869,195748,196218,196829,196887,197102,197103,197105,197106,197107,197108,198207,198514,200028,200029,201186,202481,202501,202502,202503,202507,202508,202510,202512,202513,202514,202515,202516,202518,202520,202521,202522,202523,202524,202525,202526,202527,202528,202529,202530,202531,202532,202533,202534,202536,202537,202538,205677,205678,205679,210169,210170,210171,210172,210173,210174,210175,211574,213025,213027,213028,213029,213030,213031,213297,213298,213299,213726,214582,214583,216282,216284,216287,216291,216294,216296,216297,216299,216300,217377,225904,225905,225906,225907,225910,231804,231806,231807,231808,245693,245694,245695,248938,248940,248941,248944,248945,248948,248949,248950,248952,248955,248956,248957,248959,248962,249060,249061,249132,249133,251118,253878,264116,264117,266522,268506,268627,269918,269919,269920,269921,273510,277874,278705,278707,280007,281296,281719,282351,282867,282868,282963,282968,282969,282976,282977,282978,290008,290010,290012,290014,290015,290016,290526,291047,291177,291962,292683,294931,296919,296923,296924,296928,296930,296932,296933,296935,297383,297788,297789,299086,300587)

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='KIMBER' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Conversion Kits' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Gun Parts' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Magazines' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Speedloaders' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 18 and c.style_id in (28310,28288,72158,133561,306887,28292,28308,152488,296918,305507,306882,269936,169806,292215,305498,169803,305511,305510,28313,169810,305496,189122,306881,296130,28291,189124,225909,305502,75255,189101,189112,189115,189129,216289,291179,205676,78565,78567,169801,169807,169808,169811,169812,169813,169814,189110,189123,189125,193529,202517,210166,210167,214586,214587,216290,225908,291181,292213,305503,305504,305506,169815,172949,189102,189105,198208,202506,202509,202519,216298,248960,248961,273512,278706,305505,89338,248946,282975,289999,290009,291176,291178,291180,292214,293461,296921,296922,296926,296934,305497,305499,28294,28299,28312,28320,28321,28357,28358,28359,28360,28361,28363,28370,28371,28372,28373,28374,28376,28378,28379,28380,28386,28390,28391,28392,28394,28398,28399,28401,28402,28403,28406,28409,28410,28411,28412,28413,28414,28415,28417,28418,28419,28421,28424,28465,63723,77169,78044,78568,85097,89322,90008,90009,90416,90749,90912,91958,94385,100180,100442,106970,108406,108930,109808,110579,110757,114177,122138,123004,127957,129009,129287,130639,134183,134654,135770,137940,140044,141380,143406,143735,147452,147460,147461,149840,151401,152106,152487,152489,152490,152491,152492,152493,152494,152495,152496,152497,152498,152499,152500,152501,158092,158093,158094,158095,158096,158104,158105,158106,159077,159199,159200,159201,163756,169802,169804,169805,169809,169817,169818,169819,169823,169825,169827,169829,169830,169833,169834,169840,169843,169845,169846,169849,169850,169852,169853,169872,169875,169942,169943,172950,172953,175603,175604,175606,176395,181479,181481,181482,181483,181484,181485,181486,181487,181489,182210,183873,183874,188529,189095,189096,189097,189098,189099,189100,189103,189104,189106,189107,189113,189118,189119,189120,189121,189126,189130,189131,193530,193869,195748,196218,196829,196887,197102,197103,197105,197106,197107,197108,198207,198514,200028,200029,201186,202481,202501,202502,202503,202507,202508,202510,202512,202513,202514,202515,202516,202518,202520,202521,202522,202523,202524,202525,202526,202527,202528,202529,202530,202531,202532,202533,202534,202536,202537,202538,205677,205678,205679,210169,210170,210171,210172,210173,210174,210175,211574,213025,213027,213028,213029,213030,213031,213297,213298,213299,213726,214582,214583,216282,216284,216287,216291,216294,216296,216297,216299,216300,217377,225904,225905,225906,225907,225910,231804,231806,231807,231808,245693,245694,245695,248938,248940,248941,248944,248945,248948,248949,248950,248952,248955,248956,248957,248959,248962,249060,249061,249132,249133,251118,253878,264116,264117,266522,268506,268627,269918,269919,269920,269921,273510,277874,278705,278707,280007,281296,281719,282351,282867,282868,282963,282968,282969,282976,282977,282978,290008,290010,290012,290014,290015,290016,290526,291047,291177,291962,292683,294931,296919,296923,296924,296928,296930,296932,296933,296935,297383,297788,297789,299086,300587)

select distinct typ from getproducts1 where dept='Firearms' and brand='KIMBER' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Blemished Guns' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Bolt Action Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Revolvers' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Used Gun Collection' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 795 and c.style_id in (28310,28288,72158,133561,306887,28292,28308,152488,296918,305507,306882,269936,169806,292215,305498,169803,305511,305510,28313,169810,305496,189122,306881,296130,28291,189124,225909,305502,75255,189101,189112,189115,189129,216289,291179,205676,78565,78567,169801,169807,169808,169811,169812,169813,169814,189110,189123,189125,193529,202517,210166,210167,214586,214587,216290,225908,291181,292213,305503,305504,305506,169815,172949,189102,189105,198208,202506,202509,202519,216298,248960,248961,273512,278706,305505,89338,248946,282975,289999,290009,291176,291178,291180,292214,293461,296921,296922,296926,296934,305497,305499,28294,28299,28312,28320,28321,28357,28358,28359,28360,28361,28363,28370,28371,28372,28373,28374,28376,28378,28379,28380,28386,28390,28391,28392,28394,28398,28399,28401,28402,28403,28406,28409,28410,28411,28412,28413,28414,28415,28417,28418,28419,28421,28424,28465,63723,77169,78044,78568,85097,89322,90008,90009,90416,90749,90912,91958,94385,100180,100442,106970,108406,108930,109808,110579,110757,114177,122138,123004,127957,129009,129287,130639,134183,134654,135770,137940,140044,141380,143406,143735,147452,147460,147461,149840,151401,152106,152487,152489,152490,152491,152492,152493,152494,152495,152496,152497,152498,152499,152500,152501,158092,158093,158094,158095,158096,158104,158105,158106,159077,159199,159200,159201,163756,169802,169804,169805,169809,169817,169818,169819,169823,169825,169827,169829,169830,169833,169834,169840,169843,169845,169846,169849,169850,169852,169853,169872,169875,169942,169943,172950,172953,175603,175604,175606,176395,181479,181481,181482,181483,181484,181485,181486,181487,181489,182210,183873,183874,188529,189095,189096,189097,189098,189099,189100,189103,189104,189106,189107,189113,189118,189119,189120,189121,189126,189130,189131,193530,193869,195748,196218,196829,196887,197102,197103,197105,197106,197107,197108,198207,198514,200028,200029,201186,202481,202501,202502,202503,202507,202508,202510,202512,202513,202514,202515,202516,202518,202520,202521,202522,202523,202524,202525,202526,202527,202528,202529,202530,202531,202532,202533,202534,202536,202537,202538,205677,205678,205679,210169,210170,210171,210172,210173,210174,210175,211574,213025,213027,213028,213029,213030,213031,213297,213298,213299,213726,214582,214583,216282,216284,216287,216291,216294,216296,216297,216299,216300,217377,225904,225905,225906,225907,225910,231804,231806,231807,231808,245693,245694,245695,248938,248940,248941,248944,248945,248948,248949,248950,248952,248955,248956,248957,248959,248962,249060,249061,249132,249133,251118,253878,264116,264117,266522,268506,268627,269918,269919,269920,269921,273510,277874,278705,278707,280007,281296,281719,282351,282867,282868,282963,282968,282969,282976,282977,282978,290008,290010,290012,290014,290015,290016,290526,291047,291177,291962,292683,294931,296919,296923,296924,296928,296930,296932,296933,296935,297383,297788,297789,299086,300587)

select distinct typ from getproducts1 where dept='Guns with Color' and brand='KIMBER' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='Pistols with Color' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='Rifles with Color' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 2181 and c.style_id in (28310,28288,72158,133561,306887,28292,28308,152488,296918,305507,306882,269936,169806,292215,305498,169803,305511,305510,28313,169810,305496,189122,306881,296130,28291,189124,225909,305502,75255,189101,189112,189115,189129,216289,291179,205676,78565,78567,169801,169807,169808,169811,169812,169813,169814,189110,189123,189125,193529,202517,210166,210167,214586,214587,216290,225908,291181,292213,305503,305504,305506,169815,172949,189102,189105,198208,202506,202509,202519,216298,248960,248961,273512,278706,305505,89338,248946,282975,289999,290009,291176,291178,291180,292214,293461,296921,296922,296926,296934,305497,305499,28294,28299,28312,28320,28321,28357,28358,28359,28360,28361,28363,28370,28371,28372,28373,28374,28376,28378,28379,28380,28386,28390,28391,28392,28394,28398,28399,28401,28402,28403,28406,28409,28410,28411,28412,28413,28414,28415,28417,28418,28419,28421,28424,28465,63723,77169,78044,78568,85097,89322,90008,90009,90416,90749,90912,91958,94385,100180,100442,106970,108406,108930,109808,110579,110757,114177,122138,123004,127957,129009,129287,130639,134183,134654,135770,137940,140044,141380,143406,143735,147452,147460,147461,149840,151401,152106,152487,152489,152490,152491,152492,152493,152494,152495,152496,152497,152498,152499,152500,152501,158092,158093,158094,158095,158096,158104,158105,158106,159077,159199,159200,159201,163756,169802,169804,169805,169809,169817,169818,169819,169823,169825,169827,169829,169830,169833,169834,169840,169843,169845,169846,169849,169850,169852,169853,169872,169875,169942,169943,172950,172953,175603,175604,175606,176395,181479,181481,181482,181483,181484,181485,181486,181487,181489,182210,183873,183874,188529,189095,189096,189097,189098,189099,189100,189103,189104,189106,189107,189113,189118,189119,189120,189121,189126,189130,189131,193530,193869,195748,196218,196829,196887,197102,197103,197105,197106,197107,197108,198207,198514,200028,200029,201186,202481,202501,202502,202503,202507,202508,202510,202512,202513,202514,202515,202516,202518,202520,202521,202522,202523,202524,202525,202526,202527,202528,202529,202530,202531,202532,202533,202534,202536,202537,202538,205677,205678,205679,210169,210170,210171,210172,210173,210174,210175,211574,213025,213027,213028,213029,213030,213031,213297,213298,213299,213726,214582,214583,216282,216284,216287,216291,216294,216296,216297,216299,216300,217377,225904,225905,225906,225907,225910,231804,231806,231807,231808,245693,245694,245695,248938,248940,248941,248944,248945,248948,248949,248950,248952,248955,248956,248957,248959,248962,249060,249061,249132,249133,251118,253878,264116,264117,266522,268506,268627,269918,269919,269920,269921,273510,277874,278705,278707,280007,281296,281719,282351,282867,282868,282963,282968,282969,282976,282977,282978,290008,290010,290012,290014,290015,290016,290526,291047,291177,291962,292683,294931,296919,296923,296924,296928,296930,296932,296933,296935,297383,297788,297789,299086,300587)

select distinct typ from getproducts1 where dept='Kimber' and brand='KIMBER' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='1911 Pistols' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='Evo SP' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='Kimber Factory Magazines' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='Micro 380' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='Micro 9' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='Revolvers' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='Solo Pistols' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Kimber' and typ='Special Editions' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Personal Defense' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 2222 and c.style_id in (28310,28288,72158,133561,306887,28292,28308,152488,296918,305507,306882,269936,169806,292215,305498,169803,305511,305510,28313,169810,305496,189122,306881,296130,28291,189124,225909,305502,75255,189101,189112,189115,189129,216289,291179,205676,78565,78567,169801,169807,169808,169811,169812,169813,169814,189110,189123,189125,193529,202517,210166,210167,214586,214587,216290,225908,291181,292213,305503,305504,305506,169815,172949,189102,189105,198208,202506,202509,202519,216298,248960,248961,273512,278706,305505,89338,248946,282975,289999,290009,291176,291178,291180,292214,293461,296921,296922,296926,296934,305497,305499,28294,28299,28312,28320,28321,28357,28358,28359,28360,28361,28363,28370,28371,28372,28373,28374,28376,28378,28379,28380,28386,28390,28391,28392,28394,28398,28399,28401,28402,28403,28406,28409,28410,28411,28412,28413,28414,28415,28417,28418,28419,28421,28424,28465,63723,77169,78044,78568,85097,89322,90008,90009,90416,90749,90912,91958,94385,100180,100442,106970,108406,108930,109808,110579,110757,114177,122138,123004,127957,129009,129287,130639,134183,134654,135770,137940,140044,141380,143406,143735,147452,147460,147461,149840,151401,152106,152487,152489,152490,152491,152492,152493,152494,152495,152496,152497,152498,152499,152500,152501,158092,158093,158094,158095,158096,158104,158105,158106,159077,159199,159200,159201,163756,169802,169804,169805,169809,169817,169818,169819,169823,169825,169827,169829,169830,169833,169834,169840,169843,169845,169846,169849,169850,169852,169853,169872,169875,169942,169943,172950,172953,175603,175604,175606,176395,181479,181481,181482,181483,181484,181485,181486,181487,181489,182210,183873,183874,188529,189095,189096,189097,189098,189099,189100,189103,189104,189106,189107,189113,189118,189119,189120,189121,189126,189130,189131,193530,193869,195748,196218,196829,196887,197102,197103,197105,197106,197107,197108,198207,198514,200028,200029,201186,202481,202501,202502,202503,202507,202508,202510,202512,202513,202514,202515,202516,202518,202520,202521,202522,202523,202524,202525,202526,202527,202528,202529,202530,202531,202532,202533,202534,202536,202537,202538,205677,205678,205679,210169,210170,210171,210172,210173,210174,210175,211574,213025,213027,213028,213029,213030,213031,213297,213298,213299,213726,214582,214583,216282,216284,216287,216291,216294,216296,216297,216299,216300,217377,225904,225905,225906,225907,225910,231804,231806,231807,231808,245693,245694,245695,248938,248940,248941,248944,248945,248948,248949,248950,248952,248955,248956,248957,248959,248962,249060,249061,249132,249133,251118,253878,264116,264117,266522,268506,268627,269918,269919,269920,269921,273510,277874,278705,278707,280007,281296,281719,282351,282867,282868,282963,282968,282969,282976,282977,282978,290008,290010,290012,290014,290015,290016,290526,291047,291177,291962,292683,294931,296919,296923,296924,296928,296930,296932,296933,296935,297383,297788,297789,299086,300587)

select distinct typ from getproducts1 where dept='Personal Defense' and brand='KIMBER' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Personal Defense' and typ='Pepper Spray' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url from tb_web_taxonomy with (nolock) where dept='' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202507 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202507 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:02' and
end_date >= 'May 20, 2024 14:56:02'
and store_id=10 and style_id=202507

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202507 
and (a.start_date<= 'May 20, 2024 14:56:02' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:02'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202507  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202507 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202508 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202508 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:02' and
end_date >= 'May 20, 2024 14:56:02'
and store_id=10 and style_id=202508

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202508 
and (a.start_date<= 'May 20, 2024 14:56:02' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:02'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202508  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202508 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202510 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202510 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:02' and
end_date >= 'May 20, 2024 14:56:02'
and store_id=10 and style_id=202510

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202510 
and (a.start_date<= 'May 20, 2024 14:56:02' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:02'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202510  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202510 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202512 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202512 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:02' and
end_date >= 'May 20, 2024 14:56:02'
and store_id=10 and style_id=202512

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202512 
and (a.start_date<= 'May 20, 2024 14:56:02' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:02'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202512  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202512 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202513 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202513 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:02' and
end_date >= 'May 20, 2024 14:56:02'
and store_id=10 and style_id=202513

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202513 
and (a.start_date<= 'May 20, 2024 14:56:02' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:02'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202513  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202513 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202514 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202514 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:02' and
end_date >= 'May 20, 2024 14:56:02'
and store_id=10 and style_id=202514

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202514 
and (a.start_date<= 'May 20, 2024 14:56:02' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:02'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202514  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202514 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202515 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202515 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:02' and
end_date >= 'May 20, 2024 14:56:02'
and store_id=10 and style_id=202515

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202515 
and (a.start_date<= 'May 20, 2024 14:56:02' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:02'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202515  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202515 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202516 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202516 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:02' and
end_date >= 'May 20, 2024 14:56:02'
and store_id=10 and style_id=202516

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202516 
and (a.start_date<= 'May 20, 2024 14:56:02' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:02'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202516  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202516 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202518 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202518 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202518

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202518 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202518  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202518 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202520 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202520 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202520

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202520 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202520  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202520 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202521 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202521 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202521

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202521 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202521  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202521 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202522 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202522 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202522

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202522 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202522  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202522 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202523 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202523 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202523

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202523 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202523  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202523 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202524 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202524 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202524

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202524 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202524  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202524 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202525 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202525 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202525

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202525 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202525  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202525 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202526 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202526 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202526

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202526 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202526  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202526 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202527 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202527 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202527

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202527 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202527  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202527 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 202528 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 202528 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:03' and
end_date >= 'May 20, 2024 14:56:03'
and store_id=10 and style_id=202528

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 202528 
and (a.start_date<= 'May 20, 2024 14:56:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:03'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=202528  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=202528 and status='A' and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF; CFGLOBALS=urltoken%3DCFID%23%3D8512%26CFTOKEN%23%3Dee4e16a37a9175ca%2DE994AB14%2D9E00%2D26DC%2D57DC0CDC4B6F2AFF%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A56%3A01%27%7D%23hitcount%3D79%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A55%3A18%27%7D%23cftoken%3Dee4e16a37a9175ca%2DE994AB14%2D9E00%2D26DC%2D57DC0CDC4B6F2AFF%23cfid%3D8512%23; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-8512; CT_U=2359; PRD_U=131922%2C85; LAST_NAME=; USERNAME=; CUSTOMER_ID=; EMAIL=; PASSWORD=; FIRST_NAME=
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/category.cfm/CurrentPage/17/sportsman/EMPTY/brand/KIMBER
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/17/sportsman/EMPTY/brand/KIMBER
PATH_TRANSLATED=E:\inetpub\wwwroot\category.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=8512
cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
hitcount=79
lastvisit={ts '2024-05-20 14:56:01'}
timecreated={ts '2024-05-20 14:55:18'}
urltoken=CFID=8512&CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF

Cookie Variables:
CFGLOBALS=urltoken=CFID#=8512&CFTOKEN#=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF#lastvisit={ts '2024-05-20 14:56:01'}#hitcount=79#timecreated={ts '2024-05-20 14:55:18'}#cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF#cfid=8512#
CFID=8512
CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
CT_U=2359
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=131922,85
USERNAME=

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=8512
cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
cs=/category.cfm/CurrentPage/17/sportsman/EMPTY/brand/KIMBER
displaycount=18
employeeloggedin=N
executed=YES
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_8512_ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
strarray=Array (0)
urltoken=CFID=8512&CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF

URL Parameters:
CLEARANCE=
CurrentPage=17
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PAGETYPE=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WEB_TAXONOMY_ID=
WHATSNEW=
brand=KIMBER
sportsman=EMPTY