sortable

94 rows where text = "$blah"

descending

Link	pk1	pk2	content	sortable	sortable_with_nulls	sortable_with_nulls_2	text
d,w	d	w	d-w	75	0.26455462565889964		$blah
d,x	d	x	d-x	-71	0.5445623787105787		$blah
d,y	d	y	d-y	52	0.7489577220696233	0.4391534486737374	$blah
d,z	d	z	d-z	-31		0.8894228892924536	$blah
e,a	e	a	e-a	54	0.0913268866309852		$blah
e,f	e	f	e-f	68		0.18758254139452712	$blah
e,g	e	g	e-g	94		0.43811609507237825	$blah
e,h	e	h	e-h	-69			$blah
e,i	e	i	e-i	-77			$blah
e,j	e	j	e-j	83	0.291861560261786		$blah
e,k	e	k	e-k	41	0.19061037094792832		$blah
e,l	e	l	e-l	97	0.41494242355134514	0.00256525935857721	$blah
e,m	e	m	e-m	50		0.44654739304319446	$blah
e,r	e	r	e-r	20	0.2650227795434089	0.692704598586882	$blah
e,u	e	u	e-u	13		0.04599096867721275	$blah
e,y	e	y	e-y	-82	0.3455656244430817	0.962029072823442	$blah
e,z	e	z	e-z	16	0.8453039251425987	0.8533354586601858	$blah
f,d	f	d	f-d	60		0.4408231901628116	$blah
f,e	f	e	f-e	87	0.13141180642048544		$blah
f,f	f	f	f-f	35		0.2569700845632623	$blah
f,g	f	g	f-g	91	0.8703969593250397		$blah
f,h	f	h	f-h	42		0.2644585783524238	$blah
f,i	f	i	f-i	49	0.3810254992724753		$blah
f,m	f	m	f-m	6	0.8336930832963215		$blah
f,n	f	n	f-n	-45	0.44338308606070165	0.6856802654812854	$blah
f,t	f	t	f-t	-56	0.26536750832497336	0.5260855265978671	$blah
f,u	f	u	f-u	99	0.36203897381751204		$blah
f,v	f	v	f-v	17	0.6433406842054887		$blah
f,w	f	w	f-w	82			$blah
f,x	f	x	f-x	59	0.6330767243010155	0.3809043988185208	$blah
g,c	g	c	g-c	50	0.5616833815697281	0.35359807963376766	$blah
g,f	g	f	g-f	9	0.9745466021257082		$blah
g,j	g	j	g-j	-87		0.27210284354621894	$blah
g,n	g	n	g-n	27	0.7470141234297678	0.23011071607665967	$blah
g,o	g	o	g-o	-82	0.3970711742472973	0.0187415365856457	$blah
g,q	g	q	g-q	58	0.4600969018938087		$blah
g,u	g	u	g-u	-55	0.9512921405795819	0.7544458252469858	$blah
h,a	h	a	h-a	-90	0.24774372359828423	0.5240685531701745	$blah
h,b	h	b	h-b	-28	0.7744647885737355	0.7892269315636647	$blah
h,d	h	d	h-d	-15	0.08150198744788395	0.6560547180360552	$blah
h,f	h	f	h-f	71	0.9471086244193812	0.09345296506602174	$blah
h,j	h	j	h-j	84	0.41085861149653347	0.969588603408625	$blah
h,l	h	l	h-l	-6	0.6783068250650924	0.4616799784409892	$blah
h,m	h	m	h-m	-59		0.8730019200593472	$blah
h,n	h	n	h-n	41	0.7114009771190007		$blah
h,o	h	o	h-o	15	0.9053062089782412	0.09171356965909339	$blah
h,s	h	s	h-s	-80		0.7272347853249318	$blah

Advanced export

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

CREATE TABLE sortable (
  pk1 varchar(30),
  pk2 varchar(30),
  content text,
  sortable integer,
  sortable_with_nulls real,
  sortable_with_nulls_2 real,
  text text,
  PRIMARY KEY (pk1, pk2)
);