Hi Point

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<= '2026-04-13 16:00:00' AND b.end_date >= '2026-04-13 16:00:00' AND b.store_id in ('10','32')

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<= '04/13/2026 23:59:00' and a.end_date >= '04/13/2026'
	
	and a.site='sportsman'

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock)
	where site is NULL

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 in ('10', 32)
	
	
	
	
	 and a.brand='hi point'
	
	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 grandgetproductshipoint
		where
		 style_id is not null
            
				and brand='HI POINT'
			


group by Style_id order by

 	available desc, non_invt desc

select * from grandgetproductshipoint
		where
		 picture_id is not null
            
			
				and brand='HI POINT'
			


order by

min_price

select distinct (dept) as dept from getproducts1 where brand='HI POINT' 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 (324225,23550,199531,23551,208009,23549,172668,189776,189773,23547,295107,287194,323326,355918,357497,323335,355921,339370,23539,189756,292147,344610,355815,361869,362035,23521,23527,23529,23541,23552,76136,85564,88897,94027,102273,114183,115358,116933,121790,139955,150211,151558,155547,158388,159528,161357,161358,161638,161639,168060,169719,172483,172484,172485,173617,173619,173622,183650,183652,183653,189750,189751,189752,189753,189754,189755,189757,189759,189760,189765,189766,189767,189768,189770,189771,189774,189777,189778,189779,189780,189781,189782,189784,189786,195627,196379,196381,197694,197695,197696,197697,197698,197699,197700,197701,197702,197703,199244,199530,199850,202913,204208,204209,204210,205560,207854,208893,209448,216853,216854,221051,225677,226013,226014,228172,228173,228174,228175,231773,231799,231800,231801,231802,246720,246722,246723,246726,246728,246729,247540,247661,247669,247670,247671,247673,247675,247676,247677,247678,247679,247680,247783,247790,247814,247826,247830,247831,247833,248937,249342,249419,249423,249424,249425,255988,256020,264311,267505,267643,267663,267684,267774,267775,267776,267777,267778,267779,267780,267781,267782,267784,267798,267800,267801,267802,267814,267816,267817,267818,267819,267820,267821,267824,267825,267826,267828,267829,267830,267831,267832,267833,267835,267836,267837,267838,267839,267841,267848,267849,267850,267852,267853,267854,267857,267858,267859,267860,267862,267863,267864,268221,268765,268767,269461,269463,269464,277334,277857,277858,277907,277908,277909,278382,278389,279939,279954,279963,279985,279992,279997,280172,280830,280845,281331,281383,281416,281657,281736,281954,283201,283229,283351,283359,284747,284748,285143,285146,285155,285156,285158,285166,285172,285181,285185,285187,285493,285498,285510,285513,285514,285771,285785,285796,285804,285838,285840,285848,285964,287898,287899,287912,287925,287999,288033,288115,288151,288185,289136,289387,289438,289458,289818,289819,289820,290742,290750,290752,290754,291059,291253,291254,291255,291256,291257,291740,292058,292072,292073,292146,294876,294897,294899,294911,294929,294952,294954,295109,295110,296107,296471,296548,296549,296551,296552,296843,297403,298062,298701,298718,298719,298720,298739,298747,298816,298933,298993,298999,299029,299289,300720,301155,301158,301551,303655,305063,305103,305117,305592,305597,308277,309311,309625,309626,311093,312425,316672,316715,319851,322500,322523,322553,322618,323327,323328,323333,323334,323336,323337,324736,324793,324794,324795,324796,324798,324800,324801,324804,324807,324808,324809,324810,324811,324812,324813,324814,324815,324816,324817,324818,324819,324822,324823,324825,324841,325008,326318,326624,326646,330955,330957,330999,331965,331967,332096,332314,332328,332639,332777,332868,333042,333623,333935,334111,336222,336224,336241,336256,336257,336259,336262,336290,336291,336292,336391,336478,336481,336762,337361,337384,337405,337409,337421,337620,337622,337623,337624,337625,337627,337847,338052,338061,338642,338650,338652,338656,338776,338826,339368,339371,340700,340717,342232,343137,343139,343142,343143,343145,343148,343151,343152,343154,343158,344034,344037,344038,344267,344499,344611,345150,345151,345153,345154,345155,345157,345159,345161,345163,346834,346865,346866,346867,346869,346871,346873,346875,346876,346877,346944,346992,347279,348052,348055,348056,348057,348502,348509,348919,348920,351994,351995,351996,352211,352707,353774,353825,353835,353836,353837,353838,353839,354158,354425,354439,354446,354943,355223,355224,355225,355226,355227,355228,355923,356017,356018,356026,356027,356028,356645,356659,357498,358269,358270,358272,358273,358275,358280,358281,358282,358283,358284,359224,360269,360280,360285,360288,360290,360706,360970,361010,361734,362045)

