Here is what I have...
Code: Select all
SELECT users.users_id AS users_id, users.name AS name, users.created_dt AS date, count( content.content_id ) AS contentcount, replace( DATEDIFF( content.created_dt, now( ) ) , '-', '' ) AS datediff, time_format( replace( TIMEDIFF( content.created_dt, now( ) ) , '-', '' ) , '%l' ) AS timediff
FROM users
LEFT JOIN content ON users.users_id = content.users_id
WHERE users.users_id = 27
AND users.active = '1' AND content.
GROUP BY users.name
ORDER BY users.name, users.created_dt