NonplayerCharacter's Pastebin

5,363 43,396 1 10 years ago

Name / Title	Added	Expires	Hits	Syntax
Plutarch, Cineas, Pyrrhus	Dec 28th, 2024	Never	177	None	-
certutil \| Get file hash on Windows	Mar 23rd, 2023	Never	285	None	-
Excel \| Sort sheets alphabetically	Mar 7th, 2023	Never	1,889	VBScript	-
PGexercises.com \| 3-table join	Feb 27th, 2023	Never	193	PostgreSQL	-
PostgreSQL \| Relation does not exist, set search_path	Feb 23rd, 2023	Never	1,505	PostgreSQL	-
PostgreSQL \| Self-join \| Recommenders	Feb 23rd, 2023	Never	942	PostgreSQL	-
JS \| GA \| Identify unique pageviews	Feb 10th, 2023	Never	1,007	JavaScript	-
JS \| Push page blur to dataLayer	Dec 16th, 2022	Never	714	JavaScript	-
JS \| GA4 ecommerce example lite	Nov 22nd, 2022	Never	1,421	JavaScript	-
Plutarch: Solon, Aesop, kings — rare vs pleasing	Jul 21st, 2022	Never	301	None	-
JS \| Override disable right click	Jul 20th, 2022	Never	1,156	JavaScript	-
JS \| Jonas \| Object 101	Jul 6th, 2022	Never	1,131	JavaScript	-
autoTRADER.ca \| Extract year+km from search results	Jun 12th, 2022	Never	330	JavaScript	-
PostgreSQL \| StrataScratch.com \| Friend request acceptance rate by date	Apr 23rd, 2022	Never	1,993	PostgreSQL	-
JS \| List global variables	Apr 8th, 2022	Never	1,418	JavaScript	-
PostgreSQL \| Count with unnest	Apr 7th, 2022	Never	1,420	PostgreSQL	-
StrataScratch.com \| Hide locked questions	Apr 5th, 2022	Never	1,326	JavaScript	-
PGexercises.com \| Monthly facility utilisation rate	Mar 22nd, 2022	Never	250	PostgreSQL	-
PGexercises.com \| Bookings by month	Mar 22nd, 2022	Never	1,664	PostgreSQL	-
PGexercises.com \| Last 10 bookings by endtime, starttime	Mar 22nd, 2022	Never	246	PostgreSQL	-
PGexercises.com \| Count days in each month	Mar 22nd, 2022	Never	1,132	PostgreSQL	-
PGexercises.com \| Seconds between dates	Mar 22nd, 2022	Never	360	PostgreSQL	-
PostgreSQL \| PGExercises.com \| Days left in month	Mar 9th, 2022	Never	1,286	PostgreSQL	-
PostgreSQL \| PGExercises.com \| Rolling average revenue	Mar 8th, 2022	Never	247	PostgreSQL	-
JS \| Add listener to every member of array/nodelist	Mar 8th, 2022	Never	1,667	JavaScript	-
PostgreSQL \| PGExercises.com \| Months to repay	Mar 8th, 2022	Never	254	PostgreSQL	-
PostgreSQL \| PGExercises.com \| Rank by revenue	Mar 7th, 2022	Never	259	PostgreSQL	-
PostgreSQL \| PGExercises.com \| Rank users by total hours	Mar 7th, 2022	Never	251	PostgreSQL	-
PGExercises.com \| PostgreSQL \| Distinct on	Mar 7th, 2022	Never	1,728	PostgreSQL	-
Python 101	May 25th, 2021	Never	1,202	Python	-
Mean vs median: meaning of skew	Apr 27th, 2021	Never	300	None	-
Python psycopg2 PostgreSQL 101	Apr 20th, 2021	Never	1,068	Python	-
Weighted average	Mar 2nd, 2020	Never	297	None	-
JS \| Hash	Feb 20th, 2020	Never	360	JavaScript	-
JS \| Browsers geolocation API	Jan 13th, 2020	Never	405	JavaScript	-
Regex 101 \| Look(behind\|ahead)	Jun 28th, 2019	Never	389	None	-
OpenDataSoft \| Specify date range	Jun 18th, 2019	Never	373	HTML 5	-
Google Tag Manager \| Rewrite referrer for subdomain	Jun 14th, 2019	Never	280	JavaScript	-
Google Apps Script \| API query to spreadsheet	May 28th, 2019	Never	282	JavaScript	-
Spreadsheets \| Grab left cell if cell X has value	May 2nd, 2019	Never	379	JavaScript	-
Firefox vs VPN	Apr 9th, 2019	Never	2,335	None	-
Spreadsheets \| VLOOKUP vs INDEX MATCH	Apr 3rd, 2019	Never	374	JavaScript	-
JS \| Vanilla \| Prevent default	Apr 2nd, 2019	Never	351	JavaScript	-
Regex \| Find duplicate lines	Mar 4th, 2019	Never	334	JavaScript	-
Spreadsheets \| VLOOKUP + REGEXEXTRACT	Mar 1st, 2019	Never	364	SQL	-
JS \| GTM \| window.performance.timing buckets	Jan 22nd, 2019	Never	369	JavaScript	-
Google \| Search Instagram posts with min likes or comments	Jan 4th, 2019	Never	278	CSS	-
Spreadsheets \| Sum if regex match	Dec 14th, 2018	Never	369	SQL	-
Spreadsheets \| % change \| (new-old)/old	Dec 11th, 2018	Never	336	SQL	-
Spreadsheets \| VLOOKUP	Dec 11th, 2018	Never	355	SQL	-
Google Analytics \| Pretty-print the tracker	Nov 30th, 2018	Never	343	JavaScript	-
Google Analytics \| Get tracker name, trackingId, clientId	Nov 27th, 2018	Never	278	JavaScript	-
JS \| Timestamp in local time as "YYYYMMDD hh:mm:ss:mss"	Nov 21st, 2018	Never	353	JavaScript	-
Google Analytics hit limit	Sep 19th, 2018	Never	299	None	-
JS \| Floating point surprise	Aug 1st, 2018	Never	339	JavaScript	-
GTM \| Conditional display features	May 17th, 2018	Never	419	JavaScript	-
GTM EEcommerce implementation guide	Apr 12th, 2018	Never	344	None	-
JS \| Return week number	Mar 22nd, 2018	Never	335	JavaScript	-
R + GA \| Browser versions	Feb 9th, 2018	Never	358	R	-
JS \| IIFE \| Return UTC date as YYYYMMDD HH:MM:SS	Jan 18th, 2018	Never	363	JavaScript	-
Remote job search	Aug 7th, 2017	Never	375	None	-
What 10752 characters look like	May 18th, 2017	Never	340	None	-
IIFE \| m. \| List all values of a property in data layer	May 8th, 2017	Never	397	JavaScript	-
IIFE \| Google Analytics tracker name	May 4th, 2017	Never	299	JavaScript	-
Get devicePixelRatio in main browsers	May 4th, 2017	Never	323	JavaScript	-
IIFE \| Verify that values of a given property are in array	Apr 28th, 2017	Never	521	JavaScript	-
IIFE \| Sum all numbers up to a limit	Apr 19th, 2017	Never	371	JavaScript	-