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
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 content 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
WHERE c.component_id = cop.component_id
AND c.component_type_id =9
AND cop.page_id =92
AND c.component_type_id = ct.component_type_id
AND c.presentation_id =1
GROUP BY c.component_id
Chyba:Unknown column 'c.component_id' in 'on clause' MYSQL [rss] Chyba:no result CTU.CZ - Telekomunikační věstníkTelekomunikační věstník
http://www.ctu.cz/main.php?pageid=17
cs