SELECT IP FROM block_ip 
	WHERE IP = '3.133.147.252'
	limit 1

	
	SELECT     product.product_id, product.product_name,product.is_active, product.date_created,product.old_id,product.cloud_map , man.man_id, man.man_name, man.MAN_TITLE ,man.auth_dealer,Product_detail.weight, Product_detail.dim_weight, 
                      Product_detail.X, Product_detail.Y, Product_detail.Z, Product_detail.MAP, Product_detail.use_map, Product_detail.qty_in_stock, Product_detail.eta, 
                      Product_detail.days_till_ship, product_detail.ARcust_code ,Product_detail.UPC, Product_detail.SKU, Product_detail.use_ALOC ,Product_detail.Has_image, Product_detail.Product_note, Product_detail.sale_price,Product_detail.Offer_Tradein,
					  Product_detail.Pre_Sale_QTY,Product_detail.POP_Discount,Product_detail.POP_Discount_backUP,Product_detail.List_Price,Product_detail.man_Warranty,product.is_active,
					
					  (SELECT ONHAND FROM arinv99 where ITEM = left(product_detail.ARcust_code,50) limit 1) as ONHAND,
					  (select product_name from product p where product_id=Product_detail.Free_product) as Free_product_name,
					  (select product_kit_name from product p where product_id=Product_detail.Free_product) as Free_kit_name,
					  Product_detail.Free_product as Free_product_id,Product_detail.Block_Search,
                      Product_detail.Demo_URL, Product_detail.PDF_URL, Product_detail.Product_note_start, Product_detail.Product_note_end, Product_detail.fk_Warranty_id,
                      Product_detail.show_Ship_USA_only, Product_detail.ship_ground_only,Product_detail.show_please_call, Product_detail.Block_cart ,stock_type.stock_type_id, stock_type.stock_type_name, 
                      stock_type.stock_type_color, stock_type.stock_type_name_internal, product_condition.product_condition_id, 
                      product_condition.product_condition_name, Product_rebate.Product_rebate_id, Product_rebate.rebate_url, Product_rebate.rebate_text, 
                      Product_rebate.rebate_amount, Product_rebate.from_date, Product_rebate.to_date, Product_description.features, Product_description.spec,  Product_description.spec_Mobile, 
					  Product_description.bulletpoint1,Product_description.bulletpoint2,Product_description.bulletpoint3,Product_description.bulletpoint4,Product_description.bulletpoint5,
                      Product_description.caption, Product_to_cat_sub.fk_Cat_sub_id, Product_detail.alt_item, Product_description.meta_title, 
                      Product_description.meta_Description, Product_description.meta_Keywords, Cat_sub.Cat_sub_id, Cat_sub.sub_name, Cat_Category.Cat_Category_id, 
                      Cat_Category.Category_name, Cat_department.Cat_department_id, Cat_department.Department_name,
                          (SELECT     shipping_type.shipmentDesc
                            FROM          product_shipping INNER JOIN
                                                   shipping_type ON product_shipping.fk_shipping_type = shipping_type.shipping_type_id
                            WHERE      (shipping_type.stateCode IS NOT NULL) AND (shipping_type.countryCode = 'US') AND 
                                                   (product_shipping.fk_product_id = product.product_id)
                            ORDER BY shipping_type.shipping_type_id DESC limit 1 ) AS shipping, product_store.Price, product_store.fk_store_id, 
                      '' as SG_URL ,
					  (SELECT fk_product_id
						FROM feature_value inner join product_to_feature on feature_value.feature_value_id = product_to_feature.fk_feature_value_id
						WHERE feature_value_id = 6 and fk_product_id=product.product_id LIMIT 1) as made_in_usa ,
							(SELECT HTML_page from man_store WHERE FK_MAN_ID=man.MAN_ID and fk_store_id =product_store.fk_store_id) AS HTML_page ,
							
							(SELECT ALOC FROM arinv99 where ITEM = left(product_detail.ARcust_code,50) limit 1) as ALOC,
							 page_rank.rank
					
