a:7:{s:15:"fieldTablePairs";a:2:{i:0;s:10:"categories";i:1;s:8:"sections";}s:12:"tableAliases";a:2:{s:10:"categories";s:1:"c";s:8:"sections";s:1:"s";}s:19:"reverseTableAliases";a:2:{s:1:"c";s:10:"categories";s:1:"s";s:8:"sections";}s:12:"fieldAliases";a:17:{s:2:"id";s:2:"id";s:9:"parent_id";s:9:"parent_id";s:5:"title";s:5:"title";s:4:"name";s:4:"name";s:5:"alias";s:5:"alias";s:5:"image";s:5:"image";s:7:"section";s:7:"section";s:14:"image_position";s:14:"image_position";s:11:"description";s:11:"description";s:9:"published";s:9:"published";s:11:"checked_out";s:11:"checked_out";s:16:"checked_out_time";s:16:"checked_out_time";s:6:"editor";s:6:"editor";s:8:"ordering";s:8:"ordering";s:6:"access";s:6:"access";s:5:"count";s:5:"count";s:6:"params";s:6:"params";}s:19:"fieldTableAliasData";a:19:{i:0;a:4:{s:14:"fieldNameAlias";s:2:"id";s:9:"fieldName";s:2:"id";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:1;a:4:{s:14:"fieldNameAlias";s:9:"parent_id";s:9:"fieldName";s:9:"parent_id";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:2;a:4:{s:14:"fieldNameAlias";s:5:"title";s:9:"fieldName";s:5:"title";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:3;a:4:{s:14:"fieldNameAlias";s:4:"name";s:9:"fieldName";s:4:"name";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:4;a:4:{s:14:"fieldNameAlias";s:5:"alias";s:9:"fieldName";s:5:"alias";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:5;a:4:{s:14:"fieldNameAlias";s:5:"image";s:9:"fieldName";s:5:"image";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:6;a:4:{s:14:"fieldNameAlias";s:7:"section";s:9:"fieldName";s:7:"section";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:7;a:4:{s:14:"fieldNameAlias";s:14:"image_position";s:9:"fieldName";s:14:"image_position";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:8;a:4:{s:14:"fieldNameAlias";s:11:"description";s:9:"fieldName";s:11:"description";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:9;a:4:{s:14:"fieldNameAlias";s:9:"published";s:9:"fieldName";s:9:"published";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:10;a:4:{s:14:"fieldNameAlias";s:11:"checked_out";s:9:"fieldName";s:11:"checked_out";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:11;a:4:{s:14:"fieldNameAlias";s:16:"checked_out_time";s:9:"fieldName";s:16:"checked_out_time";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:12;a:4:{s:14:"fieldNameAlias";s:6:"editor";s:9:"fieldName";s:6:"editor";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:13;a:4:{s:14:"fieldNameAlias";s:8:"ordering";s:9:"fieldName";s:8:"ordering";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:14;a:4:{s:14:"fieldNameAlias";s:6:"access";s:9:"fieldName";s:6:"access";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:15;a:4:{s:14:"fieldNameAlias";s:5:"count";s:9:"fieldName";s:5:"count";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:16;a:4:{s:14:"fieldNameAlias";s:6:"params";s:9:"fieldName";s:6:"params";s:14:"tableNameAlias";s:1:"c";s:9:"tableName";s:10:"categories";}i:17;a:4:{s:14:"fieldNameAlias";s:9:"sectionid";s:9:"fieldName";s:2:"id";s:14:"tableNameAlias";s:1:"s";s:9:"tableName";s:8:"sections";}i:18;a:4:{s:14:"fieldNameAlias";s:12:"sectiontitle";s:9:"fieldName";s:5:"title";s:14:"tableNameAlias";s:1:"s";s:9:"tableName";s:8:"sections";}}s:10:"fieldCount";i:20;s:3:"sql";s:244:"SELECT c.*, s.id as sectionid, s.title as sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jos_categories AS c INNER JOIN jos_sections AS s ON s.id = c.section WHERE c.id = 11 LIMIT 0, 1";}