Error - supercategories
Disk full (/tmpramdisk/#sql_73c9_0); waiting for someone to free some space...
SELECT t1.id AS supercat_id, t1.desc_es AS supercat_title, t1.short_es AS supercat_short, t1.title_mini_es AS supercat_mini, t1.url_es AS supercat_url, t2.title AS supercat_country_title, t2.title_short AS supercat_country_short, t2.meta_tags AS supercat_country_meta_tags, t2.meta_desc AS supercat_country_meta_desc, t2.web_desc AS supercat_country_web_desc, t2.title_mini AS supercat_country_mini FROM xtra_cat AS t1 LEFT JOIN data_cat_country AS t2 ON ( t2.id_cat=t1.id AND t2.id_country='25' AND t2.id_language='es' ) WHERE t1.state=1 AND t1.is_supercat=1 ORDER BY FIELD(t1.id,103,102,101)