1. ROFIS AR01 All-Directional Rotary Outdoor Camping Fishing Flashlight Mount Holder Clip - Black[70331]

    Price:  $6.25

    This product was added to our catalog on Sunday 02 November, 2014.

    This is a Outdoor flashlight mount holder clip for JR10/20/40 / TR31/31C / PR11/21/22 etc. It can be rotary in all directions and used widely in fishing camping barbecue indoor emergency etc. Clip quickly and easily onto the rod branch handrail etc. without any tools. It is well compatible with flashlight with diameter less than 30mm.


    * Brand: ROFIS
    * Model: AR01
    * Color: Black
    * Material: PC
    * Outdoor flashlight mount holder clip
    * Rotary in all directions
    * Anti-impact and anti-heat compressive resistant super durable
    * High temperature dueability
    * Suitable for flashlight with diameter less than 30mm such as JR10/20/40 / TR31/31C / PR11/21/22 etc.
    * Can be used as an flashlight accessory for fishing camping barbecue indoor emergency etc.
    * Size: 19.2 x 5.4 x 4cm / 7.56 x 2.13 x 1.57inch

    Package Includes:
    1 x Flashlight Clip Holder



1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'good8com_stationall.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image, p.products_price, p.products_tax_class_id from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '2128' and opa.orders_id = opb.orders_id and opb.products_id != '2128' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 3