Unknown column 'partner_with_us.php' in 'where clause'<br/><br/>SELECT DISTINCT(pkBatteryID), batteries.fkBatteryBrandID, BatteryModel, BatteryType, BatteryImage, BatterySpecification, BatteryCapacity, BatteryWarranty,  BatteryCityPrice_MRP, BatteryCityPrice_WithPrice, BatteryCityPrice_WithoutPrice, BatteryBrandTitle 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 INNER JOIN battery_manufacture_model ON  battery_manufacture_model.fkBatteryID = batteries.pkBatteryID INNER JOIN manufactures ON  manufactures.pkManufactureID = battery_manufacture_model.fkManufactureID WHERE 1  AND BatteryStatus = "Active"  AND batteries.fkBatteryTypeID=partner_with_us.php AND battery_prices.fkCityID ='1' AND battery_brands.BatteryBrandStatus= "Active" AND batteries.fkBatteryBrandID='3'  group by battery_manufacture_model.fkBatteryID ORDER BY BatteryCityPrice_MRP ASC