/** Korean **/
INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language_code = 'KR'), 0.045, 0.000, 0.090;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language_code = 'KR'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language_code = 'KR'), 0.045, 0.010, 0.110;

/** Danish **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language_code = 'DK'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language_code = 'DK'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language_code = 'DK'), 0.040, 0.010, 0.100;

/** Dutch **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Dutch'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Dutch'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Dutch'), 0.040, 0.010, 0.100;

/** ENGLISH (AUSTRALIA) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language_code = 'AU'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language_code = 'AU'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language_code = 'AU'), 0.040, 0.010, 0.100;

/** ENGLISH (CANADA) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'English (CA)'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'English (CA)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'English (CA)'), 0.040, 0.010, 0.100;

/** FINNISH (SUOMI) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language_code = 'FI'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language_code = 'FI'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language_code = 'FI'), 0.040, 0.010, 0.100;

/** FRENCH (CANADA) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'French (Canada)'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'French (Canada)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'French (Canada)'), 0.040, 0.010, 0.100;

/** French (France) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'French (France)'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'French (France)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'French (France)'), 0.040, 0.010, 0.100;

/** GERMAN (GERMANY) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'German'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'German'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'German'), 0.040, 0.010, 0.100;

/** HEBREW **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Hebrew'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Hebrew'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Hebrew'), 0.040, 0.010, 0.100;

/** ICELANDIC **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Icelandic'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Icelandic'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Icelandic'), 0.040, 0.010, 0.100;

/** IRISH **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Irish'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Irish'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Irish'), 0.040, 0.010, 0.100;

/** ITALIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Italian'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Italian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Italian'), 0.040, 0.010, 0.100;

/** NORWEGIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Norwegian (bokmal)'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Norwegian (bokmal)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Norwegian (bokmal)'), 0.040, 0.010, 0.100;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Norwegian (nynorsk)'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Norwegian (nynorsk)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Norwegian (nynorsk)'), 0.040, 0.010, 0.100;

/** SPANISH (SPAIN) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Spanish (Spain)'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Spanish (Spain)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Spanish (Spain)'), 0.040, 0.010, 0.100;

/** SWEDISH **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Swedish'), 0.040, 0.000, 0.080;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Swedish'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Swedish'), 0.040, 0.010, 0.100;

/** ARAB (MULTIPLE DIALECTS) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Arabic'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Arabic'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Arabic'), 0.030, 0.010, 0.080;

/** BOSNIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Bosnian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Bosnian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Bosnian'), 0.030, 0.010, 0.080;

/** BULGARIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Bulgarian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Bulgarian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Bulgarian'), 0.030, 0.010, 0.080;

/** CROATIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Croatian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Croatian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Croatian'), 0.030, 0.010, 0.080;

/** CZECH **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Czech'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Czech'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Czech'), 0.030, 0.010, 0.080;

/** ENGLISH (UNITED KINGDOM) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'English (UK)'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'English (UK)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'English (UK)'), 0.030, 0.010, 0.080;

/** ENGLISH (US) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'English (US)'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'English (US)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'English (US)'), 0.030, 0.010, 0.080;

/** FILIPINO **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Filipino'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Filipino'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Filipino'), 0.030, 0.010, 0.080;

/** GREEK **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Greek'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Greek'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Greek'), 0.030, 0.010, 0.080;

/** HUNGARIAN (MAGYAR) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Hungarian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Hungarian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Hungarian'), 0.030, 0.010, 0.080;

/** INDIAN (MULTIPLE DIALECTS) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Hindi'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Hindi'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Hindi'), 0.030, 0.010, 0.080;

/** INDONESIAN (BAHASA) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Indonesian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Indonesian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Indonesian'), 0.030, 0.010, 0.080;

/** INDONESIAN (BAHASA) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Indonesian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Indonesian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Indonesian'), 0.030, 0.010, 0.080;

/** MALAY **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Malay'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Malay'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Malay'), 0.030, 0.010, 0.080;

/** PERSIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Persian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Persian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Persian'), 0.030, 0.010, 0.080;

/** POLISH **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Polish'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Polish'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Polish'), 0.030, 0.010, 0.080;

/** PORTUGUESE (BRAZIL) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Portuguese (Brazil)'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Portuguese (Brazil)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Portuguese (Brazil)'), 0.030, 0.010, 0.080;

/** PORTUGUESE (PORTUGAL) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Portuguese (Portugal)'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Portuguese (Portugal)'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Portuguese (Portugal)'), 0.030, 0.010, 0.080;

/** ROMANIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Romanian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Romanian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Romanian'), 0.030, 0.010, 0.080;

/** RUSSIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Russian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Russian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Russian'), 0.030, 0.010, 0.080;

/** SERBIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Serbian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Serbian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Serbian'), 0.030, 0.010, 0.080;

/** SLOVAK **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Slovak'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Slovak'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Slovak'), 0.030, 0.010, 0.080;

/** SLOVENIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Slovenian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Slovenian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Slovenian'), 0.030, 0.010, 0.080;

/** SPANISH **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Spanish'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Spanish'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Spanish'), 0.030, 0.010, 0.080;

/** TURKISH **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Turkish'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Turkish'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Turkish'), 0.030, 0.010, 0.080;

/** UKRANIAN **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Ukrainian'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Ukrainian'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Ukrainian'), 0.030, 0.010, 0.080;

/** VIETNAMESE **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Vietnamese'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Vietnamese'), 0.000, 0.010, 0.020;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Vietnamese'), 0.030, 0.010, 0.080;

/** CANTONESE **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Traditional Chinese (Hong Kong)'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Traditional Chinese (Hong Kong)'), 0.000, 0.005, 0.010;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Traditional Chinese (Hong Kong)'), 0.030, 0.005, 0.070;

/** JAPANESE **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Japanese'), 0.030, 0.000, 0.060;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Japanese'), 0.000, 0.005, 0.010;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Japanese'), 0.030, 0.005, 0.070;

/** CHINESE (SIMPLIFIED) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Simplified Chinese (China)'), 0.020, 0.000, 0.040;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Simplified Chinese (China)'), 0.000, 0.005, 0.010;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Simplified Chinese (China)'), 0.020, 0.005, 0.050;

/** CHINESE (TRADITIONAL) **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Traditional Chinese (Taiwan)'), 0.020, 0.000, 0.040;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Traditional Chinese (Taiwan)'), 0.000, 0.005, 0.010;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Traditional Chinese (Taiwan)'), 0.020, 0.005, 0.050;

/** THAI **/

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing'), 
(SELECT id FROM languages WHERE language = 'Thai'), 0.020, 0.000, 0.040;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'editing'), 
(SELECT id FROM languages WHERE language = 'Thai'), 0.000, 0.005, 0.010;

INSERT INTO package_lang_prices (package_id, language_id, price_writing, price_editing, price_client)
SELECT (SELECT id FROM packages WHERE code = 'writing_editing'), 
(SELECT id FROM languages WHERE language = 'Thai'), 0.020, 0.005, 0.050;