Lines Matching refs:title

29       title TEXT UNIQUE NOT NULL
51     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
60     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title, tn
69     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
78     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
88     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
94     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
104     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn
109     SELECT name FROM album JOIN track USING (aid) ORDER BY +title DESC, +tn
115     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn
121     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
126     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn DESC
132     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
139      ORDER BY title DESC, tn DESC
145      ORDER BY +title DESC, +tn DESC
152      ORDER BY title DESC, tn DESC
166       title TEXT NOT NULL
168     CREATE INDEX album_i1 ON album(title, aid);
188     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
197     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
203     SELECT name FROM album JOIN track USING (aid) ORDER BY title, aid, tn
209     SELECT name FROM album JOIN track USING (aid) ORDER BY title, aid, tn
218     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
227     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
237     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
243     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
253     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn
258     SELECT name FROM album JOIN track USING (aid) ORDER BY +title DESC, +tn
264     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn
271     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
276     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn DESC
282     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
288     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn DESC
293     SELECT name FROM album JOIN track USING (aid) ORDER BY +title DESC, +tn DESC
299     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn DESC
313       title TEXT UNIQUE NOT NULL
335     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title, tn DESC
344     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title, tn DESC
353     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn DESC
362     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn DESC
372     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
378     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn DESC
388     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
393     SELECT name FROM album JOIN track USING (aid) ORDER BY +title, +tn
399     SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn
405     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn DESC
410     SELECT name FROM album JOIN track USING (aid) ORDER BY +title DESC, +tn DESC
416     SELECT name FROM album JOIN track USING (aid) ORDER BY title DESC, tn DESC
423     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title DESC, tn
429      ORDER BY +title DESC, +tn
435     SELECT name FROM album CROSS JOIN track USING (aid) ORDER BY title DESC, tn