1054 - Unknown column 'pcs.city' in 'where clause'
select m.memberID, m.genderType, m.yourName, m.mobilePhone, m.phone, m.city_code, m.compName, m.state, m.sub_city_code, m.country, m.country_code, m.agent_rating, t.comp_logo, t.travelDesc, t.logo_image_status, m.new_mobile_phone, m.file_name from travels as t inner join members as m where m.memberID = t.memberID && m.file_name!='' && pcs.city='11246' and m.activeStatus IN ('Y','B') and t.activeStatus='Y' and m.memberType = '1' && m.paid_status > 1 order by rand() limit 0,4