FROM
                      product INNER JOIN
                      Product_detail ON Product_detail.fk_product_id = product.product_id INNER JOIN
                      Product_description ON product.product_id = Product_description.fk_product_id INNER JOIN
                      product_condition ON Product_detail.fk_product_condition_id = product_condition.product_condition_id INNER JOIN
                      stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id inner join product_store
					  ON product_store.fk_product_id = product.product_id  LEFT OUTER JOIN
                      Cat_sub LEFT OUTER JOIN
                      Product_to_cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id LEFT OUTER JOIN
                      Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id LEFT OUTER JOIN
                      Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id ON 
                      product.product_id = Product_to_cat_sub.fk_product_id LEFT OUTER JOIN
                      Product_rebate ON product.product_id = Product_rebate.fk_product_id LEFT OUTER JOIN
                      man ON product.fk_man_id = man.man_id 
					    left outer join  page_rank on product.product_id =  page_rank.fk_product_id  
					  
		WHERE     (product_store.fk_store_id = 17) AND 
					 
					product.product_id = 24180 
					AND product.FK_MAN_ID <>224 
					AND product.FK_MAN_ID <> 85
					AND product.FK_MAN_ID <> 262
					
					and Product_detail.Block_cart <> 3
					 and  product_detail.fk_stock_type_id not in (12)
					AND  (product.is_active = 1) AND
	   (product_store.is_active = 1)
	
	 
	 

	SELECT     fk_product_group_id
                            FROM          product_group_to_product_id AS product_group_to_product_id_1
                            WHERE      (fk_product_id = 24180)
	

SELECT     Product_group.Product_group_id, Product_group.Group_name,Product_detail.sku, Product_detail.Has_image, Product_detail.Block_cart,product.product_name, product.product_kit_name,product.Model_name, 
                      product.is_active, product.product_id, product_store.Price,man.man_name,stock_type.stock_type_id, stock_type.stock_type_name, 
                      stock_type.stock_type_color,product_detail.ARcust_code,Product_detail.fk_product_condition_id as product_condition_id
FROM         product_group_to_product_id INNER JOIN
                      Product_group ON product_group_to_product_id.fk_product_group_id = Product_group.Product_group_id INNER JOIN
                      product ON product_group_to_product_id.fk_product_id = product.product_id INNER JOIN
                      Product_detail ON product.product_id = Product_detail.fk_product_id INNER JOIN
                      product_store ON Product_detail.fk_product_id = product_store.fk_product_id inner join
					  man ON product.fk_man_id = man.man_id INNER JOIN
                      stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id
WHERE (product.is_active = 1) AND
	   (product_store.is_active = 1) AND 
		product_store.fk_store_id=17 AND
	  	product_store.Price > 0 and 
		 Product_detail.Block_cart <> 3 and
		 Product_group.Product_group_id = 5071 and
		  Product_detail.Block_Search = 0 
		  
			 
		


ORDER BY stock_type.order_by,product_store.Price, product_group_to_product_id.order_by

SELECT     product_to_acc.fk_product_id, product.product_id  ,product.product_name, product.product_kit_name,product.old_id,product_store.Price, Product_description.caption,product_detail.ARcust_code
,Product_detail.fk_stock_type_id,Product_detail.fk_product_condition_id as product_condition_id
FROM         product_store INNER JOIN
                      product ON product_store.fk_product_id = product.product_id INNER JOIN
                      product_to_acc ON product.product_id = product_to_acc.fk_acc_id INNER JOIN
                      Product_description ON product.product_id = Product_description.fk_product_id INNER JOIN
                      Product_detail ON product.product_id = Product_detail.fk_product_id
WHERE     (product_to_acc.fk_product_id = 24180) AND 
		 (product_store.fk_store_id = 17) and (product.is_active = 1) and product_store.Price <> 0
		 and Product_detail.fk_stock_type_id in (1,2,6,7,8,10,11)
		 
ORDER BY product_to_acc.order_by

SELECT     product_alt_image_id, fk_product_id, image_header
FROM         product_alt_image
where is_active =1 and fk_product_id = 24180 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24180 

SELECT     product_to_acc.fk_product_id, product.product_id  ,product.product_name,product.product_kit_name, product.old_id,product_store.Price, 
			Product_description.caption,Product_description.features,product_detail.ARcust_code,Product_detail.fk_stock_type_id,Product_detail.fk_product_condition_id as product_condition_id
FROM         product_store INNER JOIN
                      product ON product_store.fk_product_id = product.product_id INNER JOIN
                      product_to_acc ON product.product_id = product_to_acc.fk_acc_id INNER JOIN
                      Product_description ON product.product_id = Product_description.fk_product_id INNER JOIN
                      Product_detail ON product.product_id = Product_detail.fk_product_id
WHERE     (product_to_acc.fk_product_id = 24180) AND 
		 (product_store.fk_store_id = 17) and (product.is_active = 1) and product_store.Price <> 0
		 
