Konkurss 2020 - Märka LEADERit 2.0
Eesti maaelu arengukava 2014-2020 LEADER-meetme parimate projektid andmebaas:
SELECT t1.`id` , tt0.value, tt1.value, tt2.value, tt3.value, tt4.value, tt5.value FROM `maa_db_record` AS t1 LEFT JOIN maa_db_record_value tt0 ON tt0.record_id=t1.id AND tt0.field_id='601' AND tt0.lang_id='est' LEFT JOIN maa_db_record_value tt1 ON tt1.record_id=t1.id AND tt1.field_id='604' AND tt1.lang_id='est' LEFT JOIN maa_db_record_value tt2 ON tt2.record_id=t1.id AND tt2.field_id='607' AND tt2.lang_id='est' LEFT JOIN maa_db_record_value tt3 ON tt3.record_id=t1.id AND tt3.field_id='611' AND tt3.lang_id='est' LEFT JOIN maa_db_record_value tt4 ON tt4.record_id=t1.id AND tt4.field_id='612' AND tt4.lang_id='est' LEFT JOIN maa_db_record_value tt5 ON tt5.record_id=t1.id AND tt5.field_id='625' AND tt5.lang_id='est' LEFT JOIN maa_db_record_value tt6 ON tt6.record_id=t1.id AND tt6.field_id='623' AND tt6.lang_id='est' WHERE t1.db_id='42' AND t1.archive='false' AND t1.avalik='true' GROUP BY t1.id ORDER BY tt1.value asc, tt6.value DESC, t1.`id`
Disk full (/tmp/#sql-temptable-467-1e82c7-c6757.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")