select distinct typ from getproducts1 where dept='California Guns' and brand='HI POINT' 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 Rifles' 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 (324225,23550,199531,23551,208009,23549,172668,189776,189773,23547,295107,287194,323326,355918,357497,323335,355921,339370,23539,189756,292147,344610,355815,361869,362035,23521,23527,23529,23541,23552,76136,85564,88897,94027,102273,114183,115358,116933,121790,139955,150211,151558,155547,158388,159528,161357,161358,161638,161639,168060,169719,172483,172484,172485,173617,173619,173622,183650,183652,183653,189750,189751,189752,189753,189754,189755,189757,189759,189760,189765,189766,189767,189768,189770,189771,189774,189777,189778,189779,189780,189781,189782,189784,189786,195627,196379,196381,197694,197695,197696,197697,197698,197699,197700,197701,197702,197703,199244,199530,199850,202913,204208,204209,204210,205560,207854,208893,209448,216853,216854,221051,225677,226013,226014,228172,228173,228174,228175,231773,231799,231800,231801,231802,246720,246722,246723,246726,246728,246729,247540,247661,247669,247670,247671,247673,247675,247676,247677,247678,247679,247680,247783,247790,247814,247826,247830,247831,247833,248937,249342,249419,249423,249424,249425,255988,256020,264311,267505,267643,267663,267684,267774,267775,267776,267777,267778,267779,267780,267781,267782,267784,267798,267800,267801,267802,267814,267816,267817,267818,267819,267820,267821,267824,267825,267826,267828,267829,267830,267831,267832,267833,267835,267836,267837,267838,267839,267841,267848,267849,267850,267852,267853,267854,267857,267858,267859,267860,267862,267863,267864,268221,268765,268767,269461,269463,269464,277334,277857,277858,277907,277908,277909,278382,278389,279939,279954,279963,279985,279992,279997,280172,280830,280845,281331,281383,281416,281657,281736,281954,283201,283229,283351,283359,284747,284748,285143,285146,285155,285156,285158,285166,285172,285181,285185,285187,285493,285498,285510,285513,285514,285771,285785,285796,285804,285838,285840,285848,285964,287898,287899,287912,287925,287999,288033,288115,288151,288185,289136,289387,289438,289458,289818,289819,289820,290742,290750,290752,290754,291059,291253,291254,291255,291256,291257,291740,292058,292072,292073,292146,294876,294897,294899,294911,294929,294952,294954,295109,295110,296107,296471,296548,296549,296551,296552,296843,297403,298062,298701,298718,298719,298720,298739,298747,298816,298933,298993,298999,299029,299289,300720,301155,301158,301551,303655,305063,305103,305117,305592,305597,308277,309311,309625,309626,311093,312425,316672,316715,319851,322500,322523,322553,322618,323327,323328,323333,323334,323336,323337,324736,324793,324794,324795,324796,324798,324800,324801,324804,324807,324808,324809,324810,324811,324812,324813,324814,324815,324816,324817,324818,324819,324822,324823,324825,324841,325008,326318,326624,326646,330955,330957,330999,331965,331967,332096,332314,332328,332639,332777,332868,333042,333623,333935,334111,336222,336224,336241,336256,336257,336259,336262,336290,336291,336292,336391,336478,336481,336762,337361,337384,337405,337409,337421,337620,337622,337623,337624,337625,337627,337847,338052,338061,338642,338650,338652,338656,338776,338826,339368,339371,340700,340717,342232,343137,343139,343142,343143,343145,343148,343151,343152,343154,343158,344034,344037,344038,344267,344499,344611,345150,345151,345153,345154,345155,345157,345159,345161,345163,346834,346865,346866,346867,346869,346871,346873,346875,346876,346877,346944,346992,347279,348052,348055,348056,348057,348502,348509,348919,348920,351994,351995,351996,352211,352707,353774,353825,353835,353836,353837,353838,353839,354158,354425,354439,354446,354943,355223,355224,355225,355226,355227,355228,355923,356017,356018,356026,356027,356028,356645,356659,357498,358269,358270,358272,358273,358275,358280,358281,358282,358283,358284,359224,360269,360280,360285,360288,360290,360706,360970,361010,361734,362045)

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='HI POINT' 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='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, 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 (324225,23550,199531,23551,208009,23549,172668,189776,189773,23547,295107,287194,323326,355918,357497,323335,355921,339370,23539,189756,292147,344610,355815,361869,362035,23521,23527,23529,23541,23552,76136,85564,88897,94027,102273,114183,115358,116933,121790,139955,150211,151558,155547,158388,159528,161357,161358,161638,161639,168060,169719,172483,172484,172485,173617,173619,173622,183650,183652,183653,189750,189751,189752,189753,189754,189755,189757,189759,189760,189765,189766,189767,189768,189770,189771,189774,189777,189778,189779,189780,189781,189782,189784,189786,195627,196379,196381,197694,197695,197696,197697,197698,197699,197700,197701,197702,197703,199244,199530,199850,202913,204208,204209,204210,205560,207854,208893,209448,216853,216854,221051,225677,226013,226014,228172,228173,228174,228175,231773,231799,231800,231801,231802,246720,246722,246723,246726,246728,246729,247540,247661,247669,247670,247671,247673,247675,247676,247677,247678,247679,247680,247783,247790,247814,247826,247830,247831,247833,248937,249342,249419,249423,249424,249425,255988,256020,264311,267505,267643,267663,267684,267774,267775,267776,267777,267778,267779,267780,267781,267782,267784,267798,267800,267801,267802,267814,267816,267817,267818,267819,267820,267821,267824,267825,267826,267828,267829,267830,267831,267832,267833,267835,267836,267837,267838,267839,267841,267848,267849,267850,267852,267853,267854,267857,267858,267859,267860,267862,267863,267864,268221,268765,268767,269461,269463,269464,277334,277857,277858,277907,277908,277909,278382,278389,279939,279954,279963,279985,279992,279997,280172,280830,280845,281331,281383,281416,281657,281736,281954,283201,283229,283351,283359,284747,284748,285143,285146,285155,285156,285158,285166,285172,285181,285185,285187,285493,285498,285510,285513,285514,285771,285785,285796,285804,285838,285840,285848,285964,287898,287899,287912,287925,287999,288033,288115,288151,288185,289136,289387,289438,289458,289818,289819,289820,290742,290750,290752,290754,291059,291253,291254,291255,291256,291257,291740,292058,292072,292073,292146,294876,294897,294899,294911,294929,294952,294954,295109,295110,296107,296471,296548,296549,296551,296552,296843,297403,298062,298701,298718,298719,298720,298739,298747,298816,298933,298993,298999,299029,299289,300720,301155,301158,301551,303655,305063,305103,305117,305592,305597,308277,309311,309625,309626,311093,312425,316672,316715,319851,322500,322523,322553,322618,323327,323328,323333,323334,323336,323337,324736,324793,324794,324795,324796,324798,324800,324801,324804,324807,324808,324809,324810,324811,324812,324813,324814,324815,324816,324817,324818,324819,324822,324823,324825,324841,325008,326318,326624,326646,330955,330957,330999,331965,331967,332096,332314,332328,332639,332777,332868,333042,333623,333935,334111,336222,336224,336241,336256,336257,336259,336262,336290,336291,336292,336391,336478,336481,336762,337361,337384,337405,337409,337421,337620,337622,337623,337624,337625,337627,337847,338052,338061,338642,338650,338652,338656,338776,338826,339368,339371,340700,340717,342232,343137,343139,343142,343143,343145,343148,343151,343152,343154,343158,344034,344037,344038,344267,344499,344611,345150,345151,345153,345154,345155,345157,345159,345161,345163,346834,346865,346866,346867,346869,346871,346873,346875,346876,346877,346944,346992,347279,348052,348055,348056,348057,348502,348509,348919,348920,351994,351995,351996,352211,352707,353774,353825,353835,353836,353837,353838,353839,354158,354425,354439,354446,354943,355223,355224,355225,355226,355227,355228,355923,356017,356018,356026,356027,356028,356645,356659,357498,358269,358270,358272,358273,358275,358280,358281,358282,358283,358284,359224,360269,360280,360285,360288,360290,360706,360970,361010,361734,362045)

