dcop amarok collection query "SELECT ALL t.title, t.artist FROM tags t WHERE t.title like '%$search%' ORDER BY t.title"

Otsingutulemusele vastav lugu nr 1
101
Lugu nr 2
874
Lugu 3
278
...
Lugu n
1667

dcop amarok collection query "SELECT DISTINCT t.name FROM artist t WHERE t.id like '<ID>'"

Otsingutulemusele vastav lugu nr 1 (Esitaja 1)
Lugu nr 2 (Esitaja 2)
Lugu 3 (Esitaja 3)
...
Lugu n (Esitaja n)

SELECT tags.title, artist.name FROM tags INNER JOIN artist ON tags.artist = artist.id WHERE tags.title LIKE '%$search%' ORDER BY tags.title;

#!/bin/bash
IFS='
'
array=(`dcop amarok collection query "select tags.title, artist.name from tags inner join artist on tags.artist = artist.id where tags.title like '%$1%' order by tags.title;"`)
len=${#array[*]}
i=0
while [ $i -lt $len ]; do
    echo -n ${array[$i]}
    echo -n " ("
    echo -n ${array[$i+1]}
    echo ")"
    let i=i+2
done

sh test.sh Walk

Walking Spanish (Tom Waits)
You'll Never Walk Alone (Johnny Cash)