Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `foreman_material_received` ORDER BY `item_id` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id item_id Descending Ascending 1
FK ไปยัง foreman_material_items.id
received_no
ครั้งที่รับ (1, 2, 3, ...)
received_qty
จำนวนที่รับ
received_date
วันที่รับ
received_by
ชื่อผู้รับ
signature_data issued_by warehouse_history_id remarks
หมายเหตุ
created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 10263
10263 18989 2 12.00 2026-10-01 15:55:39 ถาวร mint store 38725 NULL 2026-10-01 15:55:39 2026-10-01 15:55:42
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9946
9946 18989 1 3.00 2026-10-01 13:31:13 ถาวร mint store 38406 NULL 2026-10-01 13:31:13 2026-10-01 13:31:15
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 10166
10166 18791 1 8.00 2026-10-01 14:54:28 อองซออู mint store 38626 NULL 2026-10-01 14:54:28 2026-10-01 14:54:30
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9798
9798 18752 2 7.00 2026-09-30 10:32:43 พี mint store 38077 NULL 2026-09-30 10:32:43 2026-09-30 10:32:46
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9797
9797 18752 1 6.00 2026-09-30 10:32:33 ตาล mint store 38076 NULL 2026-09-30 10:32:33 2026-09-30 10:32:35
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9996
9996 18746 1 8.00 2026-10-01 13:58:49 Meng ดุษฎี อุตมะ 38569 NULL 2026-10-01 13:58:49 2026-10-01 14:33:49
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9995
9995 18745 1 14.00 2026-10-01 13:58:49 Meng ดุษฎี อุตมะ 38568 NULL 2026-10-01 13:58:49 2026-10-01 14:33:47
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9879
9879 18744 1 30.00 2026-10-01 11:00:32 นาวิน NULL NULL NULL 2026-10-01 11:00:32 2026-10-01 11:00:32
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9878
9878 18743 1 30.00 2026-10-01 11:00:32 นาวิน NULL NULL NULL 2026-10-01 11:00:32 2026-10-01 11:00:32
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9877
9877 18742 1 30.00 2026-10-01 11:00:32 นาวิน NULL NULL NULL 2026-10-01 11:00:32 2026-10-01 11:00:32
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9876
9876 18741 1 30.00 2026-10-01 11:00:32 นาวิน NULL NULL NULL 2026-10-01 11:00:32 2026-10-01 11:00:32
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 10165
10165 18736 1 10.00 2026-10-01 14:53:52 อองซออู NULL NULL NULL 2026-10-01 14:53:52 2026-10-01 14:53:52
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9860
9860 18735 1 2.00 2026-10-01 09:06:16 น้ำ mint store 38283 NULL 2026-10-01 09:06:16 2026-10-01 09:06:19
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 10164
10164 18734 1 50.00 2026-10-01 14:53:52 อองซออู mint store 38625 NULL 2026-10-01 14:53:52 2026-10-01 14:53:58
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9777
9777 18733 1 8.00 2026-09-29 15:19:24 Zaw myo htwe สมปอง มากประโคน 38016 NULL 2026-09-29 15:19:24 2026-09-29 15:19:43
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9776
9776 18732 1 4.00 2026-09-29 15:19:24 Zaw myo htwe สมปอง มากประโคน 38015 NULL 2026-09-29 15:19:24 2026-09-29 15:19:42
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9775
9775 18731 1 8.00 2026-09-29 15:19:24 Zaw myo htwe สมปอง มากประโคน 38014 NULL 2026-09-29 15:19:24 2026-09-29 15:19:40
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9774
9774 18730 1 5.00 2026-09-29 15:19:24 Zaw myo htwe สมปอง มากประโคน 38013 NULL 2026-09-29 15:19:24 2026-09-29 15:19:38
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9769
9769 18709 1 3.00 2026-09-29 13:58:21 3 mint store 38012 NULL 2026-09-29 13:58:21 2026-09-29 13:58:41
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9772
9772 18708 1 10.00 2026-09-29 14:16:52 นาวิน NULL NULL NULL 2026-09-29 14:16:52 2026-09-29 14:16:52
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9771
9771 18707 1 10.00 2026-09-29 14:16:26 นาวิน NULL NULL NULL 2026-09-29 14:16:26 2026-09-29 14:16:26
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9770
9770 18706 1 2.00 2026-09-29 14:16:00 นาวิน NULL NULL NULL 2026-09-29 14:16:00 2026-09-29 14:16:00
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9729
9729 18705 1 15.00 2026-09-29 12:31:13 แต NULL NULL NULL 2026-09-29 12:31:13 2026-09-29 12:31:13
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9851
9851 18579 1 7.00 2026-09-30 14:20:13 เมียวซออู mint store 38177 NULL 2026-09-30 14:20:13 2026-09-30 14:20:17
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 9795
9795 18567 1 8.00 2026-09-30 09:33:20 เมียว ซอ อู mint store 38081 NULL 2026-09-30 09:33:20 2026-09-30 10:47:16
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query