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

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

33 <field name="category_id" type="sql" default="" extension="com_spsimpleportfolio" multiple="multiple" class="input-xxlarge" query="SELECT id, title FROM #__spsimpleportfolio_tags ORDER BY title ASC" key_field="id" value_field="title" label="MOD_SPSIMPLEPORTFOLIO_CATEGORY" description="MOD_SPSIMPLEPORTFOLIO_CATEGORY" />

22 //has category
23 if ($params->get('category_id') != '') {
24 $query->where($db->qn('a.catid')." = ".$db->quote( $params->get('category_id') ));
25 }

22 //has category
23 if ($params->get('category_id') != '') {
24 $query->where($db->qn('a.tagids')." = ".$db->quote( $params->get('category_id') ));
25 }

{"show_filter":"0","category_id":["10","6","7","9"],"layout_type":"gallery_space","columns":"3","thumbnail_type":"rectangular","limit":"6","layout":"_:default","moduleclass_sfx":"","cache":"1","cache_time":"900","module_tag":"div","bootstrap_size":"0","header_tag":"h3","header_class":"","style":"0"}

<?php $query->where('a.catid IN('.implode(',', $params->get('category_id')).')'); ?>

$query->where($db->qn('a.tagids')." = ".$db->quote( $params->get('category_id') ));

$query->where('a.catid IN('.implode(',', $params->get('category_id')).')');

<field name="category_id" type="sql" default="" extension="com_spsimpleportfolio" multiple="multiple" class="input-xxlarge" query="SELECT id, title FROM #__spsimpleportfolio_tags ORDER BY title ASC" key_field="id" value_field="title" label="MOD_SPSIMPLEPORTFOLIO_CATEGORY" description="MOD_SPSIMPLEPORTFOLIO_CATEGORY" />

<field name="spsimpleportfolio_tags" type="spsimpleportfoliotags" label="MOD_SPSIMPLEPORTFOLIO_CATEGORY" description="MOD_SPSIMPLEPORTFOLIO_CATEGORY"><option value="">MOD_SPSIMPLEPORTFOLIO_CATEGORY_ALL</option></field>

<?php print_r($params->get('spsimpleportfolio_tags')); ?>

<?php $query->where('a.tagids IN('.implode(',', $params->get('category_id')).')'); ?>

if ($params->get('category_id')!= '') {
$query->where('a.tagids IN('.implode(',', $params->get('category_id')).')');
}

<?php $query->where('a.tagids IN('.implode(',', $params->get('category_id')).')'); ?>

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

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

<?php $items = $db->loadObjectList(); ?>

<?php echo (string)$query; ?>

SELECT a.*, a.id AS spsimpleportfolio_item_id , a.tagids AS spsimpleportfolio_tag_id, a.created AS created_on
FROM `#__spsimpleportfolio_items` AS `a`
WHERE `a`.`published` = 1 AND `a`.`access` IN (1,1,5)
ORDER BY `a`.`ordering` ASC LIMIT 6