Tag et Ordre

SELECT i.id, i.title, i.*, ie.*, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie ON ie.item_id = i.id INNER JOIN #__flexicontent_tags_item_relations AS t ON t.itemid = i.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid LEFT JOIN #__categories AS mc ON mc.id = i.catid WHERE t.tid = 142 AND i.state IN (1, -5) AND i.sectionid = 5 AND mc.access <= 0 AND i.access <= 0 GROUP BY i.id ORDER BY f.value + 0 ASC, i.title Unknown column 'f.value' in 'order clause' SQL=SELECT i.id, i.title, i.*, ie.*, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM jos_content AS i LEFT JOIN jos_flexicontent_items_ext AS ie ON ie.item_id = i.id INNER JOIN jos_flexicontent_tags_item_relations AS t ON t.itemid = i.id LEFT JOIN jos_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jos_categories AS c ON c.id = rel.catid LEFT JOIN jos_categories AS mc ON mc.id = i.catid WHERE t.tid = 142 AND i.state IN (1, -5) AND i.sectionid = 5 AND mc.access <= 0 AND i.access <= 0 GROUP BY i.id ORDER BY f.value + 0 ASC, i.title LIMIT 0, 20