GertJanFrl

SELECT * FROM wp_posts
LEFT JOIN wp_term_relationships ON
(wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_taxonomy ON
(wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
WHERE wp_posts.post_type = 'post'
AND wp_term_taxonomy.taxonomy = 'category'
AND wp_term_taxonomy.term_id = 48
ORDER BY post_date DESC

GertJanFrl

# Run this script using "share" or "unshare" as arguments:
# To share the Plex libraries:
#     python share_unshare_libraries.py share
# To unshare the Plex libraries:
#     python share_unshare_libraries.py unshare

import requests
import sys
from xml.dom import minidom

GertJanFrl

#!/bin/bash
# Docker Setup for streaming backend using cloudbox, intended to be run as root :
## To Do : Pass arguments to script if reboot is necessary, edit only the necessary line in plex-autoscan config file.

KERNEL=$(uname -r)
BASE=4.10
echo $KERNEL

if [ "$KERNEL" != "$BASE" ]; then
tput setaf 1; echo "You don't need to reboot, continuing install" && tput setaf 7;

GertJanFrl

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console