|
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/right-to-housing/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/right-to-housing/article Dossiers Right to Housing --- 2 articles found --- Click on the titles --- Habitat Netz Fri, Feb 02 2007 The Universal Declaration of Human Rights declared that housing is one of the components of the human right to an adequate standard of living. Since then, the international community on the right to housing have developed a couple of instruments, including some internationally binding convenants. Here, we provide some links to basic information. >> To the Dossier >> zur Rubrik Habitat Netz Wed, Mar 07 2007 It is common to speak about violations of housing rights when it comes to extraodinary large forced evictions without proper compensation. Focussing on such mass evictions, which can affect thousands and hundred thousands of people are moere and more alarming in Africa and emerging economies in Asia, we should not forget the everday pressure on poor and ordinary inhabitants, which can have catastrophic consequences even in "developed" countries in Europa or North America. This dossier deals with the "structural violence" behind the phenomenons. Barcelona movements call it "urban real estate violence": speculation, mobbing of inhabitants, incremental legal evictions, rent increases... >> To the Dossier >> zur Rubrik |
|
