SQL Ololo

gistfile1.sql

INSERT INTO portal_parameters_map (portal_id, portal_parameter_id, parameter_value)
 
SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'uservoice_code') AS portal_parameter_id, uservoice_code AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.uservoice_code <> '' AND m.uservoice_code IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'chartbeat_code') AS portal_parameter_id, chartbeat_code AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.chartbeat_code <> '' AND m.chartbeat_code IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'google_conversion_id') AS portal_parameter_id, google_conversion_id AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.google_conversion_id <> '' AND m.google_conversion_id IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'google_conversion_label') AS portal_parameter_id, google_conversion_label AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.google_conversion_label <> '' AND m.google_conversion_label IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'facebook_page') AS portal_parameter_id, facebook_page AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.facebook_page <> '' AND m.facebook_page IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'google_plus_page') AS portal_parameter_id, google_plus_page AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.google_plus_page <> '' AND m.google_plus_page IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'use_ajax') AS portal_parameter_id, use_ajax AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.use_ajax IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'offset') AS portal_parameter_id, offset AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.offset IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'default_view') AS portal_parameter_id, default_view AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.default_view IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'run_frame') AS portal_parameter_id, run_frame AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.run_frame IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'frame_percent_show') AS portal_parameter_id, frame_percent_show AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.frame_percent_show IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'min_price') AS portal_parameter_id, min_price AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.min_price IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'relevance_group_size') AS portal_parameter_id, relevance_group_size AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.relevance_group_size IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'use_sale_sort') AS portal_parameter_id, use_sale_sort AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.use_sale_sort IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'multitracking_criteria') AS portal_parameter_id, multitracking_criteria AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.multitracking_criteria <> '' AND m.multitracking_criteria IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'expert_reviews') AS portal_parameter_id, expert_reviews AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.expert_reviews <> '' AND m.expert_reviews IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'popular_searches') AS portal_parameter_id, popular_searches AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.popular_searches <> '' AND m.popular_searches IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'show_merchant_logo') AS portal_parameter_id, show_merchant_logo AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.show_merchant_logo IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'is_lazy_loading') AS portal_parameter_id, is_lazy_loading AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.is_lazy_loading IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'use_relevance_sort') AS portal_parameter_id, use_relevance_sort AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.use_relevance_sort IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'use_auctions') AS portal_parameter_id, use_auctions AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.use_auctions IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'use_meta_robots') AS portal_parameter_id, use_meta_robots AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.use_meta_robots IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'use_backfill_offers') AS portal_parameter_id, use_backfill_offers AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.use_backfill_offers IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'show_search_rating') AS portal_parameter_id, show_search_rating AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.show_search_rating IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)

UNION SELECT id AS portal_id, (SELECT id from portal_parameters WHERE code = 'is_wide_offers') AS portal_parameter_id, is_wide_offer AS parameter_value 
FROM runashop_priceportal.main_data m 
WHERE m.is_wide_offer IS NOT NULL AND m.id IN (SELECT id FROM `portals_migration`)
;