|
From the columns:
c_query_subs 1 SELECT id, target, type, filelink, filepad, place, country, filedate, date_format( filedate, '%a, %b %d %Y' ) AS date, date_format(filedate,'') as day, time_format(starttime,'%h:%i %p') as starttime, time_format(endtime,'%h:%i %p') as endtime, Tit, Utit, Vsp, Txt, author, authoremail, organization, rights, economy, policy, environment, social, strategies, discourses, movements, region, en, fr, es, de, date_pass, mainlink, piclink, picalt, link1, link1_descr, link2, link2_descr, link3, link3_descr, dos_name, lib_author, lib_type, lib_title, lib_url, lib_year,lib_descr, lib_editor, lex_name, term, term_trans, sources, status, habitantsDOTde FROM habitantsDOTde_en
WHERE target '%habitants.de%' AND filepad = 'topics/europe/articles' AND type = 'fix' AND access = 'pub' AND status = 'public'
ORDER BY filedate DESC LIMIT 1 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''%habitants.de%' AND filepad = 'topics/europe/articles' AND typ Habitat and Europe --- 1 article found --- Click on the titles --- Habitat Netz Sun, May 20 2007 According to the EU constitution draft and the Lisbon strategy "territorial cohesion" - besides economic and social cohesion - should become a third pillar of European integration and the Lisbon strategy which aims to make the EU the "most competitive knowledge based economy in the world". Within this frame real sustainability, social inclusion and right based approaches have a diificult standing. >> To the Dossier >> zur Rubrik |
|
