MYSQL [rss] Dotaz:
SELECT ar.* AS xXx,
ct.component_type_id AS module_id,
ct.name AS module_name,
ct.prefix AS module_prefix,
ct.code_name AS module_code,
ct.class_name AS module_class,
ct.class_file AS module_file,
ct.constant_name AS ct_constant_name,
c.component_id,
c.name AS component_name,
c.code AS component_code,
cop.page_id AS article_page_id,
COUNT(article_attachment_id) AS at,
cf.forum_id
FROM
component c,
component_type ct,
component_on_page cop
LEFT JOIN version_container AS vc ON vc.component_id=c.component_id
LEFT JOIN article AS ar ON ar.version_id=vc.version_id
LEFT JOIN version_info AS vi ON vi.version_id = vc.version_id AND vi.status_id= 405
LEFT JOIN article_attachment aa ON aa.version_id=vi.version_id
LEFT JOIN component_forum cf ON cf.component_id=vc.component_id
WHERE
c.component_id = cop.component_id
AND c.component_type_id= 22
AND ( cop.page_id = 142 || cop.page_id = 32)
AND c.component_type_id = ct.component_type_id
AND c.presentation_id = 1
AND ar.date_from <= NOW()
AND ar.date_to >= NOW()
AND TO_DAYS(NOW()) - TO_DAYS(ar.date_display) <= 10
GROUP BY c.component_id
ORDER BY ar.date_display DESC,ar.position DESC
Chyba:Unknown column 'c.component_id' in 'on clause' MYSQL [rss] Chyba:no result CTU.CZ - Aktuální informaceobsahuje Aktuální informace, Tiskové zprávy
http://www.ctu.cz/main.php?pageid=5
cs