Cacher is the code snippet organizer for pro developers

-- se tbl_payment.payment_0_date_expire == null non ritorna valori
SELECT 
'payment-0' as p0,
COUNT(tbl_payment.payment_0_date_expire ) as pp
FROM tbl_payment
WHERE tbl_payment.state_order =0
UNION
SELECT
'payment-1' as pn1,
COUNT(tbl_payment.payment_1_date_expire ) as pc1
FROM tbl_payment
WHERE tbl_payment.state_order =0
UNION
SELECT
'payment-2' as pn2,
COUNT(tbl_payment.payment_2_date_expire ) as pc2
FROM tbl_payment
WHERE tbl_payment.state_order =0
UNION
SELECT
'payment-3' as pn3,
COUNT(tbl_payment.payment_3_date_expire ) as pc3
FROM tbl_payment
WHERE tbl_payment.state_order =0
UNION
SELECT
'payment-4' as pn4,
COUNT(tbl_payment.payment_4_date_expire ) as pc4
FROM tbl_payment
WHERE tbl_payment.state_order =0
UNION
SELECT
'payment-5' as pn5,
COUNT(tbl_payment.payment_5_date_expire ) as pc5
FROM tbl_payment
WHERE tbl_payment.state_order =0
UNION
SELECT
'payment-6' as pn6,
COUNT(tbl_payment.payment_6_date_expire ) as pc6
FROM tbl_payment
WHERE tbl_payment.state_order =0