Hi
I send you the 4 tables involved in the rankings lists i want do
i want to make an albums kanking and a songs kanking.
thank you so much for your patience.

if it's possible i want to make an exclusive kanking for a specific artist

Could you provide a sample output how table should look (for example for 2-3 artists, songs)?

Regards,
ARI Soft

top 10 kraftwerk albums
Artist->record->average
Kraftwerk -> Computer world -> 5.8
Kraftwerk -> Autobhan -> 4.6

Top 10 kraftwerk songs
Album -> song -> average
Computer world -> homecomputer -> 5
Autobhan -> atoban -> 3.5

Top 10 non kraftwerk songs

Is that what you mean, ihope so
thanks

Use the following query to show top 10 albums of 'Kraftwerk' artist:

SELECT
A.artist_name AS Artist,
AL.name AS Album,
AVG(R.points) AS Average
FROM
jos_muscol_artists A INNER JOIN jos_muscol_albums AL
ON AL.artist_id = A.id
INNER JOIN jos_muscol_ratings R
ON R.album_id = AL.id
WHERE
A.artist_name = 'Kraftwerk'
AND
R.type = 'album'
GROUP BY
AL.id
ORDER BY
AVG(R.points) DESC
LIMIT 0,10


The following query to show top 10 songs of 'Kraftwerk' group:

SELECT
A.artist_name AS Artist,
AL.name AS Album,
S.name AS Song,
AVG(R.points) AS Average
FROM
jos_muscol_artists A INNER JOIN jos_muscol_albums AL
ON AL.artist_id = A.id
INNER JOIN jos_muscol_songs S
ON S.album_id = AL.id
INNER JOIN jos_muscol_ratings R
ON R.album_id = S.id
WHERE
A.artist_name = 'Kraftwerk'
AND
R.type = 'song'
GROUP BY
S.id
ORDER BY
AVG(R.points) DESC
LIMIT 0,10

Regards,
ARI Soft

Hi
i'm very ashamed, but when i write the code in the sql query and press the save button it disappears.
I've tried several times. Why does it happens.

Check that you use the latest version of the extension (1.15.6) and "System - ARI Extensions" plugin is enabled.

Regards,
ARI Soft