registeracy

SELECT o.id_order, c.email, c.firstname, c.lastname, d.product_name, o.payment, o.id_cart FROM tb_orders o INNER JOIN tb_customer c ON ( c.id_customer = o.id_customer ) INNER JOIN tb_order_detail d ON ( d.id_order = o.id_order ) WHERE o.delivery_number <> 1array(16) { [0]=> array(7) { ["id_order"]=> string(5) "10695" ["email"]=> string(29) "" ["firstname"]=> string(10) "TEST LENKA" ["lastname"]=> string(1) "K" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "13827" } [1]=> array(7) { ["id_order"]=> string(5) "10696" ["email"]=> string(29) "" ["firstname"]=> string(10) "TEST LENKA" ["lastname"]=> string(1) "K" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "13828" } [2]=> array(7) { ["id_order"]=> string(5) "10778" ["email"]=> string(29) "" ["firstname"]=> string(10) "TEST LENKA" ["lastname"]=> string(1) "K" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "13924" } [3]=> array(7) { ["id_order"]=> string(5) "10820" ["email"]=> string(22) "" ["firstname"]=> string(7) "Tomáš" ["lastname"]=> string(7) "Popelka" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "13983" } [4]=> array(7) { ["id_order"]=> string(5) "11398" ["email"]=> string(25) "" ["firstname"]=> string(5) "Lenka" ["lastname"]=> string(10) "Chvostová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "14689" } [5]=> array(7) { ["id_order"]=> string(5) "11413" ["email"]=> string(32) "" ["firstname"]=> string(6) "Pavel " ["lastname"]=> string(9) "Schiller " ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "14710" } [6]=> array(7) { ["id_order"]=> string(5) "11421" ["email"]=> string(24) "" ["firstname"]=> string(5) "Tomas" ["lastname"]=> string(7) "Vondra " ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "14720" } [7]=> array(7) { ["id_order"]=> string(5) "11632" ["email"]=> string(17) "" ["firstname"]=> string(5) "Marko" ["lastname"]=> string(6) "Haspel" ["product_name"]=> string(21) "VOUCHER FOR 5 TICKETS" ["payment"]=> string(26) "COMAGATE - payment gateway" ["id_cart"]=> string(5) "14988" } [8]=> array(7) { ["id_order"]=> string(5) "12016" ["email"]=> string(18) "" ["firstname"]=> string(10) "Vladislava" ["lastname"]=> string(10) "Benešová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "15464" } [9]=> array(7) { ["id_order"]=> string(5) "12018" ["email"]=> string(18) "" ["firstname"]=> string(10) "Vladislava" ["lastname"]=> string(10) "Benešová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "15467" } [10]=> array(7) { ["id_order"]=> string(5) "12019" ["email"]=> string(18) "" ["firstname"]=> string(10) "Vladislava" ["lastname"]=> string(10) "Benešová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "15468" } [11]=> array(7) { ["id_order"]=> string(5) "13329" ["email"]=> string(14) "" ["firstname"]=> string(7) "Richard" ["lastname"]=> string(7) "Mikulec" ["product_name"]=> string(54) "25.3.2023 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "17180" } [12]=> array(7) { ["id_order"]=> string(5) "13330" ["email"]=> string(25) "" ["firstname"]=> string(9) "Vratislav" ["lastname"]=> string(5) "Macho" ["product_name"]=> string(54) "25.3.2023 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "17179" } [13]=> array(7) { ["id_order"]=> string(5) "13331" ["email"]=> string(14) "" ["firstname"]=> string(7) "Richard" ["lastname"]=> string(7) "Mikulec" ["product_name"]=> string(54) "25.3.2023 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "17181" } [14]=> array(7) { ["id_order"]=> string(5) "13332" ["email"]=> string(20) "" ["firstname"]=> string(7) "Martina" ["lastname"]=> string(9) "Davidová" ["product_name"]=> string(54) "25.3.2023 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "17182" } [15]=> array(7) { ["id_order"]=> string(5) "13333" ["email"]=> string(25) "" ["firstname"]=> string(8) "Marcela " ["lastname"]=> string(9) "Barborík" ["product_name"]=> string(54) "25.3.2023 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "17185" } }