Clever Life Hacks

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 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 190, 10;

SELECT FOUND_ROWS();

SELECT lifehacks_posts.* FROM lifehacks_posts WHERE ID IN (26479,26473,26467,26476,26470,26494,26488,26485,26435,26438);

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 (26435, 26438, 26467, 26470, 26473, 26476, 26479, 26485, 26488, 26494) ORDER BY t.name ASC ;

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (26435,26438,26467,26470,26473,26476,26479,26485,26488,26494) ORDER BY
meta_id ASC;

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

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 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 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, 10;

SELECT FOUND_ROWS();

SELECT lifehacks_posts.* FROM lifehacks_posts WHERE ID IN (27679,27670,27673,27666,27662,27654,27657,27650,27619,27607);

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

SELECT lifehacks_posts.* FROM lifehacks_posts WHERE ID IN (26481,26475,26469,26478,26472,26496,26490,26487,26437,26440);

SELECT post_id, meta_key, meta_value FROM lifehacks_postmeta WHERE post_id IN (26437,26440,26469,26472,26475,26478,26481,26487,26490,26496) ORDER BY
meta_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 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;

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
(14565,14693,14946,15073,73,367,181,662,16133,229,14517,16134,16431,16132,18942,1133,18943,14735,386,130,14947,123,2920,20855,20654,2961,13554,349,532,13305,12618,193,353,180,422,352,14483,1720,867,13557,13453,283,378,564,449)
ORDER BY meta_id ASC;