1. Headset Microphone Headphone for XBOX 360 / X BOX 360 Live ZY020[23002]

    Price:  $11.78

    This product was added to our catalog on Saturday 01 November, 2014.

    Metal 2 Sections 20cm Tripod for Digital Camera Camcorder Black is composed of high quality aluminum with universal functions. The tilt head is easy to aim precisely, and adjustable legs keep everything steady.

      100% Brand New

      Material: Aluminum / copper

      Max height: 20cm
      Min height: 12.7cm

      Color: Black

      Diameter of one leg: 9.8mm

      Leg Section: 2

      Works with all compact digital cameras & camcorders

      Top ball head providing 360° turning and 90° tilt

      Easily attaches to cameras 1/4" tripod socket

      Perfect size for travel and leisure

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