ORDER BY product_to_acc.order_by

					SELECT HTML_Page 
					FROM product_store
					WHERE fk_product_id = 24180 and fk_store_id=18
					

		 select scale_spec_id, fk_product_id,Capacity,Capacity_Unit,Readability,Readability_Unit,Legal_Capacity,Legal_Capacity_Unit,Legal_Readability,Leagl_Readability_Unit,Pan_Size,Pan_Size_Unit,Pan_Size_Round,Cannabis
		 from scale_spec
		 where fk_product_id = 24180
		 order by Capacity_Unit,Capacity
		 

		SELECT warranty_group.fk_product_id as PRODUCT_ID, product.product_name, product.old_id, product_store.Price, Product_description.caption
		
		FROM warranty_group inner join warranty on warranty.warranty_id = warranty_group.fk_Warranty_id inner join product
		 on product.product_id = warranty_group.fk_product_id inner join  product_store 
		on product_store.fk_product_id = product.product_id INNER JOIN
         Product_description ON product.product_id = Product_description.fk_product_id
		 
		 where warranty_group.fk_Warranty_id=0 and from_price <= 125.75 and to_price >= 125.75
		and (product_store.fk_store_id = 17) and (product.is_active = 1) and product_store.Price <> 0
		order by warranty_group.from_price, product.product_name
		

		select * , AVG(RATING) as rating_sum
		from product_review 
		where fk_product_id = 24180 and APROVED = 1
		group by the_date
		order by the_date desc
		

	select product_group_to_product_id_2.fk_product_id 
from product_group_to_product_id inner join product_group_to_product_id product_group_to_product_id_2 on
    product_group_to_product_id.fk_product_group_id = product_group_to_product_id_2.fk_product_group_id
WHERE product_group_to_product_id.fk_product_id = 24180 

	select product_group_to_product_id_2.fk_product_id 
from product_group_to_product_id inner join product_group_to_product_id product_group_to_product_id_2 on
    product_group_to_product_id.fk_product_group_id = product_group_to_product_id_2.fk_product_group_id
WHERE product_group_to_product_id.fk_product_id = 24180
	union
	
	
	SELECT fk_component_id as fk_product_id FROM product_kit_component where fk_product_id in(24132,24129,24126,24123,24120,24117,24114,24135,24138,24141,24144,24147,24150,24153,24156,24159,24162,24165,24168,24171,24174,24177,24180,24183,24186,24189,24192,24195,24198,24201,24204,24207,24210,24213,24216,24222,24225,24228,24231)
	union
	SELECT fk_product_id FROM product_kit_component where fk_component_id in(24132,24129,24126,24123,24120,24117,24114,24135,24138,24141,24144,24147,24150,24153,24156,24159,24162,24165,24168,24171,24174,24177,24180,24183,24186,24189,24192,24195,24198,24201,24204,24207,24210,24213,24216,24222,24225,24228,24231)
	

		SELECT ticket_id, thedate_time, type
		FROM ticket
		Where fk_product_id in(24132,24129,24126,24123,24120,24117,24114,24135,24138,24141,24144,24147,24150,24153,24156,24159,24162,24165,24168,24171,24174,24177,24180,24183,24186,24189,24192,24195,24198,24201,24204,24207,24210,24213,24216,24222,24225,24228,24231) AND APROVED = 1 and type <> 'News'
		order by type,ticket_id	
		limit 1
		

		 select scale_spec_id, fk_product_id,Capacity,Capacity_Unit,Readability,Readability_Unit,Legal_Capacity,Legal_Capacity_Unit,Legal_Readability,Leagl_Readability_Unit,Pan_Size,Pan_Size_Unit,Pan_Size_Round
		 from scale_spec
		 where fk_product_id = 24180
		 order by Capacity_Unit,Capacity
		 

