Preview:

SELECT * FROM invoice WHERE 1=1 AND (payment_status = 4 or payment_status = 5 or payment_status = 6 ) ORDER BY `invoice`.`id` DESC
ID Amnt Delivery Pay Status Customer Location Order Date Description
A47254-Yen-Oct13 410 Not Paid(GPay) Deliverd Yen PAZHOOKARA Oct 13, 4:10 pm Clean cheyaruth🚫
A47251-Valsa-Oct13 240 Not Paid(GPay) Deliverd Valsa ASHTAMICHIRA Oct 13, 3:52 pm Clean cheyanam✂️
A47250-Lija-Oct13 290 Not Paid(GPay) Deliverd Lija CHALAKUDY Oct 13, 3:29 pm Clean cheyanam✂️
A47249-Ranjitth R-Oct13 320 Not Paid(GPay) Deliverd Ranjitth R PAZHOOKARA Oct 13, 3:29 pm Clean cheyanam✂️
A47248-Rinu Mathew-Oct13 490 Not Paid(GPay) Deliverd Rinu Mathew PAZHOOKARA Oct 13, 12:38 pm Cut🔪
A47247-Latha Biju-Oct13 740 Not Paid(GPay) Deliverd Latha Biju KADUKUTTY Oct 13, 12:33 pm Medium pieces 🔪
A47244-Shiji pzhkra-Oct12 300 Not Paid(GPay) Deliverd Shiji pzhkra PAZHOOKARA Oct 12, 6:04 pm
A47243-Dittez Company-Oct12 260 Not Paid(GPay) Deliverd Dittez Company PAZHOOKARA Oct 12, 6:03 pm Clean cheyanam✂️
A47241-Ancy sinto-Oct12 702.5 Not Paid(GPay) Deliverd Ancy sinto PAZHOOKARA Oct 12, 8:41 am
A47230-Selestin-Oct12 500 Not Paid(GPay) Deliverd Selestin THIRUTHIPARAMBU Oct 12, 3:26 am No cut🚫
A47211-Dittez Company-Oct10 260 Not Paid(GPay) Deliverd Dittez Company PAZHOOKARA Oct 10, 3:55 pm Clean cheyanam✂️
A47200-Jithin Smlash-Oct10 358.7 Not Paid(GPay) Deliverd Jithin Smlash PAZHOOKARA Oct 10, 11:42 am
A47199-Treasa John-Oct10 500 Not Paid(GPay) Deliverd Treasa John CHALAKUDY Oct 10, 6:12 am Cut🔪
A47155-Jino Jose-Oct5 550 Not Paid(GPay) Deliverd Jino Jose CHALAKUDY Oct 5, 4:20 pm
A47131-Binu Joseph-Oct5 900 Not Paid(GPay) Deliverd Binu Joseph PAZHOOKARA Oct 5, 3:21 am Cut🔪
A47068-test-Sep29 0 Not Paid(GPay) New Order test ASHTAMICHIRA Sep 29, 8:44 pm
A46985-raji-Sep25 195 Not Paid(GPay) Deliverd raji ASHTAMICHIRA Sep 25, 10:42 am
A46173-Antony ashtami-Jul22 250 Not Paid(GPay) Deliverd Antony ashtamichira ASHTAMICHIRA Jul 22, 8:53 am
A42582-Midhun hotel -Dec9 838 0 Not Paid(GPay) Deliverd Midhun hotel PAZHOOKARA Dec 9, 11:12 am
Total 8104.2 Rs

Total: