brunocalderon

select
    p.ID as order_id,
    p.post_date,
    max( CASE WHEN pm.meta_key = '_billing_email' and p.ID = pm.post_id THEN pm.meta_value END ) as billing_email,
    max( CASE WHEN pm.meta_key = '_billing_first_name' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_first_name,
    max( CASE WHEN pm.meta_key = '_billing_last_name' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_last_name,
    max( CASE WHEN pm.meta_key = '_billing_address_1' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_address_1,
    max( CASE WHEN pm.meta_key = '_billing_address_2' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_address_2,
    max( CASE WHEN pm.meta_key = '_billing_city' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_city,
    max( CASE WHEN pm.meta_key = '_billing_state' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_state,

brunocalderon

<?php
$everything_is_easy = $_GET['everything_is_easy'];
$future_work_promises = $_GET['future_work_promises'];
$unrealistic_deadline = $_GET['unrealistic_deadline'];
$questioning_rates = $_GET['questioning_rates'];
$changed_agency = $_GET['changed_agency'];
$you_dont_get_it = $_GET['you_dont_get_it'];
$dissapearing = $_GET['dissapearing'];
$free_proofs = $_GET['free_proofs'];
$disorganized = $_GET['disorganized'];