1. Digital Camera Battery 1050mAh for Canon NB7L Replacement[31342]

    Price:  $7.21

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

    Digital Camera Battery 1400mAh for Canon BP 511 Replacement  employs the latest Li-ion battery technology and fits many Canon models with 1400mAh capacity.

    100% Brand New

    Dimension: 55.1 x 38.2 x 21.0mm

    Voltage: 7.4V

    Battery Type: Li-ion

    Capacity: 1400mAh

    Color: Black

    Good Replacement for Canon BP 511, BP-508, BP-511a, BP-512, BP-514, BP-522, BP-535

    Fit Canon Models:

    MVX100iOptura 50MCEOS 5DOptura 20
    EOS 20DaMV650iMVX3iDM-MV400
    MV750iPV130MV630iPowerShot G5
    MV600iMV730iEOS 300DMVX2i
    EOS 10DMV450iMV700iEOS 30D
    MV600DM-MVX1iMV430iPowerShot Pro 90
    MV400iMV550iMV700Optura 100MC
    MV300EOS 20DMV300iOptura Xi
    EOS Kiss DigitalMV500PowerShot Pro 90 ISMVX150i
    IXY DVMEOS D30MV430IMCPowerShot G6
    ZR70MCFVM10FVM1Optura 10
    ZR50MCFV400FV40Optura Pi
    FV300ZR30MCZR30PowerShot G2
    EOS 50DFV30FV200DM-MV100Xi
    ZR25MCMedia Storage M30Media Storage M80ZR40
    EOS 40DFV2FV100PowerShot G1
    ZR10PowerShot Pro 70ZR90DM-MV450
    FV10PowerShot Pro 1PowerShot G3ZR45MC
    ZR85EOS Digital RebelEOS D60Optura 200MC

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