SELECT `mitr_no`, `mitr_tree`, `mitr_tiefe`, `mitr_name`, `mitr_bild`, `mitl_name`, `mitr_inhalt`, `mitr_art`, `mitr_bild_no` FROM `mind_tree` LEFT JOIN `mind_tree_language` ON `mitl_mitr_no` = `mind_tree`.`mitr_no` AND `mitl_sprache` =2 WHERE `mitr_tiefe` = 1 AND `mitr_art` < 256 ORDER BY `mitr_tree`;

Foren-Seite.de
Icon-Leiste
Status
Inhalt