slow query

sql query

SELECT p.name as procedure_name, addr.zip as zip,
				s.procedure_id	as proc,  s.id
				FROM slots AS s, procedures AS p, organizations AS o, addresses_organizations as au, addresses as addr
				WHERE s.provider_id = o.id
				AND s.procedure_id = p.id
				AND au.organization_id = o.id
				AND addr.id = au.address_id
				AND addr.zip LIKE '".$zipcode."%'
				ORDER BY random()
				LIMIT 5