Login or create new account.
To download materials or to upload your own, you must be logged.
Download materials from other users
Search our database of materials for Corona for Cinema 4D
Upload your own materials
You've done your own materials? Then they share with other users.
Login
Deutsch
English
Fehler beim Ausfuehren der SQL-Anfrage
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bewert' in 'order clause'
Anfrage: SELECT materialien.*, user.name AS user, SUM(bewertung) as summe, COUNT(bewertung) AS anzahl, (SELECT COUNT(*) FROM materialien_kommentare WHERE materialien_kommentare.matID = materialien.matID) AS kommentare, kategorien.name_en AS kateg FROM materialien JOIN user ON user.userID = materialien.userID JOIN kategorien ON kategorien.katID = materialien.katID LEFT JOIN materialien_bewertung ON materialien_bewertung.matID = materialien.matID WHERE kategorien.katID = :kateg GROUP BY materialien.matID ORDER BY bewert DESC
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bewert' in 'order clause'
Anfrage: SELECT materialien.*, user.name AS user, SUM(bewertung) as summe, COUNT(bewertung) AS anzahl, (SELECT COUNT(*) FROM materialien_kommentare WHERE materialien_kommentare.matID = materialien.matID) AS kommentare, kategorien.name_en AS kateg FROM materialien JOIN user ON user.userID = materialien.userID JOIN kategorien ON kategorien.katID = materialien.katID LEFT JOIN materialien_bewertung ON materialien_bewertung.matID = materialien.matID WHERE kategorien.katID = :kateg GROUP BY materialien.matID ORDER BY bewert DESC