select distinct typ from getproducts1 where dept='Firearms' and brand='HI POINT' 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='Class 3 NFA Items & Silencers' 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='Semi-Auto 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='Single Shot 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='Firearms' and typ='Used Guns' 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 (324225,23550,199531,23551,208009,23549,172668,189776,189773,23547,295107,287194,323326,355918,357497,323335,355921,339370,23539,189756,292147,344610,355815,361869,362035,23521,23527,23529,23541,23552,76136,85564,88897,94027,102273,114183,115358,116933,121790,139955,150211,151558,155547,158388,159528,161357,161358,161638,161639,168060,169719,172483,172484,172485,173617,173619,173622,183650,183652,183653,189750,189751,189752,189753,189754,189755,189757,189759,189760,189765,189766,189767,189768,189770,189771,189774,189777,189778,189779,189780,189781,189782,189784,189786,195627,196379,196381,197694,197695,197696,197697,197698,197699,197700,197701,197702,197703,199244,199530,199850,202913,204208,204209,204210,205560,207854,208893,209448,216853,216854,221051,225677,226013,226014,228172,228173,228174,228175,231773,231799,231800,231801,231802,246720,246722,246723,246726,246728,246729,247540,247661,247669,247670,247671,247673,247675,247676,247677,247678,247679,247680,247783,247790,247814,247826,247830,247831,247833,248937,249342,249419,249423,249424,249425,255988,256020,264311,267505,267643,267663,267684,267774,267775,267776,267777,267778,267779,267780,267781,267782,267784,267798,267800,267801,267802,267814,267816,267817,267818,267819,267820,267821,267824,267825,267826,267828,267829,267830,267831,267832,267833,267835,267836,267837,267838,267839,267841,267848,267849,267850,267852,267853,267854,267857,267858,267859,267860,267862,267863,267864,268221,268765,268767,269461,269463,269464,277334,277857,277858,277907,277908,277909,278382,278389,279939,279954,279963,279985,279992,279997,280172,280830,280845,281331,281383,281416,281657,281736,281954,283201,283229,283351,283359,284747,284748,285143,285146,285155,285156,285158,285166,285172,285181,285185,285187,285493,285498,285510,285513,285514,285771,285785,285796,285804,285838,285840,285848,285964,287898,287899,287912,287925,287999,288033,288115,288151,288185,289136,289387,289438,289458,289818,289819,289820,290742,290750,290752,290754,291059,291253,291254,291255,291256,291257,291740,292058,292072,292073,292146,294876,294897,294899,294911,294929,294952,294954,295109,295110,296107,296471,296548,296549,296551,296552,296843,297403,298062,298701,298718,298719,298720,298739,298747,298816,298933,298993,298999,299029,299289,300720,301155,301158,301551,303655,305063,305103,305117,305592,305597,308277,309311,309625,309626,311093,312425,316672,316715,319851,322500,322523,322553,322618,323327,323328,323333,323334,323336,323337,324736,324793,324794,324795,324796,324798,324800,324801,324804,324807,324808,324809,324810,324811,324812,324813,324814,324815,324816,324817,324818,324819,324822,324823,324825,324841,325008,326318,326624,326646,330955,330957,330999,331965,331967,332096,332314,332328,332639,332777,332868,333042,333623,333935,334111,336222,336224,336241,336256,336257,336259,336262,336290,336291,336292,336391,336478,336481,336762,337361,337384,337405,337409,337421,337620,337622,337623,337624,337625,337627,337847,338052,338061,338642,338650,338652,338656,338776,338826,339368,339371,340700,340717,342232,343137,343139,343142,343143,343145,343148,343151,343152,343154,343158,344034,344037,344038,344267,344499,344611,345150,345151,345153,345154,345155,345157,345159,345161,345163,346834,346865,346866,346867,346869,346871,346873,346875,346876,346877,346944,346992,347279,348052,348055,348056,348057,348502,348509,348919,348920,351994,351995,351996,352211,352707,353774,353825,353835,353836,353837,353838,353839,354158,354425,354439,354446,354943,355223,355224,355225,355226,355227,355228,355923,356017,356018,356026,356027,356028,356645,356659,357498,358269,358270,358272,358273,358275,358280,358281,358282,358283,358284,359224,360269,360280,360285,360288,360290,360706,360970,361010,361734,362045)

