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
ชื่อผู้รับ
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` = 7064
7064 13160 1 1.00 2026-08-01 13:55:00 Aung Mon Anawin Rodroka 31093 2026-08-01 13:55:00 2026-08-01 14:26:42
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7066
7066 13094 1 6.00 2026-08-01 17:03:16 Thanakan Inkham Anawin Rodroka 31113 2026-08-01 17:03:16 2026-08-01 17:03:25
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7065
7065 13089 1 1.00 2026-08-01 17:03:12 Thanakan Inkham Anawin Rodroka 31112 2026-08-01 17:03:12 2026-08-01 17:03:23
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7039
7039 13061 1 12.00 2026-07-30 16:19:05 ฐรินดา Anawin Rodroka 30973 2026-07-30 16:19:05 2026-07-30 16:21:17
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7055
7055 13043 1 2.00 2026-07-31 09:23:13 Anawin Rodroka Anawin Rodroka 30977 2026-07-31 09:23:13 2026-07-31 09:23:20
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7056
7056 13041 2 30.00 2026-07-31 09:40:19 Chonlada Tingbun NULL 2026-07-31 09:40:19 2026-07-31 09:40:19
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7034
7034 13015 1 4.00 2026-07-30 15:59:58 ไก่ฟ้า NULL 2026-07-30 15:59:58 2026-07-30 15:59:58
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7035
7035 13000 1 3.00 2026-07-30 16:11:39 Thanakan Inkham NULL 2026-07-30 16:11:39 2026-07-30 16:11:39
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7036
7036 12987 1 3.00 2026-07-30 16:11:46 Thanakan Inkham NULL 2026-07-30 16:11:46 2026-07-30 16:11:46
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7026
7026 12982 1 3.00 2026-07-30 10:59:06 ไก่ฟ้า NULL 2026-07-30 10:59:06 2026-07-30 10:59:06
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7023
7023 12981 1 18.00 2026-07-30 10:31:11 Zaw Myo Htwe Anawin Rodroka 30953 2026-07-30 10:31:11 2026-07-30 10:31:18
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7024
7024 12973 1 8.00 2026-07-30 10:54:37 ไก่ฟ้า NULL 2026-07-30 10:54:37 2026-07-30 10:54:37
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7025
7025 12956 1 3.00 2026-07-30 10:56:34 ไก่ฟ้า NULL 2026-07-30 10:56:34 2026-07-30 10:56:34
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7019
7019 12947 1 5.00 2026-07-30 09:26:35 Zaw Myo Htwe NULL 2026-07-30 09:26:35 2026-07-30 09:26:35
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7009
7009 12945 1 1.00 2026-07-28 16:40:03 Nattawat mapon เลเซอร์ Anawin Rodroka 30917 2026-07-28 16:40:03 2026-07-28 16:40:20
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7008
7008 12944 1 2.00 2026-07-28 16:39:59 Nattawat mapon เลเซอร์ Anawin Rodroka 30916 2026-07-28 16:39:59 2026-07-28 16:40:18
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7007
7007 12943 1 14.00 2026-07-28 16:15:38 ภานุวัฒน์ ภูสมที PHUTHARET 30913 2026-07-28 16:15:38 2026-07-28 16:15:45
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7006
7006 12942 1 3.00 2026-07-28 15:59:27 Laddawan Anawin Rodroka 30912 2026-07-28 15:59:27 2026-07-28 16:02:47
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7005
7005 12915 1 10.00 2026-07-28 14:14:33 นาวิน Anawin Rodroka 30888 2026-07-28 14:14:33 2026-07-28 14:14:44
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7004
7004 12913 1 10.00 2026-07-28 14:14:29 นาวิน Anawin Rodroka 30887 2026-07-28 14:14:29 2026-07-28 14:14:43
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7003
7003 12890 1 3.00 2026-07-28 13:40:50 Laddawan Anawin Rodroka 30882 2026-07-28 13:40:50 2026-07-28 13:41:49
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 6985
6985 12885 1 30.00 2026-07-28 09:59:53 ภานุวัฒน์ ภูสมที Anawin Rodroka 30870 2026-07-28 09:59:53 2026-07-28 10:51:22
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 6986
6986 12884 1 37.00 2026-07-28 10:00:01 ภานุวัฒน์ ภูสมที Anawin Rodroka 30869 2026-07-28 10:00:01 2026-07-28 10:51:19
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 6987
6987 12883 1 37.00 2026-07-28 10:00:21 ภานุวัฒน์ ภูสมที Anawin Rodroka 30868 2026-07-28 10:00:21 2026-07-28 10:51:17
Edit Edit Copy Copy Delete Delete
DELETE FROM foreman_material_received WHERE `foreman_material_received`.`id` = 7060
7060 12882 1 130.00 2026-07-31 16:39:56 Yannaioo Anawin Rodroka 31107 2026-07-31 16:39:56 2026-08-01 16:16:06
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