|
No valid database connection Unknown column 'i.state' in 'where clause' SQL=SELECT c.*, CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT i.id ) FROM jos_hg_hotelitems AS i LEFT JOIN jos_hg_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jos_hg_categories AS cc ON cc.id = rel.catid WHERE cc.published = 1 AND cc.parent_id = 0 AND cc.access <= 0 AND i.state IN (1, -4) AND c.id = cc.id GROUP BY cc.id) AS assignedhotelitems FROM jos_hg_categories AS c WHERE c.published = 1 AND c.parent_id = 0 AND c.access <= 0 ORDER BY c.ordering ASC LIMIT 0, 5
|
