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(33) { [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) "13362" ["email"]=> string(20) "" ["firstname"]=> string(5) "Karel" ["lastname"]=> string(6) "Šmíd" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "17219" } [12]=> array(7) { ["id_order"]=> string(5) "13510" ["email"]=> string(27) "" ["firstname"]=> string(8) "Veronika" ["lastname"]=> string(9) "Strossova" ["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) "17415" } [13]=> array(7) { ["id_order"]=> string(5) "13681" ["email"]=> string(8) "dvsyd@ff" ["firstname"]=> string(2) "dv" ["lastname"]=> string(4) "dfvs" ["product_name"]=> string(55) "15.4.2023 ŽIVÁ EXOTIKA (Vstup od / Entry from: 10:30)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "17635" } [14]=> array(7) { ["id_order"]=> string(5) "14649" ["email"]=> string(28) "" ["firstname"]=> string(10) "Drahoslava" ["lastname"]=> string(8) "Loudová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "18871" } [15]=> array(7) { ["id_order"]=> string(5) "14973" ["email"]=> string(25) "" ["firstname"]=> string(6) "Nikola" ["lastname"]=> string(10) "Pazderová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "19271" } [16]=> array(7) { ["id_order"]=> string(5) "14974" ["email"]=> string(25) "" ["firstname"]=> string(6) "Nikola" ["lastname"]=> string(10) "Pazderová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "19272" } [17]=> array(7) { ["id_order"]=> string(5) "15712" ["email"]=> string(18) "" ["firstname"]=> string(5) "Hoang" ["lastname"]=> string(3) "Nam" ["product_name"]=> string(21) "VOUCHER FOR 5 TICKETS" ["payment"]=> string(26) "COMAGATE - payment gateway" ["id_cart"]=> string(5) "20228" } [18]=> array(7) { ["id_order"]=> string(5) "16570" ["email"]=> string(18) "" ["firstname"]=> string(5) "Pavla" ["lastname"]=> string(9) "Kaňková" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(17) "Bankovní převod" ["id_cart"]=> string(5) "21277" } [19]=> array(7) { ["id_order"]=> string(5) "17227" ["email"]=> string(29) "" ["firstname"]=> string(10) "TEST LENKA" ["lastname"]=> string(1) "K" ["product_name"]=> string(8) "Časopis" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "22052" } [20]=> array(7) { ["id_order"]=> string(5) "17267" ["email"]=> string(26) "" ["firstname"]=> string(7) "Ondřej" ["lastname"]=> string(6) "Šiman" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "22104" } [21]=> array(7) { ["id_order"]=> string(5) "17389" ["email"]=> string(29) "" ["firstname"]=> string(10) "TEST LENKA" ["lastname"]=> string(1) "K" ["product_name"]=> string(27) "DÁRKOVÝ POUKAZ NA 1 VSTUP" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "22259" } [22]=> array(7) { ["id_order"]=> string(5) "17395" ["email"]=> string(20) "" ["firstname"]=> string(7) "Vendula" ["lastname"]=> string(13) "Kramolišová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "22267" } [23]=> array(7) { ["id_order"]=> string(5) "18039" ["email"]=> string(29) "" ["firstname"]=> string(10) "TEST LENKA" ["lastname"]=> string(1) "K" ["product_name"]=> string(31) "DÁRKOVÝ POUKAZ NA JEDEN VSTUP" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "23018" } [24]=> array(7) { ["id_order"]=> string(5) "18793" ["email"]=> string(21) "" ["firstname"]=> string(6) "Tereza" ["lastname"]=> string(9) "Vlčková" ["product_name"]=> string(31) "DÁRKOVÝ POUKAZ NA JEDEN VSTUP" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "23987" } [25]=> array(7) { ["id_order"]=> string(5) "18804" ["email"]=> string(15) "" ["firstname"]=> string(4) "Anna" ["lastname"]=> string(11) "Špáňová" ["product_name"]=> string(31) "DÁRKOVÝ POUKAZ NA JEDEN VSTUP" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "24005" } [26]=> array(7) { ["id_order"]=> string(5) "18861" ["email"]=> string(20) "" ["firstname"]=> string(7) "Vendula" ["lastname"]=> string(12) "Mrkáčková" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "24093" } [27]=> array(7) { ["id_order"]=> string(5) "18901" ["email"]=> string(17) "" ["firstname"]=> string(4) "Petr" ["lastname"]=> string(9) "Vaníček" ["product_name"]=> string(31) "DÁRKOVÝ POUKAZ NA JEDEN VSTUP" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "24150" } [28]=> array(7) { ["id_order"]=> string(5) "19165" ["email"]=> string(6) "hg@dde" ["firstname"]=> string(1) "E" ["lastname"]=> string(2) "Rf" ["product_name"]=> string(54) "13.1.2024 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "24519" } [29]=> array(7) { ["id_order"]=> string(5) "19660" ["email"]=> string(28) "" ["firstname"]=> string(10) "Drahoslava" ["lastname"]=> string(8) "Loudová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "25144" } [30]=> array(7) { ["id_order"]=> string(5) "19716" ["email"]=> string(17) "" ["firstname"]=> string(6) "Nikola" ["lastname"]=> string(8) "Loudová" ["product_name"]=> string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "25247" } [31]=> array(7) { ["id_order"]=> string(5) "19966" ["email"]=> string(15) "" ["firstname"]=> string(7) "Richard" ["lastname"]=> string(5) "Kraus" ["product_name"]=> string(54) "24.2.2024 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "25570" } [32]=> array(7) { ["id_order"]=> string(5) "19967" ["email"]=> string(15) "" ["firstname"]=> string(7) "Richard" ["lastname"]=> string(5) "Kraus" ["product_name"]=> string(54) "24.2.2024 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)" ["payment"]=> string(26) "COMGATE - platební brána" ["id_cart"]=> string(5) "25571" } }