Page History

    UPDATE services
    INNER JOIN `module_rows` ON `services`.`module_row_id` = `module_rows`.`id`
    INNER JOIN `modules` ON `modules`.`id` = `module_rows`.`module_id` AND `modules`.`class` = 'generic_domains'
    INNER JOIN `modules` AS enom_module ON `enom_module`.`class` = 'enom'
    INNER JOIN `module_rows` AS enom_module_row ON `enom_module_row`.`module_id` = `enom_module`.`id`
    INNER JOIN `package_pricing` ON `package_pricing`.`id` = `services`.`pricing_id`
    INNER JOIN `packages` ON `package_pricing`.`package_id` = `packages`.`id`
    INNER JOIN `package_meta` ON `package_meta`.`package_id` = `packages`.`id` AND `package_meta`.`key` = 'tlds'
    INNER JOIN `pricings` ON `package_pricing`.`pricing_id` = `pricings`.`id`
INNER JOIN `modules` AS enom_module ON `enom_module`.`class` = 'enom'
INNER JOIN `module_rows` AS enom_module_row ON `enom_module_row`.`module_id` = `enom_module`.`id`
INNER JOIN `pricings` AS enom_pricings ON `enom_pricings`.`term` = `pricings`.`term`
        AND `enom_pricings`.`period` = `pricings`.`period`
    INNER JOIN `package_pricing` AS enom_package_pricing ON `enom_package_pricing`.`pricing_id` = `enom_pricings`.`id`
    INNER JOIN `packages` AS enom_packages ON `enom_package_pricing`.`package_id` = `enom_packages`.`id`
    AND `enom_packages`.`module_id` = `enom_module`.`id`
INNER JOIN `package_meta` AS enom_package_meta ON `enom_package_meta`packages`.`value``id` = `package`enom_package_meta`.`value``package_id` AND `enom_package_meta`.`key` = 'tlds'
    AND `enom_packages`package_meta`.`id``value` = `enom`package_package_meta`.`package_id`
    `value`
SET services`services`.module`module_row_idid` = `enom_module_row`.`id`, services`services`.pricing`pricing_idid` = `enom_package_pricing`.`id`