[SELECT *,Car.CarID As CarID
                  From Car
                       INNER JOIN CarModel ON Car.CarModelID = CarModel.CarModelID
                       INNER JOIN CarMake ON Car.CarMakeID = CarMake.CarMakeID
           Where 1=1  /*AND Car.OrderTempStatus <>'2'*/ And CarIsEnabled='1' And CarIsPaid=0  And CarDelete=0  And CarID='22772'
          ]