Правильность синтаксиса запроса - страница 3 - Общие вопросы по расширениям Joomla

$query->where('a.tagids IN('.implode(',', array_filter($params->get('spsimpleportfolio_tags'))).')');

$query->where('id IN('.implode(',', array_filter($params->get('spsimpleportfolio_tags'))).')');

<field name="category_id" type="category" extension="com_spsimpleportfolio" default="" label="MOD_SPSIMPLEPORTFOLIO_CATEGORY" description="MOD_SPSIMPLEPORTFOLIO_CATEGORY">
<option value="">MOD_SPSIMPLEPORTFOLIO_CATEGORY_ALL</option>
</field>

<field name="spsimpleportfolio_tags" type="spsimpleportfoliotags" label="MOD_SPSIMPLEPORTFOLIO_CATEGORY" multiple="multiple" class="input-xxlarge" description="MOD_SPSIMPLEPORTFOLIO_CATEGORY">
<option value="">MOD_SPSIMPLEPORTFOLIO_CATEGORY_ALL</option>
</field>

$query->select('a.*, a.id AS spsimpleportfolio_item_id , a.tagids AS spsimpleportfolio_tag_id, a.created AS created_on')
->from($db->quoteName('#__spsimpleportfolio_items', 'a'))
->where($db->quoteName('a.published'). ' = 1');
//has category
if ($params->get('category_id')!= '') {
$query->where($db->qn('a.catid')." = ".$db->quote( $params->get('category_id') ));
}
$query->where($db->quoteName('a.access')." IN (" . implode( ',', JFactory::getUser()->getAuthorisedViewLevels() ). ")")
->order($db->quoteName('a.ordering'). ' ASC')
->setLimit($params->get('limit', 6));

$query->select('a.*, a.id AS spsimpleportfolio_item_id , a.tagids AS spsimpleportfolio_tag_id, a.created AS created_on')
->from($db->quoteName('#__spsimpleportfolio_items', 'a'))
->where($db->quoteName('a.published'). ' = 1');
//has category
if ($params->get('spsimpleportfolio_tags')!= '') {
$query->where('a.tagids IN('.implode(',', array_filter($params->get('spsimpleportfolio_tags'))).')');
}
$query->where($db->quoteName('a.access')." IN (" . implode( ',', JFactory::getUser()->getAuthorisedViewLevels() ). ")")
->order($db->quoteName('a.ordering'). ' ASC')
->setLimit($params->get('limit', 6));

if ($params->get('category_id')!= '') {

if ($params->get('spsimpleportfolio_tags')!= '') {

#1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY id ASC' at line 3 SQL=SELECT `id`,`title`,`alias` FROM `#__spsimpleportfolio_tags` WHERE `id` IN () ORDER BY id ASC

$query->select('a.*, a.id AS spsimpleportfolio_item_id , a.tagids AS spsimpleportfolio_tag_id, a.created AS created_on')
->from($db->quoteName('#__spsimpleportfolio_items', 'a'))
->where($db->quoteName('a.published'). ' = 1');
//has category
if ($params->get('spsimpleportfolio_tags')!= '')
$query->where('id IN('.implode(',', array_filter($params->get('spsimpleportfolio_tags'))).')');
}
$query->where($db->quoteName('a.access')." IN (" . implode( ',', JFactory::getUser()->getAuthorisedViewLevels() ). ")")
->order($db->quoteName('a.ordering'). ' ASC')
->setLimit($params->get('limit', 6));

$tagged_items = array();

foreach ($items as $item) {
	$item->tagids = json_decode($item->tagids);
	
	if (!empty($item->tagids)) {
		$tagged_items[] = $item;
	}
}

if (!empty($tagged_items)) {
	$tagList = $model->getTagList($tagged_items);
}

$moduleclass_sfx = htmlspecialchars($params->get('moduleclass_sfx'));

SELECT `id`,`title`,`alias` FROM `#__spsimpleportfolio_tags` WHERE `id` IN ()