Filtrar : Dibujos para colorear y pintar dibujo vampiro (3) Aprender a dibujar dibujo vampiro (3)

 

SELECT SQL_CALC_FOUND_ROWS titre, optimized_title, url, quali, bg, id, url_vignette, alt_media, id_rubrique, largeur_lightbox, hauteur_lightbox, open_in_lightbox, type, nbc FROM ((SELECT c.titre_contenu AS titre, c.optimized_title, COALESCE(c.qualite, 0) AS quali, '999999999' AS bg, c.id_contenu AS id, COALESCE(m.url_vignette, '/design/normal/default/default-hellokids.jpg') AS url_vignette, m.alt_media, c.id_rubrique, COALESCE(c.url_redirection, CONCAT('/c_', c.id_contenu, '/', c.url_rew_contenu)) AS url, c.largeur_lightbox, c.hauteur_lightbox, c.open_in_lightbox, 'contenu' AS type, '1' AS nbc FROM tags_liaison tl, rubriques r, contenus c LEFT JOIN medias m ON m.id_media = c.id_media_vignette WHERE tl.id_tag = '6269' AND r.id_rubrique = c.id_rubrique AND r.bg > 1 AND r.bd < 2114 AND c.id_contenu = tl.id_externe AND tl.type_tag = 'contenu' AND c.actif_contenu = '1' AND (c.date_debut <= NOW() OR c.date_debut IS NULL) AND (c.date_fin >= NOW() OR c.date_fin IS NULL) ) UNION ( SELECT c.titre_contenu AS titre, c.optimized_title, COALESCE(c.qualite, 0) AS quali, '999999999' AS bg, c.id_contenu AS id, COALESCE(m.url_vignette, '/design/normal/default/default-hellokids.jpg') AS url_vignette, m.alt_media, c.id_rubrique, COALESCE(c.url_redirection, CONCAT('/c_', c.id_contenu, '/', c.url_rew_contenu)) AS url, c.largeur_lightbox, c.hauteur_lightbox, c.open_in_lightbox, 'contenu' AS type, '1' AS nbc FROM rubriques r, contenus c LEFT JOIN medias m ON m.id_media = c.id_media_vignette WHERE c.id_rubrique IN (619) AND r.id_rubrique = c.id_rubrique AND r.bg > 1 AND r.bd < 2114 AND c.actif_contenu = '1' AND (c.date_debut <= NOW() OR c.date_debut IS NULL) AND (c.date_fin >= NOW() OR c.date_fin IS NULL) ) UNION ( SELECT r.titre_rubrique AS titre, NULL as optimized_title, 11 AS quali, r.bg, r.id_rubrique AS id, COALESCE(m.url_vignette, '/design/normal/default/default-hellokids.jpg') AS url_vignette, m.alt_media, r.id_rubrique, COALESCE(r.url_redirection, CONCAT('/r_', r.id_rubrique, '/', r.url_rew_rubrique)) AS url, '0' AS largeur_lightbox, '0' AS hauteur_lightbox, '0' AS open_in_lightbox, 'rubrique' AS type, COUNT(c.id_contenu) AS nbc FROM rubriques r LEFT JOIN medias m ON m.id_media = r.id_media_vignette LEFT JOIN contenus c ON c.id_rubrique = r.id_rubrique AND c.actif_contenu = '1' AND (c.date_debut <= NOW() OR c.date_debut IS NULL) AND (c.date_fin >= NOW() OR c.date_fin IS NULL) WHERE r.id_rubrique IN (619) AND r.actif_rubrique = '1' AND r.bg > 1 AND r.bd < 2114 GROUP BY r.id_rubrique )) AS tmp_table GROUP BY url ORDER BY bg, id DESC LIMIT 0, 42
Got error 28 from storage engine