VbzCart/docs/queries/qryTitleTopic Titles

About

• Returns: titles x topics with complete Title data
• Used by: Topic pages
• Requires: Template:Vbzcart, Template:Vbzcart
• History:
  • 2011-01-24 created for Title listing on Topic pages
  • 2011-09-28 source table renamed (brs_titles_x_topics -> cat_title_x_topic)

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitleTopic_Titles AS

 SELECT tt.ID_Topic, t.*
 FROM cat_title_x_topic AS tt
 LEFT JOIN cat_titles AS t
 ON tt.ID_Title=t.ID;</mysql>

<section end=sql />