SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('192.168.99.82') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '6gstecc207lcf7hhekov96vf87' SELECT * FROM variable SELECT pid FROM url_alias LIMIT 1 SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC SELECT rid, redirect, query, fragment, type FROM path_redirect WHERE path = '' OR path = '' SELECT rid, redirect, query, fragment, type FROM path_redirect WHERE path = '' OR path = '' SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1) SELECT title, cid FROM aggregator_category ORDER BY title SELECT * FROM system WHERE type = 'theme' SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC SELECT * FROM panels_info SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid ORDER BY v.weight, v.name SELECT * FROM view_view WHERE page = 1 SELECT * FROM profile_fields ORDER BY category, weight SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid ORDER BY v.weight, v.name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 16 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 16 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 22 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 22 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 27 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 27 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 2 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 2 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 19 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 19 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 13 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 13 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 8 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 8 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 20 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 20 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 7 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 7 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 15 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 15 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 17 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 17 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 18 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 18 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 9 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 9 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 10 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 10 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 11 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 11 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 4 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 4 ORDER BY weight, name SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 12 ORDER BY v.weight, v.name SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 12 ORDER BY weight, name SELECT * FROM role ORDER BY name SELECT presetid, presetname FROM imagecache_preset ORDER BY presetname SELECT * FROM node_field SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_across' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_advanced_solution' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_advanced_sudoku_todo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_aquarius' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_aries' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_article_weight' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_designation' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_location' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_no_profile' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_picture' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_type' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_user_reference' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_with_profile' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_bengaluru_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_body_teaser' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_by_line' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cancer' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_capricorn' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_archie_author' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_archie_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_archie_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_calvin_author' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_calvin_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_calvin_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_tarzan_author' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_tarzan_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_tarzan_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_wizard_author' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_wizard_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_wizard_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_channel' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_channel_video' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_chennai_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_citizen_rep_story_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_citizen_rep_story_place' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_classified_subcategory' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_delhi_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_down' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_durmuhurtam' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_features' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_file_attachment' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_first_level_category' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_fours' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_from_date' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_gallery' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_gallery_video' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_gemini' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_home_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_hyderabad_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_image_flag' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_captain' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_captain_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_coach' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_foriegn_player' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_indian_stars' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_match_date_time' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_match_starttime' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_match_winner' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_owner' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_place' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_lost' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_mp' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_played' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_tie' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_wins' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_team1' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_team2' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_team_logo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_lead_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_lead_image_caption' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_lead_image_credit' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_leo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_libra' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_mumbai_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_net_run_rate' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_not_result' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_oneline_news' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_pisces' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_bengaluru' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_chennai' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_delhi' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_hyderabad' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_mumbai' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_publish_date' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_publish_place' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_rahukalam' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_runs' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sagittarius' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sarvadhari' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_scorpio' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_second_level_category' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_short_central_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sixier' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_solution' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sponsor_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_star' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_submit_publish' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sudoku_todo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sunrise_tomorrow' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sunset_today' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_supplementary_feature' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_tabloid_features' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_taurus' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_team_logo_icn' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_third_level_category' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_thithi' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_today_advanced' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_today_sudoku' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_to_date' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_varjaya' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_varjya' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_virgo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_wickets' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_yesterday_solution' SELECT * FROM node_type ORDER BY type ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = '50_yrs_ago' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'ad' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'advpoll_binary' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'advpoll_ranking' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'article' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'astroguide' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'author' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'banner_image' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'blog' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'blogs' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'cartoon' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'chess' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'citizen_reporter_story' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'citizen_reporter_video' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'counter_point' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'crossword' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'daily_predictions' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'dc_classifieds' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'dc_image' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'ed_classified' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'forum' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'hocus_focus' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'image' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'image_gallery' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'ipl_team_members' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'latest_news' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'match' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'oneline' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'page' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'players' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'prayers' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'short_central_news' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'sms_of_the_day' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'sponsors' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'standings' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'stars' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'stars_this_week' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'story' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'supplementary' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'su_do_ku' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'tabloids' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'video' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'video_gallery' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'weekly_predictions' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_across' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_advanced_solution' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_advanced_sudoku_todo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_aquarius' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_aries' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_article_weight' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_designation' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_location' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_no_profile' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_picture' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_type' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_user_reference' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_author_with_profile' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_bengaluru_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_body_teaser' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_by_line' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cancer' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_capricorn' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_archie_author' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_archie_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_archie_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_calvin_author' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_calvin_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_calvin_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_tarzan_author' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_tarzan_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_tarzan_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_wizard_author' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_wizard_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_cartoon_wizard_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_channel' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_channel_video' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_chennai_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_citizen_rep_story_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_citizen_rep_story_place' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_classified_subcategory' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_delhi_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_down' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_durmuhurtam' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_features' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_file_attachment' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_first_level_category' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_fours' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_from_date' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_gallery' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_gallery_video' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_gemini' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_home_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_hyderabad_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_image_flag' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_captain' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_captain_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_coach' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_foriegn_player' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_indian_stars' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_match_date_time' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_match_starttime' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_match_winner' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_owner' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_place' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_lost' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_mp' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_played' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_tie' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_standing_wins' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_team1' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_team2' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_ipl_team_logo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_lead_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_lead_image_caption' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_lead_image_credit' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_leo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_libra' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_mumbai_title' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_net_run_rate' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_not_result' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_oneline_news' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_pisces' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_bengaluru' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_chennai' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_delhi' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_hyderabad' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_prayer_mumbai' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_publish_date' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_publish_place' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_rahukalam' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_runs' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sagittarius' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sarvadhari' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_scorpio' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_second_level_category' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_short_central_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sixier' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_solution' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sponsor_image' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_star' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_submit_publish' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sudoku_todo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sunrise_tomorrow' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_sunset_today' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_supplementary_feature' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_tabloid_features' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_taurus' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_team_logo_icn' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_third_level_category' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_thithi' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_today_advanced' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_today_sudoku' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_to_date' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_varjaya' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_varjya' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_virgo' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_wickets' SELECT type_name, label FROM node_field_instance WHERE field_name = 'field_yesterday_solution' SELECT * FROM node_type ORDER BY type ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = '50_yrs_ago' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'ad' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'advpoll_binary' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'advpoll_ranking' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'article' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'astroguide' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'author' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'banner_image' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'blog' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'blogs' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'cartoon' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'chess' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'citizen_reporter_story' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'citizen_reporter_video' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'counter_point' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'crossword' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'daily_predictions' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'dc_classifieds' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'dc_image' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'ed_classified' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'forum' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'hocus_focus' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'image' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'image_gallery' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'ipl_team_members' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'latest_news' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'match' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'oneline' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'page' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'players' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'prayers' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'short_central_news' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'sms_of_the_day' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'sponsors' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'standings' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'stars' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'stars_this_week' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'story' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'supplementary' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'su_do_ku' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'tabloids' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'video' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'video_gallery' ORDER BY nfi.weight ASC, nfi.label ASC SELECT * FROM node_field_instance nfi WHERE nfi.type_name = 'weekly_predictions' ORDER BY nfi.weight ASC, nfi.label ASC SELECT t.tid as tid,t.name as name FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 2 SELECT t.tid as tid,t.name as name FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 2 SELECT DISTINCT tag FROM votingapi_vote WHERE content_type = 'node' SELECT DISTINCT value_type FROM votingapi_vote WHERE content_type = 'node' SELECT DISTINCT tag FROM votingapi_cache WHERE content_type = 'node' SELECT DISTINCT value_type FROM votingapi_cache WHERE content_type = 'node' SELECT DISTINCT function FROM votingapi_cache WHERE content_type = 'node' SELECT * FROM nodequeue_queue SELECT m.mid, m.* FROM menu m ORDER BY m.mid ASC SELECT filename FROM system WHERE name = 'poll' AND type = 'module' SELECT name, url FROM view_view WHERE page = 1 SELECT v.* FROM view_view v WHERE v.name = '' SELECT * FROM panels_info WHERE did = 7 SELECT * FROM panels_area WHERE did = 7 ORDER BY area, position SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'dc' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module SELECT body, format FROM boxes WHERE bid = 27 SELECT cache FROM filter_formats WHERE format = 2 SELECT * FROM filters WHERE format = 2 ORDER BY weight ASC SELECT body, format FROM boxes WHERE bid = 56 SELECT a.aid FROM ads a INNER JOIN term_node n ON a.aid = n.nid WHERE a.adstatus = 'active' AND n.tid IN(1196) SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 17154 SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 17154 SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 17154 ORDER BY v.weight, t.weight, t.name SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 17210 ORDER BY f.fid SELECT * FROM ads WHERE aid = 17154 SELECT a.*, f.filepath FROM ad_image a LEFT JOIN files f ON a.fid = f.fid WHERE aid = 17154 SELECT link, comments, url_list FROM print_node_conf WHERE nid = 17154 SELECT v.vid, v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE n.type = 'ad' ORDER BY v.weight, v.name SELECT filename FROM system WHERE name = 'ad_image' SELECT body, format FROM boxes WHERE bid = 48 SELECT vid from vocabulary where name like 'Channel' SELECT v.* FROM view_view v WHERE v.name = 'views_specialcoverage_othersnews' SELECT * FROM view_sort vs WHERE vid = 167 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 167 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 167 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 167 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 167 ORDER BY position ASC SELECT vid from vocabulary where name like 'Channel' SET @@session.time_zone = '+00:00' SELECT arg.*, view.name FROM view_argument arg INNER JOIN view_view view ON arg.vid=view.vid WHERE arg.type IN ('content: field_from_date','content: field_ipl_match_date_time','content: field_publish_date','content: field_to_date') AND view.page_type='date_views_browser' SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all')) AND grant_view >= 1 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_first_level_category node_data_field_first_level_category ON node.vid = node_data_field_first_level_category.vid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_first_level_category.field_first_level_category_value IN ('1199')) AND (EXTRACT(DAY FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(DAY FROM((NOW() + INTERVAL (19800) SECOND)))) AND (EXTRACT(MONTH FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(MONTH FROM((NOW() + INTERVAL (19800) SECOND)))) AND (EXTRACT(YEAR FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(YEAR FROM((NOW() + INTERVAL (19800) SECOND)))) AND (term_node.tid = '1201') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 2 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_first_level_category node_data_field_first_level_category ON node.vid = node_data_field_first_level_category.vid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_first_level_category.field_first_level_category_value IN ('1199')) AND (EXTRACT(DAY FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(DAY FROM((NOW() + INTERVAL (19800) SECOND)))) AND (EXTRACT(MONTH FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(MONTH FROM((NOW() + INTERVAL (19800) SECOND)))) AND (EXTRACT(YEAR FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(YEAR FROM((NOW() + INTERVAL (19800) SECOND)))) AND (term_node.tid = '1202') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 2 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_first_level_category node_data_field_first_level_category ON node.vid = node_data_field_first_level_category.vid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_first_level_category.field_first_level_category_value IN ('1199')) AND (EXTRACT(DAY FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(DAY FROM((NOW() + INTERVAL (19800) SECOND)))) AND (EXTRACT(MONTH FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(MONTH FROM((NOW() + INTERVAL (19800) SECOND)))) AND (EXTRACT(YEAR FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(YEAR FROM((NOW() + INTERVAL (19800) SECOND)))) AND (term_node.tid = '1203') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 2 SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 0 ORDER BY weight, name SELECT v.* FROM view_view v WHERE v.name = 'special_view_most_read' SELECT * FROM view_sort vs WHERE vid = 175 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 175 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 175 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 175 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 175 ORDER BY position ASC SELECT node.nid, node_counter.totalcount AS node_counter_totalcount, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid WHERE ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-153000) SECOND)) AND (node.type IN ('article')) AND (node.status = '1') ORDER BY node_counter_totalcount DESC LIMIT 0, 7 SELECT v.* FROM view_view v WHERE v.name = 'speical_view_most_commented' SELECT * FROM view_sort vs WHERE vid = 174 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 174 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 174 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 174 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 174 ORDER BY position ASC SELECT node.nid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid WHERE (node_comment_statistics.comment_count > '0') AND (node.type IN ('article')) AND (node.status = '1') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-153000) SECOND)) ORDER BY node_comment_statistics_comment_count DESC LIMIT 0, 7 SELECT cache FROM filter_formats WHERE format = 1 SELECT * FROM filters WHERE format = 1 ORDER BY weight ASC SELECT n.nid, n.title, count(*) AS cnt FROM forward_log s LEFT JOIN node n ON s.nid = n.nid LEFT JOIN content_field_first_level_category cf ON cf.nid = n.nid WHERE s.type='sent' AND n.status=1 AND timestamp > 1239799305 and cf.field_first_level_category_value=0 GROUP BY n.nid, n.title ORDER BY cnt DESC LIMIT 0, 7 SELECT body, format FROM boxes WHERE bid = 49 SELECT body, format FROM boxes WHERE bid = 43 SELECT body, format FROM boxes WHERE bid = 20 SELECT v.* FROM view_view v WHERE v.name = 'view_latest_news' SELECT * FROM view_sort vs WHERE vid = 43 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 43 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 43 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 43 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 43 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid WHERE (node.type IN ('latest_news')) AND (node.status = '1') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-153000) SECOND)) ORDER BY node_changed_changed DESC LIMIT 0, 7 SELECT v.* FROM view_view v WHERE v.name = 'view_most_commented' SELECT * FROM view_sort vs WHERE vid = 5 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 5 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 5 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 5 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 5 ORDER BY position ASC SELECT node.nid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid WHERE (node_comment_statistics.comment_count > '0') AND (node.type IN ('article','supplementary','tabloids')) AND (node.status = '1') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-585000) SECOND)) ORDER BY node_comment_statistics_comment_count DESC LIMIT 0, 7 SELECT n.nid, n.title, count(*) AS cnt FROM forward_log s LEFT JOIN node n ON s.nid = n.nid WHERE s.type='sent' AND n.status=1 AND timestamp > 1239799305 GROUP BY n.nid, n.title ORDER BY cnt DESC LIMIT 0, 5 SELECT dst FROM url_alias WHERE src = 'node/17267' SELECT dst FROM url_alias WHERE src = 'node/17254' SELECT v.* FROM view_view v WHERE v.name = 'view_most_read' SELECT * FROM view_sort vs WHERE vid = 4 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 4 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 4 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 4 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 4 ORDER BY position ASC SELECT node.nid, node_counter.totalcount AS node_counter_totalcount, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid WHERE ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-153000) SECOND)) ORDER BY node_counter_totalcount DESC LIMIT 0, 7 SELECT dst FROM url_alias WHERE src = 'node/17118' SELECT dst FROM url_alias WHERE src = 'node/17117' SELECT dst FROM url_alias WHERE src = 'node/17122' SELECT body, format FROM boxes WHERE bid = 45 SELECT td.tid,LOWER(td.name) as name FROM term_data as td, vocabulary as v where v.vid = td.vid and v.name = 'News Type' and (LOWER(td.name)=LOWER('good news') or LOWER(td.name)=LOWER('bad News')) SELECT v.* FROM view_view v WHERE v.name = 'view_article_good_bad_news' SELECT * FROM view_sort vs WHERE vid = 161 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 161 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 161 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 161 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 161 ORDER BY position ASC SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, node_data_field_body_teaser.field_body_teaser_value AS node_data_field_body_teaser_field_body_teaser_value, node_data_field_first_level_category.field_first_level_category_value AS node_data_field_first_level_category_field_first_level_category_value, node_data_field_second_level_category.field_second_level_category_value AS node_data_field_second_level_category_field_second_level_category_value FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid LEFT JOIN content_field_body_teaser node_data_field_body_teaser ON node.vid = node_data_field_body_teaser.vid LEFT JOIN content_field_first_level_category node_data_field_first_level_category ON node.vid = node_data_field_first_level_category.vid LEFT JOIN content_field_second_level_category node_data_field_second_level_category ON node.vid = node_data_field_second_level_category.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '1189') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT dst FROM url_alias WHERE src = 'node/17211' SELECT dst FROM url_alias WHERE src = 'node/17209' SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, node_data_field_body_teaser.field_body_teaser_value AS node_data_field_body_teaser_field_body_teaser_value, node_data_field_first_level_category.field_first_level_category_value AS node_data_field_first_level_category_field_first_level_category_value, node_data_field_second_level_category.field_second_level_category_value AS node_data_field_second_level_category_field_second_level_category_value FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid LEFT JOIN content_field_body_teaser node_data_field_body_teaser ON node.vid = node_data_field_body_teaser.vid LEFT JOIN content_field_first_level_category node_data_field_first_level_category ON node.vid = node_data_field_first_level_category.vid LEFT JOIN content_field_second_level_category node_data_field_second_level_category ON node.vid = node_data_field_second_level_category.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '1190') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT dst FROM url_alias WHERE src = 'node/17127' SELECT dst FROM url_alias WHERE src = 'node/17123' SELECT a.aid FROM ads a INNER JOIN term_node n ON a.aid = n.nid WHERE a.adstatus = 'active' AND n.tid IN(1191) SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 17149 SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 17149 SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 17149 ORDER BY v.weight, t.weight, t.name SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 17205 ORDER BY f.fid SELECT * FROM ads WHERE aid = 17149 SELECT a.*, f.filepath FROM ad_image a LEFT JOIN files f ON a.fid = f.fid WHERE aid = 17149 SELECT link, comments, url_list FROM print_node_conf WHERE nid = 17149 SELECT v.vid, v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE n.type = 'ad' ORDER BY v.weight, v.name SELECT filename FROM system WHERE name = 'ad_image' SELECT a.aid FROM ads a INNER JOIN term_node n ON a.aid = n.nid WHERE a.adstatus = 'active' AND n.tid IN(1192) SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 17143 SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 17143 SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 17143 ORDER BY v.weight, t.weight, t.name SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 17199 ORDER BY f.fid SELECT * FROM ads WHERE aid = 17143 SELECT a.*, f.filepath FROM ad_image a LEFT JOIN files f ON a.fid = f.fid WHERE aid = 17143 SELECT link, comments, url_list FROM print_node_conf WHERE nid = 17143 SELECT v.vid, v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE n.type = 'ad' ORDER BY v.weight, v.name SELECT filename FROM system WHERE name = 'ad_image' SELECT body, format FROM boxes WHERE bid = 54 SELECT body, format FROM boxes WHERE bid = 53 SELECT body, format FROM boxes WHERE bid = 57 SELECT body, format FROM boxes WHERE bid = 21 select tn.nid from term_data td INNER JOIN term_node tn on tn.tid=td.tid INNER JOIN node n on n.nid= tn.nid where td.name='NYT Crossword' and n.status=1 order by tn.nid desc SELECT nid FROM node WHERE type='chess' ORDER BY nid DESC SELECT nid FROM node WHERE type='su_do_ku' ORDER BY nid DESC SELECT nid FROM node WHERE type='hocus_focus' ORDER BY nid DESC SELECT v.* FROM view_view v WHERE v.name = 'view_latest_tabloids' SELECT * FROM view_sort vs WHERE vid = 153 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 153 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 153 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 153 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 153 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node WHERE (node.type IN ('tabloids')) AND (node.status = '1') ORDER BY node_changed_changed DESC LIMIT 0, 5 SELECT dst FROM url_alias WHERE src = 'node/16964' SELECT dst FROM url_alias WHERE src = 'node/17227' SELECT dst FROM url_alias WHERE src = 'node/17282' SELECT dst FROM url_alias WHERE src = 'node/17281' SELECT dst FROM url_alias WHERE src = 'node/17279' SELECT body, format FROM boxes WHERE bid = 26 SELECT v.* FROM view_view v WHERE v.name = 'view_home_poll' SELECT * FROM view_sort vs WHERE vid = 17 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 17 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 17 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 17 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 17 ORDER BY position ASC SELECT node.nid, node.created AS node_created_created FROM node node LEFT JOIN content_field_first_level_category node_data_field_first_level_category ON node.vid = node_data_field_first_level_category.vid WHERE (node.status = '1') AND (node.type IN ('advpoll_binary')) AND (node_data_field_first_level_category.field_first_level_category_value IN ('0')) ORDER BY node_created_created DESC LIMIT 0, 1 SELECT n.nid, n.title, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid WHERE n.status = 1 AND n.type = 'forum' ORDER BY l.last_comment_timestamp DESC LIMIT 0, 5 SELECT module, type FROM captcha_points WHERE form_id = 'search_theme_form' SELECT * FROM system WHERE type = 'theme' AND name = 'dc' SELECT body, format FROM boxes WHERE bid = 42 SELECT v.* FROM view_view v WHERE v.name = 'views_prayers' SELECT * FROM view_sort vs WHERE vid = 150 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 150 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 150 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 150 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 150 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node_data_field_prayer_bengaluru.field_prayer_bengaluru_value AS node_data_field_prayer_bengaluru_field_prayer_bengaluru_value, node_data_field_chennai_title.field_chennai_title_value AS node_data_field_chennai_title_field_chennai_title_value, node_data_field_prayer_chennai.field_prayer_chennai_value AS node_data_field_prayer_chennai_field_prayer_chennai_value, node_data_field_mumbai_title.field_mumbai_title_value AS node_data_field_mumbai_title_field_mumbai_title_value, node_data_field_prayer_mumbai.field_prayer_mumbai_value AS node_data_field_prayer_mumbai_field_prayer_mumbai_value, node_data_field_hyderabad_title.field_hyderabad_title_value AS node_data_field_hyderabad_title_field_hyderabad_title_value, node_data_field_prayer_hyderabad.field_prayer_hyderabad_value AS node_data_field_prayer_hyderabad_field_prayer_hyderabad_value, node_data_field_delhi_title.field_delhi_title_value AS node_data_field_delhi_title_field_delhi_title_value, node_data_field_prayer_delhi.field_prayer_delhi_value AS node_data_field_prayer_delhi_field_prayer_delhi_value, node_data_field_bengaluru_title.field_bengaluru_title_value AS node_data_field_bengaluru_title_field_bengaluru_title_value FROM node node LEFT JOIN content_type_prayers node_data_field_prayer_bengaluru ON node.vid = node_data_field_prayer_bengaluru.vid LEFT JOIN content_type_prayers node_data_field_chennai_title ON node.vid = node_data_field_chennai_title.vid LEFT JOIN content_type_prayers node_data_field_prayer_chennai ON node.vid = node_data_field_prayer_chennai.vid LEFT JOIN content_type_prayers node_data_field_mumbai_title ON node.vid = node_data_field_mumbai_title.vid LEFT JOIN content_type_prayers node_data_field_prayer_mumbai ON node.vid = node_data_field_prayer_mumbai.vid LEFT JOIN content_type_prayers node_data_field_hyderabad_title ON node.vid = node_data_field_hyderabad_title.vid LEFT JOIN content_type_prayers node_data_field_prayer_hyderabad ON node.vid = node_data_field_prayer_hyderabad.vid LEFT JOIN content_type_prayers node_data_field_delhi_title ON node.vid = node_data_field_delhi_title.vid LEFT JOIN content_type_prayers node_data_field_prayer_delhi ON node.vid = node_data_field_prayer_delhi.vid LEFT JOIN content_type_prayers node_data_field_bengaluru_title ON node.vid = node_data_field_bengaluru_title.vid WHERE (node.status = '1') AND (node.type IN ('prayers')) ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT dst FROM url_alias WHERE src = 'prayers' SELECT v.* FROM view_view v WHERE v.name = 'view_headline_image' SELECT * FROM view_sort vs WHERE vid = 21 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 21 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 21 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 21 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 21 ORDER BY position ASC SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '120') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3567 SELECT v.* FROM view_view v WHERE v.name = 'view_home_channel_headlines' SELECT * FROM view_sort vs WHERE vid = 19 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 19 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 19 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 19 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 19 ORDER BY position ASC SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '120') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node_data_field_publish_date.field_publish_date_value, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '1201') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND)>='2009-05-15 00:00:00') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND)<='2009-05-15 23:59:59') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT node.nid, node_data_field_publish_date.field_publish_date_value, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '1201') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND)>='2009-05-15 00:00:00') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND)<='2009-05-15 23:59:59') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '1200') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '1200') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT v.* FROM view_view v WHERE v.name = 'view_home_headlines' SELECT * FROM view_sort vs WHERE vid = 20 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 20 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 20 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 20 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 20 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt, node_data_field_body_teaser.field_body_teaser_value AS node_data_field_body_teaser_field_body_teaser_value FROM node node LEFT JOIN content_field_features node_data_field_features ON node.vid = node_data_field_features.vid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid LEFT JOIN content_field_body_teaser node_data_field_body_teaser ON node.vid = node_data_field_body_teaser.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_features.field_features_value IN ('1')) ORDER BY node_changed_changed DESC LIMIT 0, 3 SELECT * FROM files WHERE fid = 0 SELECT * FROM files WHERE fid = 0 SELECT * FROM files WHERE fid = 0 SELECT v.* FROM view_view v WHERE v.name = 'views_50_yrs_ago' SELECT * FROM view_sort vs WHERE vid = 98 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 98 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 98 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 98 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 98 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, node_data_field_body_teaser.field_body_teaser_value AS node_data_field_body_teaser_field_body_teaser_value FROM node node LEFT JOIN content_field_body_teaser node_data_field_body_teaser ON node.vid = node_data_field_body_teaser.vid WHERE (node.type IN ('50_yrs_ago')) AND (node.status = '1') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 17054 SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 17054 SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 17054 ORDER BY v.weight, t.weight, t.name SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 17103 ORDER BY f.fid SELECT * FROM ads WHERE aid = 17054 SELECT field_body_teaser_value AS value FROM content_field_body_teaser WHERE vid = 17103 SELECT link, comments, url_list FROM print_node_conf WHERE nid = 17054 SELECT * FROM node_group ORDER BY weight, group_name SELECT nfi.*, ng.group_name FROM node_group ng INNER JOIN node_group_fields ngf ON ngf.type_name = ng.type_name AND ngf.group_name = ng.group_name INNER JOIN node_field_instance nfi ON nfi.field_name = ngf.field_name AND nfi.type_name = ngf.type_name ORDER BY nfi.weight SELECT v.* FROM view_view v WHERE v.name = 'view_images' SELECT * FROM view_sort vs WHERE vid = 9 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 9 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 9 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 9 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 9 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node_data_field_image.field_image_fid AS node_data_field_image_field_image_fid, node_data_field_image.field_image_title AS node_data_field_image_field_image_title, node_data_field_image.field_image_alt AS node_data_field_image_field_image_alt, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_field_features node_data_field_features ON node.vid = node_data_field_features.vid LEFT JOIN content_type_dc_image node_data_field_image ON node.vid = node_data_field_image.vid WHERE (node.status = '1') AND (node.type IN ('dc_image')) AND (node_data_field_features.field_features_value = 1) ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3656 SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '3') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3562 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '3') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '763') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3556 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '763') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '98') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3569 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '98') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '8') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3563 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '8') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '4') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3565 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '4') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node_data_field_publish_date.field_publish_date_value, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '1232') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND)>='2009-05-15 00:00:00') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND)<='2009-05-15 23:59:59') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT node.nid, node_data_field_publish_date.field_publish_date_value, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '1232') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND)>='2009-05-15 00:00:00') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND)<='2009-05-15 23:59:59') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '927') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3314 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '927') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT node.nid, node.created AS node_created_created, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '928') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3382 SELECT node.nid, node_data_field_publish_date.field_publish_date_value AS node_data_field_publish_date_field_publish_date_value, node_data_field_article_weight.field_article_weight_value AS node_data_field_article_weight_field_article_weight_value, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN content_field_article_weight node_data_field_article_weight ON node.vid = node_data_field_article_weight.vid WHERE (node.status = '1') AND (node.type IN ('article')) AND (term_node.tid = '928') ORDER BY node_data_field_publish_date_field_publish_date_value DESC, node_data_field_article_weight_field_article_weight_value ASC, node_changed_changed DESC, node.nid DESC LIMIT 0, 3 SELECT v.* FROM view_view v WHERE v.name = 'views_counterpoint' SELECT * FROM view_sort vs WHERE vid = 108 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 108 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 108 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 108 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 108 ORDER BY position ASC SELECT node.nid, node.created AS node_created_created, node_data_field_cartoon_image.field_cartoon_image_fid AS node_data_field_cartoon_image_field_cartoon_image_fid, node_data_field_cartoon_image.field_cartoon_image_title AS node_data_field_cartoon_image_field_cartoon_image_title, node_data_field_cartoon_image.field_cartoon_image_alt AS node_data_field_cartoon_image_field_cartoon_image_alt FROM node node LEFT JOIN content_type_counter_point node_data_field_cartoon_image ON node.vid = node_data_field_cartoon_image.vid WHERE (node.type IN ('counter_point')) AND (node.status = '1') ORDER BY node_created_created DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3551 SELECT v.* FROM view_view v WHERE v.name = 'views_home_supplementary_image' SELECT * FROM view_sort vs WHERE vid = 100 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 100 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 100 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 100 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 100 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('supplementary')) AND (node_data_field_image_flag.field_image_flag_value = '1') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3256 SELECT v.* FROM view_view v WHERE v.name = 'views_home_supplementary' SELECT * FROM view_sort vs WHERE vid = 99 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 99 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 99 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 99 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 99 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node WHERE (node.type IN ('supplementary')) AND (node.status = '1') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('supplementary')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '765') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3230 SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (node.type IN ('supplementary')) AND (node.status = '1') AND (term_node.tid = '765') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('supplementary')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '924') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3256 SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (node.type IN ('supplementary')) AND (node.status = '1') AND (term_node.tid = '924') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('supplementary')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '766') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3510 SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (node.type IN ('supplementary')) AND (node.status = '1') AND (term_node.tid = '766') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('supplementary')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '767') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_home_image.field_home_image_fid AS node_data_field_home_image_field_home_image_fid, node_data_field_home_image.field_home_image_title AS node_data_field_home_image_field_home_image_title, node_data_field_home_image.field_home_image_alt AS node_data_field_home_image_field_home_image_alt FROM node node LEFT JOIN content_field_image_flag node_data_field_image_flag ON node.vid = node_data_field_image_flag.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_home_image node_data_field_home_image ON node.vid = node_data_field_home_image.vid WHERE (node.status = '1') AND (node.type IN ('supplementary')) AND (node_data_field_image_flag.field_image_flag_value = '1') AND (term_node.tid = '935') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3368 SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (node.type IN ('supplementary')) AND (node.status = '1') AND (term_node.tid = '767') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (node.type IN ('supplementary')) AND (node.status = '1') AND (term_node.tid = '935') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT v.* FROM view_view v WHERE v.name = 'views_home_prominent_tabloid' SELECT * FROM view_sort vs WHERE vid = 102 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 102 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 102 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 102 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 102 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt, node_data_field_body_teaser.field_body_teaser_value AS node_data_field_body_teaser_field_body_teaser_value FROM node node LEFT JOIN content_field_tabloid_features node_data_field_tabloid_features ON node.vid = node_data_field_tabloid_features.vid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid LEFT JOIN content_field_body_teaser node_data_field_body_teaser ON node.vid = node_data_field_body_teaser.vid WHERE (node.type IN ('tabloids')) AND (node_data_field_tabloid_features.field_tabloid_features_value IN ('2')) AND (node.status = '1') AND (EXTRACT(DAY FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(DAY FROM((NOW() + INTERVAL (19800) SECOND)))) AND (EXTRACT(MONTH FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(MONTH FROM((NOW() + INTERVAL (19800) SECOND)))) AND (EXTRACT(YEAR FROM((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND))) = EXTRACT(YEAR FROM((NOW() + INTERVAL (19800) SECOND)))) AND (term_node.tid = '947') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT v.* FROM view_view v WHERE v.name = 'views_home_headline_tabloid' SELECT * FROM view_sort vs WHERE vid = 103 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 103 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 103 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 103 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 103 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt, node_data_field_body_teaser.field_body_teaser_value AS node_data_field_body_teaser_field_body_teaser_value FROM node node LEFT JOIN content_field_tabloid_features node_data_field_tabloid_features ON node.vid = node_data_field_tabloid_features.vid LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid LEFT JOIN content_field_body_teaser node_data_field_body_teaser ON node.vid = node_data_field_body_teaser.vid WHERE (node.type IN ('tabloids')) AND (node_data_field_tabloid_features.field_tabloid_features_value IN ('1')) AND (node.status = '1') AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-585000) SECOND)) AND (term_node.tid = '947') ORDER BY node_changed_changed DESC LIMIT 0, 3 SELECT v.* FROM view_view v WHERE v.name = 'views_home_tabloids_image' SELECT * FROM view_sort vs WHERE vid = 101 ORDER BY position ASC SELECT * FROM view_argument WHERE vid = 101 ORDER BY position ASC SELECT * FROM view_tablefield WHERE vid = 101 ORDER BY position ASC SELECT * FROM view_filter WHERE vid = 101 ORDER BY position ASC SELECT * FROM view_exposed_filter WHERE vid = 101 ORDER BY position ASC SELECT node.nid, node.changed AS node_changed_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid WHERE (node.status = '1') AND (node.type IN ('tabloids')) AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-1189800) SECOND)) AND (term_node.tid = '808') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 0 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid WHERE (node.status = '1') AND (node.type IN ('tabloids')) AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-1189800) SECOND)) AND (term_node.tid = '870') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid WHERE (node.status = '1') AND (node.type IN ('tabloids')) AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-1189800) SECOND)) AND (term_node.tid = '975') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT * FROM files WHERE fid = 3661 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid WHERE (node.status = '1') AND (node.type IN ('tabloids')) AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-1189800) SECOND)) AND (term_node.tid = '1028') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid WHERE (node.status = '1') AND (node.type IN ('tabloids')) AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-1189800) SECOND)) AND (term_node.tid = '1029') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid WHERE (node.status = '1') AND (node.type IN ('tabloids')) AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-1189800) SECOND)) AND (term_node.tid = '991') ORDER BY node_changed_changed DESC LIMIT 0, 1 SELECT node.nid, node.changed AS node_changed_changed, node_data_field_lead_image.field_lead_image_fid AS node_data_field_lead_image_field_lead_image_fid, node_data_field_lead_image.field_lead_image_title AS node_data_field_lead_image_field_lead_image_title, node_data_field_lead_image.field_lead_image_alt AS node_data_field_lead_image_field_lead_image_alt FROM node node LEFT JOIN content_field_publish_date node_data_field_publish_date ON node.vid = node_data_field_publish_date.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_field_lead_image node_data_field_lead_image ON node.vid = node_data_field_lead_image.vid WHERE (node.status = '1') AND (node.type IN ('tabloids')) AND ((FROM_UNIXTIME(node_data_field_publish_date.field_publish_date_value) + INTERVAL (19800) SECOND) >= (NOW() + INTERVAL (-1189800) SECOND)) AND (term_node.tid = '797') ORDER BY node_changed_changed DESC LIMIT 0, 1 INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Home', 'home', '', '192.168.99.82', 0, '6gstecc207lcf7hhekov96vf87', 1838, 1242391306) SELECT sid FROM sessions WHERE sid = '6gstecc207lcf7hhekov96vf87' UPDATE sessions SET uid = 0, cache = 0, hostname = '192.168.99.82', session = 'section|s:6:\"nation\";image_captcha|a:0:{}captcha|a:1:{s:12:\"comment_form\";a:7:{s:32:\"4e963533774bca6da60cc482b68512e6\";s:4:\"Sm6h\";s:7:\"success\";b:0;s:32:\"55a75bc562c8bf85e36a5039d0de2dda\";s:4:\"h4G6\";s:32:\"c001e96beada3e9d283f23abe15efdd6\";s:4:\"68KW\";s:32:\"c00fc8e1593ccd2afe87f6754b4ea4ef\";s:4:\"ita7\";s:32:\"41f5fcb52380e9e9c83f17247d9056b8\";s:4:\"hYjt\";s:32:\"ca8b64a9918fc313f5557edcdba6c696\";s:4:\"thhW\";}}', timestamp = 1242391306 WHERE sid = '6gstecc207lcf7hhekov96vf87'