[TYPO3-project-formidable] A problem with datasource:DB

[Ivan Gomez Rodriguez]

I'm trying to use a datasource like follows:

                    <datasource:DB name="list_make_datasource">
	                <sql><![CDATA[
	                   SELECT
                            makes.make as make_name ,count(*) as num
	                   FROM
	                    tx_glcarauctionsystem_car cars
	                    LEFT JOIN tx_glcarauctionsystem_static_make makes
	                       ON cars.make = makes.uid 	

	                    GROUP BY makes.uid	
	                  ]]>
	                </sql>
                    </datasource:DB>

but formidable core builds the following not well built query

SELECT SQL_CALC_FOUND_ROWS makes.make as make_name ,count(*) as num
FROM tx_glcarauctionsystem_car cars
     LEFT JOIN tx_glcarauctionsystem_static_make makes
       ON cars.make = makes.uid
GROUP BY makes.uid
WHERE TRUE LIMIT 0, 3

And WHERE must be placed before GROUP BY.

I know the problem is in tx_dsdb:_getSql() but i don't know how solve it
:)

Regards,

Iván Gómez Rodríguez
Ingeniero en Informática
mailto:igomez at igalia.com