1. Infrared Thermometer Gun with Laser Pointer[42480]

    Price:  $21.67

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

    It features a large LCD screen showing readings in Fahrenheit or Celsius and temperature reading within 0.5 second and remains on screen for 5 seconds. Laser points to aim the target accurately. Backlight function is helpful for using in dark places.


    100% Brand New

    Dimension: 140 * 80 * 38mm

    Laser pointer for accurate target aiming


    Measurement range: -50 - + 280?

    Resolution: 0.1?/?

    Distance Spot Ratio: 8:1

    ?/? selection

    Emissivity: 0.95 (Pre-Set)

    Response Time & Wavelength: 500ms & (8-14)um

    Auto Power Shut off

    Low battery indication


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 = '3097' and opa.orders_id = opb.orders_id and opb.products_id != '3097' 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