Skip to content

Instantly share code, notes, and snippets.

Jack Scott JackScottAU

Block or report user

Report or block JackScottAU

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
JackScottAU / get_customer_emails.sql
Created Jul 19, 2017
Get Customer Emails from WooCommerce
View get_customer_emails.sql
SELECT meta_value AS email, COUNT(meta_value) AS orders
FROM wp_postmeta INNER JOIN wp_posts ON wp_posts.ID = wp_postmeta.post_id
WHERE wp_posts.post_type = 'shop_order' AND wp_postmeta.meta_key = '_billing_email'
GROUP BY meta_value
ORDER BY COUNT(meta_value) DESC;
JackScottAU /
Created Sep 9, 2016
The most useful python script I've ever written...
import os
import time
while True:
View gist:e976c6ba01bc4ccfef2d
### Keybase proof
I hereby claim:
* I am JackScottAU on github.
* I am jackscottau ( on keybase.
* I have a public key whose fingerprint is 78C0 CEC6 A138 C5C8 7A2D 0DA3 F3EA BD1A AC83 D520
To claim this, I am signing this object:
View Ginger Beer
Into a 1.25L bottle:
* Juice from one lemon.
* 0.25 teaspoon of baking/brewing yeast.
* 1 cup of sugar (white traditionally, but I'm trying raw and brown in these batches).
* 1 tablespoon of fresh ginger root (I removed the skin, chopped into chunks and then blended with a bit of water).
* Swill these ingredients in with about half a bottle of water.
Shake furiously. Try to get the sugar disolved.
Add enough water to fill the bottle. Leave about half an inch to an inch of air space at the top.
You can’t perform that action at this time.