Template:Char

From Edge of Darkness Wiki

Revision as of 15:47, 23 January 2017 (view source) West (Talk | contribs) ← Older edit		Revision as of 15:49, 23 January 2017 (view source) West (Talk | contribs) Newer edit →
Line 12:		Line 12:
	{{{threadid|}}}joindate=COALESCE(u1.joindate, created, u2.joindate),		{{{threadid|}}}joindate=COALESCE(u1.joindate, created, u2.joindate),
-	{{{threadid|}}}statusvenue=(COALESCE(NULLIF(uf1.field165,''), NULLIF(uf2.field165,''), 0)),	+	{{{threadid|}}}statusvenue=COALESCE(uf1.field165, uf2.field165),
-	{{{threadid|}}}statusorganization=(COALESCE(NULLIF(uf1.field166,''), NULLIF(uf2.field166,''), 0)),	+
-	{{{threadid|}}}statusfamily=(COALESCE(NULLIF(uf1.field167,''), NULLIF(uf2.field167,''), 0)),	+	{{{threadid|}}}statusvenue=COALESCE(uf1.field166, uf2.field166),
		+
		+	{{{threadid|}}}statusvenue=COALESCE(uf1.field167, uf2.field167),
	{{{threadid|}}}lastpostid=COALESCE(u1.lastpostid, u2.lastpostid),		{{{threadid|}}}lastpostid=COALESCE(u1.lastpostid, u2.lastpostid),

---

Revision as of 15:49, 23 January 2017