SELECT * FROM Review ORDER BY `ItemID`

SELECT ItemID, COUNT(*) AS TotalCount FROM (SELECT `ItemID`,`Confirm` FROM z251031 WHERE `Confirm` != 'Rejected' UNION ALL SELECT `ItemID`,`Confirm` FROM z251029 WHERE `Confirm` != 'Rejected') AS all_items GROUP BY ItemID

JayJayTea

SELECT * FROM menu WHERE `NextDeliveryDate`!='' ORDER BY `SpecialLevel` DESC,`NextDeliveryDate`,`SearchPoint` DESC

0CheckOut

MENU:

1 |

Black Milk Tea

3.5★★★★★4 Review
Next Delivery Date:
Wed 11/19/25(9:00AM-2:00PM) Crystal Boba ($0.25)
Pudding Boba ($0.50)
Kiwi Jam ($0.75)
x2 Topping ($1.00)

Khan Daoshop


Delivery Schedule:
Mon,Wed,Fri,Sun,

Quantity

Price: $4.00 Info: Read

Mango Passion Fruit

5.0★★★★★1 Review
Next Delivery Date:
Wed 11/19/25(9:00AM-2:00PM)

Khan Daoshop


Delivery Schedule:
Mon,Wed,Fri,Sun,

Quantity

Price: $4.00

ba?nh canh ca? lo?c

0.0★★★★★0 Review
Next Delivery Date:
Wed 11/19/25(9:00AM-2:00PM) Cha? ca? ($1.5)
Thi?t nguô?i ($1)

Khan Daoshop


Delivery Schedule:
Wed,Thu,Fri

Quantity

Price: $10.50 Info: Read

Bánh canh cua

0.0★★★★★0 Review
Next Delivery Date:
Fri 11/21/25(9:00AM-2:00PM) Chả cua ($1)

Khan Daoshop


Delivery Schedule:
Fri

Quantity

Price: $10.00 Info: Read

Bánh canh cua

0.0★★★★★0 Review
Next Delivery Date:
Fri 11/21/25(9:00AM-2:00PM) Chả cua ($1)
tôm ($2)
thịt ($3)

Khan Daoshop


Delivery Schedule:
Fri

Quantity

Price: $10.00 Info: Read

ioihlhli

0.0★★★★★0 Review
Next Delivery Date:
Fri 11/21/25(9:00AM-2:00PM) t ($3)
tt ($4)
ttt ($5)

Khan Daoshop


Delivery Schedule:
Fri

Quantity

Price: $33.00 Info: Read

ccc

0.0★★★★★0 Review
Next Delivery Date:
Fri 11/21/25(9:00AM-2:00PM) das ($1)
asd ($2)
sdfd ($3)

Khan Daoshop


Delivery Schedule:
Fri,Sat,Sun

Quantity

Price: $23.00 Info: Read
1 |