Need some examples of usages of JDatabaseQuery

[xillibit]

Hello,

I need some examples of replacements with JDatabaseQuery for the followings MySQL functions:

• MAX()
• TRIM()
• COUNT(*)
• SUM()
• INSERT IGNORE INTO
• DISTINCT
• REPLACE INTO

For this kind of query how i do with JDatabaseQuery :

INSERT INTO #__myusers (userid,options) SELECT a.id AS userid, 1 AS options
                    FROM #__users AS a
                    LEFT JOIN #__myusers AS b ON b.userid=a.id
                    WHERE b.userid IS NULL

Thanks in advance