No publications found

 

 

SELECT id, page_url, last_updated, title, description, pub_isbn, pub_cover, pub_secure, pub_down, pub_pdfkb , CASE WHEN (type_archive=1 OR archive=1) THEN -30 ELSE 0 END AS Relevance3, (MATCH (type_name) AGAINST ("§ion=44") * 5) AS Relevance1, (MATCH(title) AGAINST("§ion=44") * 10) + (MATCH(TEXT) AGAINST("§ion=44") * 3) + (MATCH(description) AGAINST("§ion=44")) AS Relevance2 FROM content_2014 LEFT JOIN type ON content_2014.type = type_id WHERE (((MATCH(title) AGAINST("§ion=44")) OR (MATCH(TEXT) AGAINST("§ion=44")) OR (MATCH(description) AGAINST("§ion=44"))) OR MATCH(type_name) AGAINST("§ion=44")) AND (14 = type OR 14 = type_2 OR 14 = type_3) AND last_updated <= NOW() AND page_type=3 AND status=1 HAVING (Relevance1+Relevance2+Relevance3) > 0 ORDER BY (Relevance1+Relevance2+Relevance3) DESC

Sustain
The Green House
244-254 Cambridge Heath Road
London E2 9DA

020 3559 6777
sustain@sustainweb.org
RSS

Sustain advocates food and agriculture policies and practices that enhance the health and welfare of people and animals, improve the working and living environment, promote equity and enrich society and culture.

© Sustain 2020
Registered charity (no. 1018643)
Data privacy & cookies

Sustain