Email Signup

Untitled Document

Please enter your email address below and click Sign Up. Your privacy is important to us.

Please read our Privacy Policy protecting your personal information.

 
FIRST NAME *
LAST NAME *
PHONE *
EMAIL *
LightsOutXF
Lights Out Xtreme Fighting (LXF)
 
select p.products_image, pd.products_name, p.products_model, p.products_weight, m.manufacturers_name, p.products_not_for_sale, p.products_not_for_sale_show, p.hide_title, p.products_description_embed_url, p.products_id, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_external_url, pd.products_subtitle from pages_description pd, pages p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, pages_to_pages_categories p2c left join specials s on p2c.products_id = s.products_id left join pages_categories c on c.categories_id = p2c.categories_id where (p.products_date_available <= CURDATE() or p.products_date_available is null) and m.manufacturers_status='1' and c.categories_status = '1' and p.products_status = '1' and p.products_public = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '170'group by p.products_id order by IF(p2c.sort_order > 0, p2c.sort_order, IF(p.products_ordered> 0, p.products_ordered, 999999)), p.products_model, pd.products_name desc3

select p.products_image, pd.products_name, p.products_model, p.products_weight, m.manufacturers_name, p.products_not_for_sale, p.products_not_for_sale_show, p.hide_title, p.products_description_embed_url, p.products_id, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_external_url, pd.products_subtitle from pages_description pd, pages p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, pages_to_pages_categories p2c left join specials s on p2c.products_id = s.products_id left join pages_categories c on c.categories_id = p2c.categories_id where (p.products_date_available <= CURDATE() or p.products_date_available is null) and m.manufacturers_status='1' and c.categories_status = '1' and p.products_status = '1' and p.products_public = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '170'group by p.products_id order by IF(p2c.sort_order > 0, p2c.sort_order, IF(p.products_ordered> 0, p.products_ordered, 999999)), p.products_model, pd.products_name desc limit 0, 3 - 3