select distinct typ from getproducts1 where dept='Guns with Color' and brand='HI POINT' 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 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 = 324794 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324794 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324794  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=324794 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 = 324795 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324795 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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<= 'Apr 13, 2026 16:31:15' and
end_date >= 'Apr 13, 2026 16:31:15'
and store_id=10 and style_id=324795

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 = 324795 
and (a.start_date<= 'Apr 13, 2026 16:31:15' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 16:31:15'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=324795  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=324795 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 = 324796 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324796 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324796  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=324796 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 = 324798 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324798 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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<= 'Apr 13, 2026 16:31:15' and
end_date >= 'Apr 13, 2026 16:31:15'
and store_id=10 and style_id=324798

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 = 324798 
and (a.start_date<= 'Apr 13, 2026 16:31:15' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 16:31:15'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=324798  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=324798 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 = 324800 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324800 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324800  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=324800 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 = 324801 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324801 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324801  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=324801 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 = 324804 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324804 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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<= 'Apr 13, 2026 16:31:15' and
end_date >= 'Apr 13, 2026 16:31:15'
and store_id=10 and style_id=324804

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 = 324804 
and (a.start_date<= 'Apr 13, 2026 16:31:15' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 16:31:15'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=324804  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=324804 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 = 324807 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324807 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324807  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=324807 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 = 324808 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324808 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324808  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=324808 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 = 324809 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324809 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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<= 'Apr 13, 2026 16:31:16' and
end_date >= 'Apr 13, 2026 16:31:16'
and store_id=10 and style_id=324809

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 = 324809 
and (a.start_date<= 'Apr 13, 2026 16:31:16' or a.active = 1)
and a.end_date >= 'Apr 13, 2026 16:31:16'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=324809  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=324809 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 = 324810 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324810 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324810  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=324810 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 = 324811 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324811 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324811  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=324811 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 = 324812 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324812 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324812  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=324812 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 = 324813 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324813 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324813  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=324813 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 = 324814 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324814 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324814  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=324814 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 = 324815 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324815 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324815  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=324815 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 = 324816 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324816 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324816  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=324816 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 = 324817 and e.store_id in ('10',32) 

			group by a.style_id, e.qc

			order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	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 = 324817 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

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

select * from tb_product_reviews with (nolock) where style_id=324817  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=324817 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=SOSS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
baseurl=https://www.sportsmansoutdoorsuperstore.com/sezzle/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
[email protected]
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/
privatekay=sz_pr_nMBvrWcNk9cNGP9sN695umNINohQkV4r
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
publickey=sz_pub_T20udXXUkabHIADEGrGe3pgtZjwms0K6
qoh_store=10
safety_stock=0
[email protected]
secureurl=https://www.sportsmansoutdoorsuperstore.com/
sezzleapiurl=https://gateway.sezzle.com
sezzletenderid=66
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, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT=CN=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, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=S_U_F345=Y; USERNAME=""; LAST_NAME=""; CUSTOMER_ID=""; FIRST_NAME=""; EMAIL=""; CFID=Z4joj6qrkm3od1lmwralrv08p89d4av1gjql6k28gz3tw2hee1-22857161; CFTOKEN=Z4joj6qrkm3od1lmwralrv08p89d4av1gjql6k28gz3tw2hee1-974fa2ecd7b80216%2D55682855%2D99DB%2DFF5D%2D1820128A9DB4E1BB; PASSWORD=""; CFGLOBALS=urltoken%3DCFID%23%3D22857161%26CFTOKEN%23%3D974fa2ecd7b80216%2D55682855%2D99DB%2DFF5D%2D1820128A9DB4E1BB%23lastvisit%3D%7Bts%20%272026%2D04%2D13%2016%3A31%3A14%27%7D%23hitcount%3D5%23timecreated%3D%7Bts%20%272026%2D04%2D13%2016%3A31%3A08%27%7D%23cftoken%3D974fa2ecd7b80216%2D55682855%2D99DB%2DFF5D%2D1820128A9DB4E1BB%23cfid%3D22857161%23
HTTP_HOST=sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/category.cfm/CurrentPage/21/brand/hi%20point
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/21/brand/hi point
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=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=22857161
cftoken=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB
hitcount=5
lastvisit={ts '2026-04-13 16:31:14'}
timecreated={ts '2026-04-13 16:31:08'}
urltoken=CFID=22857161&CFTOKEN=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB

Cookie Variables:
CFGLOBALS=urltoken=CFID#=22857161&CFTOKEN#=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB#lastvisit={ts '2026-04-13 16:31:14'}#hitcount=5#timecreated={ts '2026-04-13 16:31:08'}#cftoken=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB#cfid=22857161#
CFID=22857161
CFTOKEN=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
S_U_F345=Y
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=22857161
cftoken=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB
cs=/category.cfm/CurrentPage/21/brand/hi point
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22857161_974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB
strarray=Array (0)
urltoken=CFID=22857161&CFTOKEN=974fa2ecd7b80216-55682855-99DB-FF5D-1820128A9DB4E1BB

URL Parameters:
CLEARANCE=
CurrentPage=21
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PAGETYPE=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WEB_TAXONOMY_ID=hipoint
WHATSNEW=
brand=hi point