xmpp: implementations: 31 rows where software

xep_id: XEP
xep_version: XEP version
software_id: Software

31 rows where software_id = 42

descending

Link	xep_id	software_id	xep_version	status
194,42	Service Discovery 194	yaxim 42	2.5rc3	complete
209,42	Multi-User Chat 209	yaxim 42	1.32.0	complete
212,42	Bookmarks 212	yaxim 42	1.1	partial
213,42	Private XML Storage 213	yaxim 42	1.2	complete
230,42	Out of Band Data 230	yaxim 42	1.5	complete
241,42	In-Band Registration 241	yaxim 42	2.4	partial
255,42	Legacy Delayed Delivery 255	yaxim 42	1.4	complete
256,42	Software Version 256	yaxim 42	1.1	complete
279,42	Entity Capabilities 279	yaxim 42	1.5.1	complete
311,42	XMPP URI Scheme Query Components 311	yaxim 42	1.2	complete
336,42	User Nickname 336	yaxim 42	1.1	complete
348,42	Message Delivery Receipts 348	yaxim 42	1.4.0	complete
362,42	Stream Management 362	yaxim 42	1.6	complete
363,42	XMPP Ping 363	yaxim 42	2.0.1	complete
367,42	Delayed Delivery 367	yaxim 42	2.0	complete
409,42	The /me Command 409	yaxim 42	1.0	complete
413,42	Direct MUC Invitations 413	yaxim 42	1.2	partial
444,42	Message Carbons 444	yaxim 42	0.13.1	complete
450,42	Mobile Considerations on LTE Networks 450	yaxim 42	1.0.0	complete
461,42	Stanza Forwarding 461	yaxim 42	1.0	complete
472,42	Last Message Correction 472	yaxim 42	1.1.0	complete
477,42	Message Archive Management 477	yaxim 42	0.6.3	partial
516,42	Client State Indication 516	yaxim 42	0.3.0	complete
521,42	Push Notifications 521	yaxim 42	0.3	complete
523,42	Unique and Stable Stanza IDs 523	yaxim 42	0.6.0	partial
527,42	HTTP File Upload 527	yaxim 42	0.9.0	complete
543,42	Pre-Authenticated Roster Subscription 543	yaxim 42	0.3.1	complete
556,42	Consistent Color Generation 556	yaxim 42	0.6.0	complete
557,42	Message Styling 557	yaxim 42	0.1.4	complete
565,42	Ad-hoc Account Invitation Generation 565	yaxim 42	0.3.0	complete
574,42	MUC Self-Ping (Schrödinger's Chat) 574	yaxim 42	1.0.1	complete

Advanced export

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

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