Features ● DURABLE, IMPACT-RESISTANT CONSTRUCTION ● HEADLAMP-WITH ADJUSTABLE HEADBAND TO FIT USERS' HEAD OR HELMET ● WITH ROTATABLE HEAD (ANGLE ADJUSTABLE BY MAXIMUM 90 DEGREE) TO MEET CUSTOMER'S VISION NEED ● LOCKING MECHANISM ON BATTERY COMPARTMENT TO ENSURE OPEN EASILY AND SAFELY Specs Battery Size 3*AAA Light Source Cree XPG2 LED Mode High/Low/Off Light Output 75lm(Low)/150lm(High) Beam Distance 75m(Low)/100m(High) Run Time 4hrs 30mins(Low)/2hrs 30min(High) IP Rating IP67 Weight 143g(w/o battery) Dimension 80*50*45mm Certifications & Standards CLASS I DIV I GRP ABCD CLASS II DIV I GRP EFG CLASS III / TEMPERATURE CODE T4 IP67 FILE NUMBER: E324236 II 1G Ex ia IIC T4 Ex ia IIC T4 Ga IP67 IECEx UL 14.0059x
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'labsafet.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 from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '124' and opa.orders_id = opb.orders_id and opb.products_id != '124' 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 6