[TYPO3-dev] DBAL: SELECT DISTINCT

[Franz Holzinger]

There has been an error in this SQL statement.

It should have been

SELECT products.uid uid, tt_products_language.pid pid,
products.categorycategory, products.price price, products.price2 price2,
products.taxtax, products.inStock inStock,
tt_products_language.titletitle, products.image image, products.size size
FROM tt_products_language tt_products_language, tt_products products
LEFT OUTER JOIN tt_products_cat tt_products_cat ON tt_products_cat.uid =
products.category
WHERE products.pid
IN ( 119 )
AND products.uid = tt_products_language.prod_uid
AND 1 =1
AND (
products.inStock <>0
)
AND tt_products_language.sys_language_uid =2
AND tt_products_language.deleted =0
LIMIT 0 , 30


This works without DISTINCT.