SELECT SUM(total_count_klm) AS KLM_tweets
FROM (
    SELECT COUNT(*) AS total_count_klm
    FROM tweets_extend
    WHERE user_mention0_id = '56377143' OR user_mention0_name = 'KLM' OR user_mention0_name = 'klm' OR user_mention1_name = 'klm' OR user_mention1_name = 'KLM' OR user_mention1_id = '56377143'

    UNION ALL

    SELECT COUNT(*) AS total_count_klm
    FROM user_data
    WHERE user_id1 = '56377143'
) AS klm_counts; 
SELECT SUM(total_count_airfrance) AS AirFrance_tweets
FROM (
    SELECT COUNT(*) AS total_count_airfrance
    FROM tweets_extend
    WHERE user_mention0_id = '106062176' OR user_mention0_name = 'AirFrance' OR user_mention0_name = 'airfrance' OR user_mention1_name = 'airfrance' OR user_mention1_name = 'AirFrance' OR user_mention1_id = '106062176'

    UNION ALL

    SELECT COUNT(*) AS total_count_airfrance
    FROM user_data
    WHERE user_id1 = '106062176'
) AS airfrance_counts;
SELECT SUM(total_count_british_airways) AS British_Airways_tweets
FROM (
    SELECT COUNT(*) AS total_count_british_airways
    FROM tweets_extend
    WHERE user_mention0_id = '18332190' OR user_mention0_name = 'British_Airways' OR user_mention0_name = 'british_airways' OR user_mention1_name = 'british_airways' OR user_mention1_name = 'British_Airways' OR user_mention1_id = '18332190'

    UNION ALL

    SELECT COUNT(*) AS total_count_british_airways
    FROM user_data
    WHERE user_id1 = '18332190'
) AS british_airways_counts;
SELECT SUM(total_count_american_airlines) AS American_Airlines_tweets
FROM (
    SELECT COUNT(*) AS total_count_american_airlines
    FROM tweets_extend
    WHERE user_mention0_id = '22536055' OR user_mention0_name = 'AmericanAirlines' OR user_mention0_name = 'americanairlines' OR user_mention1_name = 'americanairlines' OR user_mention1_name = 'AmericanAirlines' OR user_mention1_id = '22536055'

    UNION ALL

    SELECT COUNT(*) AS total_count_american_airlines
    FROM user_data
    WHERE user_id1 = '22536055'
) AS american_airlines_counts;
SELECT SUM(total_count_lufthansa) AS Lufthansa_tweets
FROM (
    SELECT COUNT(*) AS total_count_lufthansa
    FROM tweets_extend
    WHERE user_mention0_id = '124476322' OR user_mention0_name = 'Lufthansa' OR user_mention0_name = 'lufthansa' OR user_mention1_name = 'lufthansa' OR user_mention1_name = 'Lufthansa' OR user_mention1_id = '124476322'

    UNION ALL

    SELECT COUNT(*) AS total_count_lufthansa
    FROM user_data
    WHERE user_id1 = '124476322'
) AS lufthansa_counts;
SELECT SUM(total_count_airberlin) AS AirBerlin_tweets
FROM (
    SELECT COUNT(*) AS total_count_airberlin
    FROM tweets_extend
    WHERE user_mention0_id = '26223583' OR user_mention0_name = 'AirBerlin' OR user_mention0_name = 'airberlin' OR user_mention1_name = 'airberlin' OR user_mention1_name = 'AirBerlin' OR user_mention1_id = '26223583'

    UNION ALL

    SELECT COUNT(*) AS total_count_airberlin
    FROM user_data
    WHERE user_id1 = '26223583'
) AS airberlin_counts;
SELECT SUM(total_count_airberlin_assist) AS AirBerlin_Assist_tweets
FROM (
    SELECT COUNT(*) AS total_count_airberlin_assist
    FROM tweets_extend
    WHERE user_mention0_id = '2182373406' OR user_mention0_name = 'AirBerlin assist' OR user_mention0_name = 'airberlin_assist' OR user_mention1_name = 'airberlin_assist' OR user_mention1_name = 'AirBerlin assist' OR user_mention1_id = '2182373406'

    UNION ALL

    SELECT COUNT(*) AS total_count_airberlin_assist
    FROM user_data
    WHERE user_id1 = '2182373406'
) AS airberlin_assist_counts;
SELECT SUM(total_count_easyjet) AS EasyJet_tweets
FROM (
    SELECT COUNT(*) AS total_count_easyjet
    FROM tweets_extend
    WHERE user_mention0_id = '38676903' OR user_mention0_name = 'easyJet' OR user_mention0_name = 'easyjet' OR user_mention1_name = 'easyjet' OR user_mention1_name = 'easyJet' OR user_mention1_id = '38676903'

    UNION ALL

    SELECT COUNT(*) AS total_count_easyjet
    FROM user_data
    WHERE user_id1 = '38676903'
) AS easyjet_counts;
SELECT SUM(total_count_ryanair) AS Ryanair_tweets
FROM (
    SELECT COUNT(*) AS total_count_ryanair
    FROM tweets_extend
    WHERE user_mention0_id = '1542862735' OR user_mention0_name = 'Ryanair' OR user_mention0_name = 'ryanair' OR user_mention1_name = 'ryanair' OR user_mention1_name = 'Ryanair' OR user_mention1_id = '1542862735'

    UNION ALL

    SELECT COUNT(*) AS total_count_ryanair
    FROM user_data
    WHERE user_id1 = '1542862735'
) AS ryanair_counts;
SELECT SUM(total_count_singapore_airlines) AS Singapore_Airlines_tweets
FROM (
    SELECT COUNT(*) AS total_count_singapore_airlines
    FROM tweets_extend
    WHERE user_mention0_id = '253340062' OR user_mention0_name = 'SingaporeAir' OR user_mention0_name = 'singaporeair' OR user_mention1_name = 'singaporeair' OR user_mention1_name = 'SingaporeAir' OR user_mention1_id = '253340062'

    UNION ALL

    SELECT COUNT(*) AS total_count_singapore_airlines
    FROM user_data
    WHERE user_id1 = '253340062'
) AS singapore_airlines_counts;
SELECT SUM(total_count_qantas) AS Qantas_tweets
FROM (
    SELECT COUNT(*) AS total_count_qantas
    FROM tweets_extend
    WHERE user_mention0_id = '218730857' OR user_mention0_name = 'Qantas' OR user_mention0_name = 'qantas' OR user_mention1_name = 'qantas' OR user_mention1_name = 'Qantas' OR user_mention1_id = '218730857'

    UNION ALL

    SELECT COUNT(*) AS total_count_qantas
    FROM user_data
    WHERE user_id1 = '218730857'
) AS qantas_counts;
SELECT SUM(total_count_etihad_airways) AS Etihad_Airways_tweets
FROM (
    SELECT COUNT(*) AS total_count_etihad_airways
    FROM tweets_extend
    WHERE user_mention0_id = '45621423' OR user_mention0_name = 'EtihadAirways' OR user_mention0_name = 'etihadairways' OR user_mention1_name = 'etihadairways' OR user_mention1_name = 'EtihadAirways' OR user_mention1_id = '45621423'

    UNION ALL

    SELECT COUNT(*) AS total_count_etihad_airways
    FROM user_data
    WHERE user_id1 = '45621423'
) AS etihad_airways_counts;

SELECT SUM(total_count_virgin_atlantic) AS Virgin_Atlantic_tweets
FROM (
    SELECT COUNT(*) AS total_count_virgin_atlantic
    FROM tweets_extend
    WHERE user_mention0_id = '20626359' OR user_mention0_name = 'VirginAtlantic' OR user_mention0_name = 'virginatlantic' OR user_mention1_name = 'virginatlantic' OR user_mention1_name = 'VirginAtlantic' OR user_mention1_id = '20626359'

    UNION ALL

    SELECT COUNT(*) AS total_count_virgin_atlantic
    FROM user_data
    WHERE user_id1 = '20626359'
) AS virgin_atlantic_counts;