1. Metal Hot Shoe Mount Adapter with 1/4" Thread for Flash Bracket - Black[19155]

    Price:  $1.76

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

    This item is specially for flash bracket of DC digital camera. It suits for various kinds of cameras. It will be a good helper for your taking photos. That's really a good partner for the flash bracket of your DC digital camera. 

    * Convenient and practical
    * With 1/4” brass nut in the bottom, suitable for light stands or flash holders with 1/4” screw head
    * Designed with cold foot, support standard hot shoe

    Compatible modes:
    * Canon 600EX-RT/580EX II/580EX/550EX/540EZ/430EX II/430EX/420EZ/380EX
    * Nikon SB910/SB900/SB800/SB700/SB600/SB80DX/SB28/SB26/SB24
    * Pentax 54AF00FGZ/AF500FTZ/AF360FGZ
    * Olympus FL-50R/FL-36R
    * Metz AF58 Series/AF54 Series /AF50 Series /AF48 Series /AF44 Series /AF36 Series
    * Sigma EF500 Series /EF530 Series /EF540 Series
    * Nissin DI866 Series /DI622 Series /DI466 Series
    * Material: Alloy + plastic
    * Size: 2.3 x 2.1 x 1.3 cm
    * Color: Black

    Package included:
    1* Hot Shoe Mount Adapter


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