Joomla! 1.5x Customization by Daniel Chapman
Author:Daniel Chapman
Language: eng
Format: mobi, epub
Publisher: Packt Publishing
This will leave us with a query that looks something like this:
SELECT u.username as name, u.id as userid, count(jp.id) as total FROM jos_joobb_posts jp LEFT JOIN jos_users u ON jp.id_user = u.id GROUP BY u.id ORDER BY total DESC
If we put this query into Easy SQL, we should get exactly the output we are after. However, there may be an unnamed record in your list. This is because Joo!BB can allow guests to post (depending on your settings) in the forum, and it is very likely that if we allow guests, then guest will always be our top user. This is because all guests posts will be added together.
So to get around this, we will add a WHERE clause into our SQL to ignore the guest posts.
SELECT u.username as name, u.id as userid, count(jp.id) as total FROM jos_joobb_posts jp LEFT JOIN jos_users u ON jp.id_user = u.id WHERE jp.id_user > 0 GROUP BY u.id ORDER BY total DESC
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Hello! Python by Anthony Briggs(9928)
The Mikado Method by Ola Ellnestam Daniel Brolund(9791)
Dependency Injection in .NET by Mark Seemann(9348)
Sass and Compass in Action by Wynn Netherland Nathan Weizenbaum Chris Eppstein Brandon Mathis(7792)
The Well-Grounded Java Developer by Benjamin J. Evans Martijn Verburg(7570)
Svelte with Test-Driven Development by Daniel Irvine(7287)
Test-Driven Development with PHP 8 by Rainier Sarabia(7026)
Layered Design for Ruby on Rails Applications by Dementyev Vladimir;(6881)
Secrets of the JavaScript Ninja by John Resig & Bear Bibeault(6541)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6427)
Web Development with Django by Ben Shaw Saurabh Badhwar(6344)
React Application Architecture for Production by Alan Alickovic(6067)
Jquery UI in Action : Master the concepts Of Jquery UI: A Step By Step Approach by ANMOL GOYAL(5816)
Kotlin in Action by Dmitry Jemerov(5076)
Audition by Ryu Murakami(4594)
Software Architecture for Web Developers by Mihaela Roxana Ghidersa(4521)
Accelerating Server-Side Development with Fastify by Manuel Spigolon Maksim Sinik & Matteo Collina(4369)
Hands-On Full-Stack Web Development with GraphQL and React by Sebastian Grebe(4323)
Solidity Programming Essentials by Ritesh Modi(4074)
