SELECT p.products_model, p.sub_products_type, pd.products_name, m.manufacturers_name, pd.products_quantity as products_quantity , p.products_image, p.products_weight,pd.products_url,pd.is_new_window,p.customer_id,pd.outofstock_status,pd.free_shipping,p.is_kit, p.products_id, p.manufacturers_id, p.is_variant, p.variant_parent_id, p.products_parent_id, pd.products_price, p.passover, p.passover_only, p.products_tax_class_id,pd.min_buy_qty,pd.purchase_in,pd.purchase_in_unit,pd.products_blurb,pd.min_case_pack,pd.video_types,pd.video_embeded_code,pd.products_grp_permission,p.products_weight,pd.products_deafult_category_id,p.products_model,
IF(pd.special_status, pd.special_price, NULL) as specials_new_products_price,
IF(pd.special_status, pd.special_price, pd.products_price) as final_price FROM products p
LEFT JOIN manufacturers m on p.manufacturers_id = m.manufacturers_id,
products_description pd,
products_to_categories p2c
WHERE p.products_status = 1
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.web_id='1' and pd.enable_in_site=1
and (pd.products_group_access like "%,G,%" or pd.products_group_access like "G,%" or pd.products_group_access like "%,G" or pd.products_group_access = "G")
and pd.language_id = 1
and p2c.categories_id = 312 and pd.products_quantity >= IF(pd.min_buy_qty > 1,pd.min_buy_qty, 1) and p.products_carrot != 1 and (IF(p.sub_products_type != 'Parent', pd.products_price > 0, 1) OR IF(p.sub_products_type != 'Parent Product', pd.products_price > 0, 1) ) ORDER BY p.products_model , pd.products_name
SPORT GLIDE FLSB
By using this website, you agree to our use of cookies. We use cookies to provide you with a great experience and to help our website run effectively. More info.
Accept Cookie
Email Me When Available
We will send you email notification when item is back in stock
