|
Could be anything that's on your mind this was our discussion in our office the other day that I added my thoughts on ...
Most Under Rated Guitar Player Rory Gallagher
Most Over Rated Guitar Player Eric Clapton
IMO, Clapton's god like status is silly....
Started by Guido on
, 15 posts
by 7 people.
Answer Snippets (Read the full thread at deadhookforums):
Terrapin is WAAAAY overrated....
Forgive me...
|
|
There is a query I've just made
SELECT * FROM users INNER JOIN ratings ON ratings.rateable=users.id ORDER BY SUM(ratings.rating)/COUNT(ratings.rating)
But, it doesn't work, I just get one person in result, although there are 3 people in ratings table!...
Started by Anton on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Are you storing the users.id field value in the rateable column in your ratings table?
This is just a hunch, but....
It's hard to tell because I can't see all of your stuff....but my guess is in the ' ON ratings.rateable=users.id ' part of your SQL .
|
|
So I just built a star-rating system and and trying to come up with an algorithm to list the "Top Rated" items. For simplicity, here are the columns:
item_name average_rating (a decimal from 1 to 5) num_votes
I'm trying to determine the "sweet spot" between...
Started by Matt on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
An idea not to take.
The question is, how much higher the 4.6/20 shall be rated than the 5.0/2...
|
Ask your Facebook Friends
|
The actual question is a little more complex than that, so here goes.
I have a website which reviews games. Ratings/reviews are posted for each game, and so I have a MySQL database to handle it all.
Thing is, I'd really like a page that showed what score...
Started by different on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SELECT DISTINCT game.gameName, game.gameImage, review.ourScore FROM game LEFT JOIN review ON game.ID = review.gameID ORDER BY review.postedOn LIMIT 10
Or something like that, check out how to use the Distinct first, I'm not sure on the syntax, and you... .
|
|
I have 2 columns, one called rating_average and one called rating_count.
I need to select the 3 rows with the highest rating with the rating count factored into the equation as well.
Started by Webnet on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
How do you want to factor in the rating count exactly? If you wanted to limit it to say items with....
SELECT * FROM table ORDER BY rating_average DESC LIMIT 3
That may work, but you should post the schema so we can see exactly what you want.
|
|
On the side of jeeps there is the round sticker that says "trail rated".If I am not mistaken,I have seen them as "Mail Rated".Am I correct? Where would one find them?
Started by Will on
, 13 posts
by 6 people.
Answer Snippets (Read the full thread at jeepz):
Someone probably does make them I've seen "Mall Rated" badges but not "Mail Rated" dang they want 29$ just for the trail rated....
Jeep only has the trail rated badge pooh! it should be easy to get one on ebay.
Some one custom made it.
|
|
I am currently trying to find some blogs that talk (almost solely) on the JavaScript Language , and this is due to the fact that most of the time, bloggers with real life experience at work or at home development can explain more clearly and concisely...
Started by Andreas Grech on
, 12 posts
by 12 people.
Answer Snippets (Read the full thread at stackoverflow):
For example most....
It isn't entirely a JavaScript blog but Web Bug Track has a lot of useful info about how and where browsers fall down with JavaScript .
I find that http://ajaxian.com/ has a lot of useful information about javascript, ajax, and so on .
|
|
I'm doing research into a web API for my company, and it's starting to look like we might implement a RESTful one. I've read a couple of books about this now (O'Reilly's "RESTful web services" seeming the most useful) and have come up with the following...
Started by Greg Beech on
, 8 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Although I don't get why using the different HTTP methods is better then just using just the normal GET/POST and using a URL structure like:
movies/10/edit movies/10/ratings/add movies/10/ratings/10/reply movies/10/ratings/10/edit movies... .
Makes sense to me.
|
|
Hello dudes and dudettes, i don't know if there is allready a thread like this but let the...
gonk scream EVO-RATING scream gonk
Starts!!! stressed
Well, this is simple, you can post your avatar to be rated or you can rate avatars, but the difference ...
Started by 7VM on
, 13 posts
by 4 people.
Answer Snippets (Read the full thread at gaiaonline):
Epic bump a tragic love epic bump THANKYOU VERY MUCHO!!! heart 7VM a tragic love epic bump THANKYOU VERY MUCHO!!! heart
ur welcome im here to hang out x3 a tragic love 7VM a tragic love epic bump THANKYOU VERY MUCHO!!! heart
ur welcome im here to hang... .
|
|
Is Ishant Sharma over rated? bowling at 140 doesnt mean that you are good enough at top level.
Started by nomi 3-0 on
, 13 posts
by 13 people.
Answer Snippets (Read the full thread at yahoo):
Look at the bug above
"Over here he is over rated , that....
Big mouth backs down like a little girl, when the batsman ?
Anybody who is bought by SRK turns out to be the most over-rated player.
To tell you the truth, I never rated him.
|
