SELECT
    mainTable.cpda_id
FROM
    cp_data AS mainTable
LEFT OUTER JOIN
    cp_data AS table0
        ON table0.cpda_meta_id = mainTable.cpda_id
        AND table0.cpda_meta_key = '47248'
LEFT OUTER JOIN
    cp_data AS table1
        ON table1.cpda_meta_id = mainTable.cpda_id
        AND table1.cpda_meta_key = '47241'
LEFT OUTER JOIN
    cp_data AS table2
        ON table2.cpda_meta_id = mainTable.cpda_id
        AND table2.cpda_meta_key = '47242'
LEFT OUTER JOIN
    cp_data AS table3
        ON table3.cpda_meta_id = mainTable.cpda_id
        AND table3.cpda_meta_key = '66838'
LEFT OUTER JOIN
    cp_data AS table4
        ON table4.cpda_meta_id = mainTable.cpda_id
        AND table4.cpda_meta_key = '66843'
LEFT OUTER JOIN
    cp_data AS table5
        ON table5.cpda_meta_id = mainTable.cpda_id
        AND table5.cpda_meta_key = '47252'
LEFT OUTER JOIN
    cp_data AS table6
        ON table6.cpda_meta_id = mainTable.cpda_id
        AND table6.cpda_meta_key = '47255'
WHERE
    mainTable.cpda_meta_id = 47236
    AND mainTable.cpda_active = 1
    AND mainTable.cpda_meta_key = 'set_element_stub'
    AND table0.cpda_meta_val = 49297
    AND table1.cpda_meta_val != 66116
    AND (
        table5.cpda_meta_val = 497
        OR table6.cpda_meta_val = 497
    )
ORDER BY
    table2.cpda_meta_val,
    mainTable.cpda_seq,
    mainTable.cpda_id

SELECT
    mainTable.cpda_id
FROM
    cp_data AS mainTable
LEFT OUTER JOIN
    cp_data AS table0
        ON table0.cpda_meta_id = mainTable.cpda_id
        AND table0.cpda_meta_key = '47248'
LEFT OUTER JOIN
    cp_data AS table1
        ON table1.cpda_meta_id = mainTable.cpda_id
        AND table1.cpda_meta_key = '47241'
LEFT OUTER JOIN
    cp_data AS table2
        ON table2.cpda_meta_id = mainTable.cpda_id
        AND table2.cpda_meta_key = '47242'
LEFT OUTER JOIN
    cp_data AS table3
        ON table3.cpda_meta_id = mainTable.cpda_id
        AND table3.cpda_meta_key = '66838'
LEFT OUTER JOIN
    cp_data AS table4
        ON table4.cpda_meta_id = mainTable.cpda_id
        AND table4.cpda_meta_key = '66843'
LEFT OUTER JOIN
    cp_data AS table5
        ON table5.cpda_meta_id = mainTable.cpda_id
        AND table5.cpda_meta_key = '47252'
LEFT OUTER JOIN
    cp_data AS table6
        ON table6.cpda_meta_id = mainTable.cpda_id
        AND table6.cpda_meta_key = '47255'
CASE
    WHEN table4.cpda_meta_val = 1 THEN table3.cpda_meta_val
    ELSE table2.cpda_meta_val
END as table2.cpda_meta_val
WHERE
    mainTable.cpda_meta_id = 47236
    AND mainTable.cpda_active = 1
    AND mainTable.cpda_meta_key = 'set_element_stub'
    AND table0.cpda_meta_val = 49297
    AND table1.cpda_meta_val != 66116
    AND (
        table5.cpda_meta_val = 497
        OR table6.cpda_meta_val = 497
    )
ORDER BY
    table2.cpda_meta_val,
    mainTable.cpda_seq,
    mainTable.cpda_id