With joins

gistfile1.sql

SQL (903.1ms)  SELECT `landing_pages`.`id` AS t0_r0, `landing_pages`.`program_region_id` AS t0_r1, `landing_pages`.`enabled` AS t0_r2, `landing_pages`.`program_url` AS t0_r3, `landing_pages`.`effort` AS t0_r4, `landing_pages`.`no_of_text_fields` AS t0_r5, `landing_pages`.`end_date` AS t0_r6, `landing_pages`.`double_opt_in` AS t0_r7, `landing_pages`.`revokement_quote` AS t0_r8, `landing_pages`.`ephc_90` AS t0_r9, `landing_pages`.`conversion` AS t0_r10, `landing_pages`.`title` AS t0_r11, `landing_pages`.`teaser` AS t0_r12, `landing_pages`.`required_actions` AS t0_r13, `landing_pages`.`created_at` AS t0_r14, `landing_pages`.`updated_at` AS t0_r15, `landing_pages`.`required_actions_long` AS t0_r16, `landing_pages`.`premium_brand` AS t0_r17, `landing_pages`.`priority` AS t0_r18, `landing_pages`.`epc` AS t0_r19, `landing_pages`.`method_of_payment` AS t0_r20, `landing_pages`.`required_actions_en` AS t0_r21, `landing_pages`.`deleted_at` AS t0_r22, `landing_pages`.`fraud_score` AS t0_r23, `landing_pages`.`fraud_limit_id` AS t0_r24, `landing_pages`.`multiple_completitions` AS t0_r25, `landing_pages`.`application_whitelist` AS t0_r26, `landing_pages`.`affiliate_callback_url` AS t0_r27, `landing_pages`.`video_offer` AS t0_r28, `landing_pages`.`video_url` AS t0_r29, `landing_pages`.`clickthrough_text` AS t0_r30, `landing_pages`.`banner_url` AS t0_r31, `landing_pages`.`video_share_url` AS t0_r32, `landing_pages`.`widget` AS t0_r33, `landing_pages`.`brand_banner_url` AS t0_r34, `landing_pages`.`video_type` AS t0_r35, `landing_pages`.`groupon_offer` AS t0_r36, `landing_pages`.`widget_title` AS t0_r37, `landing_pages`.`widget_description` AS t0_r38, `landing_pages`.`campaign` AS t0_r39, `landing_pages`.`campaign_img_url` AS t0_r40, `landing_pages`.`web_offer` AS t0_r41, `landing_pages`.`ios_offer` AS t0_r42, `landing_pages`.`android_offer` AS t0_r43, `landing_pages`.`mobile_title` AS t0_r44, `landing_pages`.`mobile_teaser` AS t0_r45, `landing_pages`.`mobile_required_action` AS t0_r46, `landing_pages`.`demographically_targeted` AS t0_r47, `landing_pages`.`demograph_age_min` AS t0_r48, `landing_pages`.`demograph_age_max` AS t0_r49, `landing_pages`.`demograph_gender` AS t0_r50, `landing_pages`.`demographics_apps` AS t0_r51, `landing_pages`.`video_duration` AS t0_r52, `landing_pages`.`testoffer` AS t0_r53, `landing_pages`.`geo_target` AS t0_r54, `landing_pages`.`geo_longitude` AS t0_r55, `landing_pages`.`geo_latitude` AS t0_r56, `landing_pages`.`geo_radius` AS t0_r57, `landing_pages`.`video_snippet` AS t0_r58, `landing_pages`.`video_pay_type` AS t0_r59, `landing_pages`.`video_width` AS t0_r60, `landing_pages`.`video_height` AS t0_r61, `landing_pages`.`mc_velocity` AS t0_r62, `landing_pages`.`required_landing_page_id` AS t0_r63, `landing_pages`.`app_price` AS t0_r64, `landing_pages`.`unique_identifier` AS t0_r65, `landing_pages`.`mobile_required_action_tag` AS t0_r66, `landing_pages`.`completed_lpids` AS t0_r67, `landing_pages`.`stats_disabled` AS t0_r68, `landing_pages`.`publisher_callbacks_disabled` AS t0_r69, `landing_pages`.`tracking_type_sdk` AS t0_r70, `landing_pages`.`tracking_type_web` AS t0_r71, `landing_pages`.`tracking_type_dib` AS t0_r72, `landing_pages`.`tracking_type_ios_sdk` AS t0_r73, `landing_pages`.`active_on_all_levels` AS t0_r74, `landing_pages`.`custom_campaign` AS t0_r75, `landing_pages`.`affiliate_offer_id` AS t0_r76, `landing_pages`.`time_window_start` AS t0_r77, `landing_pages`.`time_window_end` AS t0_r78, `landing_pages`.`time_window_targeted` AS t0_r79, `landing_pages`.`start_date` AS t0_r80, `landing_pages`.`ipad_offer` AS t0_r81, `landing_pages`.`android_tablet_offer` AS t0_r82, `landing_pages`.`previewed` AS t0_r83, `landing_pages`.`daily_contingent` AS t0_r84, `landing_pages`.`contingent` AS t0_r85, `landing_pages`.`cr_limit` AS t0_r86, `landing_pages`.`absolute_time_window_zone` AS t0_r87, `landing_pages`.`absolute_time_window_start` AS t0_r88, `landing_pages`.`absolute_time_window_end` AS t0_r89, `landing_pages`.`absolute_time_window_targeted` AS t0_r90, `landing_pages`.`postal_codes` AS t0_r91, `landing_pages`.`offer_type` AS t0_r92, `landing_pages`.`trailer_landscape_background` AS t0_r93, `landing_pages`.`trailer_portrait_background` AS t0_r94, `landing_pages`.`last_modifier_id` AS t0_r95, `landing_pages`.`trigger_banner_url` AS t0_r96, `landing_pages`.`rewarded_action_id` AS t0_r97, `landing_pages`.`daily_budget` AS t0_r98, `landing_pages`.`budget` AS t0_r99, `landing_pages`.`mobile_custom_campaign` AS t0_r100, `landing_pages`.`payout_delay` AS t0_r101, `landing_pages`.`independent_publisher_event` AS t0_r102, `landing_pages`.`expected_engagement_rate` AS t0_r103, `program_regions`.`id` AS t1_r0, `program_regions`.`program_id` AS t1_r1, `program_regions`.`country_id` AS t1_r2, `program_regions`.`language_id` AS t1_r3, `program_regions`.`enabled` AS t1_r4, `program_regions`.`created_at` AS t1_r5, `program_regions`.`updated_at` AS t1_r6, `program_regions`.`deleted_at` AS t1_r7, `countries`.`id` AS t2_r0, `countries`.`name` AS t2_r1, `countries`.`code` AS t2_r2, `countries`.`relevant` AS t2_r3, `provisions`.`id` AS t3_r0, `provisions`.`cp_model` AS t3_r1, `provisions`.`billingtype` AS t3_r2, `provisions`.`value` AS t3_r3, `provisions`.`currency` AS t3_r4, `provisions`.`created_at` AS t3_r5, `provisions`.`updated_at` AS t3_r6, `provisions`.`min_lead` AS t3_r7, `provisions`.`max_lead` AS t3_r8, `provisions`.`landing_page_id` AS t3_r9, `provisions`.`payout_control` AS t3_r10, `provisions`.`ignore_communicated_provision` AS t3_r11, `provisions`.`sp_media_fee` AS t3_r12, `programs`.`id` AS t4_r0, `programs`.`name` AS t4_r1, `programs`.`advertiser_id` AS t4_r2, `programs`.`auto_accept` AS t4_r3, `programs`.`enabled` AS t4_r4, `programs`.`anonym` AS t4_r5, `programs`.`latency` AS t4_r6, `programs`.`contingent` AS t4_r7, `programs`.`leads_per_user` AS t4_r8, `programs`.`sem_restricted` AS t4_r9, `programs`.`minimum_age` AS t4_r10, `programs`.`tracking_type` AS t4_r11, `programs`.`created_at` AS t4_r12, `programs`.`updated_at` AS t4_r13, `programs`.`revokement_quote` AS t4_r14, `programs`.`processing_time` AS t4_r15, `programs`.`group_name` AS t4_r16, `programs`.`target_reach` AS t4_r17, `programs`.`application_status` AS t4_r18, `programs`.`ecpm` AS t4_r19, `programs`.`epc` AS t4_r20, `programs`.`revokement_quote_source` AS t4_r21, `programs`.`latency_computed` AS t4_r22, `programs`.`deleted_at` AS t4_r23, `programs`.`fb_compliance` AS t4_r24, `programs`.`daily_max_clicks` AS t4_r25, `programs`.`daily_contingent` AS t4_r26, `programs`.`comment` AS t4_r27, `programs`.`expected_revenue` AS t4_r28, `programs`.`account_manager_id` AS t4_r29, `programs`.`sales_manager_id` AS t4_r30, `programs`.`mobile_callbacks_counter` AS t4_r31, `programs`.`previous_mobile_callbacks_counter` AS t4_r32, `programs`.`application_id` AS t4_r33, `programs`.`last_ping` AS t4_r34, `programs`.`traffic_test_mode` AS t4_r35, `programs`.`budget` AS t4_r36, `advertisers`.`id` AS t5_r0, `advertisers`.`affiliate_network_id` AS t5_r1, `advertisers`.`name` AS t5_r2, `advertisers`.`end_date` AS t5_r3, `advertisers`.`enabled` AS t5_r4, `advertisers`.`url` AS t5_r5, `advertisers`.`created_at` AS t5_r6, `advertisers`.`updated_at` AS t5_r7, `advertisers`.`revokement_quote` AS t5_r8, `advertisers`.`revokement_quote_source` AS t5_r9, `advertisers`.`deleted_at` AS t5_r10, `advertisers`.`company_id` AS t5_r11, `advertisers`.`balance` AS t5_r12, `advertisers`.`minimum_provision_android` AS t5_r13, `advertisers`.`minimum_provision_ios` AS t5_r14, `advertisers`.`discount` AS t5_r15, `advertisers`.`direct` AS t5_r16, `advertisers`.`affiliate_advertiser_id` AS t5_r17, `affiliate_networks`.`id` AS t6_r0, `affiliate_networks`.`name` AS t6_r1, `affiliate_networks`.`statistic_grabber` AS t6_r2, `affiliate_networks`.`enabled` AS t6_r3, `affiliate_networks`.`created_at` AS t6_r4, `affiliate_networks`.`updated_at` AS t6_r5, `affiliate_networks`.`provision` AS t6_r6, `affiliate_networks`.`deleted_at` AS t6_r7, `affiliate_networks`.`type` AS t6_r8, `affiliate_networks`.`direct_payment_provider` AS t6_r9, `affiliate_networks`.`callback_enabled` AS t6_r10, `affiliate_networks`.`https` AS t6_r11, `affiliate_networks`.`autoplay` AS t6_r12, `affiliate_networks`.`sp_media_fee` AS t6_r13, `affiliate_networks`.`mandatory_affiliate_offer_id` AS t6_r14, `affiliate_networks`.`provider` AS t6_r15, `program_categories`.`id` AS t7_r0, `program_categories`.`category_id` AS t7_r1, `program_categories`.`subcategory_id` AS t7_r2, `program_categories`.`landing_page_id` AS t7_r3, `categories`.`id` AS t8_r0, `categories`.`name` AS t8_r1, `categories`.`enabled` AS t8_r2, `categories`.`deleted_at` AS t8_r3, `categories`.`greedy` AS t8_r4, `tags`.`id` AS t9_r0, `tags`.`name` AS t9_r1, `blacklists_landing_pages`.`id` AS t10_r0, `blacklists_landing_pages`.`name` AS t10_r1 FROM `landing_pages` INNER JOIN `program_regions` ON `program_regions`.`id` = `landing_pages`.`program_region_id` INNER JOIN `countries` ON `countries`.`id` = `program_regions`.`country_id` INNER JOIN `program_categories` ON `program_categories`.`landing_page_id` = `landing_pages`.`id` INNER JOIN `categories` ON `categories`.`id` = `program_categories`.`category_id` INNER JOIN `programs` ON `programs`.`id` = `program_regions`.`program_id` INNER JOIN `advertisers` ON `advertisers`.`id` = `programs`.`advertiser_id` INNER JOIN `affiliate_networks` ON `affiliate_networks`.`id` = `advertisers`.`affiliate_network_id` LEFT OUTER JOIN `provisions` ON `provisions`.`landing_page_id` = `landing_pages`.`id` LEFT OUTER JOIN `program_regions` `program_regions_landing_pages_join` ON `program_regions_landing_pages_join`.`id` = `landing_pages`.`program_region_id` LEFT OUTER JOIN `programs` `programs_landing_pages` ON `programs_landing_pages`.`id` = `program_regions_landing_pages_join`.`program_id` LEFT OUTER JOIN `advertisers` `advertisers_programs` ON `advertisers_programs`.`id` = `programs_landing_pages`.`advertiser_id` LEFT OUTER JOIN `affiliate_networks` `affiliate_networks_advertisers` ON `affiliate_networks_advertisers`.`id` = `advertisers_programs`.`affiliate_network_id` LEFT OUTER JOIN `program_categories` `program_categories_landing_pages` ON `program_categories_landing_pages`.`landing_page_id` = `landing_pages`.`id` LEFT OUTER JOIN `taggings` ON `taggings`.`taggable_id` = `landing_pages`.`id` AND taggings.context = 'whitelists' AND `taggings`.`taggable_type` = 'LandingPage' LEFT OUTER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` LEFT OUTER JOIN `taggings` `blacklist_taggings_landing_pages_join` ON `blacklist_taggings_landing_pages_join`.`taggable_id` = `landing_pages`.`id` AND taggings.context = 'blacklists' AND `blacklist_taggings_landing_pages_join`.`taggable_type` = 'LandingPage' LEFT OUTER JOIN `tags` `blacklists_landing_pages` ON `blacklists_landing_pages`.`id` = `blacklist_taggings_landing_pages_join`.`tag_id` LEFT OUTER JOIN `additional_regions` ON `program_regions`.`id` = `additional_regions`.`program_region_id` WHERE (((`program_regions`.`country_id` = 107 OR `countries`.`code` = 'XG' AND `program_regions`.`enabled` = 1) OR `additional_regions`.`country_id` = 107 AND `additional_regions`.`enabled` = 1)) AND (`landing_pages`.`enabled` = 1 AND `landing_pages`.`deleted_at` IS NULL AND (`landing_pages`.`end_date` > '2013-04-02 09:02:52' OR `landing_pages`.`end_date` IS NULL) AND (`landing_pages`.`start_date` < '2013-04-02 09:02:52' OR `landing_pages`.`start_date` IS NULL) AND (`program_regions`.`enabled` = 1 OR `countries`.`code` = 'XG') AND `programs`.`enabled` = 1 AND `advertisers`.`enabled` = 1 AND `affiliate_networks`.`enabled` = 1) ORDER BY landing_pages.ID DESC