#metabrainz

/

      • rexwilliams1234[
        <rexwilliams1234[> "Thank you. Much appreciated..." <- Thanks for the query on genres. One thing I am curious about is entity_tag. I can’t find it as a table or view. Would it be some kind of legacy reference or some type of generalized tag placeholder meant to refer to different tag tables? I substituted artist_tag for entity_tag. and saw that the query worked. Appreciate any information on where entity_tag comes
      • from.
      • \- joined the channel
      • function1 has quit
      • function1 joined the channel
      • aerozol[m]
        Thanks bitmap, it’s all good, it’s usually just a few accounts/not thousands!
      • Otherwise I’ll let you or reo know
      • bitmap[m]
        <rexwilliams1234[> "Thanks for the query on genres...." <- the `FROM artist_tag entity_tag` part just creates a [table alias](https://www.postgresql.org/docs/16/sql-select.html#SQL-FROM), and yes, it was copied from the server code where it was primarily used to avoid having to interpolate the specific table name many times :) if you're only working with artists it serves no real purpose
      • Kladky has quit
      • Kladky_ joined the channel
      • Kladky_ is now known as Kladky
      • Kladky has quit
      • HSOWA joined the channel
      • LupinIII joined the channel
      • ApeKattQuest has quit
      • Zenigata has quit
      • salaxceitor[m] has quit
      • minimal has quit
      • pite has quit
      • Kladky joined the channel
      • Kladky has quit
      • Kladky joined the channel
      • Kladky has quit
      • Kladky joined the channel
      • Kladky has quit
      • Kladky joined the channel
      • Kladky has quit
      • Kladky joined the channel