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 '%DENIA%')) AND (`tipo`.listingsdbelements_field_name = 'tipo' AND `tipo`.listingsdbelements_field_value = 'apartamento') ORDER BY listingsdb_last_modified DESC

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

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

---------------------------------------------------------
Server Type: Apache
Request Method: GET
Query String: cur_page=1&sortby=listingsdb_last_modified&sorttype=DESC&action=searchresults&operacion%5B%5D=Venta&poblacion%5B%5D=DENIA&tipo=apartamento
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Request URI: /index.php?cur_page=1&sortby=listingsdb_last_modified&sorttype=DESC&action=searchresults&operacion%5B%5D=Venta&poblacion%5B%5D=DENIA&tipo=apartamento
POST Variables: array (
)
GET Variables: array (
'cur_page' => '1',
'sortby' => 'listingsdb_last_modified',
'sorttype' => 'DESC',
'action' => 'searchresults',
'operacion' =>
array (
0 => 'Venta',
),
'poblacion' =>
array (
0 => 'DENIA',
),
'tipo' => 'apartamento',
'printer_friendly' => false,
)