SELECT modulesfaq_questions.*,
(SELECT modulesfaq_answers.id FROM modulesfaq_answers WHERE modulesfaq_answers.status='enabled' AND modulesfaq_answers.modulesfaq_questions_id = modulesfaq_questions.id ORDER BY modulesfaq_answers.Version DESC Limit 1) AS answer,
(SELECT modulesfaq_answers.id FROM modulesfaq_answers WHERE modulesfaq_answers.modulesfaq_questions_id = modulesfaq_questions.id ORDER BY modulesfaq_answers.Version DESC Limit 1) AS answerCount,
(SELECT COUNT(*) FROM modulesfaq_questions AS MQ WHERE MQ.Modul = modulesfaq_questions.Modul GROUP BY MQ.Modul) AS questionsByModul
FROM modulesfaq_questions
WHERE 1 AND modulesfaq_questions.language = 'de' AND modulesfaq_questions.status = 'enabled' AND modulesfaq_questions.Modul = 'specs'
ORDER BY modulesfaq_questions.Modul, modulesfaq_questions.pos, modulesfaq_questions.Frage
Alle Beiträge zu specs
Informationstext zum Modul specs
