Debugging a specific query
From Joomla! Documentation
Example:debugging a specific query[edit]
//$db = your db object gotten before, with a query loaded (set)
var_dump($db->replacePrefix( (string) $db->getQuery()) );//debug
You can also try this with some other debug methods instead because a "var_dump" (bit like echo) will not always display on your screen.
E-builds 2012-09-11