Displaying 1 result from an estimated 1 matches for "gid_block".
2010 May 01
1
I need some help joining data from 3 MySQL tables, please
...etime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`),
KEY `gid_block` (`gid`,`block`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;
CREATE TABLE IF NOT EXISTS `jos_mls_teams_members` (
`id` int(11) NOT NULL auto_increment,
`teamid` int(11) NOT NULL default '0',
`userid` int(11) NOT...