Which query will execute faster? SELECT term_data.name FROM term_data INNER JOIN term_node ON term_data.tid= term_node.tid INNER JOIN node ON term_node.nid= node.nid WHERE node.nid = $nid and term_data.vid=$vid OR SELECT term_data.name FROM term_data,node INNER JOIN term_node ON term_data.tid= term_node.tid WHERE term_node.nid=$nid AND node.nid =$nid AND term_data.vid=$vid Table structure ------------ CREATE TABLE `term_data` ( `tid` int(10) unsigned NOT NULL auto_increment, `vid` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` longtext, `weight` tinyint(4) NOT NULL default '0', PRIMARY KEY (`tid`), KEY `vid` (`vid`) ) CREATE TABLE `term_node` ( `nid` int(10) unsigned NOT NULL default '0', `tid` int(10) unsigned NOT NULL default '0', KEY `nid` (`nid`), KEY `tid` (`tid`) ) CREATE TABLE `node` ( `nid` int(10) unsigned NOT NULL auto_increment, `vid` int(10) unsigned NOT NULL default '0', `type` varchar(32) NOT NULL default '', `title` varchar(255) default NULL, `uid` int(11) NOT NULL default '0', `status` int(11) NOT NULL default '1', `created` int(11) NOT NULL default '0', `changed` int(11) NOT NULL default '0', `comment` int(11) NOT NULL default '0', `promote` int(11) NOT NULL default '0', `moderate` int(11) NOT NULL default '0', `sticky` int(11) NOT NULL default '0', PRIMARY KEY (`nid`,`vid`), UNIQUE KEY `vid` (`vid`), KEY `node_type` (`type`(4)), KEY `node_title_type` (`title`,`type`(4)), KEY `status` (`status`), KEY `uid` (`uid`), KEY `node_moderate` (`moderate`), KEY `node_promote_status` (`promote`,`status`), KEY `node_created` (`created`), KEY `node_changed` (`changed`), KEY `node_status_type` (`status`,`type`,`nid`), KEY `nid` (`nid`) )