Here is an example of how to write subquery in Joomla! 3 using JDatabase method. <?php // Initialize variables. $db = JFactory::getDbo(); $subQuery = $db->getQuery(true); $query = $db->getQuery(true); // Create the base subQuery select statement.