Combining queries or correct my attempt to combine them
===

I would like to add the second query to the first using a LEFT JOIN ON drops.type = mobs.drop_list this is for a gaming application I use the data in drops to decide what items the monster I'm spawning has on his inventory.

    sql="SELECT
       spawns.*, 
       (quantity - COUNT(game_moblist.spawn_id)) AS quantity_to_spawn,
       mobs.* 
    FROM 
      spawns 
      LEFT JOIN mobs USING (mob_id) 
      LEFT JOIN game_moblist USING (spawn_id) 
    GROUP BY
      spawn_id
    HAVING
       quantity_to_spawn > 0
       AND next_spawn<=0"
    
    
    sql= "
    SELECT
      common, 
      uncommon,
      rare,
      legendary
    FROM
      drops
    WHERE
      type='"+rows[r].drop_list+"' 
      AND level <="+rows[r].level+" 
    ORDER BY level DESC 
    LIMIT 1";


So far this is close but I need it to only join the row from drops table where drops.level is the highest.  When I did Max(drops.level) it added that field maxed only.
    
        SELECT drops.common, drops.uncommon, drops.rare, drops.legendary, spawns . * , (
        quantity -0
        ) AS quantity_to_spawn, mobs . * 
        FROM spawns
        LEFT JOIN mobs
        USING ( mob_id ) 
        LEFT JOIN game_moblist
        USING ( spawn_id ) 
        LEFT JOIN drops ON ( drops.type = mobs.drop_list
        AND drops.level <= spawns.level ) 
        GROUP BY spawn_id
        HAVING quantity_to_spawn >0
        AND next_spawn <=0