SELECT HTML_Page 
FROM product_store
WHERE fk_product_id = 24180 and fk_store_id=17 

		SELECT man_Warranty 
		from Product_detail 
		where fk_product_id = 24180 

	SELECT BG_Product_Type_id,
   	BG_Product_Type_Name,
    FK_Product_id
	FROM `store2008`.`bg_product_type` inner join bg_product_type_to_product on bg_product_type_to_product.FK_BG_Product_Type_ID = bg_product_type.BG_Product_Type_id
	where FK_Product_id=24180 

		 select scale_spec_id, fk_product_id,Capacity,Capacity_Unit,Readability,Readability_Unit,Legal_Capacity,Legal_Capacity_Unit,Legal_Readability,Leagl_Readability_Unit,Pan_Size,Pan_Size_Unit,Pan_Size_Round,Cert_type
		 ,Set_Name,Set_Count,Set_Includes
		 from scale_spec
		 where fk_product_id in(24231,24180,24210,24216,24222,24225,24228,24162,24165,24168,24171,24174,24177,24195,24198,24201,24204,24207,24213,24159,24192,24156,24189,24153,24186,24150,24183,24144,24147,24141,24138,24135,24132,24129,24126,24123,24120,24117,24114)   
		 order by Capacity_Unit, CAST(Capacity AS UNSIGNED) ,Capacity ,Readability_Unit, CAST(Readability AS UNSIGNED) , PAN_SIZE_UNIT,PAN_SIZE
		 

		 select scale_spec_id, fk_product_id,Capacity,Capacity_Unit,Readability,Readability_Unit,Legal_Capacity,Legal_Capacity_Unit,Legal_Readability,Leagl_Readability_Unit,Pan_Size,Pan_Size_Unit,Pan_Size_Round,Cert_type
		 ,Set_Name,Set_Count,Set_Includes
		 from scale_spec
		 where fk_product_id in(24231,24180,24210,24216,24222,24225,24228,24162,24165,24168,24171,24174,24177,24195,24198,24201,24204,24207,24213,24159,24192,24156,24189,24153,24186,24150,24183,24144,24147,24141,24138,24135,24132,24129,24126,24123,24120,24117,24114)   
		 order by Capacity_Unit, CAST(Capacity AS UNSIGNED) ,Capacity ,Readability_Unit, CAST(Readability AS UNSIGNED) , PAN_SIZE_UNIT,PAN_SIZE
		 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24180 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24180 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24180 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24177 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24177 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24177 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24174 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24174 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24174 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24171 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24171 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24171 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24168 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24168 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24168 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24165 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24165 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24165 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24162 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24162 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24162 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24159 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24159 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24159 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24156 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24156 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24156 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24153 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24153 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24153 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24150 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24150 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24150 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24147 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24147 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24147 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24144 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24144 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24144 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24141 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24141 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24141 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24138 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24138 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24138 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24135 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24135 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24135 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24132 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24132 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24132 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24129 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24129 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24129 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24126 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24126 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24126 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24123 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24123 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24123 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24120 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24120 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24120 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24117 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24117 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24117 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24114 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24114 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24114 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24231 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24231 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24231 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24228 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24228 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24228 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24225 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24225 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24225 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24222 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24222 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24222 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24216 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24216 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24216 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24213 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24213 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24213 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24192 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24192 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24192 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24204 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24204 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24204 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24195 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24195 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24195 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24207 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24207 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24207 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24198 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24198 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24198 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24210 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24210 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24210 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24201 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24201 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24201 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24189 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24189 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24189 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24186 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24186 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24186 

SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 24183 

  select SKU ,product_name , (select price from product_store where fk_product_id = Product.Product_id and fk_store_id = 18 limit 1) as price
  from Product_detail inner join Product on Product.Product_id=Product_detail.fk_product_id
  where fk_product_id = 24183 

	Select Price,stock_type_id, stock_type_name, stock_type_color,eta,Block_cart,Product_name,POP_Discount
	from mini_sProduct
	where Product_id =24183 

Application Variables:
applicationname=store_17

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\Websites\itinscales.com\product\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www1.itinscales.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=www1.scalesgalore.com
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\Websites\itinscales.com\product\index.cfm
QUERY_STRING=product_id=24180
REMOTE_ADDR=10.189.254.4
REMOTE_HOST=10.189.254.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/product/index.cfm
SERVER_NAME=www1.itinscales.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.0
WEB_SERVER_API=

Client Variables:
cfid=17752304
cftoken=1925b0e4e0aa122a-D776F879-9FE1-0E23-4056A5B70E82CB57
hitcount=2
lastvisit={ts '2024-04-25 09:57:20'}
remote_addr=3.133.147.252
timecreated={ts '2024-04-25 09:57:20'}
urltoken=CFID=17752304&CFTOKEN=1925b0e4e0aa122a-D776F879-9FE1-0E23-4056A5B70E82CB57&jsessionid=C6A3D28876DEBE2309BCDE0F25CED4F7.cfusion

Cookie Variables:
CFID=17752304
CFTOKEN=1925b0e4e0aa122a-D776F879-9FE1-0E23-4056A5B70E82CB57

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

Session Variables:
sessionid=C6A3D28876DEBE2309BCDE0F25CED4F7.cfusion
urltoken=CFID=17752304&CFTOKEN=1925b0e4e0aa122a-D776F879-9FE1-0E23-4056A5B70E82CB57&jsessionid=C6A3D28876DEBE2309BCDE0F25CED4F7.cfusion

URL Parameters:
product_id=24180