Несколько запросов в $db->setQuery. Как ? - Модификации расширений для Joomla

CREATE TEMPORARY TABLE loc ( id INT(11) NOT NULL, loc longtext NOT NULL );
INSERT INTO loc (id, loc) SELECT record_id, field_value FROM jos_js_res_record_values WHERE field_id IN (10,48);
CREATE TEMPORARY TABLE HTML ( id INT(11) NOT NULL, HTML longtext NOT NULL );
INSERT INTO HTML (id, html) SELECT record_id, field_value FROM jos_js_res_record_values WHERE field_id IN (3,33);
CREATE TEMPORARY TABLE img ( id INT(11) NOT NULL, img longtext NOT NULL );
INSERT INTO img (id, img) SELECT record_id, field_value FROM jos_js_res_record_values WHERE field_id IN (47,49);
SELECT r.id, r.title, r.published, r.type_id, rc.catid, loc.loc, html.html, img.img FROM jos_js_res_record AS r LEFT JOIN jos_js_res_record_category AS rc ON rc.record_id = r.id 
LEFT JOIN loc AS loc ON loc.id = r.id
LEFT JOIN HTML as HTML ON html.id = r.id
LEFT JOIN img as img ON img.id = r.id
WHERE r.type_id IN (1,8,10) AND rc.catid IN (2,205,206)

        $db = &JFactory::getDBO();

        $query = 'CREATE TEMPORARY TABLE loc ( id INT(11) NOT NULL, loc longtext NOT NULL ); ';
		$db->setQuery($query);
		$db->queryBatch();
		$query = ' INSERT INTO loc (id, loc) SELECT record_id, field_value FROM jos_js_res_record_values WHERE field_id IN (10,48);';
		$db->setQuery($query);
		$db->queryBatch();
		$query = 'CREATE TEMPORARY TABLE HTML ( id INT(11) NOT NULL, HTML longtext NOT NULL );';
		$db->setQuery($query);
		$db->queryBatch();
		$query = 'INSERT INTO HTML (id, html) SELECT record_id, field_value FROM jos_js_res_record_values WHERE field_id = 3;';
		$db->setQuery($query);
		$db->queryBatch();
		$query = 'CREATE TEMPORARY TABLE img ( id INT(11) NOT NULL, img longtext NOT NULL );';
		$db->setQuery($query);
		$db->queryBatch();
		$query = 'INSERT INTO img (id, img) SELECT record_id, field_value FROM jos_js_res_record_values WHERE field_id = 47;';
		$db->setQuery($query);
		$db->queryBatch();
		$query = 'SELECT r.id, r.title, r.published, r.type_id, rc.catid, loc.loc, html.html, img.img FROM jos_js_res_record AS r 
		LEFT JOIN jos_js_res_record_category AS rc ON rc.record_id = r.id 
		LEFT JOIN loc AS loc ON loc.id = r.id
		LEFT JOIN HTML as HTML ON html.id = r.id
		LEFT JOIN img as img ON img.id = r.id
		WHERE r.type_id IN (1,8,10) AND rc.catid IN (2,205,206)';
		$db->setQuery($query);
       
		$items = $db->loadObjectList();
		return $items;

function getItems($params, $cids)
    {
 $db = &JFactory::getDBO();
$query = 'xxxxxxxxxx';
$db->setQuery($query);
$db->queryBatch();
$items = $db->loadObjectList();
return $items;
   }

function getItems($params, $cids)
    {
 $db = &JFactory::getDBO();
$query = 'xxxxxxxxxx';
$db->setQuery($query);
$items = $db->queryBatch();
return $items;
   }

function getItems($params, $cids)
    {
 $db = &JFactory::getDBO();
$query = 'много запросов подряд';
$db->setQuery($query);
$items = $db->queryBatch();
$query = 'результирующий запрос SELECT ххх';
$db->setQuery($query);
$items = $db->loadObjectList();
return $items;
   }