Unknown column 'BatteryDelivery' in 'field list'
SELECT DISTINCT(pkBatteryID), fkBatteryBrandID, fkBatteryTypeID, BatteryType, BatteryImage, BatterySpecification, BatteryCapacity, BatteryWarranty, BatteryPriceMRP, BatteryPriceWithBattery, BatteryPriceWithoutBattery, BatteryBrandTitle,with_out_battery,BatteryDelivery FROM batteries
LEFT JOIN battery_brands ON batteries.fkBatteryBrandID = battery_brands.pkBatteryBrandID
LEFT JOIN battery_types ON batteries.fkBatteryTypeID = battery_types.pkBatteryTypeID WHERE BatteryStatus = "Active" AND batteries.fkBatteryTypeID='' ORDER BY BatteryPriceMRP ASC