Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

top ten songs
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: top ten songs
#56562
Re:top ten songs 1 Year, 12 Months ago Karma: 0
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
File Attachment:
File Name: jos_muscol_tables.zip
File Size: 37325
The administrator has disabled public write access.
 
#56567
Re:top ten songs 1 Year, 11 Months ago Karma: 670
Could you provide a sample output how table should look (for example for 2-3 artists, songs)?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#56568
Re:top ten songs 1 Year, 11 Months ago Karma: 0
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
The administrator has disabled public write access.
 
#56570
Re:top ten songs 1 Year, 11 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#56578
Re:top ten songs 1 Year, 11 Months ago Karma: 0
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.
The administrator has disabled public write access.
 
#56579
Re:top ten songs 1 Year, 11 Months ago Karma: 670
Check that you use the latest version of the extension (1.15.6) and "System - ARI Extensions" plugin is enabled.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 123