xmpp: implementations: 22 rows where software

xep_id: XEP
xep_version: XEP version
software_id: Software

22 rows where software_id = 42

descending

Link	xep_version	status	software_id	xep_id
3,42	2.13.0	partial	Halcyon 42	Data Forms 3
29,42	2.5rc3	complete	Halcyon 42	Service Discovery 29
44,42	1.34.3	complete	Halcyon 42	Multi-User Chat 44
58,42	1.0	complete	Halcyon 42	Result Set Management 58
59,42	1.24.1	partial	Halcyon 42	Publish-Subscribe 59
76,42	2.4	complete	Halcyon 42	In-Band Registration 76
81,42	1.1.1	complete	Halcyon 42	XMPP Date and Time Profiles 81
84,42	2.1	complete	Halcyon 42	Chat State Notifications 84
114,42	1.6.0	complete	Halcyon 42	Entity Capabilities 114
242,42	1.4.0	complete	Halcyon 42	Message Delivery Receipts 242
256,42	1.6	complete	Halcyon 42	Stream Management 256
257,42	2.0.1	complete	Halcyon 42	XMPP Ping 257
261,42	2.0	complete	Halcyon 42	Delayed Delivery 261
295,42	1.3	partial	Halcyon 42	Roster Versioning 295
312,42	1.2	complete	Halcyon 42	Direct MUC Invitations 312
347,42	1.0.1	partial	Halcyon 42	Message Carbons 347
380,42	1.0.1	complete	Halcyon 42	Message Archive Management 380
400,42	0.4	complete	Halcyon 42	Chat Markers 400
401,42	0.3.0	partial	Halcyon 42	Message Processing Hints 401
424,42		planned	Halcyon 42	Push Notifications 424
426,42	0.6.1	complete	Halcyon 42	Unique and Stable Stanza IDs 426
436,42	0.14.6	partial	Halcyon 42	Mediated Information eXchange (MIX) 436

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [implementations] (
   [xep_version] TEXT,
   [status] TEXT,
   [software_id] INTEGER,
   [xep_id] INTEGER,
   PRIMARY KEY ([xep_id], [software_id]),
   FOREIGN KEY([xep_id]) REFERENCES [xeps]([id]),
   FOREIGN KEY([software_id]) REFERENCES [software]([id])
);