ILyaCyclone icon

Untitled

ILyaCyclone | PRO | 03/20/19 08:04:46 PM UTC | 0 ⭐ | 674 👁️ | Never ⏰ | []
SQL |

450 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
SELECT t.id, t.name, t.votes 
FROM ( 
       SELECT r.id, r.name, COUNT(v.id_user) AS votes 
       FROM restaurants r, 
            user_votes v 
       WHERE v.id_restaurant = r.id 
         AND v.DATE = ?1 
       GROUP BY r.id, r.name 
     ) t 
WHERE t.votes = 
      (SELECT MAX(votes) 
       FROM (SELECT COUNT(v2.id_user) AS votes 
             FROM user_votes v2 
             WHERE v2.DATE = ?1 
             GROUP BY v2.id_restaurant))

Comments

  • icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
    
    

    

            
    •