mysql_output_subquery

### MYSQL OUTPUT SUBQUERY
151210 15:18:18  2211 CONNECT   root@localhost ON mw_cgates
         2211 Query SET SQL_AUTO_IS_NULL=0, NAMES 'utf8', @@wait_timeout = 2147483
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SELECT  `configuration_parameters`.* FROM `configuration_parameters` WHERE `configuration_parameters`.`type` = 'Setting' AND `configuration_parameters`.`parameter` = 'allow_connection_without_ssl' LIMIT 1
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SELECT  `configuration_parameters`.* FROM `configuration_parameters` WHERE `configuration_parameters`.`type` = 'Setting' AND `configuration_parameters`.`parameter` = 'allow_ssl_connection_without_cn' LIMIT 1
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SELECT  `configuration_parameters`.* FROM `configuration_parameters` WHERE `configuration_parameters`.`type` = 'Setting' AND `configuration_parameters`.`parameter` = 'alternative_images_server' LIMIT 1
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SELECT  `configuration_parameters`.* FROM `configuration_parameters` WHERE `configuration_parameters`.`type` = 'Setting' AND `configuration_parameters`.`parameter` = 'alternative_images_server' LIMIT 1
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SELECT  `configuration_parameters`.* FROM `configuration_parameters` WHERE `configuration_parameters`.`type` = 'Setting' AND `configuration_parameters`.`parameter` = 'currency' LIMIT 1
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `entitlements`
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `device_models`
         2211 Query SHOW TABLES
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `profiles`
         2211 Query SHOW TABLES
         2211 Query DESCRIBE `offers_products`
         2211 Query DESCRIBE `categories_vods`
         2211 Query DESCRIBE `categories_internet_radios`
         2211 Query DESCRIBE `categories_vods`
         2211 Query DESCRIBE `content_ratings_vods`
         2211 Query DESCRIBE `genres_products`
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `area_codes`
         2211 Query SHOW TABLES
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `content_servers`
         2211 Query SHOW TABLES
         2212 CONNECT   root@localhost ON mw_cgates
         2212 Query SELECT * FROM configuration_parameters WHERE TYPE = 'Setting'
         2212 Quit
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `payments`
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `customers`
         2211 Query SHOW TABLES
         2211 Query DESCRIBE `customer_groups_customers`
         2211 Query SHOW TABLES
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `addresses`
151210 15:18:19  2211 Query SHOW TABLES
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `advertisements`
         2211 Query SHOW TABLES
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `customer_groups`
         2211 Query SHOW TABLES
         2211 Query DESCRIBE `customer_groups_customers`
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `offers`
         2211 Query SHOW TABLES
         2211 Query DESCRIBE `offers_products`
         2211 Query SHOW TABLES
         2211 Query DESCRIBE `offers_products`
         2211 Query DESCRIBE `offers_products`
         2211 Query DESCRIBE `offers_products`
         2211 Query DESCRIBE `offers_products`
         2211 Query DESCRIBE `offers_products`
         2211 Query DESCRIBE `offers_products`
         2211 Query DESCRIBE `package_offers_services`
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `devices`
         2211 Query SHOW TABLES
         2211 Query SHOW TABLES LIKE 'service_labels_products'
         2211 Query DESCRIBE `service_labels_products`
         2211 Query SHOW TABLES
         2211 Query SHOW FIELDS FROM `epgs`
         2211 Query SHOW TABLES
         2211 Query DESCRIBE `genres_products`
         2211 Query DESCRIBE `genres_products`
         2211 Query DESCRIBE `epgs_genres`
         2211 Query DESCRIBE `categories_catchup_events`
         2211 Query DESCRIBE `categories_internet_radios`
         2211 Query DESCRIBE `service_labels_products`
         2211 Query DESCRIBE `service_labels_products`
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SELECT  `configuration_parameters`.* FROM `configuration_parameters` WHERE `configuration_parameters`.`type` = 'Setting' AND `configuration_parameters`.`parameter` = 'entitlement_renewal_period' LIMIT 1
         2211 Query SHOW FIELDS FROM `configuration_parameters`
         2211 Query SELECT  `configuration_parameters`.* FROM `configuration_parameters` WHERE `configuration_parameters`.`type` = 'Setting' AND `configuration_parameters`.`parameter` = 'tenant' LIMIT 1
151210 15:18:20  2211 Query SHOW TABLES LIKE 'my_rentals_%'
         2211 Query CREATE TABLE my_rentals_1449757100 LIKE my_rentals
         2211 Query SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 0
         2211 Query SELECT COUNT(*)
        FROM
          entitlements AS e
        INNER JOIN
          offers_products AS op ON e.offer_id = op.offer_id
        INNER JOIN
          offers AS o ON o.id = op.offer_id
        INNER JOIN
          products AS vods ON vods.id = op.product_id
        INNER JOIN
          (SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 10000) AS customer_ids
          ON customer_ids.id = e.customer_id
        WHERE
          e.expires_at > UTC_TIMESTAMP()
          AND o.STATUS = 'available'
          AND COALESCE(o.available_till > UTC_TIMESTAMP(), TRUE)
          AND COALESCE(o.available_from < UTC_TIMESTAMP(), TRUE)
          AND vods.TYPE = 'Vod'
          AND o.TYPE != 'PackageOffer'
