xmpp: implementations: 19 rows where xep

xep_id: XEP
xep_version: XEP version
software_id: Software

19 rows where xep_id = 117

descending

Link	xep_id	xep_version	status	software_id
117,2	User Tune 117		complete	cr-xmpp 2
117,3	User Tune 117	1.3.0	complete	slixmpp 3
117,5	User Tune 117			Miranda NG 5
117,13	User Tune 117	1.3.0	complete	Prosody IM 13
117,24	User Tune 117			AstraChat XMPP Server 24
117,30	User Tune 117	1.2	complete	Metronome IM 30
117,37	User Tune 117		planned	Slidge 37
117,40	User Tune 117	1.2	complete	xmpp-parsers 40
117,43	User Tune 117	1.3.0		XMPP Interop Testing Framework 43
117,47	User Tune 117	1.3.0	complete	monocles chat 47
117,51	User Tune 117			Tigase XMPP Server 51
117,58	User Tune 117	1.2	partial	poezio 58
117,66	User Tune 117		complete	Smack 66
117,67	User Tune 117	1.3.0	partial	Artalk.Xmpp 67
117,72	User Tune 117	1.2	complete	Gajim 72
117,73	User Tune 117		complete	Psi 73
117,75	User Tune 117	1.3.0	complete	QXmpp 75
117,76	User Tune 117	1.2	complete	python-nbxmpp 76
117,85	User Tune 117	1.2	partial	Movim 85

Advanced export

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

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