[TYPO3-mvc] extbase queries, add count() and left join

[Muriel le Pair]

Muriel le Pair schreef op 25-06-14 12:13:

> SELECT count(tx_sffilterdb_items_cataardvdaanpak_mm.uid_foreign) as
> amount, tx_sffilterdb_domain_model_cataardvdaanpak.*
> FROM tx_sffilterdb_domain_model_cataardvdaanpak
> LEFT JOIN tx_sffilterdb_items_cataardvdaanpak_mm ON
> tx_sffilterdb_domain_model_cataardvdaanpak.uid =
> tx_sffilterdb_items_cataardvdaanpak_mm.uid_foreign
> LEFT JOIN tx_sffilterdb_domain_model_items as i ON i.uid =
> tx_sffilterdb_items_cataardvdaanpak_mm.uid_foreign
> WHERE tx_sffilterdb_domain_model_cataardvdaanpak.deleted=0
> AND (tx_sffilterdb_domain_model_cataardvdaanpak.t3ver_wsid=0 OR
> tx_sffilterdb_domain_model_cataardvdaanpak.t3ver_wsid=0)
> AND tx_sffilterdb_domain_model_cataardvdaanpak.pid<>-1
> GROUP BY tx_sffilterdb_domain_model_cataardvdaanpak.uid
> ORDER BY tx_sffilterdb_domain_model_cataardvdaanpak.sorting ASC
>
> I have added setAmount() and getAmount() to the repository.
> How do I get the amount from the query into setAmount()?

Ok $query->getQuerySettings()->setReturnRawQueryResult(TRUE); did the trick.

But I still wonder if there is a better way to perform this query (add 
SELECT count(tx_sffilterdb_items_cataardvdaanpak_mm.uid_foreign) and the 
second LEFT JOIN without using $query->statement($sql).

--
kind regards,

Muriel le Pair