Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
slow query
SELECT as procedure_name, as zip,
s.procedure_id as proc,
FROM slots AS s, procedures AS p, organizations AS o, addresses_organizations as au, addresses as addr
WHERE s.provider_id =
AND s.procedure_id =
AND au.organization_id =
AND = au.address_id
AND LIKE '".$zipcode."%'
ORDER BY random()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment