SELECT DISTINCT(items.id) as item_id,
items.visibility
FROM items
LEFT JOIN item_custom_data AS order_table ON order_table.account_id=items.account_id AND order_table.item_id=items.id AND order_table.key='date'
LEFT JOIN item_custom_data AS filter_table ON filter_table.account_id=items.account_id AND filter_table.item_id=items.id AND filter_table.key='date'
LEFT JOIN item_types on items.item_type_id=item_types.id
LEFT JOIN item_type_visibilities as itv ON items.item_type_id=itv.item_type_id AND items.account_id = itv.account_id
WHERE items.account_id=33254 AND (items.visibility IS NULL OR items.visibility IN('P'))
AND (SELECT COUNT(DISTINCT(item_custom_info.item_id))
FROM item_custom_info
WHERE item_custom_info.item_id=items.id AND
item_custom_info.account_id=items.account_id AND
item_custom_info.lang_code='ESP') > 0 AND item_types.name='Agenda' AND items.status='A' AND items.deleted=0 AND items.scope='module_agenda' AND filter_table.value >= '1328569200'
ORDER BY items.position ASC, order_table.value ASC, items.date_create DESC
LIMIT 10 OFFSET 0
Cartera de empleo - Hispanogas, S. A.