testingselect p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_related_code, p.manufacturers_id, p.products_special_text, p.products_special_promo_text, p.products_ordered, p.products_ordered_extra, p.products_price, p.products_rental_price, p.products_color,p.products_retail_price, p.products_tax_class_id, p.products_coming_soon_status, p.address_key, p.products_new_in_start, p.products_hot_item_start, p.products_bestseller_start, p.products_new_in, p.products_hot_item, p.products_bestseller, p.products_related_tag, p.pwp_group_id, p.products_offer_icon, p.products_offer_icon_position, p.products_offer_icon_startdate, p.products_offer_icon_enddate, p.products_wheel_chair_status, p.agent_contact from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c where p.products_status = '1' and p.products_free_gift_status = '0' and p.products_third_party_status = '0' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2466' and p.products_price >= 50.1 and p.products_price <= 100 order by p.products_out_of_stock_status asc, (p.products_ordered + p.products_ordered_extra) desc, p.products_new desc, pd.products_name

Insect Repellents 0 / 0 Products Select: Popularity New Arrivals Lowest Price Highest Price Name (A-Z) Name (Z-A) Highest Discount Rating 20 Per Page 40 Per Page 60 Per Page There are currently no products to list in this category. Sorry, you must select the options in order to add to cart.