James P. Connolly is a stand up comedian and radio/TV host known for his playful, confident style and unique sense of humor. He attended Harvard University on a Marine Corps ROTC Scholarship. While serving in Desert Storm, he was ordered to write jokes for a Colonel. Arriving in Hollywood, he began to perform at LA´s major comedy venues and soon popped up on television, commercials, and in small films. James has appeared on Americas Got Talent, soon to be seen on Netflix, Comedy Central, HBO, VH1, Comics Unleashed, hosted "Live From Here" for National Lampoon XM Radio, recorded a "Blue Collar Radio Comedy Concert" for SiriusXM, and is a frequent guest on the nationally syndicated Bob and Tom Radio Show. He has also made multiple trips overseas to entertain the troops and produces an annual Veterans Day Comedy Show benefiting the Semper Fi Fund.
Unable to get the person list select distinct person.person_id,
person.person_uuid, person.`first_name`, person.`last_name`, person.`middle_name`,
person.`full_name`, person.`date_of_birth`, person.`ssn`, person.`sex`,
person.`aka`, person.`type`, person.`sort_order`,
person.`bio`, person.`short_bio`, person.`credits`, person.talents, person.`rate_show`, person.`rate_week`,
person.`door_deal`, person.`ticket_price`, person.`stage_intro`, person.rating, person.`type`, person.`anniversary`,
person.`sort_order`, person.`verified`,
category.category_uuid, category.name category
from person
inner join person_category lcs
on person.person_uuid = lcs.person_uuid
inner join category
on lcs.category_uuid = category.category_uuid inner join company_person cpers
ON (person.person_uuid = cpers.person_uuid AND cpers.attribute = 'owner'
AND cpers.company_uuid = '01493dd313ac170') inner join person_management pman
ON (person.person_uuid = pman.person_uuid
AND pman.attribute = 'manager'
AND pman.management_uuid = '0149a09ee952c91') inner join person_role prole on person.person_uuid = prole.person_uuid inner join role on (prole.role_uuid = role.role_uuid and role.`role_uuid`='01491a2ad7089dc') where 1 and person.person_uuid NOT IN (SELECT DISTINCT person_uuid FROM person_role WHERE role_uuid = '014a85b5eb27385') and (person.full_name like '% Veteran's Day Fundraiser with James P. Connolly%' or
person.first_name like '% Veteran's Day Fundraiser with James P. Connolly%' or
person.last_name like '% Veteran's Day Fundraiser with James P. Connolly%' or
person.aka like '% Veteran's Day Fundraiser with James P. Connolly%' or
person.date_of_birth like '% Veteran's Day Fundraiser with James P. Connolly%' or
person.ssn like '% Veteran's Day Fundraiser with James P. Connolly%' or
person.sex = ' Veteran's Day Fundraiser with James P. Connolly' or
person.type like '% Veteran's Day Fundraiser with James P. Connolly%') and (category.name = 'Performer') and person.deleted != 'Y' ORDER BY person.aka, person.last_name You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Day Fundraiser with James P. Connolly%' or
person.first_name like '% Vetera' at line 18
