Database Error
Message:MySQL Query fail: SELECT a.*, ai.Images, aif.Image, ac.Comments, at.Name as ArticleType, u.Username as Username FROM articles AS a LEFT OUTER JOIN (SELECT Article_ID, count(ID) AS Images FROM articleimages WHERE State=2 GROUP BY Article_ID) AS ai ON ai.Article_ID = a.ID LEFT OUTER JOIN(Select ai1.Article_ID, ai1.File as Image, ai2.Sorting FROM articleimages as ai1 INNER JOIN (SELECT Article_ID, min(Sorting) as Sorting FROM articleimages WHERE State=2 GROUP BY Article_ID) as ai2 WHERE ai1.Sorting = ai2.Sorting AND ai1.Article_ID = ai2.Article_ID AND ai1.State=2) as aif ON aif.Article_ID = a.ID LEFT OUTER JOIN(Select Article_ID, count(ID) AS Comments FROM comments WHERE State<>0 GROUP BY Article_ID) as ac ON ac.Article_ID = a.ID INNER JOIN articletypes AS at ON a.ArticleType_ID = at.ID INNER JOIN users AS u ON a.User_ID = u.ID WHERE a.ID= GROUP BY a.ID
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY a.ID' at line 11
Date:Sunday, February 18, 2018 at 11:43:20 AM
Script:/articledetail/?filter=11
Database Error
Message:MySQL Query fail: SELECT * FROM articleimages WHERE Article_ID= AND State=2 ORDER BY Sorting
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND State=2 ORDER BY Sorting' at line 2
Date:Sunday, February 18, 2018 at 11:43:20 AM
Script:/articledetail/?filter=11
Database Error
Message:MySQL Query fail: SELECT * FROM propertygroups WHERE ArticleType_ID= AND State=2 ORDER BY Sorting
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND State=2 ORDER BY Sorting' at line 2
Date:Sunday, February 18, 2018 at 11:43:20 AM
Script:/articledetail/?filter=11
Database Error
Message:MySQL Query fail: SELECT a.*, aif.Image, ac.Comments, at.Name as ArticleType FROM articles AS a LEFT OUTER JOIN (SELECT Article_ID, count(ID) AS Images FROM articleimages WHERE State=2 GROUP BY Article_ID) AS ai ON ai.Article_ID = a.ID LEFT OUTER JOIN(Select ai1.Article_ID, ai1.File as Image, ai2.Sorting FROM articleimages as ai1 INNER JOIN (SELECT Article_ID, min(Sorting) as Sorting FROM articleimages WHERE State=2 GROUP BY Article_ID) as ai2 WHERE ai1.Sorting = ai2.Sorting AND ai1.Article_ID = ai2.Article_ID) as aif ON aif.Article_ID = a.ID LEFT OUTER JOIN(Select Article_ID, count(ID) AS Comments FROM comments WHERE State = 2 GROUP BY Article_ID) as ac ON ac.Article_ID = a.ID INNER JOIN articletypes AS at ON a.ArticleType_ID = at.ID LEFT JOIN article2property as ap ON a.ID = ap.Article_ID WHERE( a.ArticleType_ID=) AND ap.Property_ID IN (11) AND a.State=2 GROUP BY a.ID ORDER BY a.Update_Timestamp DESC
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ap.Property_ID IN (11) AND a.State=2 GROUP BY a.I' at line 8
Date:Sunday, February 18, 2018 at 11:43:20 AM
Script:/articledetail/?filter=11
Database Error
Message:MySQL Query fail: SELECT * FROM articlelinks WHERE Article_ID= AND State=2 ORDER BY Sorting ASC
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND State=2 ORDER BY Sorting ASC' at line 2
Date:Sunday, February 18, 2018 at 11:43:20 AM
Script:/articledetail/?filter=11
Database Error
Message:MySQL Query fail: SELECT * FROM articlefiles WHERE Article_ID= AND State=2 AND Type=1 ORDER BY Sorting
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND State=2 AND Type=1 ORDER BY Sorting' at line 2
Date:Sunday, February 18, 2018 at 11:43:20 AM
Script:/articledetail/?filter=11
Database Error
Message:MySQL Query fail: SELECT * FROM articlefiles WHERE Article_ID= AND State=2 AND Type=2 ORDER BY Sorting
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND State=2 AND Type=2 ORDER BY Sorting' at line 2
Date:Sunday, February 18, 2018 at 11:43:20 AM
Script:/articledetail/?filter=11
JÜRG SPECOGNA AG
could not find template:templates\default.php