|
|||||||||||||||
Modell / Bezeichnung |
Details |
||||||||||||||
|
Error encountered: (MySQL) error 1064 : 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 'THEN 0 ELSE 1 END AS inherited,
CONCAT(created.firstname,' ',created.las' at line 3 SELECT t_properties.id, t_properties_lang.name, t_properties_lang.description, t_properties_lang.id langid, fk_folderid folderid,t_properties_lang.language lang, typeid, t_properties_lang.isactive, t_properties.orderid, groups.id groupid, t_properties_values_lang.name valuename, t_properties_values.id valueid, t_properties_values_lang.language valuelang, t_properties_values_lang.id valuelangid, CASE WHEN t_properties.fk_folderid = THEN 0 ELSE 1 END AS inherited, CONCAT(created.firstname,' ',created.lastname) createdby, UNIX_TIMESTAMP(t_properties.createdon) createdon, CONCAT(modified.firstname,' ',modified.lastname) modifiedby, UNIX_TIMESTAMP(t_properties.modifiedon) modifiedon, CONCAT(langcreated.firstname,' ',langcreated.lastname) langcreatedby, UNIX_TIMESTAMP(t_properties_lang.createdon) langcreatedon, CONCAT(langmodified.firstname,' ',langmodified.lastname) langmodifiedby, UNIX_TIMESTAMP(t_properties_lang.modifiedon) langmodifiedon FROM t_properties INNER JOIN t_properties_lang ON t_properties.id = t_properties_lang.fk_propertiesid LEFT JOIN t_properties_groups groups ON groups.id = t_properties.fk_properties_groupid LEFT JOIN t_properties_values ON t_properties.id = t_properties_values.fk_propertiesid AND t_properties_values.isdeleted = 0 LEFT JOIN t_properties_values_lang ON t_properties_values.id = t_properties_values_lang.fk_properties_valuesid AND t_properties_lang.language = t_properties_values_lang.language AND t_properties_values_lang.isdeleted = 0 LEFT JOIN t_users created ON created.id = t_properties.createdby LEFT JOIN t_users modified ON modified.id = t_properties.modifiedby LEFT JOIN t_users langcreated ON langcreated.id = t_properties_lang.createdby LEFT JOIN t_users langmodified ON langmodified.id = t_properties_lang.modifiedby WHERE t_properties.isdeleted = 0 AND t_properties_lang.isdeleted = 0 AND t_properties_lang.isactive = 1 AND t_properties.isdeleted = 0 AND t_properties.isactive = 1 AND ( t_properties.fk_folderid = ) ORDER BY CASE WHEN groups.orderid IS NULL THEN 9999 ELSE groups.orderid END, inherited DESC, t_properties.orderid, t_properties_values.orderid ASC |
||||||||||||||
Sprache
Download Flash!
