brunocalderon

^XA^FO0,0^GFA,113220,113220,102,,:::::::::::::::::::::::::P01F8K0FCN03FEN03FEK03EK03FJ01F8,P07FEJ03FEM03IFCL01IFEJ0FF8J07FCI07FC,P0IFJ07FFM0KFL07JF8001FFCI01FFEI0IF,O01IFJ0IF8K01KFCJ01KFC003FFEI01IF001IF,O01IF8I0IFCK07KFEJ03LF007FFEI03IF001IF8,O03IFC001IFEK0MFJ07LF807IFI07IF003IFC,O03IFC003IFEJ01MF8I0MFC07IF8007IF007IFC,O07IFE003JFJ03MFC001MFE07IF800JF007IFE,O0KF007JFJ07MFE003NF07IFC01JF00KF,O0KF007JF8I07NF007NF03IFE01JF00KFlN0E,N01KF80KFCI0OF007NF83IFE03IFE01KF8lM04,N03KFC1KFCI0OF80OF81JF03IFE03KF8,N03KFC1KFE001JF0JF80JF87IFC1JF07IFC03KFC,N07KFE3LF001IFC03IF80IFE01IFC0JF8JF807KFEkQ08,N07KFE7LF001IF801IFC1IFC00IFC07IFCJF80LFEkN0DF3E03F01F87061FC00E0FE,N0MF7LF801IF800IFC1IF8007FFC07IFDJF00MFkN0F3E7073839C30638E00E1C7,M01TFC01IFI0IFC1IF8007FFE03MFE01MF8kM0E1C38E0C70630630600E183,M01TFC01IFI07FFC1IFI07FFE01MFE01MF8kM0C1C18C0C60618C00600E3018,M03TFE01IFI07FFC1IFI07FFE01MFC03MFCkM0C1C18C0E60718C0FE00E3018,M07TFE01IFI0IFC1IF8007FFE00MFC07MFCkM0C1C18C0E6071D83FE00E3018,M07UF01IFI0IFC1IF8007FFC007LF807MFEkM0C1C18C0C6

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'];