Let's try that again : expose the [number] column to the outer selection (**
are for emphasis**):
( select id_song, **number** from
(
select id_song, **number**
from PLAYLIST_SONG
where id_playlist=2
{and|or } number > 258
) as MYPLAYLISTSONGS
Regards
Tim Romano
On Tue, May 11, 2010 at
And you would put move your title-condition to the outer query:
.
.
.
) as SONGIDLIST
on SONG.id_song = SONGIDLIST.id_song
where
your title-condition and|or your title-number condition
Regards
Tim Romano
___
sqlite-users mailing list
sqlite-users@s
Arrrgh, Google Chrome ate the top half of my reply.
You must also expose the number column in the inner query against
PLAYLIST_SONG; include your number-condition there and also specify the
number column in the select-list:
( select id_song, number from
(
select id_song from PLAYLIST_SONG
w
You could remove the title condition from the inner SONGS select, limiting
your conditions to artist and genre; an index on column [artist] would make
this subquery run quickly:
(
select id_song from
SONG
where genre_id = 0 AND artist = 'Las ketchup'
// AND title >= 'Asereje(karaoke version)
Sorry but in your solution, how can I solve the condition
AND title >= 'Asereje(karaoke version)' AND (title > 'Asereje(karaoke
>> version)' OR number > 258)
?
title is on song and number is song_number on Playlist_Song AS PS.
Furthermore I also need title and number in place of your select * from
1. Try discrete single-column indexes rather than multi-column composite
indexes.
2. Try breaking the query down into subsets expressed as parenthetical
queries; you can treat these parenthetical queries as if they were tables by
assigning them an alias, and then you can join against the aliases.
On 11 May 2010 11:07, Andrea Galeazzi wrote:
> Hi guys,
> I'm in a bind for a huge time consuming query!
.
.
.
> The second case is about 35 times slower... so the scrolling is quite
> impossible (or useless)!
> SELECT song_number AS number,title FROM Song AS S, Playlist_Song AS PS
> WHERE S.id =
Hi guys,
I'm in a bind for a huge time consuming query!
I made the following database schema:
CREATE TABLE Song (
idINTEGER NOT NULL UNIQUE,
titleVARCHAR(40) NOT NULL DEFAULT '' COLLATE NOCASE,
artistVARCHAR(40) NOT NULL DEFAULT '' CO
8 matches
Mail list logo
