xmpp: implementations: 27 rows where software

xep_id: XEP
xep_version: XEP version
software_id: Software

27 rows where software_id = 40

descending

Link	xep_id	software_id	xep_version	status
168,40	Data Forms 168	Renga 40	2.13.1	partial
194,40	Service Discovery 194	Renga 40	2.5.0	complete
209,40	Multi-User Chat 209	Renga 40		partial
212,40	Bookmarks 212	Renga 40	1.2	partial
218,40	vcard-temp 218	Renga 40	1.2	partial
224,40	Publish-Subscribe 224	Renga 40	1.26.0	complete
234,40	Verifying HTTP Requests via XMPP 234	Renga 40	1.0.1	partial
235,40	XHTML-IM 235	Renga 40	1.5.4	partial
241,40	In-Band Registration 241	Renga 40	2.4	partial
248,40	User Avatar 248	Renga 40	1.1.4	partial
256,40	Software Version 256	Renga 40	1.1	complete
279,40	Entity Capabilities 279	Renga 40	1.6.0	complete
322,40	CAPTCHA Forms 322	Renga 40	1.0.1	complete
327,40	Personal Eventing Protocol 327	Renga 40	1.2.2	complete
339,40	Best Practices for Use of SASL ANONYMOUS 339	Renga 40	1.2	complete
363,40	XMPP Ping 363	Renga 40	2.0.1	complete
385,40	Data Forms Media Element 385	Renga 40		partial
395,40	Bits of Binary 395	Renga 40	1.1	partial
409,40	The /me Command 409	Renga 40	1.0	complete
427,40	ECO-XMPP 427	Renga 40	1.0	partial
444,40	Message Carbons 444	Renga 40	1.0.1	complete
532,40	SRV records for XMPP over TLS 532	Renga 40	1.1.0	complete
536,40	References 536	Renga 40	0.5.0	partial
556,40	Consistent Color Generation 556	Renga 40	1.0.0	complete
566,40	PEP Native Bookmarks 566	Renga 40	1.1.4	complete
574,40	MUC Self-Ping (Schrödinger's Chat) 574	Renga 40	1.1.0	complete
617,40	DOAP usage in XMPP 617	Renga 40	0.1.2	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])
);