SQL Queries

1. SQL Queries

   #1

   To get hits for a given year:
   
   
   SELECT * FROM `lockmor_content` where date_submitted between 1420070400 and 1451606400 and hits > 1000 order by hits desc

2. Re: SQL Queries

   #2

   Already added that to the Muro Awards script. I just grab the top 10 though.

Administrators · All categories · Guildhall