SQL Error Message: Disk full (/var/tmp/#sql_447_0); waiting for someone to free some space...
SQL statement that failed below:
---------------------------------------------------------
SELECT distinct(in_es_listingsdb.listingsdb_id), in_es_listingsdb.userdb_id, in_es_listingsdb.listingsdb_title FROM in_es_listingsdb ,in_es_listingsdbelements `operacion` ,in_es_listingsdbelements `poblacion` ,in_es_listingsdbelements `tipo` WHERE (listingsdb_active = 'yes' OR listingsdb_active = 'no') AND (in_es_listingsdb.listingsdb_id = `operacion`.listingsdb_id) AND (in_es_listingsdb.listingsdb_id = `poblacion`.listingsdb_id) AND (in_es_listingsdb.listingsdb_id = `tipo`.listingsdb_id) AND (`operacion`.listingsdbelements_field_name = 'operacion' AND ( `operacion`.listingsdbelements_field_value LIKE '%Venta%')) AND (`poblacion`.listingsdbelements_field_name = 'poblacion' AND ( `poblacion`.listingsdbelements_field_value LIKE '%JALON/XALO%' OR `poblacion`.listingsdbelements_field_value LIKE '%ORBA%')) AND (`tipo`.listingsdbelements_field_name = 'tipo' AND `tipo`.listingsdbelements_field_value = 'villa') ORDER BY listingsdb_last_modified DESC

---------------------------------------------------------

ERROR REPORT www.gpereto.com: January 17, 2019, 3:40:37 am

---------------------------------------------------------
Server Type: Apache
Request Method: GET
Query String: sortby=listingsdb_last_modified&sorttype=DESC&action=searchresults&operacion%5B%5D=Venta&aseos-max=&habs-min=%5Bobject+Object%5D&poblacion%5B%5D=JALON%2FXALO&poblacion%5B%5D=ORBA&habs-min=&precio-min=&tipo=villa&vistas=&precio-max=&ref=
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Request URI: /index.php?sortby=listingsdb_last_modified&sorttype=DESC&action=searchresults&operacion%5B%5D=Venta&aseos-max=&habs-min=%5Bobject+Object%5D&poblacion%5B%5D=JALON%2FXALO&poblacion%5B%5D=ORBA&habs-min=&precio-min=&tipo=villa&vistas=&precio-max=&ref=
POST Variables: array (
)
GET Variables: array (
'sortby' => 'listingsdb_last_modified',
'sorttype' => 'DESC',
'action' => 'searchresults',
'operacion' =>
array (
0 => 'Venta',
),
'aseos-max' => '',
'habs-min' => '',
'poblacion' =>
array (
0 => 'JALON/XALO',
1 => 'ORBA',
),
'precio-min' => '',
'tipo' => 'villa',
'vistas' => '',
'precio-max' => '',
'ref' => '',
'printer_friendly' => false,
)