most userful joomla function to debug database query

// Get a db connection. $db = JFactory::getDbo();   // Create a new query object. $query = $db->getQuery(true);   // Select all articles for users who have a username which starts with ‘a’. // Order it by the created date.…