[РЕШЕНО] MySQL запрос на получение данных из доп. полей и статей - Joomla 3.x: Общие вопросы

		$db = JFactory::getDBO();
		$query = '
		select *
		from #__fields_values
		where item_id IN ('.$params.')
		';
		$db->setQuery($query);

SELECT fv.value, c.id, c.title, c.images FROM #__fields_values as fv LEFT JOIN #__content as c ON c.id = fv.item_id WHERE fv.item_id IN($params)

$db = JFactory::getDbo();
$query = $db->getQuery(true);

$query->select('fv.*, c1.id, c1.title, c1.catid, c2.title as cat_title')
	->select('c1.images->>"$.image_intro" as image_intro')
	->from('#__fields_values as fv')
	->leftJoin('#__content as c1 ON c1.id = fv.item_id')
	->leftJoin('#__categories as c2 ON c2.id = c1.catid')
	->where('fv.item_id IN(' . $params . ')');

$db->setQuery($query);

$query = '
SELECT fv.value, c.id, c.catid, c.title, c.images 
FROM #__fields_values as fv 
LEFT JOIN #__content as c ON c.id = fv.item_id 
WHERE fv.item_id IN ('.$params.')
';

$rows = $db->loadObjectList();

$rows = $db->loadAssocList('item_id');

<?php
$query = '
SELECT fv.field_id, fv.value, c.id, c.catid, c.title, c.images
FROM #__fields_values as fv
LEFT JOIN #__content as c ON c.id = fv.item_id
WHERE fv.item_id IN ('.$params.')
';
$db->setQuery($query);
$rows = $db->loadObjectList();
$items = array();
foreach($rows as $row) $items[$row->item_id][$row->field_id] = $row;

AND fv.field_id IN (3,2,9)