Оказывается, можно:
SELECT *, trt1.tag_id AS tag1, trt2.tag_id AS tag2 FROM information_items_table
INNER JOIN tags_relation_table AS trt1 ON information_items_table.information_items_id = trt1.information_items_id
INNER JOIN tags_relation_table AS trt2 ON information_items_table.information_items_id = trt2.information_items_id
WHERE information_items_table.information_systems_id = 27
HAVING tag1 IN (103) AND tag2 IN (212)
Теперь пытаюсь этот запрос перевести в термины АПИ (пока только по одной метке):
$property['select_fields'] .= ', trt1.tag_id AS tag1 ';
$property['sql_from'] .= ' INNER JOIN tags_relation_table AS trt1 ON information_items_table.information_items_id = trt1.information_items_id ';
$property['sql_having'] = ' HAVING tag1 IN (103) ';
К сожалению, в запрос попадает только секция sql_from:
SELECT SQL_CALC_FOUND_ROWS DISTINCT information_items_table.information_items_id FROM information_items_table LEFT JOIN information_groups_table ON information_items_table.information_groups_id = information_groups_table.information_groups_id AND information_groups_table.information_groups_access IN (0,-1) INNER JOIN tags_relation_table AS trt1 ON information_items_table.information_items_id = trt1.information_items_id WHERE information_items_table.information_systems_id = '27' AND information_items_table.information_items_status = '1' AND (information_items_table.information_items_putend_date >= '2011-07-11 20:32:40' OR information_items_table.information_items_putend_date ='0000-00-00 00:00:00') AND information_items_table.information_items_putoff_date <= '2011-07-11 20:32:40' AND information_items_table.information_items_access IN (0,-1) AND (information_items_table.information_groups_id='0' ) ORDER BY information_items_date desc LIMIT 0, 10
Еще раз посмотрела АПИ, - вроде все верно. Поискала по форуму, но нигде не нашла примеров использования секций $property['select_fields'] и $property['sql_having'].
Помогите, пожалуйста!