SELECT id ,city, wtype,wtype_id FROM paradox_wshops WHERE REPLACE(lower(city),' ','') LIKE 'locationshtmlstate' AND id % 100 = 45 AND enable = '1' AND date::date>=NOW()- interval '1 day'