J! 3.4.8 переезд и проблемы - Joomla 3.x: Общие вопросы

SET timestamp=1455810781;
SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,vl.title AS access_title
FROM j_content as a
LEFT JOIN j_categories AS c ON c.id = a.catid
LEFT JOIN j_users AS ua ON ua.id = a.created_by
LEFT JOIN j_viewlevels AS vl ON a.access = vl.id
LEFT OUTER JOIN (select rsi.provider_id, rsi.order from j_roksprocket_items as rsi where module_id = 424) rsi on a.id = rsi.provider_id
WHERE ((a.access IN(1,1,2,3,6) AND (a.state != -2)) AND a.catid IN (151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203))
GROUP BY id
ORDER BY IF(ISNULL(rsi.order),1,0),rsi.order,a.created DESC LIMIT 120;

AND a.catid IN (151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203)

LEFT OUTER JOIN (SELECT rsi.provider_id, rsi.ORDER FROM j_roksprocket_items AS rsi WHERE module_id = 424) rsi ON a.id = rsi.provider_id

	protected function setBaseQuery()
	{
		$this->query->select('a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid' . ', a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits' . ', a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata')->from('#__content as a');

		$this->query->select('c.title AS category_title, c.alias AS category_alias');
		$this->query->join('LEFT', '#__categories AS c ON c.id = a.catid');

		$this->query->select('ua.name AS author_name');
		$this->query->join('LEFT', '#__users AS ua ON ua.id = a.created_by');

//		$this->query->select('um.name AS last_modified_by');
//		$this->query->join('LEFT', '#__users AS um ON um.id = a.modified_by');

//		$this->query->select('ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count');
//		$this->query->join('LEFT', '#__content_rating AS v ON a.id = v.content_id');

		$this->query->select('vl.title AS access_title');
		$this->query->join('LEFT', '#__viewlevels AS vl ON a.access = vl.id');

//		$this->query->select('l.title AS language_title');
//		$this->query->join('LEFT', '#__languages AS l ON a.language = l.lang_code');
	}

SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,vl.title AS access_title FROM #__content as a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__viewlevels AS vl ON a.access = vl.id WHERE ((a.access IN(1,1,2,3,6) AND (a.state != -2)) AND a.catid IN (151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203)) GROUP BY id ORDER BY a.created DESC LIMIT 120

$this->query->group('id');