30:
SELECT Distinct(a.modelId), modelName, modelSlug, modelBodyTypeId from tblmodels a LEFT JOIN tblmodelpowertrains b on a.modelId = b.modelId LEFT JOIN tblvariants c on a.modelId = c.modelId WHERE isUpcoming = 0 AND brandId = 17 ORDER BY launchDate desc

Datsun Cars

Find Datsun related details below.

Datsun Cars Reviews