SELECT id, companyName, data AS reagon FROM cst INNER JOIN prop ON name = 'reagon' AND cstID=cst.id WHERE prop.data = 'all' AND disabled != 'Y' ORDER BY BINARY(LCASE(companyName))
חיים וסביבה. נחלת בנימין 85, ת"א 66102. טלפון: 03-5602256 פקס: 03-5602104 sviva@sviva.net Life & Environment, 85 Nahalat Binyamin st., TelAviv 66102 Tel: 972-3-5602256 Fax: 972-3-5602104 www.sviva.net
