select SQL_CALC_FOUND_ROWS p.ID, p.Business, p.Address, p.City, p.State, p.Zip, p.Contact, p.Telephone, p.URL, p.Description, p.Email, case when pmu.membership_id = 4 then 'gold' when pmu.membership_id = 3 then 'silver' when pmu.membership_id = 2 then 'bronze' when pmu.membership_id = 1 then 'free' else 'unclaimed' end as Type, tu.ID as ListingID, l.web_path , avg(r.Rating) as Rating, if(Logo>'',1,0) as LogoFlag, if(URL>'',1,0) as URLFlag ,0 as FieldRelevance ,0 as MatchRelevance ,0 as Relevance from tp_offline p left join tp_logos l on p.LogoID = l.ID left join tp_comments c on p.ID = c.TableID and c.TableAppend = 'offline' and c.Status = 'Active' left join tp_ratings r on c.ID = r.CommentID left join tp_users_listings tu on p.ID = tu.TableID and tu.TableAppend = 'offline' and tu.Status = 'Active' left join ggoybzgq1_pmpro_memberships_users pmu on tu.user_id = pmu.user_id and pmu.status = 'active' where p.Zip in (20101, 20102, 20103, 20104, 20105, 20107, 20117, 20120, 20129, 20131, 20132, 20134, 20143, 20146, 20147, 20148, 20149, 20151, 20152, 20158, 20159, 20160, 20163, 20164, 20165, 20166, 20167, 20169, 20170, 20171, 20175, 20176, 20177, 20178, 20190, 20191, 20194, 20197, 20199, 20837, 20838, 20839, 20841, 20842, 20854, 20874, 22033, 22035, 22066, 22067, 22093, 22121, 22124, 22181, 22182) and p.Updated > '2013-01-01' group by p.ID order by LogoFlag desc, URLFlag desc, Rating desc, FieldRelevance desc, MatchRelevance desc, Relevance desc, Updated desc limit 0, 10
1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay