Fehler
  • Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM hde_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM hde_content AS a LEFT JOIN hde_categories AS c ON c.id = a.catid LEFT JOIN hde_users AS ua ON ua.id = a.created_by LEFT JOIN hde_users AS uam ON uam.id = a.modified_by LEFT JOIN hde_categories as parent ON parent.id = c.parent_id LEFT JOIN hde_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM hde_categories AS cat JOIN hde_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN hde_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-12-04 02:00:43') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-12-04 02:00:43') ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC LIMIT 0, 4 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM hde_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM hde_content AS a LEFT JOIN hde_categories AS c ON c.id = a.catid LEFT JOIN hde_users AS ua ON ua.id = a.created_by LEFT JOIN hde_users AS uam ON uam.id = a.modified_by LEFT JOIN hde_categories as parent ON parent.id = c.parent_id LEFT JOIN hde_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM hde_categories AS cat JOIN hde_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN hde_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-12-04 02:00:43') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-12-04 02:00:43') ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC

Aktuelle Nachrichten

Weihnachten

HDE Aktion

aktion

Alle Informationen zum Weihnachtsgeschäft 2016: Zahlen, Grafiken und aktuelle Meldungen weiterlesen

Positionen zur Bundestagswahl

derHandelfuerWachstum300px

Branchenreport

Branchenreport-HDe-Arbeitgeber2016Der Handel als Arbeitgeber
Der Einzelhandel ist mit etwa drei Millionen Mitarbeitern einer der größten Arbeitgeber. Der vorliegende Branchenreport zeigt die große Bedeutung des Arbeitgebers Einzelhandel und das vielfältige Angebot an die Arbeitnehmer.       weiterlesen

Textilbündnis

tex Mitgliedslogo 250

Die Mitglieder des Textilbündnisses verfolgen das Ziel, die sozialen, ökologischen und ökonomischen Bedingungen entlang der Textil-Lieferkette zu verbessern. Weitere Informationen...

Kunststofftragetaschen

Tuete-klAb 1. Juli startet offiziell die "HDE-BMUB-Vereinbarung zur Verringerung des Verbrauchs von Kunststofftragetaschen“
>> weitere Informationen für Unternehmen

HDE Zahlenspiegel

ZS16 Titel-kl2Der HDE-Zahlenspiegel 2016 gibt einen Überblick über den gesamtwirtschaftlichen Rahmen, über die Entwicklung des Einzelhandels sowie über zentrale Ergebnisse von HDE-Umfragen.
>> zur Bestellmöglichkeit...

Twitter

Suche

Verbande-Spalte-1
Verbande-Spalte-2
Verbande-Spalte-3
Verbande-Spalte-4
Verbande-Spalte-5
Verbaende-Spalte-6

Logo-DerHandel-210

Arbeitsrecht Merkblaetter250 

Logo-Generationen

BMWi Energieeffizienz

HDE-Toolbox 150x150

HDE auf Facebookico-newsletterico-twitterico-xingico-rss