/* this is the table... the error is:
 *

ERROR:  Unknown column 'crm_groups_sub.leadId' in 'on clause' 

 */

/* TABLE */
CREATE TABLE `crm_groups_sub` (
  `subId` int(11) NOT NULL auto_increment,
  `userId` int(11) NOT NULL,
  `companyId` int(11) NOT NULL default '0',
  `groupId` int(11) NOT NULL default '0',
  `leadId` int(11) NOT NULL default '0',
  `receiveGroupEmails` char(3) NOT NULL default 'YES',
  `receiveSeriesEmails` char(3) NOT NULL default 'YES',
  `receiveFeedbackEmails` char(3) NOT NULL default 'YES',
  `dateSubscribed` int(11) NOT NULL default '0',
  `seriesScore` float NOT NULL default '0',
  `readOnly` char(3) NOT NULL default 'NO',
  PRIMARY KEY  (`subId`),
  KEY `groupId` (`groupId`,`leadId`),
  KEY `companyId` (`companyId`)
) ENGINE=MyISAM AUTO_INCREMENT=12489 DEFAULT CHARSET=latin1 AUTO_INCREMENT=12489 ;


/* QUERY */

SELECT lp_funnel.funnelId,  'main' AS contactId, lp_funnel.firstName, lp_funnel.lastName, CONCAT( lp_funnel.firstName,  ' ', lp_funnel.lastName ) AS fullName, lp_funnel.companyName, lp_funnel.email1, lp_funnel.title, crm_groups_sub . * 
FROM crm_groups_sub, lp_powerseries
JOIN lp_funnel ON lp_funnel.funnelId = crm_groups_sub.leadId
WHERE lp_powerseries.seriesId =  '11'
AND lp_powerseries.groupId = crm_groups_sub.groupId
AND crm_groups_sub.receiveSeriesEmails =  'YES'
AND length( lp_funnel.email1 ) >1
LIMIT 0 , 30