[SQL] pobierz, plaintext 
SELECT a.*, b.* FROM groups AS a INNER JOIN groups_cats AS b ON (b.cat_id=a.group_cat) ORDER BY a.group_id
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
CREATE TABLE `ef_groups` (
  `group_id` tinyint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL DEFAULT '',
  `group_description` text NOT NULL,
  `group_avatar` varchar(100) NOT NULL DEFAULT '',
  `group_admin` tinyint(3) NOT NULL DEFAULT '0',
  `group_cat` tinyint(1) NOT NULL DEFAULT '0',
  `group_time` int(10) NOT NULL DEFAULT '0',
  `group_forum` tinyint(1) NOT NULL DEFAULT '0',
  `group_access` tinyint(1) NOT NULL DEFAULT '0',
  `group_users` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`group_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
 
-- 
-- Zrzut danych tabeli `ef_groups`
-- 
 
INSERT INTO `ef_groups` VALUES (1, 'Maniacy..', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', '../../infusions/groups_system/img/avatars/avatar.jpg', 1, 1, 1218722762, 0, 101, 1);
 
-- --------------------------------------------------------
 
-- 
-- Struktura tabeli dla  `ef_groups_cats`
-- 
 
CREATE TABLE `ef_groups_cats` (
  `cat_id` tinyint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(40) NOT NULL DEFAULT '',
  `cat_avatar` text NOT NULL,
  PRIMARY KEY  (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
 
-- 
-- Zrzut danych tabeli `ef_groups_cats`
-- 
 
INSERT INTO `ef_groups_cats` VALUES (1, 'Ludzie', '');
 
-- --------------------------------------------------------
 
 
CREATE TABLE `ef_users` (
  `user_id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_name` varchar(30) NOT NULL DEFAULT '',
  `user_password` varchar(32) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `user_hide_email` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `user_location` varchar(50) NOT NULL DEFAULT '',
  `user_birthdate` date NOT NULL DEFAULT '0000-00-00',
  `user_aim` varchar(25) NOT NULL DEFAULT '',
  `user_icq` varchar(15) NOT NULL DEFAULT '',
  `user_msn` varchar(100) NOT NULL DEFAULT '',
  `user_yahoo` varchar(100) NOT NULL DEFAULT '',
  `user_web` varchar(200) NOT NULL DEFAULT '',
  `user_theme` varchar(100) NOT NULL DEFAULT 'Default',
  `user_offset` char(3) NOT NULL DEFAULT '0',
  `user_avatar` varchar(100) NOT NULL DEFAULT '',
  `user_sig` text NOT NULL,
  `user_posts` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `user_joined` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_lastvisit` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_ip` varchar(20) NOT NULL DEFAULT '0.0.0.0',
  `user_rights` text NOT NULL,
  `user_groups` text NOT NULL,
  `user_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '101',
  `user_status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `user_prefix` char(3) NOT NULL DEFAULT '~',
  `user_color` varchar(6) NOT NULL DEFAULT '',
  `user_adds` tinyint(4) NOT NULL DEFAULT '0',
  `user_email_act` tinyint(1) NOT NULL DEFAULT '0',
  `user_rang` varchar(30) NOT NULL DEFAULT '',
  `user_points` smallint(5) DEFAULT '0',
  `points_normal` smallint(5) DEFAULT '0',
  `points_bonus` smallint(5) DEFAULT '0',
  `points_punishment` smallint(5) DEFAULT '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
 
-- 
-- Zrzut danych tabeli `ef_users`
-- 
 
INSERT INTO `ef_users` VALUES (1, 'admin', 'xxx', 'xxx@wp.pl', 1, '', '0000-00-00', '', '', '', '', '', 'Default', '0', '', '', 0, 1217656567, 1219513455, '127.0.0.1', 'A.AC.AD.B.BP.C.CA.CO.CP.DB.DC.D.EP.FQ.FR.F.FU.IM.I.IP.M.N.NC.P.PH.PI.PO.RG.RS.S.
L.S1.S2.S3.S4.S5.S6.S7.SU.UG.U.W.WC', '', 103, 0, '@', 'F75013', 0, 1, '', 0, 0, 0, 0);
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT a.group_cat, b.*, c.* FROM ef_users AS c LEFT JOIN ef_groups AS a ON (c.user_id=a.group_admin) INNER JOIN ef_groups_cats AS b ON (b.cat_id=a.group_cat)
[SQL] pobierz, plaintext