SELECT cm.dtMarque
FROM webcms_cars c, webcms_cars_metadata cm
WHERE 1
AND c.idCar = cm.fiCar
AND cm.dtMarque != ''
...
SELECT cm.dtCategory
FROM webcms_cars c, webcms_cars_metadata cm
WHERE 1
AND c.idCar = cm.fiCar
...
SELECT c.*
FROM webcms_cars c
WHERE 1
AND c.dtType IN ('vn','vo') AND c.isActive = '1' AND c.dtProductType IN ('textile','casque') ORDER BY c.dtOrderId ASC, c.timestamp DESC, c....
SELECT c.*, cm.*
FROM webcms_cars c, webcms_cars_metadata cm
WHERE 1
AND c.idCar = '924'
AND c.idCar = cm.fiCar
AND cm.fiLanguage = '1'
...
