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 (59 = type OR 59 = type_2 OR 59 = type_3) AND last_updated <= NOW() AND page_type=3 AND status=1 HAVING (Relevance1+Relevance2+Relevance3) > 0 ORDER BY (Relevance1+Relevance2+Relevance3) DESC

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

020 3559 6777

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