1547880283 SELECT m.*, u.user_colour, g.group_colour, g.group_type FROM (phpbb_tntn2_moderator_cache m) LEFT JOIN phpbb_tntn2_users u ON (m.user_id = u.user_id) LEFT JOIN phpbb_tntn2_groups g ON (m.group_id = g.group_id) WHERE m.display_on_index = 1 4779 a:20:{i:0;a:9:{s:8:"forum_id";s:1:"1";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:1;a:9:{s:8:"forum_id";s:1:"2";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:2;a:9:{s:8:"forum_id";s:1:"3";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:3;a:9:{s:8:"forum_id";s:1:"4";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:4;a:9:{s:8:"forum_id";s:1:"5";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:5;a:9:{s:8:"forum_id";s:1:"6";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:6;a:9:{s:8:"forum_id";s:1:"7";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:7;a:9:{s:8:"forum_id";s:1:"8";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:8;a:9:{s:8:"forum_id";s:1:"9";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:9;a:9:{s:8:"forum_id";s:2:"10";s:7:"user_id";s:1:"2";s:8:"username";s:8:"Toontoon";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:10;a:9:{s:8:"forum_id";s:1:"1";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:11;a:9:{s:8:"forum_id";s:1:"2";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:12;a:9:{s:8:"forum_id";s:1:"3";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:13;a:9:{s:8:"forum_id";s:1:"4";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:14;a:9:{s:8:"forum_id";s:1:"5";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:15;a:9:{s:8:"forum_id";s:1:"6";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:16;a:9:{s:8:"forum_id";s:1:"7";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:17;a:9:{s:8:"forum_id";s:1:"8";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:18;a:9:{s:8:"forum_id";s:1:"9";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}i:19;a:9:{s:8:"forum_id";s:2:"10";s:7:"user_id";s:2:"12";s:8:"username";s:5:"Bruno";s:8:"group_id";s:1:"0";s:10:"group_name";s:0:"";s:16:"display_on_index";s:1:"1";s:11:"user_colour";s:6:"00AA00";s:12:"group_colour";N;s:10:"group_type";N;}}