Register

		SELECT ID, post_name, post_parent, post_type
		FROM wp_posts
		WHERE post_name IN ('register')
		AND post_type IN ('page','attachment')
	;

SELECT * FROM wp_posts WHERE ID = 2 LIMIT 1;

SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND (wp_posts.ID = '2') AND wp_posts.post_type = 'page'  ORDER BY wp_posts.post_date DESC ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (2) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (2) ORDER BY t.name ASC ;

SELECT user_id,
                       league_status_id,
                       group_id
      FROM wp_pred_user_groups
      WHERE user_id=0
      AND league_status_id=10
      AND group_id=2;

SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1;

SELECT * FROM wp_posts  WHERE (post_type = 'page' AND post_status = 'publish')    AND post_parent = 2   ORDER BY wp_posts.post_title ASC LIMIT 0,1;

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 3;

SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy
IN ('nav_menu') AND tt.term_id IN ('3') ORDER BY tr.object_id ASC;

SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (32) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status =
'publish'))  ORDER BY wp_posts.menu_order ASC ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32) ORDER BY meta_id ASC;

SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (20) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))  ORDER
BY wp_posts.post_date DESC ;

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (20) ORDER BY meta_id ASC;

SELECT *
        FROM wp_fb_leagues
        WHERE id =2;

SELECT DISTINCT status.league_year,
                status.league_id,
                status.league_status,
                status.id,
                leagues.abbr
      FROM wp_fb_schedules sked
      INNER JOIN wp_pred_league_status status ON sked.league_id=status.league_id
      INNER JOIN wp_fb_leagues leagues ON status.league_id=leagues.id
      WHERE status.league_status='active' AND status.league_id=2;

SELECT groups.id,
                       groups.group_name,
                       groups.group_commish,
                       groups.group_pwd,
                       users.user_id,
                       users.league_status_id,
                       users.group_id,
                       league.league_id,
                       league.league_year,
                       league.league_status
                FROM wp_pred_groups groups
                INNER JOIN wp_pred_user_groups users ON users.group_id = groups.id
                INNER JOIN wp_pred_league_status league ON league.id = users.league_status_id
                WHERE users.user_id = 0 AND league.league_id=2 ORDER BY league.league_year DESC;

SELECT *
        FROM wp_pred_league_status
        WHERE league_id=2
        AND league_year='';

SELECT * FROM wp_users WHERE ID = '1';

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;