Göta Kanal

Über die folgenden Quicklinks springen Sie direkt zu den passenden Angeboten!

SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1027 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC
• Göta-Kanal - Der Klassiker
SELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1033 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1431 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1036 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1037 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1038 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1040 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASCSELECT *, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=1) AS COUNTARTICLE, (SELECT COUNT(ID) FROM gla_index WHERE PARENT=GI.ID AND ARTICLE=0) AS COUNTCAT FROM gla_index AS GI WHERE PARENT=1028 AND RELEASED=2 AND (EXPIRYDATE>='2023-04-01' OR EXPIRYDATE='0000-00-00' OR EXPIRYDATE IS NULL) ORDER BY ARTICLE, ORDERS ASC