--CATEGORIES ENDPOINT
SELECT
*
FROM
V3_CATEGORIES
SELECT
*
FROM
V3_CATEGORIES
WHERE
alias
LIKE
'%food%'
SELECT
C.ALIAS, C.TITLE, PA.PARENT_ALIASE, PA.POSITION
FROM
V3_CATEGORIES C
INNER
JOIN
PARENT_ALIASES PA
ON
PA.V3_CATEGORIES_TITLE = C.TITLE
SELECT
C.ALIAS, C.TITLE, CB.COUNTRY_BLACKLIST, CB.
"POSITION"
FROM
V3_CATEGORIES C
INNER
JOIN
COUNTRY_BLACKLIST CB
ON
CB.V3_CATEGORIES_TITLE = C.TITLE
SELECT
C.ALIAS, C.TITLE, CW.COUNTRY_BLACKLIST, CW.
"POSITION"
FROM
V3_CATEGORIES C
INNER
JOIN
COUNTRY_WHITELIST CW
ON
CW.V3_CATEGORIES_TITLE = C.TITLE
--Events API
SELECT
*
FROM
EVENTS_1
--Location can be zip code, city, state
SELECT
*
FROM
BUSINESS
WHERE
LOCATION=
'New York'
SELECT
*
FROM
BUSINESSES
WHERE
BUSINESS_LOCATION=
'San Francisco'
SELECT
*
FROM
BUSINESSES B
INNER
JOIN
CATEGORIES_1 C
ON
B.
"POSITION"
= C.BUSINESSES_POSITION
WHERE
B.BUSINESS_LOCATION=
'Denver'
AND
C.BUSINESS_LOCATION=
'Denver'
SELECT
*
FROM
BUSINESSES B
INNER
JOIN
CATEGORIES_1 C
ON
B.
"POSITION"
= C.BUSINESSES_POSITION
WHERE
B.BUSINESS_LOCATION=
'Denver'
AND
C.BUSINESS_LOCATION=
'Denver'
AND
c.ALIAS
LIKE
'%brunch%'