EJEMPLO: 2014-09 devuelve Farmacias de Turno en Septiembre | (Prioriza las fechas cercanas)
Fatal error: Uncaught DatabaseHelper::query failed. (Out of resources when opening file '/tmp/#sql_302_0.MYI' (Errcode: 24) SQL=SELECT a.* FROM jos_zoo_item AS a LEFT JOIN jos_zoo_search_index AS s ON a.id = s.item_id AND s.element_id IN ('b870164b-fe78-45b0-b840-8ebceb9b9cb6') WHERE a.type = 'farmacia' AND a.application_id = 1 AND access <= 0 AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-09-19 21:51:20') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-09-19 21:51:20') GROUP BY a.id ORDER BY a.priority DESC, ISNULL(s.value), s.value LIMIT 0,20) thrown in /home/wwwenfarmaciasco/public_html/administrator/components/com_zoo/framework/helpers/database.php on line 37