Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: assets »Table: inventory_breakage
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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (514 total, Query took 0.0043 seconds.) [id: 1... - 25...]
SELECT * FROM `inventory_breakage` ORDER BY `id` ASC 
Full texts id Ascending Descending 1item_namecategorypurposepurchased_frompurchase_linktotal_purchasedunit_price_aedprice_aedbefore_openingquantity_restauranttotal_breakagebalance_after_breakagestorage_place_restaurantbreakage_remarksquantity_dubaistorage_place_dubaiquantity_warehousestorage_place_warehousebranchimage_linkinvoice_linkpost_date
1 MCI Traffic Safety Post Miscellaneous/Other Assets Used for traffic management, safety, and guiding p... LOCAL FROM CDA NA 4 46.00 76.00 0 4 0 4 0 NULL 0 0 0 0 Islamabad 1_MCI Traffic Safety Post_2025-02-20_10-58-43.jpg 1_MCI Traffic Safety Post_invoice_2025-02-20_10-58... 2024-12-24 00:00:00
2 Outdoor Blind Screen Civil Work Used for outdoor shade, privacy, or weather protec... LOCAL NA 2 0.00 0.00 2 0 0 2 0 NULL 0 0 0 0 Islamabad 2_Outdoor Blind Screen_2025-02-20_10-58-43.jpg 2_Outdoor Blind Screen_invoice_2025-02-20_10-58-43... 2024-12-24 00:00:00
3 Vertical Garden Panel Decorative Items The vertical garden panel is used to enhance aesth... LOCAL NA 1 0.00 0.00 1 0 0 1 Courtyard No remarks 0 NA 0 NA Islamabad 3_Vertical Garden Panel_2025-02-20_10-58-43.jpg 3_Vertical Garden Panel_invoice_2025-02-20_10-58-4... 2024-12-24 00:00:00
4 Snake Plant Pots Decorative Items Indoor or outdoor decoration, air purification, an... LOCAL NA 5 0.00 0.00 5 0 0 5 Courtyard No remarks 0 NA 0 NA Islamabad 4_Snake Plant Pots_2025-02-20_10-58-43.jpg 4_Snake Plant Pots_invoice_2025-02-20_10-58-43.jpg 2024-12-24 00:00:00
5 Noir Plant Pots Decorative Items Enhance outdoor or indoor spaces with greenery, pr... LOCAL NA 32 0.00 0.00 32 0 0 32 Courtyard No remarks 0 NA 0 NA Islamabad 5_Noir Plant Pots_2025-02-20_10-58-43.jpg 5_Noir Plant Pots_invoice_2025-02-20_10-58-43.jpg 2024-12-24 00:00:00
6 Bistro Noir Signboard Decorative Items Brand representation and aesthetic enhancement for... LOCAL NA 1 0.00 0.00 1 0 0 1 Courtyard No remarks 0 NA 0 NA Islamabad 6_Bistro Noir Signboard_2025-02-20_10-58-43.jpg 6_Bistro Noir Signboard_invoice_2025-02-20_10-58-4... 2024-12-24 00:00:00
7 Grey Clay Plant Pot Decorative Items Ideal for enhancing the aesthetic appeal of indoor... LOCAL NA 7 0.00 0.00 7 0 0 7 Courtyard No remarks 0 NA 0 NA Islamabad 7_Grey Clay Plant Pot_2025-02-20_10-58-43.jpg 7_Grey Clay Plant Pot_invoice_2025-02-20_10-58-43.... 2024-12-24 00:00:00
8 Asparagus Fern Plant Decorative Items Enhances indoor or outdoor spaces with lush green... LOCAL NA 3 0.00 0.00 3 0 0 3 Courtyard No remarks 0 NA 0 NA Islamabad 8_Asparagus Fern Plant_2025-02-20_10-58-43.jpg 8_Asparagus Fern Plant_invoice_2025-02-20_10-58-43... 2024-12-24 00:00:00
9 Wooden Candle Lantern Small Decorative Items Used for creating a warm and inviting ambiance, su... LOCAL NA 4 0.00 0.00 4 0 0 4 Courtyard, Indore No remarks 0 NA 0 NA Islamabad 9_ Wooden Candle Lantern Small_2025-02-20_10-58-43... 9_ Wooden Candle Lantern Small_invoice_2025-02-20_... 2024-12-24 00:00:00
10 Wooden Candle Lantern X-Small Decorative Items Used for creating a warm and inviting ambiance, s... LOCAL NA 3 0.00 0.00 3 0 0 3 Courtyard, Indore No remarks 0 NA 0 NA Islamabad 10_Wooden Candle Lantern X-Small_2025-02-20_10-58-... 10_Wooden Candle Lantern X-Small_invoice_2025-02-2... 2024-12-24 00:00:00
11 Wooden Candle Lantern Large Decorative Items Used for creating a warm and inviting ambiance, s... LOCAL NA 2 0.00 0.00 2 0 0 2 Courtyard No remarks 0 NA 0 NA Islamabad 11_Wooden Candle Lantern Large_2025-02-20_10-58-43... 11_Wooden Candle Lantern Large_invoice_2025-02-20_... 2024-12-24 00:00:00
12 Wooden Candle Lantern X- Large Decorative Items Used for creating a warm and inviting ambiance, su... LOCAL NA 1 0.00 0.00 1 0 0 1 Courtyard No remarks 0 NA 0 NA Islamabad 12_Wooden Candle Lantern X- Large_2025-02-20_10-58... 12_Wooden Candle Lantern X- Large_invoice_2025-02-... 2024-12-24 00:00:00
13 Rechargeable Cells Crockery & Cutlery Rechargeable cells used in the candles of lanterns UAE NA 13 60.00 76.00 0 13 0 13 FOH No remarks 0 NA 4 Basement, Middle Wardrobe Drawer Islamabad 13_Rechargeable Cells_2025-02-20_10-58-43.jpeg 13_Rechargeable Cells_invoice_2025-02-20_10-58-43.... 2024-12-24 00:00:00
14 Image Crockery & Cutlery Pottery Barn Soup Bowl, could have been used In Ho... UAE https://www.potterybarn.com/products/mendocino-bow... 16 126.00 76.00 0 16 0 16 0 No remarks 0 0 16 Basement, 1st rack when you enter Islamabad 14_Image_2025-02-20_10-58-43.jpeg 14_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
15 Gracie China Gold Porcelain Teapot Crockery & Cutlery Tea Pot, Used for serving Tea but not being used a... UAE 0 4 0.00 0.00 0 0 0 0 0 No remarks 0 0 4 Basement, 1st rack when you enter Islamabad 15_Gracie China Gold Porcelain Teapot_2025-02-20_1... 15_Gracie China Gold Porcelain Teapot_invoice_2025... 2024-12-24 00:00:00
16 Image Crockery & Cutlery Wren matte blue Dinner Plate UAE https://www.crateandbarrel.me/en-ae/my-account/ord... 40 10.00 76.00 0 40 0 40 0 No remarks 0 0 1 Basement Second Rack Islamabad 16_Image_2025-02-20_10-58-43.jpeg 16_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
17 Image Crockery & Cutlery Afternoon Tea Stand West Elm 0 29 160.00 0.00 0 0 0 0 10 No remarks 0 0 4 Basement, 1st rack when you enter Islamabad 17_Image_2025-02-20_10-58-43.jpeg 17_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
18 Image Crockery & Cutlery Moroccan Tea Set, Coasters and Glasses UAE 0 2 75.00 76.00 0 2 0 2 0 No remarks 0 0 2 Basement, 1st rack when you enter Islamabad 18_Image_2025-02-20_10-58-43.jpeg 18_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
19 Image Crockery & Cutlery 3 Tier Stand Amazon 0 4 123.00 76.00 0 0 0 0 0 No remarks 0 0 4 Basement, 1st rack when you enter Islamabad 19_Image_2025-02-20_10-58-43.jpeg 19_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
20 Image Crockery & Cutlery 2 Tier Stand Amazon 0 1 131.00 76.00 1 0 0 1 0 No remarks 0 0 1 Basement, 1st rack when you enter Islamabad 20_Image_2025-02-20_10-58-43.jpeg 20_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
21 Image Crockery & Cutlery Welcome Drink Cooler Local Purchase Pakistan 0 1 0.00 0.00 0 1 0 1 NA No remarks 0 0 1 Basement, 1st rack when you enter Islamabad 21_Image_2025-02-20_10-58-43.jpeg 21_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
22 Image Crockery & Cutlery 2 Tier Stands Homecenter 0 3 40.00 76.00 3 0 0 3 0 No remarks 0 0 3 Basement, 1st rack when you enter Islamabad 22_Image_2025-02-20_10-58-43.jpeg 22_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
23 Image Crockery & Cutlery Old Tiramisu Plate Easy Life Design www.easylifedesign.it 18 11.00 76.00 18 0 0 18 0 No remarks 0 0 18 Basement Islamabad 23_Image_2025-02-20_10-58-43.jpeg 23_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
24 Image Crockery & Cutlery Garlic knots Ramekin Crate and barrel https://www.crateandbarrel.me/en-ae/my-account/ord... 16 56.00 76.00 16 0 0 16 0 No remarks 0 0 16 Basement Islamabad 24_Image_2025-02-20_10-58-43.jpeg 24_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00
25 Image Crockery & Cutlery 0 Homecenter Homecenter.com 6 8.00 76.00 0 0 0 0 0 No remarks 0 0 6 Basement Islamabad 25_Image_2025-02-20_10-58-43.jpeg 25_Image_invoice_2025-02-20_10-58-43.jpeg 2024-12-24 00:00:00