Skip to content

Instantly share code, notes, and snippets.

@padak

padak/hlidacshopu-yankee.sql

Last active November 28, 2019 22:19
Show Gist options
  • Save padak/e3ccf165650c6a469bf2e62e2b470bbc to your computer and use it in GitHub Desktop.
Save padak/e3ccf165650c6a469bf2e62e2b470bbc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hlidacshopu-yankee.sql
SELECT
shop,
date,
itemId,
itemName,
itemUrl,
currentPrice
FROM
`hlidacshopu.hlidacshopu.allshops_uniq`
WHERE
LOWER(itemName) LIKE '%yenkee ysp 2001%'
AND date = '2019-11-27'
ORDER BY
shop,
date
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment