Back To School Life Hacks You Wish You Knew !

SELECT COUNT(*) snapshots FROM  lifehacks_options  WHERE option_name LIKE '%cronsnapshot_%';

SELECT option_value FROM lifehacks_options WHERE option_name = 'gadash_options' LIMIT 1;

SHOW TABLES LIKE 'lifehacks_snippets';

SELECT id, code, scope FROM lifehacks_snippets WHERE scope IN ('global', 'single-use', 'front-end') AND active=1 ORDER BY priority ASC, id ASC;

SELECT option_value FROM lifehacks_options WHERE option_name = 'autoptimize_js_aggregate' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'autoptimize_css_aggregate' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'autoptimize_optimize_logged' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'autoptimize_optimize_checkout' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'autoptimize_minify_excluded' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'autoptimize_imgopt_provider_stat' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'autoptimize_extra_settings' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'classic-editor-replace' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'comet_cache_options' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'video_blogster_checker' LIMIT 1;

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

SELECT option_value FROM lifehacks_options WHERE option_name = 'aoa_cookie_hours' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = '_transient_doing_cron' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = '_transient_timeout_vbp_feeds' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = '_transient_vbp_feeds' LIMIT 1;

		SELECT ID, post_name, post_parent, post_type
		FROM lifehacks_posts
		WHERE post_name IN ('back-to-school-life-hacks-you-wish-you-knew')
		AND post_type IN ('page','attachment')
	;

SELECT   lifehacks_posts.* FROM lifehacks_posts  WHERE 1=1  AND lifehacks_posts.post_name = 'back-to-school-life-hacks-you-wish-you-knew' AND
lifehacks_posts.post_type = 'post'  ORDER BY lifehacks_posts.post_date DESC ;

SELECT  t.*, tt.*, tr.object_id FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND
tr.object_id IN (17977) ORDER BY t.name ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (17977) ORDER BY meta_id ASC;

SELECT option_value FROM lifehacks_options WHERE option_name = 'aoa_show_ad' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'aoa_repeat_ad' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'aoa_close_delay' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'aoa_close_after' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'ot_css_file_paths' LIMIT 1;

SELECT * FROM lifehacks_users WHERE ID = '1' LIMIT 1;

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

SELECT option_value FROM lifehacks_options WHERE option_name = 'aoa_admin_only' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'aoa_domain_whitelist' LIMIT 1;

SELECT option_value FROM lifehacks_options WHERE option_name = 'aoa_random_status' LIMIT 1;

SELECT * FROM lifehacks_posts WHERE ID = 17979 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (17979) ORDER BY meta_id ASC;

SELECT t.*, tt.* FROM lifehacks_terms AS t INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 7386;

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

SELECT   lifehacks_posts.* FROM lifehacks_posts  WHERE 1=1  AND lifehacks_posts.ID IN (4120,4123,4124,4125,4126) AND lifehacks_posts.post_type =
'nav_menu_item' AND ((lifehacks_posts.post_status = 'publish'))  ORDER BY lifehacks_posts.menu_order ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (4120,4123,4124,4125,4126) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND
t.term_id IN ( 95,522,129,219,92 ) AND tt.count > 0 ORDER BY t.name ASC ;

SELECT term_id, meta_key, meta_value FROM lifehacks_termmeta WHERE term_id IN (219,92,522,95,129) ORDER BY meta_id ASC;

SELECT  t.term_id, tt.parent, tt.count, tt.taxonomy FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN
(17977) ORDER BY t.name ASC ;

SELECT term_id, meta_key, meta_value FROM lifehacks_termmeta WHERE term_id IN (14713) ORDER BY meta_id ASC;

SELECT rating_username, rating_rating, rating_ip FROM lifehacks_ratings WHERE rating_postid = 17977;

SELECT COUNT(*) FROM lifehacks_ratings WHERE rating_postid = 17977 AND (rating_ip = '0ac50719d9aef1fee7a1555198bde294' OR rating_ip = '18.204.48.40');

SELECT   lifehacks_posts.* FROM lifehacks_posts  WHERE 1=1  AND lifehacks_posts.post_name = 'ebace4b2f53918d3e181681fed124709' AND
lifehacks_posts.post_type = 'oembed_cache' AND ((lifehacks_posts.post_status = 'publish'))  ORDER BY lifehacks_posts.post_date DESC ;

SELECT * FROM lifehacks_aoa WHERE status = 1 ORDER BY  RAND() LIMIT 1;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND
t.term_id IN ( 14713 )  ;

SELECT   lifehacks_posts.ID FROM lifehacks_posts  LEFT JOIN lifehacks_term_relationships ON (lifehacks_posts.ID =
lifehacks_term_relationships.object_id) WHERE 1=1  AND lifehacks_posts.ID NOT IN (17977) AND ( 
  lifehacks_term_relationships.term_taxonomy_id IN (14713)
) AND lifehacks_posts.post_type = 'post' AND (lifehacks_posts.post_status = 'publish') GROUP BY lifehacks_posts.ID ORDER BY RAND() LIMIT 0, 3;

SELECT lifehacks_posts.* FROM lifehacks_posts WHERE ID IN (18355,13798,22553);

SELECT rating_username, rating_rating, rating_ip FROM lifehacks_ratings WHERE rating_postid = 17977;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (18355) ORDER
BY t.name ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (18355) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (18355) ORDER BY
t.name ASC ;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (18355) ORDER BY
t.name ASC ;

SELECT term_id, meta_key, meta_value FROM lifehacks_termmeta WHERE term_id IN
(6747,18465,13977,28752,860,16823,1042,867,14693,662,73,13554,532,386,14565,15077,2915,22007,20106,20105,1720,13453,16133,22905) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 18357 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (18357) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (13798) ORDER
BY t.name ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (13798) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (13798) ORDER BY
t.name ASC ;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (13798) ORDER BY
t.name ASC ;

SELECT term_id, meta_key, meta_value FROM lifehacks_termmeta WHERE term_id IN
(1650,14209,13882,14892,12581,13305,14517,14,14786,15073,22708,9340,42,8628) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 13800 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (13800) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (22553) ORDER
BY t.name ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (22553) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (22553) ORDER BY
t.name ASC ;

SELECT term_id, meta_key, meta_value FROM lifehacks_termmeta WHERE term_id IN (1) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (22553) ORDER BY
t.name ASC ;

SELECT term_id, meta_key, meta_value FROM lifehacks_termmeta WHERE term_id IN
(14790,13786,30580,2920,14884,13978,30576,14947,237,30574,30579,30578,30575,4387,12872,30577,193,14946,13557,2961) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 22555 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (22555) ORDER BY meta_id ASC;

SELECT SQL_CALC_FOUND_ROWS lifehacks_comments.comment_ID FROM lifehacks_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 17977 AND
comment_parent = 0  ORDER BY lifehacks_comments.comment_date_gmt ASC, lifehacks_comments.comment_ID ASC ;

SELECT lifehacks_comments.* FROM lifehacks_comments WHERE comment_ID IN
(175444,175388,175418,175458,175406,175451,175435,175468,175412,175467,175439,175429,175456,175464,175465,175423,175450,175400,175394,175452);

SELECT  lifehacks_comments.comment_ID FROM lifehacks_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 17977 AND comment_parent IN (
175444,175388,175418,175458,175406,175451,175435,175468,175412,175467,175439,175429,175456,175464,175465,175423,175450,175400,175394,175452 )  ORDER
BY lifehacks_comments.comment_date_gmt ASC, lifehacks_comments.comment_ID ASC ;

SELECT lifehacks_comments.* FROM lifehacks_comments WHERE comment_ID IN
(175449,175448,175447,175422,175421,175420,175434,175433,175446,175438,175443,175442,175411,175441,175445,175410,175432,175463,175462,175461,175460,175459,175393,175428,175427,175426,175425,175437,175455,175457,175466,175405,175404,175424,175392,175391,175454,175473,175409,175408,175431,175440,175472,175471,175403,175390,175470,175407,175430,175419,175399,175398,175417,175416,175415,175436,175402,175469,175397,175401,175396,175453,175395,175389,175414,175413);

SELECT  lifehacks_comments.comment_ID FROM lifehacks_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 17977 AND comment_parent IN (
175449,175448,175447,175422,175421,175420,175434,175433,175446,175438,175443,175442,175411,175441,175445,175410,175432,175463,175462,175461,175460,175459,175393,175428,175427,175426,175425,175437,175455,175457,175466,175405,175404,175424,175392,175391,175454,175473,175409,175408,175431,175440,175472,175471,175403,175390,175470,175407,175430,175419,175399,175398,175417,175416,175415,175436,175402,175469,175397,175401,175396,175453,175395,175389,175414,175413
)  ORDER BY lifehacks_comments.comment_date_gmt ASC, lifehacks_comments.comment_ID ASC ;

SELECT SQL_CALC_FOUND_ROWS  lifehacks_posts.ID FROM lifehacks_posts  WHERE 1=1  AND lifehacks_posts.post_type = 'post' AND
(lifehacks_posts.post_status = 'publish')  ORDER BY lifehacks_posts.post_date DESC LIMIT 0, 5;

SELECT FOUND_ROWS();

SELECT lifehacks_posts.* FROM lifehacks_posts WHERE ID IN (27446,27442,27438,27429,27432);

SELECT  t.*, tt.*, tr.object_id FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND
tr.object_id IN (27429, 27432, 27438, 27442, 27446) ORDER BY t.name ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (27429,27432,27438,27442,27446) ORDER BY meta_id ASC;

SELECT rating_username, rating_rating, rating_ip FROM lifehacks_ratings WHERE rating_postid = 17977;

SELECT * FROM lifehacks_posts WHERE ID = 27448 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (27448) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 27444 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (27444) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 27440 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (27440) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 27431 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (27431) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 27434 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (27434) ORDER BY meta_id ASC;

SELECT SQL_CALC_FOUND_ROWS  lifehacks_posts.ID FROM lifehacks_posts  WHERE 1=1  AND lifehacks_posts.post_type = 'post' AND
(lifehacks_posts.post_status = 'publish')  ORDER BY lifehacks_posts.comment_count DESC LIMIT 0, 5;

SELECT FOUND_ROWS();

SELECT lifehacks_posts.* FROM lifehacks_posts WHERE ID IN (12668,16706,16885,15247,14210);

SELECT  t.*, tt.*, tr.object_id FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND
tr.object_id IN (12668, 14210, 15247, 16706, 16885) ORDER BY t.name ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (12668,14210,15247,16706,16885) ORDER BY meta_id ASC;

SELECT rating_username, rating_rating, rating_ip FROM lifehacks_ratings WHERE rating_postid = 17977;

SELECT * FROM lifehacks_posts WHERE ID = 12670 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (12670) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 16708 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (16708) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 16887 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (16887) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 15249 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (15249) ORDER BY meta_id ASC;

SELECT * FROM lifehacks_posts WHERE ID = 14212 LIMIT 1;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (14212) ORDER BY meta_id ASC;

SELECT  t.*, tt.* FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') AND
tt.count > 0 ORDER BY tt.count DESC LIMIT 45;

SELECT term_id, meta_key, meta_value FROM lifehacks_termmeta WHERE term_id IN
(367,181,229,16134,16431,16132,18942,1133,18943,14735,130,123,20855,20654,349,12618,353,180,352,14483,422,283,378,564,13016) ORDER BY meta_id ASC;

SELECT DISTINCT lifehacks_posts.ID, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users, (t3.meta_value+0.00) AS
ratings_score FROM lifehacks_posts LEFT JOIN lifehacks_postmeta AS t1 ON t1.post_id = lifehacks_posts.ID LEFT JOIN lifehacks_postmeta As t2 ON
t1.post_id = t2.post_id LEFT JOIN lifehacks_postmeta AS t3 ON t3.post_id = lifehacks_posts.ID WHERE t1.meta_key = 'ratings_average' AND t2.meta_key =
'ratings_users' AND t3.meta_key = 'ratings_score' AND lifehacks_posts.post_password = '' AND lifehacks_posts.post_date < NOW() AND
lifehacks_posts.post_status = 'publish' AND t2.meta_value >= 0 AND 1=1 ORDER BY ratings_average DESC, ratings_users DESC LIMIT 10;

SELECT lifehacks_posts.* FROM lifehacks_posts WHERE ID IN (1228,919,3455,628,962,3824,4447,25030,983,3055);

SELECT  t.*, tt.*, tr.object_id FROM lifehacks_terms AS t  INNER JOIN lifehacks_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN
lifehacks_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND
tr.object_id IN (628, 919, 962, 983, 1228, 3055, 3455, 3824, 4447, 25030) ORDER BY t.name ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (628,919,962,983,1228,3055,3455,3824,4447,25030) ORDER BY meta_id ASC;