xmpp: implementations: 17 rows where xep

xep_id: XEP
xep_version: XEP version
software_id: Software

17 rows where xep_id = 562

descending

Link	xep_id	software_id	xep_version	status
562,1	User Avatar to vCard-Based Avatars Conversion 562	AstraChat XMPP Server 1
562,5	User Avatar to vCard-Based Avatars Conversion 562	Beagle IM 5	0.2.1	complete
562,20	User Avatar to vCard-Based Avatars Conversion 562	Prosody IM 20	1.0.0	complete
562,25	User Avatar to vCard-Based Avatars Conversion 562	Dino 25		complete
562,29	User Avatar to vCard-Based Avatars Conversion 562	Gajim 29	0.2.1	complete
562,31	User Avatar to vCard-Based Avatars Conversion 562	Psi 31	1.0.0	complete
562,33	User Avatar to vCard-Based Avatars Conversion 562	AstraChat XMPP Client 33
562,34	User Avatar to vCard-Based Avatars Conversion 562	Metronome IM 34	0.2	complete
562,38	User Avatar to vCard-Based Avatars Conversion 562	ejabberd 38	0.2.0	complete
562,41	User Avatar to vCard-Based Avatars Conversion 562	Monal IM 41	1.0.0	complete
562,46	User Avatar to vCard-Based Avatars Conversion 562	Tigase XMPP Server 46
562,55	User Avatar to vCard-Based Avatars Conversion 562	Cheogram Android 55	0.2.1	complete
562,58	User Avatar to vCard-Based Avatars Conversion 562	Conversations 58	0.2.1	complete
562,62	User Avatar to vCard-Based Avatars Conversion 562	Siskin IM 62	0.2.1	complete
562,63	User Avatar to vCard-Based Avatars Conversion 562	monocles chat 63	0.2.1	complete
562,68	User Avatar to vCard-Based Avatars Conversion 562	Openfire 68	1.0.0	complete
562,72	User Avatar to vCard-Based Avatars Conversion 562	Martin 72	0.2.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])
);