[Typo3-dev] sql-subset and INNER JOIN?

[Ries van Twisk]

Hey Peter,

maby you can just bypass the abstraction layer to make your own SQL queries it
it's you own extention ofcourse....?


Ries




> Hello,
> 
> since db-abstraction is on the way and will be part of tYPO§ pretty soon
> I do have one question about the handling of sql.
> 
> I do read
> http://typo3.org/documentation/document-library/doc_core_cgl/Supported_SQL/
> which tells me something about features of sql that
> TYPO3-DB-wrapper(abstarction?) supports.
> 
> Is this still accurate for abstraction?
> What about INNER JOIN ?
> 
> consider soemthing like this:
> 
> SELECT DISTINCT (
> tx_sometable_common.pid
> ), tx_sometable_common. * , tx_sometable_common2.sorting
> FROM tx_sometable_common
> INNER JOIN tx_sometable_common AS tx_sometable_common2 ON (
> tx_sometable_common.sorting = tx_sometable_common2.sorting )
> LEFT JOIN pages ON pages.uid = tx_sometable_common.pid
> WHERE tx_sometable_common.pid
> IN ( 36, 37, 44 ) AND tx_sometable_common.deleted =0 AND
> tx_sometable_common.hidden =0
> GROUP BY tx_sometable_common.pid
> ORDER BY pages.sorting, tx_sometable_common.sorting
> 
> Is that within supported subset?
> (of course I use t3lib_db::exec_SELECTquery(...) )
> 
> would be really cool, cause I am just picking up on the magic of sql,
> which can save loads of php sometimes. ;)
> 
> Thx,
> Peter
> 
> 
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>