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(18) { [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" } }