SELECT i.*
FROM items i
JOIN categories c ON i.category_id = c.id
WHERE c.name = 'ACCESORIES';


id
sku
name
description
category_id
category
unit
is_active
created_at
updated_at
1
0111NETCUPS
NET CUPS
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
2
012MTLCNTUB
METTAL CONECTING TUBE
2
ACCESORIES
BTG
1
2026-04-21 23:57:03
2026-04-22 03:10:40
5
014VERHYTOW
VERTICAL HYDROPONIK TOWER SYSTEM
2
ACCESORIES
BTG
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1059
99ACCUNS70
ACCU NS 70
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1570
99NETRTU915NTF
NETRTU-915-8DO
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1707
99PSRCCV3BM
PRESSURE REDUCING CONTROL VALVE 3" BERMAD
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1708
99PSRCCV4BM
PRESSURE REDUCING CONTROL VALVE 4" BERMAD
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1774
99RS11063GM
REDUCING SOCKET 110-63MM GMS
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1775
99RS11090GM
REDUCING SOCKET 110-90MM GMS
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1776
99RS160110G
REDUCING SOCKET 160-110MM GMS
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1790
99RS6350FTF
REDUCING SOCKET 63-50 MM GMS
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1793
99RS9075GMS
REDUCING SOCKET 90-75 MM GMS
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1794
99RT11090FT
REDUCING TEE 110 X 90MM FTF
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1795
99RT1611FTF
Reducing Tee 160-110 mm FTF
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40
1844
99SKITNV210
SEALS KIT FOR NAVC 10/16 2"
2
ACCESORIES
PCS
1
2026-04-21 23:57:03
2026-04-22 03:10:40