stupid-stackoverflow-formatting

    SELECT start.entity
    FROM entity
      JOIN field_values AS start
        ON entity.id = start.entity AND start.field = 'start_date' AND STR_TO_DATE(start.value, '%M %d, %Y') < NOW()
      INNER JOIN field_values AS end
        ON entity.id = end.entity AND end.field = 'end_date' AND STR_TO_DATE(end.value, '%M %d, %Y') > NOW()
      INNER JOIN field_values AS artist
        ON entity.id = artist.entity AND artist.field = 'artist' AND artist.value="some artist"
    ;