Доброго времени суток.
Такая проблема: Вроде запрос построен правильно, но выводит по 6 одинаковых строк с одним и тем же индексом....

Вот сам запрос:

SELECT *
FROM carSale AS t1
USE INDEX ( )
LEFT JOIN salerContacts AS t2 ON t1.salerContactId = t2.contactId
INNER JOIN carModels AS t3 ON t3.carModelId = t1.carModelId
LEFT JOIN carBrands AS t4 ON t4.carBrandId = t3.carBrandId
LEFT JOIN regions AS t5 ON t2.salerRegion = t5.regionId
LEFT JOIN savedsales AS ss ON ( t1.saleId = ss.saveSaleId
AND ss.userId =0
AND ss.saleTable = "carSale" )
LEFT JOIN salePhotos AS sP ON sP.photoSaleId = t1.saleId
AND sP.saleType =1
WHERE t1.saleOn =1
AND t1.carYear >= "2004"
AND t1.carYear <= "2010"
AND t1.carVolume >= "2000"
AND t1.carVolume <= "2000"
AND t1.carTransmission
IN ( 1 )
AND t1.carGearBox
IN ( 4 )
AND t1.carBody
IN ( 1 )
AND t3.carBrandId = "21"
AND saleId <>361
ORDER BY RAND( )
LIMIT 25

+ в репу тому кто поможет разобраться B)