151210 15:20:58  2213 CONNECT   root@localhost ON mw_cgates
         2213 Query SELECT * FROM configuration_parameters WHERE TYPE = 'Setting'
         2213 Quit
         2211 Query SELECT e.customer_id,op.offer_id,op.product_id,e.expires_at,vods.service_id
        FROM
          entitlements AS e
        INNER JOIN
          offers_products AS op ON e.offer_id = op.offer_id
        INNER JOIN
          offers AS o ON o.id = op.offer_id
        INNER JOIN
          products AS vods ON vods.id = op.product_id
        INNER JOIN
          (SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 0) AS customer_ids
          ON customer_ids.id = e.customer_id
        WHERE
          e.expires_at > UTC_TIMESTAMP()
          AND o.STATUS = 'available'
          AND COALESCE(o.available_till > UTC_TIMESTAMP(), TRUE)
          AND COALESCE(o.available_from < UTC_TIMESTAMP(), TRUE)
          AND vods.TYPE = 'Vod'
          AND o.TYPE != 'PackageOffer'

        LIMIT 200000
        OFFSET 0
151210 15:27:07  2211 Query SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 10000
         2214 CONNECT   root@localhost ON mw_cgates
         2214 Query SELECT * FROM configuration_parameters WHERE TYPE = 'Setting'
         2214 Quit
         2211 Query SELECT COUNT(*)
        FROM
          entitlements AS e
        INNER JOIN
          offers_products AS op ON e.offer_id = op.offer_id
        INNER JOIN
          offers AS o ON o.id = op.offer_id
        INNER JOIN
          products AS vods ON vods.id = op.product_id
        INNER JOIN
          (SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 20000) AS customer_ids
          ON customer_ids.id = e.customer_id
        WHERE
          e.expires_at > UTC_TIMESTAMP()
          AND o.STATUS = 'available'
          AND COALESCE(o.available_till > UTC_TIMESTAMP(), TRUE)
          AND COALESCE(o.available_from < UTC_TIMESTAMP(), TRUE)
          AND vods.TYPE = 'Vod'
          AND o.TYPE != 'PackageOffer'
151210 15:31:31  2215 CONNECT   root@localhost ON mw_cgates
         2215 Query SELECT * FROM configuration_parameters WHERE TYPE = 'Setting'
         2215 Quit
         2211 Query SELECT e.customer_id,op.offer_id,op.product_id,e.expires_at,vods.service_id
        FROM
          entitlements AS e
        INNER JOIN
          offers_products AS op ON e.offer_id = op.offer_id
        INNER JOIN
          offers AS o ON o.id = op.offer_id
        INNER JOIN
          products AS vods ON vods.id = op.product_id
        INNER JOIN
          (SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 0) AS customer_ids
          ON customer_ids.id = e.customer_id
        WHERE
          e.expires_at > UTC_TIMESTAMP()
          AND o.STATUS = 'available'
          AND COALESCE(o.available_till > UTC_TIMESTAMP(), TRUE)
          AND COALESCE(o.available_from < UTC_TIMESTAMP(), TRUE)
          AND vods.TYPE = 'Vod'
          AND o.TYPE != 'PackageOffer'

        LIMIT 200000
        OFFSET 0
151210 15:37:32  2211 Query SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 20000
         2216 CONNECT   root@localhost ON mw_cgates
         2216 Query SELECT * FROM configuration_parameters WHERE TYPE = 'Setting'
         2216 Quit
         2211 Query SELECT COUNT(*)
        FROM
          entitlements AS e
        INNER JOIN
          offers_products AS op ON e.offer_id = op.offer_id
        INNER JOIN
          offers AS o ON o.id = op.offer_id
        INNER JOIN
          products AS vods ON vods.id = op.product_id
        INNER JOIN
          (SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 30000) AS customer_ids
          ON customer_ids.id = e.customer_id
        WHERE
          e.expires_at > UTC_TIMESTAMP()
          AND o.STATUS = 'available'
          AND COALESCE(o.available_till > UTC_TIMESTAMP(), TRUE)
          AND COALESCE(o.available_from < UTC_TIMESTAMP(), TRUE)
          AND vods.TYPE = 'Vod'
          AND o.TYPE != 'PackageOffer'
         2211 Query SELECT e.customer_id,op.offer_id,op.product_id,e.expires_at,vods.service_id
        FROM
          entitlements AS e
        INNER JOIN
          offers_products AS op ON e.offer_id = op.offer_id
        INNER JOIN
          offers AS o ON o.id = op.offer_id
        INNER JOIN
          products AS vods ON vods.id = op.product_id
        INNER JOIN
          (SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 0) AS customer_ids
          ON customer_ids.id = e.customer_id
        WHERE
          e.expires_at > UTC_TIMESTAMP()
          AND o.STATUS = 'available'
          AND COALESCE(o.available_till > UTC_TIMESTAMP(), TRUE)
          AND COALESCE(o.available_from < UTC_TIMESTAMP(), TRUE)
          AND vods.TYPE = 'Vod'
          AND o.TYPE != 'PackageOffer'

        LIMIT 200000
        OFFSET 0
151210 15:43:40  2211 Query SELECT id
          FROM customers
          WHERE is_archived = 0
          LIMIT 10000
          OFFSET 30000
         2211 Query SELECT DISTINCT
            vods.id
          FROM
            products AS vods
          INNER JOIN
            categories_vods AS cv ON cv.vod_id = vods.id
          INNER JOIN
            categories AS c ON c.id = cv.category_id
          WHERE
            c.is_adult = 1
          OR
            vods.is_adult = 1
         2211 Query RENAME TABLE my_rentals TO my_rentals_old, my_rentals_1449757100 TO my_rentals
         2211 Query DROP TABLE IF EXISTS my_rentals_1449757100
         2211 Query DROP TABLE IF EXISTS my_rentals_old
         2211 Quit