Skip to content

Instantly share code, notes, and snippets.

@nlively
Created April 27, 2012 17:04
Show Gist options
  • Save nlively/2510846 to your computer and use it in GitHub Desktop.
Save nlively/2510846 to your computer and use it in GitHub Desktop.
Service item retrieval
SELECT
jp.*,
si.description, si.service_id
FROM sun_sundocfilings_jurisdiction_prices jp
JOIN sun_sundocfilings_service_items si
ON jp.service_id = si.service_id
AND jp.item_id = si.guid
WHERE jurisdiction_id = 'd273a29a-60ea-e011-9f2a-485b397450b7'
AND NAME LIKE '%Articles%';
@nlively
Copy link
Author

nlively commented Apr 27, 2012


mysql> select * from sun_sundocfilings_jurisdiction_prices where service_id = '36a0e6b1-afd8-4fe6-88ee-a007010bb5af' and item_id = 'e228e7ca-06d6-48bb-b2a1-9f6000a4cb95';
Empty set (0.00 sec)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment