You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" AND battery_prices.fkCityID ='1' AND battery_brands.BatteryBrandStatus= "Activ' at line 3<br/><br/>SELECT DISTINCT(pkBatteryID), batteries.fkBatteryBrandID, BatteryModel, BatteryType, BatteryImage, BatterySpecification, BatteryCapacity, BatteryWarranty,  BatteryCityPrice_MRP, BatteryCityPrice_WithPrice, BatteryCityPrice_WithoutPrice, BatteryBrandTitle,BatteryOutOfStock FROM batteries 
inner JOIN battery_brands ON batteries.fkBatteryBrandID = battery_brands.pkBatteryBrandID 
inner JOIN battery_types ON batteries.fkBatteryTypeID 	 = battery_types.pkBatteryTypeID INNER JOIN battery_prices ON  battery_prices.fkBatteryID = batteries.pkBatteryID WHERE 1  AND BatteryStatus = "Active"  AND batteries.fkBatteryTypeID=4" AND battery_prices.fkCityID ='1' AND battery_brands.BatteryBrandStatus= "Active" ORDER BY BatteryCityPrice_MRP ASC