API tools faq
paste
Guest User

Untitled

a guest
Oct 13th, 2014
425
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 140.75 KB | None | 0 0
raw download clone embed print report
  1. Database Error Code: Too many tables; MySQL can only use 61 tables in a join, 1116
  2. Additional Details:
  3. Array
  4. (
  5. [callback] => Array
  6. (
  7. [0] => CRM_Core_Error
  8. [1] => handle
  9. )
  10.  
  11. [code] => -1
  12. [message] => DB Error: unknown error
  13. [mode] => 16
  14. [debug_info] => CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache62 (Select contact_a.id as contact_id , p.id as participant_id, '' as participant_link,
  15. contact_a.sort_name as display_name, contact_a.first_name, contact_a.last_name,
  16. civicrm_email.email as email, civicrm_phone.phone as phone, civicrm_address.street_address as street_address,
  17. civicrm_address.supplemental_address_1 as supplemental_address_1, civicrm_address.city as city ,civicrm_address.postal_code as postal_code,
  18. civicrm_state_province.abbreviation as state, p.registered_by_id, contact_b.sort_name as registered_by_name,li__.id as li___id,
  19. li__.qty as li___qty,
  20. li__.unit_price as li___unit_price,
  21. li__.line_total as li___line_total,
  22. li__.participant_count as li___participant_count ,
  23. li__.label as li___label, li_104_438.id as li_104_438_id,
  24. li_104_438.qty as li_104_438_qty,
  25. li_104_438.unit_price as li_104_438_unit_price,
  26. li_104_438.line_total as li_104_438_line_total,
  27. li_104_438.participant_count as li_104_438_participant_count ,
  28. li_104_438.label as li_104_438_label, li_105_443.id as li_105_443_id,
  29. li_105_443.qty as li_105_443_qty,
  30. li_105_443.unit_price as li_105_443_unit_price,
  31. li_105_443.line_total as li_105_443_line_total,
  32. li_105_443.participant_count as li_105_443_participant_count ,
  33. li_105_443.label as li_105_443_label, li_105_440.id as li_105_440_id,
  34. li_105_440.qty as li_105_440_qty,
  35. li_105_440.unit_price as li_105_440_unit_price,
  36. li_105_440.line_total as li_105_440_line_total,
  37. li_105_440.participant_count as li_105_440_participant_count ,
  38. li_105_440.label as li_105_440_label, li_105_442.id as li_105_442_id,
  39. li_105_442.qty as li_105_442_qty,
  40. li_105_442.unit_price as li_105_442_unit_price,
  41. li_105_442.line_total as li_105_442_line_total,
  42. li_105_442.participant_count as li_105_442_participant_count ,
  43. li_105_442.label as li_105_442_label, li_105_441.id as li_105_441_id,
  44. li_105_441.qty as li_105_441_qty,
  45. li_105_441.unit_price as li_105_441_unit_price,
  46. li_105_441.line_total as li_105_441_line_total,
  47. li_105_441.participant_count as li_105_441_participant_count ,
  48. li_105_441.label as li_105_441_label, li_106_445.id as li_106_445_id,
  49. li_106_445.qty as li_106_445_qty,
  50. li_106_445.unit_price as li_106_445_unit_price,
  51. li_106_445.line_total as li_106_445_line_total,
  52. li_106_445.participant_count as li_106_445_participant_count ,
  53. li_106_445.label as li_106_445_label, li_106_444.id as li_106_444_id,
  54. li_106_444.qty as li_106_444_qty,
  55. li_106_444.unit_price as li_106_444_unit_price,
  56. li_106_444.line_total as li_106_444_line_total,
  57. li_106_444.participant_count as li_106_444_participant_count ,
  58. li_106_444.label as li_106_444_label, li_107_448.id as li_107_448_id,
  59. li_107_448.qty as li_107_448_qty,
  60. li_107_448.unit_price as li_107_448_unit_price,
  61. li_107_448.line_total as li_107_448_line_total,
  62. li_107_448.participant_count as li_107_448_participant_count ,
  63. li_107_448.label as li_107_448_label, li_107_447.id as li_107_447_id,
  64. li_107_447.qty as li_107_447_qty,
  65. li_107_447.unit_price as li_107_447_unit_price,
  66. li_107_447.line_total as li_107_447_line_total,
  67. li_107_447.participant_count as li_107_447_participant_count ,
  68. li_107_447.label as li_107_447_label, li_108_452.id as li_108_452_id,
  69. li_108_452.qty as li_108_452_qty,
  70. li_108_452.unit_price as li_108_452_unit_price,
  71. li_108_452.line_total as li_108_452_line_total,
  72. li_108_452.participant_count as li_108_452_participant_count ,
  73. li_108_452.label as li_108_452_label, li_108_453.id as li_108_453_id,
  74. li_108_453.qty as li_108_453_qty,
  75. li_108_453.unit_price as li_108_453_unit_price,
  76. li_108_453.line_total as li_108_453_line_total,
  77. li_108_453.participant_count as li_108_453_participant_count ,
  78. li_108_453.label as li_108_453_label, li_108_450.id as li_108_450_id,
  79. li_108_450.qty as li_108_450_qty,
  80. li_108_450.unit_price as li_108_450_unit_price,
  81. li_108_450.line_total as li_108_450_line_total,
  82. li_108_450.participant_count as li_108_450_participant_count ,
  83. li_108_450.label as li_108_450_label, li_108_451.id as li_108_451_id,
  84. li_108_451.qty as li_108_451_qty,
  85. li_108_451.unit_price as li_108_451_unit_price,
  86. li_108_451.line_total as li_108_451_line_total,
  87. li_108_451.participant_count as li_108_451_participant_count ,
  88. li_108_451.label as li_108_451_label, li_109_457.id as li_109_457_id,
  89. li_109_457.qty as li_109_457_qty,
  90. li_109_457.unit_price as li_109_457_unit_price,
  91. li_109_457.line_total as li_109_457_line_total,
  92. li_109_457.participant_count as li_109_457_participant_count ,
  93. li_109_457.label as li_109_457_label, li_109_456.id as li_109_456_id,
  94. li_109_456.qty as li_109_456_qty,
  95. li_109_456.unit_price as li_109_456_unit_price,
  96. li_109_456.line_total as li_109_456_line_total,
  97. li_109_456.participant_count as li_109_456_participant_count ,
  98. li_109_456.label as li_109_456_label, li_109_458.id as li_109_458_id,
  99. li_109_458.qty as li_109_458_qty,
  100. li_109_458.unit_price as li_109_458_unit_price,
  101. li_109_458.line_total as li_109_458_line_total,
  102. li_109_458.participant_count as li_109_458_participant_count ,
  103. li_109_458.label as li_109_458_label, li_109_459.id as li_109_459_id,
  104. li_109_459.qty as li_109_459_qty,
  105. li_109_459.unit_price as li_109_459_unit_price,
  106. li_109_459.line_total as li_109_459_line_total,
  107. li_109_459.participant_count as li_109_459_participant_count ,
  108. li_109_459.label as li_109_459_label, li_109_455.id as li_109_455_id,
  109. li_109_455.qty as li_109_455_qty,
  110. li_109_455.unit_price as li_109_455_unit_price,
  111. li_109_455.line_total as li_109_455_line_total,
  112. li_109_455.participant_count as li_109_455_participant_count ,
  113. li_109_455.label as li_109_455_label, li_110_462.id as li_110_462_id,
  114. li_110_462.qty as li_110_462_qty,
  115. li_110_462.unit_price as li_110_462_unit_price,
  116. li_110_462.line_total as li_110_462_line_total,
  117. li_110_462.participant_count as li_110_462_participant_count ,
  118. li_110_462.label as li_110_462_label, li_110_465.id as li_110_465_id,
  119. li_110_465.qty as li_110_465_qty,
  120. li_110_465.unit_price as li_110_465_unit_price,
  121. li_110_465.line_total as li_110_465_line_total,
  122. li_110_465.participant_count as li_110_465_participant_count ,
  123. li_110_465.label as li_110_465_label, li_110_464.id as li_110_464_id,
  124. li_110_464.qty as li_110_464_qty,
  125. li_110_464.unit_price as li_110_464_unit_price,
  126. li_110_464.line_total as li_110_464_line_total,
  127. li_110_464.participant_count as li_110_464_participant_count ,
  128. li_110_464.label as li_110_464_label, li_110_463.id as li_110_463_id,
  129. li_110_463.qty as li_110_463_qty,
  130. li_110_463.unit_price as li_110_463_unit_price,
  131. li_110_463.line_total as li_110_463_line_total,
  132. li_110_463.participant_count as li_110_463_participant_count ,
  133. li_110_463.label as li_110_463_label, li_110_466.id as li_110_466_id,
  134. li_110_466.qty as li_110_466_qty,
  135. li_110_466.unit_price as li_110_466_unit_price,
  136. li_110_466.line_total as li_110_466_line_total,
  137. li_110_466.participant_count as li_110_466_participant_count ,
  138. li_110_466.label as li_110_466_label, li_110_535.id as li_110_535_id,
  139. li_110_535.qty as li_110_535_qty,
  140. li_110_535.unit_price as li_110_535_unit_price,
  141. li_110_535.line_total as li_110_535_line_total,
  142. li_110_535.participant_count as li_110_535_participant_count ,
  143. li_110_535.label as li_110_535_label, li_111_469.id as li_111_469_id,
  144. li_111_469.qty as li_111_469_qty,
  145. li_111_469.unit_price as li_111_469_unit_price,
  146. li_111_469.line_total as li_111_469_line_total,
  147. li_111_469.participant_count as li_111_469_participant_count ,
  148. li_111_469.label as li_111_469_label, li_111_467.id as li_111_467_id,
  149. li_111_467.qty as li_111_467_qty,
  150. li_111_467.unit_price as li_111_467_unit_price,
  151. li_111_467.line_total as li_111_467_line_total,
  152. li_111_467.participant_count as li_111_467_participant_count ,
  153. li_111_467.label as li_111_467_label, li_111_470.id as li_111_470_id,
  154. li_111_470.qty as li_111_470_qty,
  155. li_111_470.unit_price as li_111_470_unit_price,
  156. li_111_470.line_total as li_111_470_line_total,
  157. li_111_470.participant_count as li_111_470_participant_count ,
  158. li_111_470.label as li_111_470_label, li_111_468.id as li_111_468_id,
  159. li_111_468.qty as li_111_468_qty,
  160. li_111_468.unit_price as li_111_468_unit_price,
  161. li_111_468.line_total as li_111_468_line_total,
  162. li_111_468.participant_count as li_111_468_participant_count ,
  163. li_111_468.label as li_111_468_label, li_112_473.id as li_112_473_id,
  164. li_112_473.qty as li_112_473_qty,
  165. li_112_473.unit_price as li_112_473_unit_price,
  166. li_112_473.line_total as li_112_473_line_total,
  167. li_112_473.participant_count as li_112_473_participant_count ,
  168. li_112_473.label as li_112_473_label, li_112_471.id as li_112_471_id,
  169. li_112_471.qty as li_112_471_qty,
  170. li_112_471.unit_price as li_112_471_unit_price,
  171. li_112_471.line_total as li_112_471_line_total,
  172. li_112_471.participant_count as li_112_471_participant_count ,
  173. li_112_471.label as li_112_471_label, li_112_474.id as li_112_474_id,
  174. li_112_474.qty as li_112_474_qty,
  175. li_112_474.unit_price as li_112_474_unit_price,
  176. li_112_474.line_total as li_112_474_line_total,
  177. li_112_474.participant_count as li_112_474_participant_count ,
  178. li_112_474.label as li_112_474_label, li_112_472.id as li_112_472_id,
  179. li_112_472.qty as li_112_472_qty,
  180. li_112_472.unit_price as li_112_472_unit_price,
  181. li_112_472.line_total as li_112_472_line_total,
  182. li_112_472.participant_count as li_112_472_participant_count ,
  183. li_112_472.label as li_112_472_label, li_113_479.id as li_113_479_id,
  184. li_113_479.qty as li_113_479_qty,
  185. li_113_479.unit_price as li_113_479_unit_price,
  186. li_113_479.line_total as li_113_479_line_total,
  187. li_113_479.participant_count as li_113_479_participant_count ,
  188. li_113_479.label as li_113_479_label, li_113_476.id as li_113_476_id,
  189. li_113_476.qty as li_113_476_qty,
  190. li_113_476.unit_price as li_113_476_unit_price,
  191. li_113_476.line_total as li_113_476_line_total,
  192. li_113_476.participant_count as li_113_476_participant_count ,
  193. li_113_476.label as li_113_476_label, li_113_477.id as li_113_477_id,
  194. li_113_477.qty as li_113_477_qty,
  195. li_113_477.unit_price as li_113_477_unit_price,
  196. li_113_477.line_total as li_113_477_line_total,
  197. li_113_477.participant_count as li_113_477_participant_count ,
  198. li_113_477.label as li_113_477_label, li_113_478.id as li_113_478_id,
  199. li_113_478.qty as li_113_478_qty,
  200. li_113_478.unit_price as li_113_478_unit_price,
  201. li_113_478.line_total as li_113_478_line_total,
  202. li_113_478.participant_count as li_113_478_participant_count ,
  203. li_113_478.label as li_113_478_label, li_113_480.id as li_113_480_id,
  204. li_113_480.qty as li_113_480_qty,
  205. li_113_480.unit_price as li_113_480_unit_price,
  206. li_113_480.line_total as li_113_480_line_total,
  207. li_113_480.participant_count as li_113_480_participant_count ,
  208. li_113_480.label as li_113_480_label, li_114_485.id as li_114_485_id,
  209. li_114_485.qty as li_114_485_qty,
  210. li_114_485.unit_price as li_114_485_unit_price,
  211. li_114_485.line_total as li_114_485_line_total,
  212. li_114_485.participant_count as li_114_485_participant_count ,
  213. li_114_485.label as li_114_485_label, li_114_482.id as li_114_482_id,
  214. li_114_482.qty as li_114_482_qty,
  215. li_114_482.unit_price as li_114_482_unit_price,
  216. li_114_482.line_total as li_114_482_line_total,
  217. li_114_482.participant_count as li_114_482_participant_count ,
  218. li_114_482.label as li_114_482_label, li_114_483.id as li_114_483_id,
  219. li_114_483.qty as li_114_483_qty,
  220. li_114_483.unit_price as li_114_483_unit_price,
  221. li_114_483.line_total as li_114_483_line_total,
  222. li_114_483.participant_count as li_114_483_participant_count ,
  223. li_114_483.label as li_114_483_label, li_114_484.id as li_114_484_id,
  224. li_114_484.qty as li_114_484_qty,
  225. li_114_484.unit_price as li_114_484_unit_price,
  226. li_114_484.line_total as li_114_484_line_total,
  227. li_114_484.participant_count as li_114_484_participant_count ,
  228. li_114_484.label as li_114_484_label, li_114_486.id as li_114_486_id,
  229. li_114_486.qty as li_114_486_qty,
  230. li_114_486.unit_price as li_114_486_unit_price,
  231. li_114_486.line_total as li_114_486_line_total,
  232. li_114_486.participant_count as li_114_486_participant_count ,
  233. li_114_486.label as li_114_486_label, li_115_489.id as li_115_489_id,
  234. li_115_489.qty as li_115_489_qty,
  235. li_115_489.unit_price as li_115_489_unit_price,
  236. li_115_489.line_total as li_115_489_line_total,
  237. li_115_489.participant_count as li_115_489_participant_count ,
  238. li_115_489.label as li_115_489_label, li_115_488.id as li_115_488_id,
  239. li_115_488.qty as li_115_488_qty,
  240. li_115_488.unit_price as li_115_488_unit_price,
  241. li_115_488.line_total as li_115_488_line_total,
  242. li_115_488.participant_count as li_115_488_participant_count ,
  243. li_115_488.label as li_115_488_label, li_116_492.id as li_116_492_id,
  244. li_116_492.qty as li_116_492_qty,
  245. li_116_492.unit_price as li_116_492_unit_price,
  246. li_116_492.line_total as li_116_492_line_total,
  247. li_116_492.participant_count as li_116_492_participant_count ,
  248. li_116_492.label as li_116_492_label, li_116_491.id as li_116_491_id,
  249. li_116_491.qty as li_116_491_qty,
  250. li_116_491.unit_price as li_116_491_unit_price,
  251. li_116_491.line_total as li_116_491_line_total,
  252. li_116_491.participant_count as li_116_491_participant_count ,
  253. li_116_491.label as li_116_491_label, li_117_493.id as li_117_493_id,
  254. li_117_493.qty as li_117_493_qty,
  255. li_117_493.unit_price as li_117_493_unit_price,
  256. li_117_493.line_total as li_117_493_line_total,
  257. li_117_493.participant_count as li_117_493_participant_count ,
  258. li_117_493.label as li_117_493_label, li_117_494.id as li_117_494_id,
  259. li_117_494.qty as li_117_494_qty,
  260. li_117_494.unit_price as li_117_494_unit_price,
  261. li_117_494.line_total as li_117_494_line_total,
  262. li_117_494.participant_count as li_117_494_participant_count ,
  263. li_117_494.label as li_117_494_label, li_118_495.id as li_118_495_id,
  264. li_118_495.qty as li_118_495_qty,
  265. li_118_495.unit_price as li_118_495_unit_price,
  266. li_118_495.line_total as li_118_495_line_total,
  267. li_118_495.participant_count as li_118_495_participant_count ,
  268. li_118_495.label as li_118_495_label, li_118_496.id as li_118_496_id,
  269. li_118_496.qty as li_118_496_qty,
  270. li_118_496.unit_price as li_118_496_unit_price,
  271. li_118_496.line_total as li_118_496_line_total,
  272. li_118_496.participant_count as li_118_496_participant_count ,
  273. li_118_496.label as li_118_496_label, li_122_501.id as li_122_501_id,
  274. li_122_501.qty as li_122_501_qty,
  275. li_122_501.unit_price as li_122_501_unit_price,
  276. li_122_501.line_total as li_122_501_line_total,
  277. li_122_501.participant_count as li_122_501_participant_count ,
  278. li_122_501.label as li_122_501_label, li_122_500.id as li_122_500_id,
  279. li_122_500.qty as li_122_500_qty,
  280. li_122_500.unit_price as li_122_500_unit_price,
  281. li_122_500.line_total as li_122_500_line_total,
  282. li_122_500.participant_count as li_122_500_participant_count ,
  283. li_122_500.label as li_122_500_label, li_124_504.id as li_124_504_id,
  284. li_124_504.qty as li_124_504_qty,
  285. li_124_504.unit_price as li_124_504_unit_price,
  286. li_124_504.line_total as li_124_504_line_total,
  287. li_124_504.participant_count as li_124_504_participant_count ,
  288. li_124_504.label as li_124_504_label, li_124_505.id as li_124_505_id,
  289. li_124_505.qty as li_124_505_qty,
  290. li_124_505.unit_price as li_124_505_unit_price,
  291. li_124_505.line_total as li_124_505_line_total,
  292. li_124_505.participant_count as li_124_505_participant_count ,
  293. li_124_505.label as li_124_505_label, li_124_506.id as li_124_506_id,
  294. li_124_506.qty as li_124_506_qty,
  295. li_124_506.unit_price as li_124_506_unit_price,
  296. li_124_506.line_total as li_124_506_line_total,
  297. li_124_506.participant_count as li_124_506_participant_count ,
  298. li_124_506.label as li_124_506_label, li_124_503.id as li_124_503_id,
  299. li_124_503.qty as li_124_503_qty,
  300. li_124_503.unit_price as li_124_503_unit_price,
  301. li_124_503.line_total as li_124_503_line_total,
  302. li_124_503.participant_count as li_124_503_participant_count ,
  303. li_124_503.label as li_124_503_label, li_125_507.id as li_125_507_id,
  304. li_125_507.qty as li_125_507_qty,
  305. li_125_507.unit_price as li_125_507_unit_price,
  306. li_125_507.line_total as li_125_507_line_total,
  307. li_125_507.participant_count as li_125_507_participant_count ,
  308. li_125_507.label as li_125_507_label, li_126_508.id as li_126_508_id,
  309. li_126_508.qty as li_126_508_qty,
  310. li_126_508.unit_price as li_126_508_unit_price,
  311. li_126_508.line_total as li_126_508_line_total,
  312. li_126_508.participant_count as li_126_508_participant_count ,
  313. li_126_508.label as li_126_508_label, li_127_509.id as li_127_509_id,
  314. li_127_509.qty as li_127_509_qty,
  315. li_127_509.unit_price as li_127_509_unit_price,
  316. li_127_509.line_total as li_127_509_line_total,
  317. li_127_509.participant_count as li_127_509_participant_count ,
  318. li_127_509.label as li_127_509_label, li_128_510.id as li_128_510_id,
  319. li_128_510.qty as li_128_510_qty,
  320. li_128_510.unit_price as li_128_510_unit_price,
  321. li_128_510.line_total as li_128_510_line_total,
  322. li_128_510.participant_count as li_128_510_participant_count ,
  323. li_128_510.label as li_128_510_label, li_129_511.id as li_129_511_id,
  324. li_129_511.qty as li_129_511_qty,
  325. li_129_511.unit_price as li_129_511_unit_price,
  326. li_129_511.line_total as li_129_511_line_total,
  327. li_129_511.participant_count as li_129_511_participant_count ,
  328. li_129_511.label as li_129_511_label, li_130_512.id as li_130_512_id,
  329. li_130_512.qty as li_130_512_qty,
  330. li_130_512.unit_price as li_130_512_unit_price,
  331. li_130_512.line_total as li_130_512_line_total,
  332. li_130_512.participant_count as li_130_512_participant_count ,
  333. li_130_512.label as li_130_512_label, li_131_513.id as li_131_513_id,
  334. li_131_513.qty as li_131_513_qty,
  335. li_131_513.unit_price as li_131_513_unit_price,
  336. li_131_513.line_total as li_131_513_line_total,
  337. li_131_513.participant_count as li_131_513_participant_count ,
  338. li_131_513.label as li_131_513_label, li_132_517.id as li_132_517_id,
  339. li_132_517.qty as li_132_517_qty,
  340. li_132_517.unit_price as li_132_517_unit_price,
  341. li_132_517.line_total as li_132_517_line_total,
  342. li_132_517.participant_count as li_132_517_participant_count ,
  343. li_132_517.label as li_132_517_label, li_132_514.id as li_132_514_id,
  344. li_132_514.qty as li_132_514_qty,
  345. li_132_514.unit_price as li_132_514_unit_price,
  346. li_132_514.line_total as li_132_514_line_total,
  347. li_132_514.participant_count as li_132_514_participant_count ,
  348. li_132_514.label as li_132_514_label, li_133_518.id as li_133_518_id,
  349. li_133_518.qty as li_133_518_qty,
  350. li_133_518.unit_price as li_133_518_unit_price,
  351. li_133_518.line_total as li_133_518_line_total,
  352. li_133_518.participant_count as li_133_518_participant_count ,
  353. li_133_518.label as li_133_518_label, li_134_523.id as li_134_523_id,
  354. li_134_523.qty as li_134_523_qty,
  355. li_134_523.unit_price as li_134_523_unit_price,
  356. li_134_523.line_total as li_134_523_line_total,
  357. li_134_523.participant_count as li_134_523_participant_count ,
  358. li_134_523.label as li_134_523_label, li_134_522.id as li_134_522_id,
  359. li_134_522.qty as li_134_522_qty,
  360. li_134_522.unit_price as li_134_522_unit_price,
  361. li_134_522.line_total as li_134_522_line_total,
  362. li_134_522.participant_count as li_134_522_participant_count ,
  363. li_134_522.label as li_134_522_label, li_135_525.id as li_135_525_id,
  364. li_135_525.qty as li_135_525_qty,
  365. li_135_525.unit_price as li_135_525_unit_price,
  366. li_135_525.line_total as li_135_525_line_total,
  367. li_135_525.participant_count as li_135_525_participant_count ,
  368. li_135_525.label as li_135_525_label, li_135_524.id as li_135_524_id,
  369. li_135_524.qty as li_135_524_qty,
  370. li_135_524.unit_price as li_135_524_unit_price,
  371. li_135_524.line_total as li_135_524_line_total,
  372. li_135_524.participant_count as li_135_524_participant_count ,
  373. li_135_524.label as li_135_524_label, li_138_538.id as li_138_538_id,
  374. li_138_538.qty as li_138_538_qty,
  375. li_138_538.unit_price as li_138_538_unit_price,
  376. li_138_538.line_total as li_138_538_line_total,
  377. li_138_538.participant_count as li_138_538_participant_count ,
  378. li_138_538.label as li_138_538_label, li_138_537.id as li_138_537_id,
  379. li_138_537.qty as li_138_537_qty,
  380. li_138_537.unit_price as li_138_537_unit_price,
  381. li_138_537.line_total as li_138_537_line_total,
  382. li_138_537.participant_count as li_138_537_participant_count ,
  383. li_138_537.label as li_138_537_label, li_139_539.id as li_139_539_id,
  384. li_139_539.qty as li_139_539_qty,
  385. li_139_539.unit_price as li_139_539_unit_price,
  386. li_139_539.line_total as li_139_539_line_total,
  387. li_139_539.participant_count as li_139_539_participant_count ,
  388. li_139_539.label as li_139_539_label, li_139_540.id as li_139_540_id,
  389. li_139_540.qty as li_139_540_qty,
  390. li_139_540.unit_price as li_139_540_unit_price,
  391. li_139_540.line_total as li_139_540_line_total,
  392. li_139_540.participant_count as li_139_540_participant_count ,
  393. li_139_540.label as li_139_540_label, civicrm_value_fbe_event_data_25.describe_your_involvement_in_far_189 , civicrm_value_fbe_event_data_25.lodging_190 , civicrm_value_fbe_event_data_25.are_you_interested_in_carpooling_191 , civicrm_value_fbe_event_data_25.time_arriving_192 , civicrm_value_fbe_event_data_25.place_arriving_193 , civicrm_value_fbe_event_data_25.i_will_be_attending_the_fbea_con_194 , civicrm_value_fbe_event_data_25.i_would_like_to_include_an_addit_195 , civicrm_value_fbe_event_data_25.dietary_restrictions_277 , civicrm_value_fbe_event_data_25.participant_nomination_278 , civicrm_value_young_farmer_gathering_registrat_37.registration_options_264 , civicrm_value_young_farmer_gathering_registrat_37.volunteer_265 , civicrm_value_young_farmer_gathering_registrat_37.how_did_you_hear_about_this_even_266 , e.currency as currency, ((date_format(now(),'%Y') - date_format(contact_a.birth_date,'%Y')) -
  394. (date_format(now(),'00-%m-%d') < date_format(contact_a.birth_date,'00-%m-%d'))) as age,
  395. p.register_date, e.title as event_title, e.start_date as event_start_date,
  396. mt.name as membership_type, ms.label as membership_status , status.label as participant_status_label
  397.  
  398. FROM civicrm_participant p LEFT JOIN civicrm_event e ON p.event_id = e.id
  399. LEFT JOIN civicrm_participant_status_type status ON p.status_id = status.id
  400. Left JOIN civicrm_participant p2 on p.registered_by_id = p2.id
  401. LEFT JOIN civicrm_contact contact_b on p2.contact_id = contact_b.id
  402. JOIN civicrm_contact contact_a on p.contact_id = contact_a.id
  403. left join civicrm_membership m on contact_a.id = m.contact_id
  404. left join civicrm_membership_type mt on m.membership_type_id = mt.id
  405. left join civicrm_membership_status ms on m.status_id = ms.id
  406. left join civicrm_email on contact_a.id = civicrm_email.contact_id
  407. left join civicrm_phone on contact_a.id = civicrm_phone.contact_id
  408. left join civicrm_address on contact_a.id = civicrm_address.contact_id
  409. left join civicrm_state_province on civicrm_address.state_province_id = civicrm_state_province.id LEFT JOIN civicrm_line_item li__ ON p.id = li__.entity_id AND li__.entity_table = 'civicrm_participant' AND li__.price_field_id = '' AND li__.price_field_value_id = '' LEFT JOIN civicrm_line_item li_104_438 ON p.id = li_104_438.entity_id AND li_104_438.entity_table = 'civicrm_participant' AND li_104_438.price_field_id = '104' AND li_104_438.price_field_value_id = '438' LEFT JOIN civicrm_line_item li_105_443 ON p.id = li_105_443.entity_id AND li_105_443.entity_table = 'civicrm_participant' AND li_105_443.price_field_id = '105' AND li_105_443.price_field_value_id = '443' LEFT JOIN civicrm_line_item li_105_440 ON p.id = li_105_440.entity_id AND li_105_440.entity_table = 'civicrm_participant' AND li_105_440.price_field_id = '105' AND li_105_440.price_field_value_id = '440' LEFT JOIN civicrm_line_item li_105_442 ON p.id = li_105_442.entity_id AND li_105_442.entity_table = 'civicrm_participant' AND li_105_442.price_field_id = '105' AND li_105_442.price_field_value_id = '442' LEFT JOIN civicrm_line_item li_105_441 ON p.id = li_105_441.entity_id AND li_105_441.entity_table = 'civicrm_participant' AND li_105_441.price_field_id = '105' AND li_105_441.price_field_value_id = '441' LEFT JOIN civicrm_line_item li_106_445 ON p.id = li_106_445.entity_id AND li_106_445.entity_table = 'civicrm_participant' AND li_106_445.price_field_id = '106' AND li_106_445.price_field_value_id = '445' LEFT JOIN civicrm_line_item li_106_444 ON p.id = li_106_444.entity_id AND li_106_444.entity_table = 'civicrm_participant' AND li_106_444.price_field_id = '106' AND li_106_444.price_field_value_id = '444' LEFT JOIN civicrm_line_item li_107_448 ON p.id = li_107_448.entity_id AND li_107_448.entity_table = 'civicrm_participant' AND li_107_448.price_field_id = '107' AND li_107_448.price_field_value_id = '448' LEFT JOIN civicrm_line_item li_107_447 ON p.id = li_107_447.entity_id AND li_107_447.entity_table = 'civicrm_participant' AND li_107_447.price_field_id = '107' AND li_107_447.price_field_value_id = '447' LEFT JOIN civicrm_line_item li_108_452 ON p.id = li_108_452.entity_id AND li_108_452.entity_table = 'civicrm_participant' AND li_108_452.price_field_id = '108' AND li_108_452.price_field_value_id = '452' LEFT JOIN civicrm_line_item li_108_453 ON p.id = li_108_453.entity_id AND li_108_453.entity_table = 'civicrm_participant' AND li_108_453.price_field_id = '108' AND li_108_453.price_field_value_id = '453' LEFT JOIN civicrm_line_item li_108_450 ON p.id = li_108_450.entity_id AND li_108_450.entity_table = 'civicrm_participant' AND li_108_450.price_field_id = '108' AND li_108_450.price_field_value_id = '450' LEFT JOIN civicrm_line_item li_108_451 ON p.id = li_108_451.entity_id AND li_108_451.entity_table = 'civicrm_participant' AND li_108_451.price_field_id = '108' AND li_108_451.price_field_value_id = '451' LEFT JOIN civicrm_line_item li_109_457 ON p.id = li_109_457.entity_id AND li_109_457.entity_table = 'civicrm_participant' AND li_109_457.price_field_id = '109' AND li_109_457.price_field_value_id = '457' LEFT JOIN civicrm_line_item li_109_456 ON p.id = li_109_456.entity_id AND li_109_456.entity_table = 'civicrm_participant' AND li_109_456.price_field_id = '109' AND li_109_456.price_field_value_id = '456' LEFT JOIN civicrm_line_item li_109_458 ON p.id = li_109_458.entity_id AND li_109_458.entity_table = 'civicrm_participant' AND li_109_458.price_field_id = '109' AND li_109_458.price_field_value_id = '458' LEFT JOIN civicrm_line_item li_109_459 ON p.id = li_109_459.entity_id AND li_109_459.entity_table = 'civicrm_participant' AND li_109_459.price_field_id = '109' AND li_109_459.price_field_value_id = '459' LEFT JOIN civicrm_line_item li_109_455 ON p.id = li_109_455.entity_id AND li_109_455.entity_table = 'civicrm_participant' AND li_109_455.price_field_id = '109' AND li_109_455.price_field_value_id = '455' LEFT JOIN civicrm_line_item li_110_462 ON p.id = li_110_462.entity_id AND li_110_462.entity_table = 'civicrm_participant' AND li_110_462.price_field_id = '110' AND li_110_462.price_field_value_id = '462' LEFT JOIN civicrm_line_item li_110_465 ON p.id = li_110_465.entity_id AND li_110_465.entity_table = 'civicrm_participant' AND li_110_465.price_field_id = '110' AND li_110_465.price_field_value_id = '465' LEFT JOIN civicrm_line_item li_110_464 ON p.id = li_110_464.entity_id AND li_110_464.entity_table = 'civicrm_participant' AND li_110_464.price_field_id = '110' AND li_110_464.price_field_value_id = '464' LEFT JOIN civicrm_line_item li_110_463 ON p.id = li_110_463.entity_id AND li_110_463.entity_table = 'civicrm_participant' AND li_110_463.price_field_id = '110' AND li_110_463.price_field_value_id = '463' LEFT JOIN civicrm_line_item li_110_466 ON p.id = li_110_466.entity_id AND li_110_466.entity_table = 'civicrm_participant' AND li_110_466.price_field_id = '110' AND li_110_466.price_field_value_id = '466' LEFT JOIN civicrm_line_item li_110_535 ON p.id = li_110_535.entity_id AND li_110_535.entity_table = 'civicrm_participant' AND li_110_535.price_field_id = '110' AND li_110_535.price_field_value_id = '535' LEFT JOIN civicrm_line_item li_111_469 ON p.id = li_111_469.entity_id AND li_111_469.entity_table = 'civicrm_participant' AND li_111_469.price_field_id = '111' AND li_111_469.price_field_value_id = '469' LEFT JOIN civicrm_line_item li_111_467 ON p.id = li_111_467.entity_id AND li_111_467.entity_table = 'civicrm_participant' AND li_111_467.price_field_id = '111' AND li_111_467.price_field_value_id = '467' LEFT JOIN civicrm_line_item li_111_470 ON p.id = li_111_470.entity_id AND li_111_470.entity_table = 'civicrm_participant' AND li_111_470.price_field_id = '111' AND li_111_470.price_field_value_id = '470' LEFT JOIN civicrm_line_item li_111_468 ON p.id = li_111_468.entity_id AND li_111_468.entity_table = 'civicrm_participant' AND li_111_468.price_field_id = '111' AND li_111_468.price_field_value_id = '468' LEFT JOIN civicrm_line_item li_112_473 ON p.id = li_112_473.entity_id AND li_112_473.entity_table = 'civicrm_participant' AND li_112_473.price_field_id = '112' AND li_112_473.price_field_value_id = '473' LEFT JOIN civicrm_line_item li_112_471 ON p.id = li_112_471.entity_id AND li_112_471.entity_table = 'civicrm_participant' AND li_112_471.price_field_id = '112' AND li_112_471.price_field_value_id = '471' LEFT JOIN civicrm_line_item li_112_474 ON p.id = li_112_474.entity_id AND li_112_474.entity_table = 'civicrm_participant' AND li_112_474.price_field_id = '112' AND li_112_474.price_field_value_id = '474' LEFT JOIN civicrm_line_item li_112_472 ON p.id = li_112_472.entity_id AND li_112_472.entity_table = 'civicrm_participant' AND li_112_472.price_field_id = '112' AND li_112_472.price_field_value_id = '472' LEFT JOIN civicrm_line_item li_113_479 ON p.id = li_113_479.entity_id AND li_113_479.entity_table = 'civicrm_participant' AND li_113_479.price_field_id = '113' AND li_113_479.price_field_value_id = '479' LEFT JOIN civicrm_line_item li_113_476 ON p.id = li_113_476.entity_id AND li_113_476.entity_table = 'civicrm_participant' AND li_113_476.price_field_id = '113' AND li_113_476.price_field_value_id = '476' LEFT JOIN civicrm_line_item li_113_477 ON p.id = li_113_477.entity_id AND li_113_477.entity_table = 'civicrm_participant' AND li_113_477.price_field_id = '113' AND li_113_477.price_field_value_id = '477' LEFT JOIN civicrm_line_item li_113_478 ON p.id = li_113_478.entity_id AND li_113_478.entity_table = 'civicrm_participant' AND li_113_478.price_field_id = '113' AND li_113_478.price_field_value_id = '478' LEFT JOIN civicrm_line_item li_113_480 ON p.id = li_113_480.entity_id AND li_113_480.entity_table = 'civicrm_participant' AND li_113_480.price_field_id = '113' AND li_113_480.price_field_value_id = '480' LEFT JOIN civicrm_line_item li_114_485 ON p.id = li_114_485.entity_id AND li_114_485.entity_table = 'civicrm_participant' AND li_114_485.price_field_id = '114' AND li_114_485.price_field_value_id = '485' LEFT JOIN civicrm_line_item li_114_482 ON p.id = li_114_482.entity_id AND li_114_482.entity_table = 'civicrm_participant' AND li_114_482.price_field_id = '114' AND li_114_482.price_field_value_id = '482' LEFT JOIN civicrm_line_item li_114_483 ON p.id = li_114_483.entity_id AND li_114_483.entity_table = 'civicrm_participant' AND li_114_483.price_field_id = '114' AND li_114_483.price_field_value_id = '483' LEFT JOIN civicrm_line_item li_114_484 ON p.id = li_114_484.entity_id AND li_114_484.entity_table = 'civicrm_participant' AND li_114_484.price_field_id = '114' AND li_114_484.price_field_value_id = '484' LEFT JOIN civicrm_line_item li_114_486 ON p.id = li_114_486.entity_id AND li_114_486.entity_table = 'civicrm_participant' AND li_114_486.price_field_id = '114' AND li_114_486.price_field_value_id = '486' LEFT JOIN civicrm_line_item li_115_489 ON p.id = li_115_489.entity_id AND li_115_489.entity_table = 'civicrm_participant' AND li_115_489.price_field_id = '115' AND li_115_489.price_field_value_id = '489' LEFT JOIN civicrm_line_item li_115_488 ON p.id = li_115_488.entity_id AND li_115_488.entity_table = 'civicrm_participant' AND li_115_488.price_field_id = '115' AND li_115_488.price_field_value_id = '488' LEFT JOIN civicrm_line_item li_116_492 ON p.id = li_116_492.entity_id AND li_116_492.entity_table = 'civicrm_participant' AND li_116_492.price_field_id = '116' AND li_116_492.price_field_value_id = '492' LEFT JOIN civicrm_line_item li_116_491 ON p.id = li_116_491.entity_id AND li_116_491.entity_table = 'civicrm_participant' AND li_116_491.price_field_id = '116' AND li_116_491.price_field_value_id = '491' LEFT JOIN civicrm_line_item li_117_493 ON p.id = li_117_493.entity_id AND li_117_493.entity_table = 'civicrm_participant' AND li_117_493.price_field_id = '117' AND li_117_493.price_field_value_id = '493' LEFT JOIN civicrm_line_item li_117_494 ON p.id = li_117_494.entity_id AND li_117_494.entity_table = 'civicrm_participant' AND li_117_494.price_field_id = '117' AND li_117_494.price_field_value_id = '494' LEFT JOIN civicrm_line_item li_118_495 ON p.id = li_118_495.entity_id AND li_118_495.entity_table = 'civicrm_participant' AND li_118_495.price_field_id = '118' AND li_118_495.price_field_value_id = '495' LEFT JOIN civicrm_line_item li_118_496 ON p.id = li_118_496.entity_id AND li_118_496.entity_table = 'civicrm_participant' AND li_118_496.price_field_id = '118' AND li_118_496.price_field_value_id = '496' LEFT JOIN civicrm_line_item li_122_501 ON p.id = li_122_501.entity_id AND li_122_501.entity_table = 'civicrm_participant' AND li_122_501.price_field_id = '122' AND li_122_501.price_field_value_id = '501' LEFT JOIN civicrm_line_item li_122_500 ON p.id = li_122_500.entity_id AND li_122_500.entity_table = 'civicrm_participant' AND li_122_500.price_field_id = '122' AND li_122_500.price_field_value_id = '500' LEFT JOIN civicrm_line_item li_124_504 ON p.id = li_124_504.entity_id AND li_124_504.entity_table = 'civicrm_participant' AND li_124_504.price_field_id = '124' AND li_124_504.price_field_value_id = '504' LEFT JOIN civicrm_line_item li_124_505 ON p.id = li_124_505.entity_id AND li_124_505.entity_table = 'civicrm_participant' AND li_124_505.price_field_id = '124' AND li_124_505.price_field_value_id = '505' LEFT JOIN civicrm_line_item li_124_506 ON p.id = li_124_506.entity_id AND li_124_506.entity_table = 'civicrm_participant' AND li_124_506.price_field_id = '124' AND li_124_506.price_field_value_id = '506' LEFT JOIN civicrm_line_item li_124_503 ON p.id = li_124_503.entity_id AND li_124_503.entity_table = 'civicrm_participant' AND li_124_503.price_field_id = '124' AND li_124_503.price_field_value_id = '503' LEFT JOIN civicrm_line_item li_125_507 ON p.id = li_125_507.entity_id AND li_125_507.entity_table = 'civicrm_participant' AND li_125_507.price_field_id = '125' AND li_125_507.price_field_value_id = '507' LEFT JOIN civicrm_line_item li_126_508 ON p.id = li_126_508.entity_id AND li_126_508.entity_table = 'civicrm_participant' AND li_126_508.price_field_id = '126' AND li_126_508.price_field_value_id = '508' LEFT JOIN civicrm_line_item li_127_509 ON p.id = li_127_509.entity_id AND li_127_509.entity_table = 'civicrm_participant' AND li_127_509.price_field_id = '127' AND li_127_509.price_field_value_id = '509' LEFT JOIN civicrm_line_item li_128_510 ON p.id = li_128_510.entity_id AND li_128_510.entity_table = 'civicrm_participant' AND li_128_510.price_field_id = '128' AND li_128_510.price_field_value_id = '510' LEFT JOIN civicrm_line_item li_129_511 ON p.id = li_129_511.entity_id AND li_129_511.entity_table = 'civicrm_participant' AND li_129_511.price_field_id = '129' AND li_129_511.price_field_value_id = '511' LEFT JOIN civicrm_line_item li_130_512 ON p.id = li_130_512.entity_id AND li_130_512.entity_table = 'civicrm_participant' AND li_130_512.price_field_id = '130' AND li_130_512.price_field_value_id = '512' LEFT JOIN civicrm_line_item li_131_513 ON p.id = li_131_513.entity_id AND li_131_513.entity_table = 'civicrm_participant' AND li_131_513.price_field_id = '131' AND li_131_513.price_field_value_id = '513' LEFT JOIN civicrm_line_item li_132_517 ON p.id = li_132_517.entity_id AND li_132_517.entity_table = 'civicrm_participant' AND li_132_517.price_field_id = '132' AND li_132_517.price_field_value_id = '517' LEFT JOIN civicrm_line_item li_132_514 ON p.id = li_132_514.entity_id AND li_132_514.entity_table = 'civicrm_participant' AND li_132_514.price_field_id = '132' AND li_132_514.price_field_value_id = '514' LEFT JOIN civicrm_line_item li_133_518 ON p.id = li_133_518.entity_id AND li_133_518.entity_table = 'civicrm_participant' AND li_133_518.price_field_id = '133' AND li_133_518.price_field_value_id = '518' LEFT JOIN civicrm_line_item li_134_523 ON p.id = li_134_523.entity_id AND li_134_523.entity_table = 'civicrm_participant' AND li_134_523.price_field_id = '134' AND li_134_523.price_field_value_id = '523' LEFT JOIN civicrm_line_item li_134_522 ON p.id = li_134_522.entity_id AND li_134_522.entity_table = 'civicrm_participant' AND li_134_522.price_field_id = '134' AND li_134_522.price_field_value_id = '522' LEFT JOIN civicrm_line_item li_135_525 ON p.id = li_135_525.entity_id AND li_135_525.entity_table = 'civicrm_participant' AND li_135_525.price_field_id = '135' AND li_135_525.price_field_value_id = '525' LEFT JOIN civicrm_line_item li_135_524 ON p.id = li_135_524.entity_id AND li_135_524.entity_table = 'civicrm_participant' AND li_135_524.price_field_id = '135' AND li_135_524.price_field_value_id = '524' LEFT JOIN civicrm_line_item li_138_538 ON p.id = li_138_538.entity_id AND li_138_538.entity_table = 'civicrm_participant' AND li_138_538.price_field_id = '138' AND li_138_538.price_field_value_id = '538' LEFT JOIN civicrm_line_item li_138_537 ON p.id = li_138_537.entity_id AND li_138_537.entity_table = 'civicrm_participant' AND li_138_537.price_field_id = '138' AND li_138_537.price_field_value_id = '537' LEFT JOIN civicrm_line_item li_139_539 ON p.id = li_139_539.entity_id AND li_139_539.entity_table = 'civicrm_participant' AND li_139_539.price_field_id = '139' AND li_139_539.price_field_value_id = '539' LEFT JOIN civicrm_line_item li_139_540 ON p.id = li_139_540.entity_id AND li_139_540.entity_table = 'civicrm_participant' AND li_139_540.price_field_id = '139' AND li_139_540.price_field_value_id = '540' LEFT JOIN civicrm_value_fbe_event_data_25 ON p.id = civicrm_value_fbe_event_data_25.entity_id LEFT JOIN civicrm_value_young_farmer_gathering_registrat_37 ON p.id = civicrm_value_young_farmer_gathering_registrat_37.entity_id
  410. WHERE ( e.id = 21 ) AND status.is_counted = 1 AND (p.is_test <> 1 ) AND (contact_a.is_deleted <> 1) group by p.id AND contact_a.id NOT IN (
  411. SELECT contact_id FROM civicrm_group_contact
  412. WHERE civicrm_group_contact.status = 'Removed'
  413. AND civicrm_group_contact.group_id = 201 ) ); [nativecode=1116 ** Too many tables; MySQL can only use 61 tables in a join]
  414. [type] => DB_Error
  415. [user_info] => CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache62 (Select contact_a.id as contact_id , p.id as participant_id, '' as participant_link,
  416. contact_a.sort_name as display_name, contact_a.first_name, contact_a.last_name,
  417. civicrm_email.email as email, civicrm_phone.phone as phone, civicrm_address.street_address as street_address,
  418. civicrm_address.supplemental_address_1 as supplemental_address_1, civicrm_address.city as city ,civicrm_address.postal_code as postal_code,
  419. civicrm_state_province.abbreviation as state, p.registered_by_id, contact_b.sort_name as registered_by_name,li__.id as li___id,
  420. li__.qty as li___qty,
  421. li__.unit_price as li___unit_price,
  422. li__.line_total as li___line_total,
  423. li__.participant_count as li___participant_count ,
  424. li__.label as li___label, li_104_438.id as li_104_438_id,
  425. li_104_438.qty as li_104_438_qty,
  426. li_104_438.unit_price as li_104_438_unit_price,
  427. li_104_438.line_total as li_104_438_line_total,
  428. li_104_438.participant_count as li_104_438_participant_count ,
  429. li_104_438.label as li_104_438_label, li_105_443.id as li_105_443_id,
  430. li_105_443.qty as li_105_443_qty,
  431. li_105_443.unit_price as li_105_443_unit_price,
  432. li_105_443.line_total as li_105_443_line_total,
  433. li_105_443.participant_count as li_105_443_participant_count ,
  434. li_105_443.label as li_105_443_label, li_105_440.id as li_105_440_id,
  435. li_105_440.qty as li_105_440_qty,
  436. li_105_440.unit_price as li_105_440_unit_price,
  437. li_105_440.line_total as li_105_440_line_total,
  438. li_105_440.participant_count as li_105_440_participant_count ,
  439. li_105_440.label as li_105_440_label, li_105_442.id as li_105_442_id,
  440. li_105_442.qty as li_105_442_qty,
  441. li_105_442.unit_price as li_105_442_unit_price,
  442. li_105_442.line_total as li_105_442_line_total,
  443. li_105_442.participant_count as li_105_442_participant_count ,
  444. li_105_442.label as li_105_442_label, li_105_441.id as li_105_441_id,
  445. li_105_441.qty as li_105_441_qty,
  446. li_105_441.unit_price as li_105_441_unit_price,
  447. li_105_441.line_total as li_105_441_line_total,
  448. li_105_441.participant_count as li_105_441_participant_count ,
  449. li_105_441.label as li_105_441_label, li_106_445.id as li_106_445_id,
  450. li_106_445.qty as li_106_445_qty,
  451. li_106_445.unit_price as li_106_445_unit_price,
  452. li_106_445.line_total as li_106_445_line_total,
  453. li_106_445.participant_count as li_106_445_participant_count ,
  454. li_106_445.label as li_106_445_label, li_106_444.id as li_106_444_id,
  455. li_106_444.qty as li_106_444_qty,
  456. li_106_444.unit_price as li_106_444_unit_price,
  457. li_106_444.line_total as li_106_444_line_total,
  458. li_106_444.participant_count as li_106_444_participant_count ,
  459. li_106_444.label as li_106_444_label, li_107_448.id as li_107_448_id,
  460. li_107_448.qty as li_107_448_qty,
  461. li_107_448.unit_price as li_107_448_unit_price,
  462. li_107_448.line_total as li_107_448_line_total,
  463. li_107_448.participant_count as li_107_448_participant_count ,
  464. li_107_448.label as li_107_448_label, li_107_447.id as li_107_447_id,
  465. li_107_447.qty as li_107_447_qty,
  466. li_107_447.unit_price as li_107_447_unit_price,
  467. li_107_447.line_total as li_107_447_line_total,
  468. li_107_447.participant_count as li_107_447_participant_count ,
  469. li_107_447.label as li_107_447_label, li_108_452.id as li_108_452_id,
  470. li_108_452.qty as li_108_452_qty,
  471. li_108_452.unit_price as li_108_452_unit_price,
  472. li_108_452.line_total as li_108_452_line_total,
  473. li_108_452.participant_count as li_108_452_participant_count ,
  474. li_108_452.label as li_108_452_label, li_108_453.id as li_108_453_id,
  475. li_108_453.qty as li_108_453_qty,
  476. li_108_453.unit_price as li_108_453_unit_price,
  477. li_108_453.line_total as li_108_453_line_total,
  478. li_108_453.participant_count as li_108_453_participant_count ,
  479. li_108_453.label as li_108_453_label, li_108_450.id as li_108_450_id,
  480. li_108_450.qty as li_108_450_qty,
  481. li_108_450.unit_price as li_108_450_unit_price,
  482. li_108_450.line_total as li_108_450_line_total,
  483. li_108_450.participant_count as li_108_450_participant_count ,
  484. li_108_450.label as li_108_450_label, li_108_451.id as li_108_451_id,
  485. li_108_451.qty as li_108_451_qty,
  486. li_108_451.unit_price as li_108_451_unit_price,
  487. li_108_451.line_total as li_108_451_line_total,
  488. li_108_451.participant_count as li_108_451_participant_count ,
  489. li_108_451.label as li_108_451_label, li_109_457.id as li_109_457_id,
  490. li_109_457.qty as li_109_457_qty,
  491. li_109_457.unit_price as li_109_457_unit_price,
  492. li_109_457.line_total as li_109_457_line_total,
  493. li_109_457.participant_count as li_109_457_participant_count ,
  494. li_109_457.label as li_109_457_label, li_109_456.id as li_109_456_id,
  495. li_109_456.qty as li_109_456_qty,
  496. li_109_456.unit_price as li_109_456_unit_price,
  497. li_109_456.line_total as li_109_456_line_total,
  498. li_109_456.participant_count as li_109_456_participant_count ,
  499. li_109_456.label as li_109_456_label, li_109_458.id as li_109_458_id,
  500. li_109_458.qty as li_109_458_qty,
  501. li_109_458.unit_price as li_109_458_unit_price,
  502. li_109_458.line_total as li_109_458_line_total,
  503. li_109_458.participant_count as li_109_458_participant_count ,
  504. li_109_458.label as li_109_458_label, li_109_459.id as li_109_459_id,
  505. li_109_459.qty as li_109_459_qty,
  506. li_109_459.unit_price as li_109_459_unit_price,
  507. li_109_459.line_total as li_109_459_line_total,
  508. li_109_459.participant_count as li_109_459_participant_count ,
  509. li_109_459.label as li_109_459_label, li_109_455.id as li_109_455_id,
  510. li_109_455.qty as li_109_455_qty,
  511. li_109_455.unit_price as li_109_455_unit_price,
  512. li_109_455.line_total as li_109_455_line_total,
  513. li_109_455.participant_count as li_109_455_participant_count ,
  514. li_109_455.label as li_109_455_label, li_110_462.id as li_110_462_id,
  515. li_110_462.qty as li_110_462_qty,
  516. li_110_462.unit_price as li_110_462_unit_price,
  517. li_110_462.line_total as li_110_462_line_total,
  518. li_110_462.participant_count as li_110_462_participant_count ,
  519. li_110_462.label as li_110_462_label, li_110_465.id as li_110_465_id,
  520. li_110_465.qty as li_110_465_qty,
  521. li_110_465.unit_price as li_110_465_unit_price,
  522. li_110_465.line_total as li_110_465_line_total,
  523. li_110_465.participant_count as li_110_465_participant_count ,
  524. li_110_465.label as li_110_465_label, li_110_464.id as li_110_464_id,
  525. li_110_464.qty as li_110_464_qty,
  526. li_110_464.unit_price as li_110_464_unit_price,
  527. li_110_464.line_total as li_110_464_line_total,
  528. li_110_464.participant_count as li_110_464_participant_count ,
  529. li_110_464.label as li_110_464_label, li_110_463.id as li_110_463_id,
  530. li_110_463.qty as li_110_463_qty,
  531. li_110_463.unit_price as li_110_463_unit_price,
  532. li_110_463.line_total as li_110_463_line_total,
  533. li_110_463.participant_count as li_110_463_participant_count ,
  534. li_110_463.label as li_110_463_label, li_110_466.id as li_110_466_id,
  535. li_110_466.qty as li_110_466_qty,
  536. li_110_466.unit_price as li_110_466_unit_price,
  537. li_110_466.line_total as li_110_466_line_total,
  538. li_110_466.participant_count as li_110_466_participant_count ,
  539. li_110_466.label as li_110_466_label, li_110_535.id as li_110_535_id,
  540. li_110_535.qty as li_110_535_qty,
  541. li_110_535.unit_price as li_110_535_unit_price,
  542. li_110_535.line_total as li_110_535_line_total,
  543. li_110_535.participant_count as li_110_535_participant_count ,
  544. li_110_535.label as li_110_535_label, li_111_469.id as li_111_469_id,
  545. li_111_469.qty as li_111_469_qty,
  546. li_111_469.unit_price as li_111_469_unit_price,
  547. li_111_469.line_total as li_111_469_line_total,
  548. li_111_469.participant_count as li_111_469_participant_count ,
  549. li_111_469.label as li_111_469_label, li_111_467.id as li_111_467_id,
  550. li_111_467.qty as li_111_467_qty,
  551. li_111_467.unit_price as li_111_467_unit_price,
  552. li_111_467.line_total as li_111_467_line_total,
  553. li_111_467.participant_count as li_111_467_participant_count ,
  554. li_111_467.label as li_111_467_label, li_111_470.id as li_111_470_id,
  555. li_111_470.qty as li_111_470_qty,
  556. li_111_470.unit_price as li_111_470_unit_price,
  557. li_111_470.line_total as li_111_470_line_total,
  558. li_111_470.participant_count as li_111_470_participant_count ,
  559. li_111_470.label as li_111_470_label, li_111_468.id as li_111_468_id,
  560. li_111_468.qty as li_111_468_qty,
  561. li_111_468.unit_price as li_111_468_unit_price,
  562. li_111_468.line_total as li_111_468_line_total,
  563. li_111_468.participant_count as li_111_468_participant_count ,
  564. li_111_468.label as li_111_468_label, li_112_473.id as li_112_473_id,
  565. li_112_473.qty as li_112_473_qty,
  566. li_112_473.unit_price as li_112_473_unit_price,
  567. li_112_473.line_total as li_112_473_line_total,
  568. li_112_473.participant_count as li_112_473_participant_count ,
  569. li_112_473.label as li_112_473_label, li_112_471.id as li_112_471_id,
  570. li_112_471.qty as li_112_471_qty,
  571. li_112_471.unit_price as li_112_471_unit_price,
  572. li_112_471.line_total as li_112_471_line_total,
  573. li_112_471.participant_count as li_112_471_participant_count ,
  574. li_112_471.label as li_112_471_label, li_112_474.id as li_112_474_id,
  575. li_112_474.qty as li_112_474_qty,
  576. li_112_474.unit_price as li_112_474_unit_price,
  577. li_112_474.line_total as li_112_474_line_total,
  578. li_112_474.participant_count as li_112_474_participant_count ,
  579. li_112_474.label as li_112_474_label, li_112_472.id as li_112_472_id,
  580. li_112_472.qty as li_112_472_qty,
  581. li_112_472.unit_price as li_112_472_unit_price,
  582. li_112_472.line_total as li_112_472_line_total,
  583. li_112_472.participant_count as li_112_472_participant_count ,
  584. li_112_472.label as li_112_472_label, li_113_479.id as li_113_479_id,
  585. li_113_479.qty as li_113_479_qty,
  586. li_113_479.unit_price as li_113_479_unit_price,
  587. li_113_479.line_total as li_113_479_line_total,
  588. li_113_479.participant_count as li_113_479_participant_count ,
  589. li_113_479.label as li_113_479_label, li_113_476.id as li_113_476_id,
  590. li_113_476.qty as li_113_476_qty,
  591. li_113_476.unit_price as li_113_476_unit_price,
  592. li_113_476.line_total as li_113_476_line_total,
  593. li_113_476.participant_count as li_113_476_participant_count ,
  594. li_113_476.label as li_113_476_label, li_113_477.id as li_113_477_id,
  595. li_113_477.qty as li_113_477_qty,
  596. li_113_477.unit_price as li_113_477_unit_price,
  597. li_113_477.line_total as li_113_477_line_total,
  598. li_113_477.participant_count as li_113_477_participant_count ,
  599. li_113_477.label as li_113_477_label, li_113_478.id as li_113_478_id,
  600. li_113_478.qty as li_113_478_qty,
  601. li_113_478.unit_price as li_113_478_unit_price,
  602. li_113_478.line_total as li_113_478_line_total,
  603. li_113_478.participant_count as li_113_478_participant_count ,
  604. li_113_478.label as li_113_478_label, li_113_480.id as li_113_480_id,
  605. li_113_480.qty as li_113_480_qty,
  606. li_113_480.unit_price as li_113_480_unit_price,
  607. li_113_480.line_total as li_113_480_line_total,
  608. li_113_480.participant_count as li_113_480_participant_count ,
  609. li_113_480.label as li_113_480_label, li_114_485.id as li_114_485_id,
  610. li_114_485.qty as li_114_485_qty,
  611. li_114_485.unit_price as li_114_485_unit_price,
  612. li_114_485.line_total as li_114_485_line_total,
  613. li_114_485.participant_count as li_114_485_participant_count ,
  614. li_114_485.label as li_114_485_label, li_114_482.id as li_114_482_id,
  615. li_114_482.qty as li_114_482_qty,
  616. li_114_482.unit_price as li_114_482_unit_price,
  617. li_114_482.line_total as li_114_482_line_total,
  618. li_114_482.participant_count as li_114_482_participant_count ,
  619. li_114_482.label as li_114_482_label, li_114_483.id as li_114_483_id,
  620. li_114_483.qty as li_114_483_qty,
  621. li_114_483.unit_price as li_114_483_unit_price,
  622. li_114_483.line_total as li_114_483_line_total,
  623. li_114_483.participant_count as li_114_483_participant_count ,
  624. li_114_483.label as li_114_483_label, li_114_484.id as li_114_484_id,
  625. li_114_484.qty as li_114_484_qty,
  626. li_114_484.unit_price as li_114_484_unit_price,
  627. li_114_484.line_total as li_114_484_line_total,
  628. li_114_484.participant_count as li_114_484_participant_count ,
  629. li_114_484.label as li_114_484_label, li_114_486.id as li_114_486_id,
  630. li_114_486.qty as li_114_486_qty,
  631. li_114_486.unit_price as li_114_486_unit_price,
  632. li_114_486.line_total as li_114_486_line_total,
  633. li_114_486.participant_count as li_114_486_participant_count ,
  634. li_114_486.label as li_114_486_label, li_115_489.id as li_115_489_id,
  635. li_115_489.qty as li_115_489_qty,
  636. li_115_489.unit_price as li_115_489_unit_price,
  637. li_115_489.line_total as li_115_489_line_total,
  638. li_115_489.participant_count as li_115_489_participant_count ,
  639. li_115_489.label as li_115_489_label, li_115_488.id as li_115_488_id,
  640. li_115_488.qty as li_115_488_qty,
  641. li_115_488.unit_price as li_115_488_unit_price,
  642. li_115_488.line_total as li_115_488_line_total,
  643. li_115_488.participant_count as li_115_488_participant_count ,
  644. li_115_488.label as li_115_488_label, li_116_492.id as li_116_492_id,
  645. li_116_492.qty as li_116_492_qty,
  646. li_116_492.unit_price as li_116_492_unit_price,
  647. li_116_492.line_total as li_116_492_line_total,
  648. li_116_492.participant_count as li_116_492_participant_count ,
  649. li_116_492.label as li_116_492_label, li_116_491.id as li_116_491_id,
  650. li_116_491.qty as li_116_491_qty,
  651. li_116_491.unit_price as li_116_491_unit_price,
  652. li_116_491.line_total as li_116_491_line_total,
  653. li_116_491.participant_count as li_116_491_participant_count ,
  654. li_116_491.label as li_116_491_label, li_117_493.id as li_117_493_id,
  655. li_117_493.qty as li_117_493_qty,
  656. li_117_493.unit_price as li_117_493_unit_price,
  657. li_117_493.line_total as li_117_493_line_total,
  658. li_117_493.participant_count as li_117_493_participant_count ,
  659. li_117_493.label as li_117_493_label, li_117_494.id as li_117_494_id,
  660. li_117_494.qty as li_117_494_qty,
  661. li_117_494.unit_price as li_117_494_unit_price,
  662. li_117_494.line_total as li_117_494_line_total,
  663. li_117_494.participant_count as li_117_494_participant_count ,
  664. li_117_494.label as li_117_494_label, li_118_495.id as li_118_495_id,
  665. li_118_495.qty as li_118_495_qty,
  666. li_118_495.unit_price as li_118_495_unit_price,
  667. li_118_495.line_total as li_118_495_line_total,
  668. li_118_495.participant_count as li_118_495_participant_count ,
  669. li_118_495.label as li_118_495_label, li_118_496.id as li_118_496_id,
  670. li_118_496.qty as li_118_496_qty,
  671. li_118_496.unit_price as li_118_496_unit_price,
  672. li_118_496.line_total as li_118_496_line_total,
  673. li_118_496.participant_count as li_118_496_participant_count ,
  674. li_118_496.label as li_118_496_label, li_122_501.id as li_122_501_id,
  675. li_122_501.qty as li_122_501_qty,
  676. li_122_501.unit_price as li_122_501_unit_price,
  677. li_122_501.line_total as li_122_501_line_total,
  678. li_122_501.participant_count as li_122_501_participant_count ,
  679. li_122_501.label as li_122_501_label, li_122_500.id as li_122_500_id,
  680. li_122_500.qty as li_122_500_qty,
  681. li_122_500.unit_price as li_122_500_unit_price,
  682. li_122_500.line_total as li_122_500_line_total,
  683. li_122_500.participant_count as li_122_500_participant_count ,
  684. li_122_500.label as li_122_500_label, li_124_504.id as li_124_504_id,
  685. li_124_504.qty as li_124_504_qty,
  686. li_124_504.unit_price as li_124_504_unit_price,
  687. li_124_504.line_total as li_124_504_line_total,
  688. li_124_504.participant_count as li_124_504_participant_count ,
  689. li_124_504.label as li_124_504_label, li_124_505.id as li_124_505_id,
  690. li_124_505.qty as li_124_505_qty,
  691. li_124_505.unit_price as li_124_505_unit_price,
  692. li_124_505.line_total as li_124_505_line_total,
  693. li_124_505.participant_count as li_124_505_participant_count ,
  694. li_124_505.label as li_124_505_label, li_124_506.id as li_124_506_id,
  695. li_124_506.qty as li_124_506_qty,
  696. li_124_506.unit_price as li_124_506_unit_price,
  697. li_124_506.line_total as li_124_506_line_total,
  698. li_124_506.participant_count as li_124_506_participant_count ,
  699. li_124_506.label as li_124_506_label, li_124_503.id as li_124_503_id,
  700. li_124_503.qty as li_124_503_qty,
  701. li_124_503.unit_price as li_124_503_unit_price,
  702. li_124_503.line_total as li_124_503_line_total,
  703. li_124_503.participant_count as li_124_503_participant_count ,
  704. li_124_503.label as li_124_503_label, li_125_507.id as li_125_507_id,
  705. li_125_507.qty as li_125_507_qty,
  706. li_125_507.unit_price as li_125_507_unit_price,
  707. li_125_507.line_total as li_125_507_line_total,
  708. li_125_507.participant_count as li_125_507_participant_count ,
  709. li_125_507.label as li_125_507_label, li_126_508.id as li_126_508_id,
  710. li_126_508.qty as li_126_508_qty,
  711. li_126_508.unit_price as li_126_508_unit_price,
  712. li_126_508.line_total as li_126_508_line_total,
  713. li_126_508.participant_count as li_126_508_participant_count ,
  714. li_126_508.label as li_126_508_label, li_127_509.id as li_127_509_id,
  715. li_127_509.qty as li_127_509_qty,
  716. li_127_509.unit_price as li_127_509_unit_price,
  717. li_127_509.line_total as li_127_509_line_total,
  718. li_127_509.participant_count as li_127_509_participant_count ,
  719. li_127_509.label as li_127_509_label, li_128_510.id as li_128_510_id,
  720. li_128_510.qty as li_128_510_qty,
  721. li_128_510.unit_price as li_128_510_unit_price,
  722. li_128_510.line_total as li_128_510_line_total,
  723. li_128_510.participant_count as li_128_510_participant_count ,
  724. li_128_510.label as li_128_510_label, li_129_511.id as li_129_511_id,
  725. li_129_511.qty as li_129_511_qty,
  726. li_129_511.unit_price as li_129_511_unit_price,
  727. li_129_511.line_total as li_129_511_line_total,
  728. li_129_511.participant_count as li_129_511_participant_count ,
  729. li_129_511.label as li_129_511_label, li_130_512.id as li_130_512_id,
  730. li_130_512.qty as li_130_512_qty,
  731. li_130_512.unit_price as li_130_512_unit_price,
  732. li_130_512.line_total as li_130_512_line_total,
  733. li_130_512.participant_count as li_130_512_participant_count ,
  734. li_130_512.label as li_130_512_label, li_131_513.id as li_131_513_id,
  735. li_131_513.qty as li_131_513_qty,
  736. li_131_513.unit_price as li_131_513_unit_price,
  737. li_131_513.line_total as li_131_513_line_total,
  738. li_131_513.participant_count as li_131_513_participant_count ,
  739. li_131_513.label as li_131_513_label, li_132_517.id as li_132_517_id,
  740. li_132_517.qty as li_132_517_qty,
  741. li_132_517.unit_price as li_132_517_unit_price,
  742. li_132_517.line_total as li_132_517_line_total,
  743. li_132_517.participant_count as li_132_517_participant_count ,
  744. li_132_517.label as li_132_517_label, li_132_514.id as li_132_514_id,
  745. li_132_514.qty as li_132_514_qty,
  746. li_132_514.unit_price as li_132_514_unit_price,
  747. li_132_514.line_total as li_132_514_line_total,
  748. li_132_514.participant_count as li_132_514_participant_count ,
  749. li_132_514.label as li_132_514_label, li_133_518.id as li_133_518_id,
  750. li_133_518.qty as li_133_518_qty,
  751. li_133_518.unit_price as li_133_518_unit_price,
  752. li_133_518.line_total as li_133_518_line_total,
  753. li_133_518.participant_count as li_133_518_participant_count ,
  754. li_133_518.label as li_133_518_label, li_134_523.id as li_134_523_id,
  755. li_134_523.qty as li_134_523_qty,
  756. li_134_523.unit_price as li_134_523_unit_price,
  757. li_134_523.line_total as li_134_523_line_total,
  758. li_134_523.participant_count as li_134_523_participant_count ,
  759. li_134_523.label as li_134_523_label, li_134_522.id as li_134_522_id,
  760. li_134_522.qty as li_134_522_qty,
  761. li_134_522.unit_price as li_134_522_unit_price,
  762. li_134_522.line_total as li_134_522_line_total,
  763. li_134_522.participant_count as li_134_522_participant_count ,
  764. li_134_522.label as li_134_522_label, li_135_525.id as li_135_525_id,
  765. li_135_525.qty as li_135_525_qty,
  766. li_135_525.unit_price as li_135_525_unit_price,
  767. li_135_525.line_total as li_135_525_line_total,
  768. li_135_525.participant_count as li_135_525_participant_count ,
  769. li_135_525.label as li_135_525_label, li_135_524.id as li_135_524_id,
  770. li_135_524.qty as li_135_524_qty,
  771. li_135_524.unit_price as li_135_524_unit_price,
  772. li_135_524.line_total as li_135_524_line_total,
  773. li_135_524.participant_count as li_135_524_participant_count ,
  774. li_135_524.label as li_135_524_label, li_138_538.id as li_138_538_id,
  775. li_138_538.qty as li_138_538_qty,
  776. li_138_538.unit_price as li_138_538_unit_price,
  777. li_138_538.line_total as li_138_538_line_total,
  778. li_138_538.participant_count as li_138_538_participant_count ,
  779. li_138_538.label as li_138_538_label, li_138_537.id as li_138_537_id,
  780. li_138_537.qty as li_138_537_qty,
  781. li_138_537.unit_price as li_138_537_unit_price,
  782. li_138_537.line_total as li_138_537_line_total,
  783. li_138_537.participant_count as li_138_537_participant_count ,
  784. li_138_537.label as li_138_537_label, li_139_539.id as li_139_539_id,
  785. li_139_539.qty as li_139_539_qty,
  786. li_139_539.unit_price as li_139_539_unit_price,
  787. li_139_539.line_total as li_139_539_line_total,
  788. li_139_539.participant_count as li_139_539_participant_count ,
  789. li_139_539.label as li_139_539_label, li_139_540.id as li_139_540_id,
  790. li_139_540.qty as li_139_540_qty,
  791. li_139_540.unit_price as li_139_540_unit_price,
  792. li_139_540.line_total as li_139_540_line_total,
  793. li_139_540.participant_count as li_139_540_participant_count ,
  794. li_139_540.label as li_139_540_label, civicrm_value_fbe_event_data_25.describe_your_involvement_in_far_189 , civicrm_value_fbe_event_data_25.lodging_190 , civicrm_value_fbe_event_data_25.are_you_interested_in_carpooling_191 , civicrm_value_fbe_event_data_25.time_arriving_192 , civicrm_value_fbe_event_data_25.place_arriving_193 , civicrm_value_fbe_event_data_25.i_will_be_attending_the_fbea_con_194 , civicrm_value_fbe_event_data_25.i_would_like_to_include_an_addit_195 , civicrm_value_fbe_event_data_25.dietary_restrictions_277 , civicrm_value_fbe_event_data_25.participant_nomination_278 , civicrm_value_young_farmer_gathering_registrat_37.registration_options_264 , civicrm_value_young_farmer_gathering_registrat_37.volunteer_265 , civicrm_value_young_farmer_gathering_registrat_37.how_did_you_hear_about_this_even_266 , e.currency as currency, ((date_format(now(),'%Y') - date_format(contact_a.birth_date,'%Y')) -
  795. (date_format(now(),'00-%m-%d') < date_format(contact_a.birth_date,'00-%m-%d'))) as age,
  796. p.register_date, e.title as event_title, e.start_date as event_start_date,
  797. mt.name as membership_type, ms.label as membership_status , status.label as participant_status_label
  798.  
  799. FROM civicrm_participant p LEFT JOIN civicrm_event e ON p.event_id = e.id
  800. LEFT JOIN civicrm_participant_status_type status ON p.status_id = status.id
  801. Left JOIN civicrm_participant p2 on p.registered_by_id = p2.id
  802. LEFT JOIN civicrm_contact contact_b on p2.contact_id = contact_b.id
  803. JOIN civicrm_contact contact_a on p.contact_id = contact_a.id
  804. left join civicrm_membership m on contact_a.id = m.contact_id
  805. left join civicrm_membership_type mt on m.membership_type_id = mt.id
  806. left join civicrm_membership_status ms on m.status_id = ms.id
  807. left join civicrm_email on contact_a.id = civicrm_email.contact_id
  808. left join civicrm_phone on contact_a.id = civicrm_phone.contact_id
  809. left join civicrm_address on contact_a.id = civicrm_address.contact_id
  810. left join civicrm_state_province on civicrm_address.state_province_id = civicrm_state_province.id LEFT JOIN civicrm_line_item li__ ON p.id = li__.entity_id AND li__.entity_table = 'civicrm_participant' AND li__.price_field_id = '' AND li__.price_field_value_id = '' LEFT JOIN civicrm_line_item li_104_438 ON p.id = li_104_438.entity_id AND li_104_438.entity_table = 'civicrm_participant' AND li_104_438.price_field_id = '104' AND li_104_438.price_field_value_id = '438' LEFT JOIN civicrm_line_item li_105_443 ON p.id = li_105_443.entity_id AND li_105_443.entity_table = 'civicrm_participant' AND li_105_443.price_field_id = '105' AND li_105_443.price_field_value_id = '443' LEFT JOIN civicrm_line_item li_105_440 ON p.id = li_105_440.entity_id AND li_105_440.entity_table = 'civicrm_participant' AND li_105_440.price_field_id = '105' AND li_105_440.price_field_value_id = '440' LEFT JOIN civicrm_line_item li_105_442 ON p.id = li_105_442.entity_id AND li_105_442.entity_table = 'civicrm_participant' AND li_105_442.price_field_id = '105' AND li_105_442.price_field_value_id = '442' LEFT JOIN civicrm_line_item li_105_441 ON p.id = li_105_441.entity_id AND li_105_441.entity_table = 'civicrm_participant' AND li_105_441.price_field_id = '105' AND li_105_441.price_field_value_id = '441' LEFT JOIN civicrm_line_item li_106_445 ON p.id = li_106_445.entity_id AND li_106_445.entity_table = 'civicrm_participant' AND li_106_445.price_field_id = '106' AND li_106_445.price_field_value_id = '445' LEFT JOIN civicrm_line_item li_106_444 ON p.id = li_106_444.entity_id AND li_106_444.entity_table = 'civicrm_participant' AND li_106_444.price_field_id = '106' AND li_106_444.price_field_value_id = '444' LEFT JOIN civicrm_line_item li_107_448 ON p.id = li_107_448.entity_id AND li_107_448.entity_table = 'civicrm_participant' AND li_107_448.price_field_id = '107' AND li_107_448.price_field_value_id = '448' LEFT JOIN civicrm_line_item li_107_447 ON p.id = li_107_447.entity_id AND li_107_447.entity_table = 'civicrm_participant' AND li_107_447.price_field_id = '107' AND li_107_447.price_field_value_id = '447' LEFT JOIN civicrm_line_item li_108_452 ON p.id = li_108_452.entity_id AND li_108_452.entity_table = 'civicrm_participant' AND li_108_452.price_field_id = '108' AND li_108_452.price_field_value_id = '452' LEFT JOIN civicrm_line_item li_108_453 ON p.id = li_108_453.entity_id AND li_108_453.entity_table = 'civicrm_participant' AND li_108_453.price_field_id = '108' AND li_108_453.price_field_value_id = '453' LEFT JOIN civicrm_line_item li_108_450 ON p.id = li_108_450.entity_id AND li_108_450.entity_table = 'civicrm_participant' AND li_108_450.price_field_id = '108' AND li_108_450.price_field_value_id = '450' LEFT JOIN civicrm_line_item li_108_451 ON p.id = li_108_451.entity_id AND li_108_451.entity_table = 'civicrm_participant' AND li_108_451.price_field_id = '108' AND li_108_451.price_field_value_id = '451' LEFT JOIN civicrm_line_item li_109_457 ON p.id = li_109_457.entity_id AND li_109_457.entity_table = 'civicrm_participant' AND li_109_457.price_field_id = '109' AND li_109_457.price_field_value_id = '457' LEFT JOIN civicrm_line_item li_109_456 ON p.id = li_109_456.entity_id AND li_109_456.entity_table = 'civicrm_participant' AND li_109_456.price_field_id = '109' AND li_109_456.price_field_value_id = '456' LEFT JOIN civicrm_line_item li_109_458 ON p.id = li_109_458.entity_id AND li_109_458.entity_table = 'civicrm_participant' AND li_109_458.price_field_id = '109' AND li_109_458.price_field_value_id = '458' LEFT JOIN civicrm_line_item li_109_459 ON p.id = li_109_459.entity_id AND li_109_459.entity_table = 'civicrm_participant' AND li_109_459.price_field_id = '109' AND li_109_459.price_field_value_id = '459' LEFT JOIN civicrm_line_item li_109_455 ON p.id = li_109_455.entity_id AND li_109_455.entity_table = 'civicrm_participant' AND li_109_455.price_field_id = '109' AND li_109_455.price_field_value_id = '455' LEFT JOIN civicrm_line_item li_110_462 ON p.id = li_110_462.entity_id AND li_110_462.entity_table = 'civicrm_participant' AND li_110_462.price_field_id = '110' AND li_110_462.price_field_value_id = '462' LEFT JOIN civicrm_line_item li_110_465 ON p.id = li_110_465.entity_id AND li_110_465.entity_table = 'civicrm_participant' AND li_110_465.price_field_id = '110' AND li_110_465.price_field_value_id = '465' LEFT JOIN civicrm_line_item li_110_464 ON p.id = li_110_464.entity_id AND li_110_464.entity_table = 'civicrm_participant' AND li_110_464.price_field_id = '110' AND li_110_464.price_field_value_id = '464' LEFT JOIN civicrm_line_item li_110_463 ON p.id = li_110_463.entity_id AND li_110_463.entity_table = 'civicrm_participant' AND li_110_463.price_field_id = '110' AND li_110_463.price_field_value_id = '463' LEFT JOIN civicrm_line_item li_110_466 ON p.id = li_110_466.entity_id AND li_110_466.entity_table = 'civicrm_participant' AND li_110_466.price_field_id = '110' AND li_110_466.price_field_value_id = '466' LEFT JOIN civicrm_line_item li_110_535 ON p.id = li_110_535.entity_id AND li_110_535.entity_table = 'civicrm_participant' AND li_110_535.price_field_id = '110' AND li_110_535.price_field_value_id = '535' LEFT JOIN civicrm_line_item li_111_469 ON p.id = li_111_469.entity_id AND li_111_469.entity_table = 'civicrm_participant' AND li_111_469.price_field_id = '111' AND li_111_469.price_field_value_id = '469' LEFT JOIN civicrm_line_item li_111_467 ON p.id = li_111_467.entity_id AND li_111_467.entity_table = 'civicrm_participant' AND li_111_467.price_field_id = '111' AND li_111_467.price_field_value_id = '467' LEFT JOIN civicrm_line_item li_111_470 ON p.id = li_111_470.entity_id AND li_111_470.entity_table = 'civicrm_participant' AND li_111_470.price_field_id = '111' AND li_111_470.price_field_value_id = '470' LEFT JOIN civicrm_line_item li_111_468 ON p.id = li_111_468.entity_id AND li_111_468.entity_table = 'civicrm_participant' AND li_111_468.price_field_id = '111' AND li_111_468.price_field_value_id = '468' LEFT JOIN civicrm_line_item li_112_473 ON p.id = li_112_473.entity_id AND li_112_473.entity_table = 'civicrm_participant' AND li_112_473.price_field_id = '112' AND li_112_473.price_field_value_id = '473' LEFT JOIN civicrm_line_item li_112_471 ON p.id = li_112_471.entity_id AND li_112_471.entity_table = 'civicrm_participant' AND li_112_471.price_field_id = '112' AND li_112_471.price_field_value_id = '471' LEFT JOIN civicrm_line_item li_112_474 ON p.id = li_112_474.entity_id AND li_112_474.entity_table = 'civicrm_participant' AND li_112_474.price_field_id = '112' AND li_112_474.price_field_value_id = '474' LEFT JOIN civicrm_line_item li_112_472 ON p.id = li_112_472.entity_id AND li_112_472.entity_table = 'civicrm_participant' AND li_112_472.price_field_id = '112' AND li_112_472.price_field_value_id = '472' LEFT JOIN civicrm_line_item li_113_479 ON p.id = li_113_479.entity_id AND li_113_479.entity_table = 'civicrm_participant' AND li_113_479.price_field_id = '113' AND li_113_479.price_field_value_id = '479' LEFT JOIN civicrm_line_item li_113_476 ON p.id = li_113_476.entity_id AND li_113_476.entity_table = 'civicrm_participant' AND li_113_476.price_field_id = '113' AND li_113_476.price_field_value_id = '476' LEFT JOIN civicrm_line_item li_113_477 ON p.id = li_113_477.entity_id AND li_113_477.entity_table = 'civicrm_participant' AND li_113_477.price_field_id = '113' AND li_113_477.price_field_value_id = '477' LEFT JOIN civicrm_line_item li_113_478 ON p.id = li_113_478.entity_id AND li_113_478.entity_table = 'civicrm_participant' AND li_113_478.price_field_id = '113' AND li_113_478.price_field_value_id = '478' LEFT JOIN civicrm_line_item li_113_480 ON p.id = li_113_480.entity_id AND li_113_480.entity_table = 'civicrm_participant' AND li_113_480.price_field_id = '113' AND li_113_480.price_field_value_id = '480' LEFT JOIN civicrm_line_item li_114_485 ON p.id = li_114_485.entity_id AND li_114_485.entity_table = 'civicrm_participant' AND li_114_485.price_field_id = '114' AND li_114_485.price_field_value_id = '485' LEFT JOIN civicrm_line_item li_114_482 ON p.id = li_114_482.entity_id AND li_114_482.entity_table = 'civicrm_participant' AND li_114_482.price_field_id = '114' AND li_114_482.price_field_value_id = '482' LEFT JOIN civicrm_line_item li_114_483 ON p.id = li_114_483.entity_id AND li_114_483.entity_table = 'civicrm_participant' AND li_114_483.price_field_id = '114' AND li_114_483.price_field_value_id = '483' LEFT JOIN civicrm_line_item li_114_484 ON p.id = li_114_484.entity_id AND li_114_484.entity_table = 'civicrm_participant' AND li_114_484.price_field_id = '114' AND li_114_484.price_field_value_id = '484' LEFT JOIN civicrm_line_item li_114_486 ON p.id = li_114_486.entity_id AND li_114_486.entity_table = 'civicrm_participant' AND li_114_486.price_field_id = '114' AND li_114_486.price_field_value_id = '486' LEFT JOIN civicrm_line_item li_115_489 ON p.id = li_115_489.entity_id AND li_115_489.entity_table = 'civicrm_participant' AND li_115_489.price_field_id = '115' AND li_115_489.price_field_value_id = '489' LEFT JOIN civicrm_line_item li_115_488 ON p.id = li_115_488.entity_id AND li_115_488.entity_table = 'civicrm_participant' AND li_115_488.price_field_id = '115' AND li_115_488.price_field_value_id = '488' LEFT JOIN civicrm_line_item li_116_492 ON p.id = li_116_492.entity_id AND li_116_492.entity_table = 'civicrm_participant' AND li_116_492.price_field_id = '116' AND li_116_492.price_field_value_id = '492' LEFT JOIN civicrm_line_item li_116_491 ON p.id = li_116_491.entity_id AND li_116_491.entity_table = 'civicrm_participant' AND li_116_491.price_field_id = '116' AND li_116_491.price_field_value_id = '491' LEFT JOIN civicrm_line_item li_117_493 ON p.id = li_117_493.entity_id AND li_117_493.entity_table = 'civicrm_participant' AND li_117_493.price_field_id = '117' AND li_117_493.price_field_value_id = '493' LEFT JOIN civicrm_line_item li_117_494 ON p.id = li_117_494.entity_id AND li_117_494.entity_table = 'civicrm_participant' AND li_117_494.price_field_id = '117' AND li_117_494.price_field_value_id = '494' LEFT JOIN civicrm_line_item li_118_495 ON p.id = li_118_495.entity_id AND li_118_495.entity_table = 'civicrm_participant' AND li_118_495.price_field_id = '118' AND li_118_495.price_field_value_id = '495' LEFT JOIN civicrm_line_item li_118_496 ON p.id = li_118_496.entity_id AND li_118_496.entity_table = 'civicrm_participant' AND li_118_496.price_field_id = '118' AND li_118_496.price_field_value_id = '496' LEFT JOIN civicrm_line_item li_122_501 ON p.id = li_122_501.entity_id AND li_122_501.entity_table = 'civicrm_participant' AND li_122_501.price_field_id = '122' AND li_122_501.price_field_value_id = '501' LEFT JOIN civicrm_line_item li_122_500 ON p.id = li_122_500.entity_id AND li_122_500.entity_table = 'civicrm_participant' AND li_122_500.price_field_id = '122' AND li_122_500.price_field_value_id = '500' LEFT JOIN civicrm_line_item li_124_504 ON p.id = li_124_504.entity_id AND li_124_504.entity_table = 'civicrm_participant' AND li_124_504.price_field_id = '124' AND li_124_504.price_field_value_id = '504' LEFT JOIN civicrm_line_item li_124_505 ON p.id = li_124_505.entity_id AND li_124_505.entity_table = 'civicrm_participant' AND li_124_505.price_field_id = '124' AND li_124_505.price_field_value_id = '505' LEFT JOIN civicrm_line_item li_124_506 ON p.id = li_124_506.entity_id AND li_124_506.entity_table = 'civicrm_participant' AND li_124_506.price_field_id = '124' AND li_124_506.price_field_value_id = '506' LEFT JOIN civicrm_line_item li_124_503 ON p.id = li_124_503.entity_id AND li_124_503.entity_table = 'civicrm_participant' AND li_124_503.price_field_id = '124' AND li_124_503.price_field_value_id = '503' LEFT JOIN civicrm_line_item li_125_507 ON p.id = li_125_507.entity_id AND li_125_507.entity_table = 'civicrm_participant' AND li_125_507.price_field_id = '125' AND li_125_507.price_field_value_id = '507' LEFT JOIN civicrm_line_item li_126_508 ON p.id = li_126_508.entity_id AND li_126_508.entity_table = 'civicrm_participant' AND li_126_508.price_field_id = '126' AND li_126_508.price_field_value_id = '508' LEFT JOIN civicrm_line_item li_127_509 ON p.id = li_127_509.entity_id AND li_127_509.entity_table = 'civicrm_participant' AND li_127_509.price_field_id = '127' AND li_127_509.price_field_value_id = '509' LEFT JOIN civicrm_line_item li_128_510 ON p.id = li_128_510.entity_id AND li_128_510.entity_table = 'civicrm_participant' AND li_128_510.price_field_id = '128' AND li_128_510.price_field_value_id = '510' LEFT JOIN civicrm_line_item li_129_511 ON p.id = li_129_511.entity_id AND li_129_511.entity_table = 'civicrm_participant' AND li_129_511.price_field_id = '129' AND li_129_511.price_field_value_id = '511' LEFT JOIN civicrm_line_item li_130_512 ON p.id = li_130_512.entity_id AND li_130_512.entity_table = 'civicrm_participant' AND li_130_512.price_field_id = '130' AND li_130_512.price_field_value_id = '512' LEFT JOIN civicrm_line_item li_131_513 ON p.id = li_131_513.entity_id AND li_131_513.entity_table = 'civicrm_participant' AND li_131_513.price_field_id = '131' AND li_131_513.price_field_value_id = '513' LEFT JOIN civicrm_line_item li_132_517 ON p.id = li_132_517.entity_id AND li_132_517.entity_table = 'civicrm_participant' AND li_132_517.price_field_id = '132' AND li_132_517.price_field_value_id = '517' LEFT JOIN civicrm_line_item li_132_514 ON p.id = li_132_514.entity_id AND li_132_514.entity_table = 'civicrm_participant' AND li_132_514.price_field_id = '132' AND li_132_514.price_field_value_id = '514' LEFT JOIN civicrm_line_item li_133_518 ON p.id = li_133_518.entity_id AND li_133_518.entity_table = 'civicrm_participant' AND li_133_518.price_field_id = '133' AND li_133_518.price_field_value_id = '518' LEFT JOIN civicrm_line_item li_134_523 ON p.id = li_134_523.entity_id AND li_134_523.entity_table = 'civicrm_participant' AND li_134_523.price_field_id = '134' AND li_134_523.price_field_value_id = '523' LEFT JOIN civicrm_line_item li_134_522 ON p.id = li_134_522.entity_id AND li_134_522.entity_table = 'civicrm_participant' AND li_134_522.price_field_id = '134' AND li_134_522.price_field_value_id = '522' LEFT JOIN civicrm_line_item li_135_525 ON p.id = li_135_525.entity_id AND li_135_525.entity_table = 'civicrm_participant' AND li_135_525.price_field_id = '135' AND li_135_525.price_field_value_id = '525' LEFT JOIN civicrm_line_item li_135_524 ON p.id = li_135_524.entity_id AND li_135_524.entity_table = 'civicrm_participant' AND li_135_524.price_field_id = '135' AND li_135_524.price_field_value_id = '524' LEFT JOIN civicrm_line_item li_138_538 ON p.id = li_138_538.entity_id AND li_138_538.entity_table = 'civicrm_participant' AND li_138_538.price_field_id = '138' AND li_138_538.price_field_value_id = '538' LEFT JOIN civicrm_line_item li_138_537 ON p.id = li_138_537.entity_id AND li_138_537.entity_table = 'civicrm_participant' AND li_138_537.price_field_id = '138' AND li_138_537.price_field_value_id = '537' LEFT JOIN civicrm_line_item li_139_539 ON p.id = li_139_539.entity_id AND li_139_539.entity_table = 'civicrm_participant' AND li_139_539.price_field_id = '139' AND li_139_539.price_field_value_id = '539' LEFT JOIN civicrm_line_item li_139_540 ON p.id = li_139_540.entity_id AND li_139_540.entity_table = 'civicrm_participant' AND li_139_540.price_field_id = '139' AND li_139_540.price_field_value_id = '540' LEFT JOIN civicrm_value_fbe_event_data_25 ON p.id = civicrm_value_fbe_event_data_25.entity_id LEFT JOIN civicrm_value_young_farmer_gathering_registrat_37 ON p.id = civicrm_value_young_farmer_gathering_registrat_37.entity_id
  811. WHERE ( e.id = 21 ) AND status.is_counted = 1 AND (p.is_test <> 1 ) AND (contact_a.is_deleted <> 1) group by p.id AND contact_a.id NOT IN (
  812. SELECT contact_id FROM civicrm_group_contact
  813. WHERE civicrm_group_contact.status = 'Removed'
  814. AND civicrm_group_contact.group_id = 201 ) ); [nativecode=1116 ** Too many tables; MySQL can only use 61 tables in a join]
  815. [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache62 (Select contact_a.id as contact_id , p.id as participant_id, '' as participant_link,
  816. contact_a.sort_name as display_name, contact_a.first_name, contact_a.last_name,
  817. civicrm_email.email as email, civicrm_phone.phone as phone, civicrm_address.street_address as street_address,
  818. civicrm_address.supplemental_address_1 as supplemental_address_1, civicrm_address.city as city ,civicrm_address.postal_code as postal_code,
  819. civicrm_state_province.abbreviation as state, p.registered_by_id, contact_b.sort_name as registered_by_name,li__.id as li___id,
  820. li__.qty as li___qty,
  821. li__.unit_price as li___unit_price,
  822. li__.line_total as li___line_total,
  823. li__.participant_count as li___participant_count ,
  824. li__.label as li___label, li_104_438.id as li_104_438_id,
  825. li_104_438.qty as li_104_438_qty,
  826. li_104_438.unit_price as li_104_438_unit_price,
  827. li_104_438.line_total as li_104_438_line_total,
  828. li_104_438.participant_count as li_104_438_participant_count ,
  829. li_104_438.label as li_104_438_label, li_105_443.id as li_105_443_id,
  830. li_105_443.qty as li_105_443_qty,
  831. li_105_443.unit_price as li_105_443_unit_price,
  832. li_105_443.line_total as li_105_443_line_total,
  833. li_105_443.participant_count as li_105_443_participant_count ,
  834. li_105_443.label as li_105_443_label, li_105_440.id as li_105_440_id,
  835. li_105_440.qty as li_105_440_qty,
  836. li_105_440.unit_price as li_105_440_unit_price,
  837. li_105_440.line_total as li_105_440_line_total,
  838. li_105_440.participant_count as li_105_440_participant_count ,
  839. li_105_440.label as li_105_440_label, li_105_442.id as li_105_442_id,
  840. li_105_442.qty as li_105_442_qty,
  841. li_105_442.unit_price as li_105_442_unit_price,
  842. li_105_442.line_total as li_105_442_line_total,
  843. li_105_442.participant_count as li_105_442_participant_count ,
  844. li_105_442.label as li_105_442_label, li_105_441.id as li_105_441_id,
  845. li_105_441.qty as li_105_441_qty,
  846. li_105_441.unit_price as li_105_441_unit_price,
  847. li_105_441.line_total as li_105_441_line_total,
  848. li_105_441.participant_count as li_105_441_participant_count ,
  849. li_105_441.label as li_105_441_label, li_106_445.id as li_106_445_id,
  850. li_106_445.qty as li_106_445_qty,
  851. li_106_445.unit_price as li_106_445_unit_price,
  852. li_106_445.line_total as li_106_445_line_total,
  853. li_106_445.participant_count as li_106_445_participant_count ,
  854. li_106_445.label as li_106_445_label, li_106_444.id as li_106_444_id,
  855. li_106_444.qty as li_106_444_qty,
  856. li_106_444.unit_price as li_106_444_unit_price,
  857. li_106_444.line_total as li_106_444_line_total,
  858. li_106_444.participant_count as li_106_444_participant_count ,
  859. li_106_444.label as li_106_444_label, li_107_448.id as li_107_448_id,
  860. li_107_448.qty as li_107_448_qty,
  861. li_107_448.unit_price as li_107_448_unit_price,
  862. li_107_448.line_total as li_107_448_line_total,
  863. li_107_448.participant_count as li_107_448_participant_count ,
  864. li_107_448.label as li_107_448_label, li_107_447.id as li_107_447_id,
  865. li_107_447.qty as li_107_447_qty,
  866. li_107_447.unit_price as li_107_447_unit_price,
  867. li_107_447.line_total as li_107_447_line_total,
  868. li_107_447.participant_count as li_107_447_participant_count ,
  869. li_107_447.label as li_107_447_label, li_108_452.id as li_108_452_id,
  870. li_108_452.qty as li_108_452_qty,
  871. li_108_452.unit_price as li_108_452_unit_price,
  872. li_108_452.line_total as li_108_452_line_total,
  873. li_108_452.participant_count as li_108_452_participant_count ,
  874. li_108_452.label as li_108_452_label, li_108_453.id as li_108_453_id,
  875. li_108_453.qty as li_108_453_qty,
  876. li_108_453.unit_price as li_108_453_unit_price,
  877. li_108_453.line_total as li_108_453_line_total,
  878. li_108_453.participant_count as li_108_453_participant_count ,
  879. li_108_453.label as li_108_453_label, li_108_450.id as li_108_450_id,
  880. li_108_450.qty as li_108_450_qty,
  881. li_108_450.unit_price as li_108_450_unit_price,
  882. li_108_450.line_total as li_108_450_line_total,
  883. li_108_450.participant_count as li_108_450_participant_count ,
  884. li_108_450.label as li_108_450_label, li_108_451.id as li_108_451_id,
  885. li_108_451.qty as li_108_451_qty,
  886. li_108_451.unit_price as li_108_451_unit_price,
  887. li_108_451.line_total as li_108_451_line_total,
  888. li_108_451.participant_count as li_108_451_participant_count ,
  889. li_108_451.label as li_108_451_label, li_109_457.id as li_109_457_id,
  890. li_109_457.qty as li_109_457_qty,
  891. li_109_457.unit_price as li_109_457_unit_price,
  892. li_109_457.line_total as li_109_457_line_total,
  893. li_109_457.participant_count as li_109_457_participant_count ,
  894. li_109_457.label as li_109_457_label, li_109_456.id as li_109_456_id,
  895. li_109_456.qty as li_109_456_qty,
  896. li_109_456.unit_price as li_109_456_unit_price,
  897. li_109_456.line_total as li_109_456_line_total,
  898. li_109_456.participant_count as li_109_456_participant_count ,
  899. li_109_456.label as li_109_456_label, li_109_458.id as li_109_458_id,
  900. li_109_458.qty as li_109_458_qty,
  901. li_109_458.unit_price as li_109_458_unit_price,
  902. li_109_458.line_total as li_109_458_line_total,
  903. li_109_458.participant_count as li_109_458_participant_count ,
  904. li_109_458.label as li_109_458_label, li_109_459.id as li_109_459_id,
  905. li_109_459.qty as li_109_459_qty,
  906. li_109_459.unit_price as li_109_459_unit_price,
  907. li_109_459.line_total as li_109_459_line_total,
  908. li_109_459.participant_count as li_109_459_participant_count ,
  909. li_109_459.label as li_109_459_label, li_109_455.id as li_109_455_id,
  910. li_109_455.qty as li_109_455_qty,
  911. li_109_455.unit_price as li_109_455_unit_price,
  912. li_109_455.line_total as li_109_455_line_total,
  913. li_109_455.participant_count as li_109_455_participant_count ,
  914. li_109_455.label as li_109_455_label, li_110_462.id as li_110_462_id,
  915. li_110_462.qty as li_110_462_qty,
  916. li_110_462.unit_price as li_110_462_unit_price,
  917. li_110_462.line_total as li_110_462_line_total,
  918. li_110_462.participant_count as li_110_462_participant_count ,
  919. li_110_462.label as li_110_462_label, li_110_465.id as li_110_465_id,
  920. li_110_465.qty as li_110_465_qty,
  921. li_110_465.unit_price as li_110_465_unit_price,
  922. li_110_465.line_total as li_110_465_line_total,
  923. li_110_465.participant_count as li_110_465_participant_count ,
  924. li_110_465.label as li_110_465_label, li_110_464.id as li_110_464_id,
  925. li_110_464.qty as li_110_464_qty,
  926. li_110_464.unit_price as li_110_464_unit_price,
  927. li_110_464.line_total as li_110_464_line_total,
  928. li_110_464.participant_count as li_110_464_participant_count ,
  929. li_110_464.label as li_110_464_label, li_110_463.id as li_110_463_id,
  930. li_110_463.qty as li_110_463_qty,
  931. li_110_463.unit_price as li_110_463_unit_price,
  932. li_110_463.line_total as li_110_463_line_total,
  933. li_110_463.participant_count as li_110_463_participant_count ,
  934. li_110_463.label as li_110_463_label, li_110_466.id as li_110_466_id,
  935. li_110_466.qty as li_110_466_qty,
  936. li_110_466.unit_price as li_110_466_unit_price,
  937. li_110_466.line_total as li_110_466_line_total,
  938. li_110_466.participant_count as li_110_466_participant_count ,
  939. li_110_466.label as li_110_466_label, li_110_535.id as li_110_535_id,
  940. li_110_535.qty as li_110_535_qty,
  941. li_110_535.unit_price as li_110_535_unit_price,
  942. li_110_535.line_total as li_110_535_line_total,
  943. li_110_535.participant_count as li_110_535_participant_count ,
  944. li_110_535.label as li_110_535_label, li_111_469.id as li_111_469_id,
  945. li_111_469.qty as li_111_469_qty,
  946. li_111_469.unit_price as li_111_469_unit_price,
  947. li_111_469.line_total as li_111_469_line_total,
  948. li_111_469.participant_count as li_111_469_participant_count ,
  949. li_111_469.label as li_111_469_label, li_111_467.id as li_111_467_id,
  950. li_111_467.qty as li_111_467_qty,
  951. li_111_467.unit_price as li_111_467_unit_price,
  952. li_111_467.line_total as li_111_467_line_total,
  953. li_111_467.participant_count as li_111_467_participant_count ,
  954. li_111_467.label as li_111_467_label, li_111_470.id as li_111_470_id,
  955. li_111_470.qty as li_111_470_qty,
  956. li_111_470.unit_price as li_111_470_unit_price,
  957. li_111_470.line_total as li_111_470_line_total,
  958. li_111_470.participant_count as li_111_470_participant_count ,
  959. li_111_470.label as li_111_470_label, li_111_468.id as li_111_468_id,
  960. li_111_468.qty as li_111_468_qty,
  961. li_111_468.unit_price as li_111_468_unit_price,
  962. li_111_468.line_total as li_111_468_line_total,
  963. li_111_468.participant_count as li_111_468_participant_count ,
  964. li_111_468.label as li_111_468_label, li_112_473.id as li_112_473_id,
  965. li_112_473.qty as li_112_473_qty,
  966. li_112_473.unit_price as li_112_473_unit_price,
  967. li_112_473.line_total as li_112_473_line_total,
  968. li_112_473.participant_count as li_112_473_participant_count ,
  969. li_112_473.label as li_112_473_label, li_112_471.id as li_112_471_id,
  970. li_112_471.qty as li_112_471_qty,
  971. li_112_471.unit_price as li_112_471_unit_price,
  972. li_112_471.line_total as li_112_471_line_total,
  973. li_112_471.participant_count as li_112_471_participant_count ,
  974. li_112_471.label as li_112_471_label, li_112_474.id as li_112_474_id,
  975. li_112_474.qty as li_112_474_qty,
  976. li_112_474.unit_price as li_112_474_unit_price,
  977. li_112_474.line_total as li_112_474_line_total,
  978. li_112_474.participant_count as li_112_474_participant_count ,
  979. li_112_474.label as li_112_474_label, li_112_472.id as li_112_472_id,
  980. li_112_472.qty as li_112_472_qty,
  981. li_112_472.unit_price as li_112_472_unit_price,
  982. li_112_472.line_total as li_112_472_line_total,
  983. li_112_472.participant_count as li_112_472_participant_count ,
  984. li_112_472.label as li_112_472_label, li_113_479.id as li_113_479_id,
  985. li_113_479.qty as li_113_479_qty,
  986. li_113_479.unit_price as li_113_479_unit_price,
  987. li_113_479.line_total as li_113_479_line_total,
  988. li_113_479.participant_count as li_113_479_participant_count ,
  989. li_113_479.label as li_113_479_label, li_113_476.id as li_113_476_id,
  990. li_113_476.qty as li_113_476_qty,
  991. li_113_476.unit_price as li_113_476_unit_price,
  992. li_113_476.line_total as li_113_476_line_total,
  993. li_113_476.participant_count as li_113_476_participant_count ,
  994. li_113_476.label as li_113_476_label, li_113_477.id as li_113_477_id,
  995. li_113_477.qty as li_113_477_qty,
  996. li_113_477.unit_price as li_113_477_unit_price,
  997. li_113_477.line_total as li_113_477_line_total,
  998. li_113_477.participant_count as li_113_477_participant_count ,
  999. li_113_477.label as li_113_477_label, li_113_478.id as li_113_478_id,
  1000. li_113_478.qty as li_113_478_qty,
  1001. li_113_478.unit_price as li_113_478_unit_price,
  1002. li_113_478.line_total as li_113_478_line_total,
  1003. li_113_478.participant_count as li_113_478_participant_count ,
  1004. li_113_478.label as li_113_478_label, li_113_480.id as li_113_480_id,
  1005. li_113_480.qty as li_113_480_qty,
  1006. li_113_480.unit_price as li_113_480_unit_price,
  1007. li_113_480.line_total as li_113_480_line_total,
  1008. li_113_480.participant_count as li_113_480_participant_count ,
  1009. li_113_480.label as li_113_480_label, li_114_485.id as li_114_485_id,
  1010. li_114_485.qty as li_114_485_qty,
  1011. li_114_485.unit_price as li_114_485_unit_price,
  1012. li_114_485.line_total as li_114_485_line_total,
  1013. li_114_485.participant_count as li_114_485_participant_count ,
  1014. li_114_485.label as li_114_485_label, li_114_482.id as li_114_482_id,
  1015. li_114_482.qty as li_114_482_qty,
  1016. li_114_482.unit_price as li_114_482_unit_price,
  1017. li_114_482.line_total as li_114_482_line_total,
  1018. li_114_482.participant_count as li_114_482_participant_count ,
  1019. li_114_482.label as li_114_482_label, li_114_483.id as li_114_483_id,
  1020. li_114_483.qty as li_114_483_qty,
  1021. li_114_483.unit_price as li_114_483_unit_price,
  1022. li_114_483.line_total as li_114_483_line_total,
  1023. li_114_483.participant_count as li_114_483_participant_count ,
  1024. li_114_483.label as li_114_483_label, li_114_484.id as li_114_484_id,
  1025. li_114_484.qty as li_114_484_qty,
  1026. li_114_484.unit_price as li_114_484_unit_price,
  1027. li_114_484.line_total as li_114_484_line_total,
  1028. li_114_484.participant_count as li_114_484_participant_count ,
  1029. li_114_484.label as li_114_484_label, li_114_486.id as li_114_486_id,
  1030. li_114_486.qty as li_114_486_qty,
  1031. li_114_486.unit_price as li_114_486_unit_price,
  1032. li_114_486.line_total as li_114_486_line_total,
  1033. li_114_486.participant_count as li_114_486_participant_count ,
  1034. li_114_486.label as li_114_486_label, li_115_489.id as li_115_489_id,
  1035. li_115_489.qty as li_115_489_qty,
  1036. li_115_489.unit_price as li_115_489_unit_price,
  1037. li_115_489.line_total as li_115_489_line_total,
  1038. li_115_489.participant_count as li_115_489_participant_count ,
  1039. li_115_489.label as li_115_489_label, li_115_488.id as li_115_488_id,
  1040. li_115_488.qty as li_115_488_qty,
  1041. li_115_488.unit_price as li_115_488_unit_price,
  1042. li_115_488.line_total as li_115_488_line_total,
  1043. li_115_488.participant_count as li_115_488_participant_count ,
  1044. li_115_488.label as li_115_488_label, li_116_492.id as li_116_492_id,
  1045. li_116_492.qty as li_116_492_qty,
  1046. li_116_492.unit_price as li_116_492_unit_price,
  1047. li_116_492.line_total as li_116_492_line_total,
  1048. li_116_492.participant_count as li_116_492_participant_count ,
  1049. li_116_492.label as li_116_492_label, li_116_491.id as li_116_491_id,
  1050. li_116_491.qty as li_116_491_qty,
  1051. li_116_491.unit_price as li_116_491_unit_price,
  1052. li_116_491.line_total as li_116_491_line_total,
  1053. li_116_491.participant_count as li_116_491_participant_count ,
  1054. li_116_491.label as li_116_491_label, li_117_493.id as li_117_493_id,
  1055. li_117_493.qty as li_117_493_qty,
  1056. li_117_493.unit_price as li_117_493_unit_price,
  1057. li_117_493.line_total as li_117_493_line_total,
  1058. li_117_493.participant_count as li_117_493_participant_count ,
  1059. li_117_493.label as li_117_493_label, li_117_494.id as li_117_494_id,
  1060. li_117_494.qty as li_117_494_qty,
  1061. li_117_494.unit_price as li_117_494_unit_price,
  1062. li_117_494.line_total as li_117_494_line_total,
  1063. li_117_494.participant_count as li_117_494_participant_count ,
  1064. li_117_494.label as li_117_494_label, li_118_495.id as li_118_495_id,
  1065. li_118_495.qty as li_118_495_qty,
  1066. li_118_495.unit_price as li_118_495_unit_price,
  1067. li_118_495.line_total as li_118_495_line_total,
  1068. li_118_495.participant_count as li_118_495_participant_count ,
  1069. li_118_495.label as li_118_495_label, li_118_496.id as li_118_496_id,
  1070. li_118_496.qty as li_118_496_qty,
  1071. li_118_496.unit_price as li_118_496_unit_price,
  1072. li_118_496.line_total as li_118_496_line_total,
  1073. li_118_496.participant_count as li_118_496_participant_count ,
  1074. li_118_496.label as li_118_496_label, li_122_501.id as li_122_501_id,
  1075. li_122_501.qty as li_122_501_qty,
  1076. li_122_501.unit_price as li_122_501_unit_price,
  1077. li_122_501.line_total as li_122_501_line_total,
  1078. li_122_501.participant_count as li_122_501_participant_count ,
  1079. li_122_501.label as li_122_501_label, li_122_500.id as li_122_500_id,
  1080. li_122_500.qty as li_122_500_qty,
  1081. li_122_500.unit_price as li_122_500_unit_price,
  1082. li_122_500.line_total as li_122_500_line_total,
  1083. li_122_500.participant_count as li_122_500_participant_count ,
  1084. li_122_500.label as li_122_500_label, li_124_504.id as li_124_504_id,
  1085. li_124_504.qty as li_124_504_qty,
  1086. li_124_504.unit_price as li_124_504_unit_price,
  1087. li_124_504.line_total as li_124_504_line_total,
  1088. li_124_504.participant_count as li_124_504_participant_count ,
  1089. li_124_504.label as li_124_504_label, li_124_505.id as li_124_505_id,
  1090. li_124_505.qty as li_124_505_qty,
  1091. li_124_505.unit_price as li_124_505_unit_price,
  1092. li_124_505.line_total as li_124_505_line_total,
  1093. li_124_505.participant_count as li_124_505_participant_count ,
  1094. li_124_505.label as li_124_505_label, li_124_506.id as li_124_506_id,
  1095. li_124_506.qty as li_124_506_qty,
  1096. li_124_506.unit_price as li_124_506_unit_price,
  1097. li_124_506.line_total as li_124_506_line_total,
  1098. li_124_506.participant_count as li_124_506_participant_count ,
  1099. li_124_506.label as li_124_506_label, li_124_503.id as li_124_503_id,
  1100. li_124_503.qty as li_124_503_qty,
  1101. li_124_503.unit_price as li_124_503_unit_price,
  1102. li_124_503.line_total as li_124_503_line_total,
  1103. li_124_503.participant_count as li_124_503_participant_count ,
  1104. li_124_503.label as li_124_503_label, li_125_507.id as li_125_507_id,
  1105. li_125_507.qty as li_125_507_qty,
  1106. li_125_507.unit_price as li_125_507_unit_price,
  1107. li_125_507.line_total as li_125_507_line_total,
  1108. li_125_507.participant_count as li_125_507_participant_count ,
  1109. li_125_507.label as li_125_507_label, li_126_508.id as li_126_508_id,
  1110. li_126_508.qty as li_126_508_qty,
  1111. li_126_508.unit_price as li_126_508_unit_price,
  1112. li_126_508.line_total as li_126_508_line_total,
  1113. li_126_508.participant_count as li_126_508_participant_count ,
  1114. li_126_508.label as li_126_508_label, li_127_509.id as li_127_509_id,
  1115. li_127_509.qty as li_127_509_qty,
  1116. li_127_509.unit_price as li_127_509_unit_price,
  1117. li_127_509.line_total as li_127_509_line_total,
  1118. li_127_509.participant_count as li_127_509_participant_count ,
  1119. li_127_509.label as li_127_509_label, li_128_510.id as li_128_510_id,
  1120. li_128_510.qty as li_128_510_qty,
  1121. li_128_510.unit_price as li_128_510_unit_price,
  1122. li_128_510.line_total as li_128_510_line_total,
  1123. li_128_510.participant_count as li_128_510_participant_count ,
  1124. li_128_510.label as li_128_510_label, li_129_511.id as li_129_511_id,
  1125. li_129_511.qty as li_129_511_qty,
  1126. li_129_511.unit_price as li_129_511_unit_price,
  1127. li_129_511.line_total as li_129_511_line_total,
  1128. li_129_511.participant_count as li_129_511_participant_count ,
  1129. li_129_511.label as li_129_511_label, li_130_512.id as li_130_512_id,
  1130. li_130_512.qty as li_130_512_qty,
  1131. li_130_512.unit_price as li_130_512_unit_price,
  1132. li_130_512.line_total as li_130_512_line_total,
  1133. li_130_512.participant_count as li_130_512_participant_count ,
  1134. li_130_512.label as li_130_512_label, li_131_513.id as li_131_513_id,
  1135. li_131_513.qty as li_131_513_qty,
  1136. li_131_513.unit_price as li_131_513_unit_price,
  1137. li_131_513.line_total as li_131_513_line_total,
  1138. li_131_513.participant_count as li_131_513_participant_count ,
  1139. li_131_513.label as li_131_513_label, li_132_517.id as li_132_517_id,
  1140. li_132_517.qty as li_132_517_qty,
  1141. li_132_517.unit_price as li_132_517_unit_price,
  1142. li_132_517.line_total as li_132_517_line_total,
  1143. li_132_517.participant_count as li_132_517_participant_count ,
  1144. li_132_517.label as li_132_517_label, li_132_514.id as li_132_514_id,
  1145. li_132_514.qty as li_132_514_qty,
  1146. li_132_514.unit_price as li_132_514_unit_price,
  1147. li_132_514.line_total as li_132_514_line_total,
  1148. li_132_514.participant_count as li_132_514_participant_count ,
  1149. li_132_514.label as li_132_514_label, li_133_518.id as li_133_518_id,
  1150. li_133_518.qty as li_133_518_qty,
  1151. li_133_518.unit_price as li_133_518_unit_price,
  1152. li_133_518.line_total as li_133_518_line_total,
  1153. li_133_518.participant_count as li_133_518_participant_count ,
  1154. li_133_518.label as li_133_518_label, li_134_523.id as li_134_523_id,
  1155. li_134_523.qty as li_134_523_qty,
  1156. li_134_523.unit_price as li_134_523_unit_price,
  1157. li_134_523.line_total as li_134_523_line_total,
  1158. li_134_523.participant_count as li_134_523_participant_count ,
  1159. li_134_523.label as li_134_523_label, li_134_522.id as li_134_522_id,
  1160. li_134_522.qty as li_134_522_qty,
  1161. li_134_522.unit_price as li_134_522_unit_price,
  1162. li_134_522.line_total as li_134_522_line_total,
  1163. li_134_522.participant_count as li_134_522_participant_count ,
  1164. li_134_522.label as li_134_522_label, li_135_525.id as li_135_525_id,
  1165. li_135_525.qty as li_135_525_qty,
  1166. li_135_525.unit_price as li_135_525_unit_price,
  1167. li_135_525.line_total as li_135_525_line_total,
  1168. li_135_525.participant_count as li_135_525_participant_count ,
  1169. li_135_525.label as li_135_525_label, li_135_524.id as li_135_524_id,
  1170. li_135_524.qty as li_135_524_qty,
  1171. li_135_524.unit_price as li_135_524_unit_price,
  1172. li_135_524.line_total as li_135_524_line_total,
  1173. li_135_524.participant_count as li_135_524_participant_count ,
  1174. li_135_524.label as li_135_524_label, li_138_538.id as li_138_538_id,
  1175. li_138_538.qty as li_138_538_qty,
  1176. li_138_538.unit_price as li_138_538_unit_price,
  1177. li_138_538.line_total as li_138_538_line_total,
  1178. li_138_538.participant_count as li_138_538_participant_count ,
  1179. li_138_538.label as li_138_538_label, li_138_537.id as li_138_537_id,
  1180. li_138_537.qty as li_138_537_qty,
  1181. li_138_537.unit_price as li_138_537_unit_price,
  1182. li_138_537.line_total as li_138_537_line_total,
  1183. li_138_537.participant_count as li_138_537_participant_count ,
  1184. li_138_537.label as li_138_537_label, li_139_539.id as li_139_539_id,
  1185. li_139_539.qty as li_139_539_qty,
  1186. li_139_539.unit_price as li_139_539_unit_price,
  1187. li_139_539.line_total as li_139_539_line_total,
  1188. li_139_539.participant_count as li_139_539_participant_count ,
  1189. li_139_539.label as li_139_539_label, li_139_540.id as li_139_540_id,
  1190. li_139_540.qty as li_139_540_qty,
  1191. li_139_540.unit_price as li_139_540_unit_price,
  1192. li_139_540.line_total as li_139_540_line_total,
  1193. li_139_540.participant_count as li_139_540_participant_count ,
  1194. li_139_540.label as li_139_540_label, civicrm_value_fbe_event_data_25.describe_your_involvement_in_far_189 , civicrm_value_fbe_event_data_25.lodging_190 , civicrm_value_fbe_event_data_25.are_you_interested_in_carpooling_191 , civicrm_value_fbe_event_data_25.time_arriving_192 , civicrm_value_fbe_event_data_25.place_arriving_193 , civicrm_value_fbe_event_data_25.i_will_be_attending_the_fbea_con_194 , civicrm_value_fbe_event_data_25.i_would_like_to_include_an_addit_195 , civicrm_value_fbe_event_data_25.dietary_restrictions_277 , civicrm_value_fbe_event_data_25.participant_nomination_278 , civicrm_value_young_farmer_gathering_registrat_37.registration_options_264 , civicrm_value_young_farmer_gathering_registrat_37.volunteer_265 , civicrm_value_young_farmer_gathering_registrat_37.how_did_you_hear_about_this_even_266 , e.currency as currency, ((date_format(now(),'%Y') - date_format(contact_a.birth_date,'%Y')) -
  1195. (date_format(now(),'00-%m-%d') < date_format(contact_a.birth_date,'00-%m-%d'))) as age,
  1196. p.register_date, e.title as event_title, e.start_date as event_start_date,
  1197. mt.name as membership_type, ms.label as membership_status , status.label as participant_status_label
  1198.  
  1199. FROM civicrm_participant p LEFT JOIN civicrm_event e ON p.event_id = e.id
  1200. LEFT JOIN civicrm_participant_status_type status ON p.status_id = status.id
  1201. Left JOIN civicrm_participant p2 on p.registered_by_id = p2.id
  1202. LEFT JOIN civicrm_contact contact_b on p2.contact_id = contact_b.id
  1203. JOIN civicrm_contact contact_a on p.contact_id = contact_a.id
  1204. left join civicrm_membership m on contact_a.id = m.contact_id
  1205. left join civicrm_membership_type mt on m.membership_type_id = mt.id
  1206. left join civicrm_membership_status ms on m.status_id = ms.id
  1207. left join civicrm_email on contact_a.id = civicrm_email.contact_id
  1208. left join civicrm_phone on contact_a.id = civicrm_phone.contact_id
  1209. left join civicrm_address on contact_a.id = civicrm_address.contact_id
  1210. left join civicrm_state_province on civicrm_address.state_province_id = civicrm_state_province.id LEFT JOIN civicrm_line_item li__ ON p.id = li__.entity_id AND li__.entity_table = 'civicrm_participant' AND li__.price_field_id = '' AND li__.price_field_value_id = '' LEFT JOIN civicrm_line_item li_104_438 ON p.id = li_104_438.entity_id AND li_104_438.entity_table = 'civicrm_participant' AND li_104_438.price_field_id = '104' AND li_104_438.price_field_value_id = '438' LEFT JOIN civicrm_line_item li_105_443 ON p.id = li_105_443.entity_id AND li_105_443.entity_table = 'civicrm_participant' AND li_105_443.price_field_id = '105' AND li_105_443.price_field_value_id = '443' LEFT JOIN civicrm_line_item li_105_440 ON p.id = li_105_440.entity_id AND li_105_440.entity_table = 'civicrm_participant' AND li_105_440.price_field_id = '105' AND li_105_440.price_field_value_id = '440' LEFT JOIN civicrm_line_item li_105_442 ON p.id = li_105_442.entity_id AND li_105_442.entity_table = 'civicrm_participant' AND li_105_442.price_field_id = '105' AND li_105_442.price_field_value_id = '442' LEFT JOIN civicrm_line_item li_105_441 ON p.id = li_105_441.entity_id AND li_105_441.entity_table = 'civicrm_participant' AND li_105_441.price_field_id = '105' AND li_105_441.price_field_value_id = '441' LEFT JOIN civicrm_line_item li_106_445 ON p.id = li_106_445.entity_id AND li_106_445.entity_table = 'civicrm_participant' AND li_106_445.price_field_id = '106' AND li_106_445.price_field_value_id = '445' LEFT JOIN civicrm_line_item li_106_444 ON p.id = li_106_444.entity_id AND li_106_444.entity_table = 'civicrm_participant' AND li_106_444.price_field_id = '106' AND li_106_444.price_field_value_id = '444' LEFT JOIN civicrm_line_item li_107_448 ON p.id = li_107_448.entity_id AND li_107_448.entity_table = 'civicrm_participant' AND li_107_448.price_field_id = '107' AND li_107_448.price_field_value_id = '448' LEFT JOIN civicrm_line_item li_107_447 ON p.id = li_107_447.entity_id AND li_107_447.entity_table = 'civicrm_participant' AND li_107_447.price_field_id = '107' AND li_107_447.price_field_value_id = '447' LEFT JOIN civicrm_line_item li_108_452 ON p.id = li_108_452.entity_id AND li_108_452.entity_table = 'civicrm_participant' AND li_108_452.price_field_id = '108' AND li_108_452.price_field_value_id = '452' LEFT JOIN civicrm_line_item li_108_453 ON p.id = li_108_453.entity_id AND li_108_453.entity_table = 'civicrm_participant' AND li_108_453.price_field_id = '108' AND li_108_453.price_field_value_id = '453' LEFT JOIN civicrm_line_item li_108_450 ON p.id = li_108_450.entity_id AND li_108_450.entity_table = 'civicrm_participant' AND li_108_450.price_field_id = '108' AND li_108_450.price_field_value_id = '450' LEFT JOIN civicrm_line_item li_108_451 ON p.id = li_108_451.entity_id AND li_108_451.entity_table = 'civicrm_participant' AND li_108_451.price_field_id = '108' AND li_108_451.price_field_value_id = '451' LEFT JOIN civicrm_line_item li_109_457 ON p.id = li_109_457.entity_id AND li_109_457.entity_table = 'civicrm_participant' AND li_109_457.price_field_id = '109' AND li_109_457.price_field_value_id = '457' LEFT JOIN civicrm_line_item li_109_456 ON p.id = li_109_456.entity_id AND li_109_456.entity_table = 'civicrm_participant' AND li_109_456.price_field_id = '109' AND li_109_456.price_field_value_id = '456' LEFT JOIN civicrm_line_item li_109_458 ON p.id = li_109_458.entity_id AND li_109_458.entity_table = 'civicrm_participant' AND li_109_458.price_field_id = '109' AND li_109_458.price_field_value_id = '458' LEFT JOIN civicrm_line_item li_109_459 ON p.id = li_109_459.entity_id AND li_109_459.entity_table = 'civicrm_participant' AND li_109_459.price_field_id = '109' AND li_109_459.price_field_value_id = '459' LEFT JOIN civicrm_line_item li_109_455 ON p.id = li_109_455.entity_id AND li_109_455.entity_table = 'civicrm_participant' AND li_109_455.price_field_id = '109' AND li_109_455.price_field_value_id = '455' LEFT JOIN civicrm_line_item li_110_462 ON p.id = li_110_462.entity_id AND li_110_462.entity_table = 'civicrm_participant' AND li_110_462.price_field_id = '110' AND li_110_462.price_field_value_id = '462' LEFT JOIN civicrm_line_item li_110_465 ON p.id = li_110_465.entity_id AND li_110_465.entity_table = 'civicrm_participant' AND li_110_465.price_field_id = '110' AND li_110_465.price_field_value_id = '465' LEFT JOIN civicrm_line_item li_110_464 ON p.id = li_110_464.entity_id AND li_110_464.entity_table = 'civicrm_participant' AND li_110_464.price_field_id = '110' AND li_110_464.price_field_value_id = '464' LEFT JOIN civicrm_line_item li_110_463 ON p.id = li_110_463.entity_id AND li_110_463.entity_table = 'civicrm_participant' AND li_110_463.price_field_id = '110' AND li_110_463.price_field_value_id = '463' LEFT JOIN civicrm_line_item li_110_466 ON p.id = li_110_466.entity_id AND li_110_466.entity_table = 'civicrm_participant' AND li_110_466.price_field_id = '110' AND li_110_466.price_field_value_id = '466' LEFT JOIN civicrm_line_item li_110_535 ON p.id = li_110_535.entity_id AND li_110_535.entity_table = 'civicrm_participant' AND li_110_535.price_field_id = '110' AND li_110_535.price_field_value_id = '535' LEFT JOIN civicrm_line_item li_111_469 ON p.id = li_111_469.entity_id AND li_111_469.entity_table = 'civicrm_participant' AND li_111_469.price_field_id = '111' AND li_111_469.price_field_value_id = '469' LEFT JOIN civicrm_line_item li_111_467 ON p.id = li_111_467.entity_id AND li_111_467.entity_table = 'civicrm_participant' AND li_111_467.price_field_id = '111' AND li_111_467.price_field_value_id = '467' LEFT JOIN civicrm_line_item li_111_470 ON p.id = li_111_470.entity_id AND li_111_470.entity_table = 'civicrm_participant' AND li_111_470.price_field_id = '111' AND li_111_470.price_field_value_id = '470' LEFT JOIN civicrm_line_item li_111_468 ON p.id = li_111_468.entity_id AND li_111_468.entity_table = 'civicrm_participant' AND li_111_468.price_field_id = '111' AND li_111_468.price_field_value_id = '468' LEFT JOIN civicrm_line_item li_112_473 ON p.id = li_112_473.entity_id AND li_112_473.entity_table = 'civicrm_participant' AND li_112_473.price_field_id = '112' AND li_112_473.price_field_value_id = '473' LEFT JOIN civicrm_line_item li_112_471 ON p.id = li_112_471.entity_id AND li_112_471.entity_table = 'civicrm_participant' AND li_112_471.price_field_id = '112' AND li_112_471.price_field_value_id = '471' LEFT JOIN civicrm_line_item li_112_474 ON p.id = li_112_474.entity_id AND li_112_474.entity_table = 'civicrm_participant' AND li_112_474.price_field_id = '112' AND li_112_474.price_field_value_id = '474' LEFT JOIN civicrm_line_item li_112_472 ON p.id = li_112_472.entity_id AND li_112_472.entity_table = 'civicrm_participant' AND li_112_472.price_field_id = '112' AND li_112_472.price_field_value_id = '472' LEFT JOIN civicrm_line_item li_113_479 ON p.id = li_113_479.entity_id AND li_113_479.entity_table = 'civicrm_participant' AND li_113_479.price_field_id = '113' AND li_113_479.price_field_value_id = '479' LEFT JOIN civicrm_line_item li_113_476 ON p.id = li_113_476.entity_id AND li_113_476.entity_table = 'civicrm_participant' AND li_113_476.price_field_id = '113' AND li_113_476.price_field_value_id = '476' LEFT JOIN civicrm_line_item li_113_477 ON p.id = li_113_477.entity_id AND li_113_477.entity_table = 'civicrm_participant' AND li_113_477.price_field_id = '113' AND li_113_477.price_field_value_id = '477' LEFT JOIN civicrm_line_item li_113_478 ON p.id = li_113_478.entity_id AND li_113_478.entity_table = 'civicrm_participant' AND li_113_478.price_field_id = '113' AND li_113_478.price_field_value_id = '478' LEFT JOIN civicrm_line_item li_113_480 ON p.id = li_113_480.entity_id AND li_113_480.entity_table = 'civicrm_participant' AND li_113_480.price_field_id = '113' AND li_113_480.price_field_value_id = '480' LEFT JOIN civicrm_line_item li_114_485 ON p.id = li_114_485.entity_id AND li_114_485.entity_table = 'civicrm_participant' AND li_114_485.price_field_id = '114' AND li_114_485.price_field_value_id = '485' LEFT JOIN civicrm_line_item li_114_482 ON p.id = li_114_482.entity_id AND li_114_482.entity_table = 'civicrm_participant' AND li_114_482.price_field_id = '114' AND li_114_482.price_field_value_id = '482' LEFT JOIN civicrm_line_item li_114_483 ON p.id = li_114_483.entity_id AND li_114_483.entity_table = 'civicrm_participant' AND li_114_483.price_field_id = '114' AND li_114_483.price_field_value_id = '483' LEFT JOIN civicrm_line_item li_114_484 ON p.id = li_114_484.entity_id AND li_114_484.entity_table = 'civicrm_participant' AND li_114_484.price_field_id = '114' AND li_114_484.price_field_value_id = '484' LEFT JOIN civicrm_line_item li_114_486 ON p.id = li_114_486.entity_id AND li_114_486.entity_table = 'civicrm_participant' AND li_114_486.price_field_id = '114' AND li_114_486.price_field_value_id = '486' LEFT JOIN civicrm_line_item li_115_489 ON p.id = li_115_489.entity_id AND li_115_489.entity_table = 'civicrm_participant' AND li_115_489.price_field_id = '115' AND li_115_489.price_field_value_id = '489' LEFT JOIN civicrm_line_item li_115_488 ON p.id = li_115_488.entity_id AND li_115_488.entity_table = 'civicrm_participant' AND li_115_488.price_field_id = '115' AND li_115_488.price_field_value_id = '488' LEFT JOIN civicrm_line_item li_116_492 ON p.id = li_116_492.entity_id AND li_116_492.entity_table = 'civicrm_participant' AND li_116_492.price_field_id = '116' AND li_116_492.price_field_value_id = '492' LEFT JOIN civicrm_line_item li_116_491 ON p.id = li_116_491.entity_id AND li_116_491.entity_table = 'civicrm_participant' AND li_116_491.price_field_id = '116' AND li_116_491.price_field_value_id = '491' LEFT JOIN civicrm_line_item li_117_493 ON p.id = li_117_493.entity_id AND li_117_493.entity_table = 'civicrm_participant' AND li_117_493.price_field_id = '117' AND li_117_493.price_field_value_id = '493' LEFT JOIN civicrm_line_item li_117_494 ON p.id = li_117_494.entity_id AND li_117_494.entity_table = 'civicrm_participant' AND li_117_494.price_field_id = '117' AND li_117_494.price_field_value_id = '494' LEFT JOIN civicrm_line_item li_118_495 ON p.id = li_118_495.entity_id AND li_118_495.entity_table = 'civicrm_participant' AND li_118_495.price_field_id = '118' AND li_118_495.price_field_value_id = '495' LEFT JOIN civicrm_line_item li_118_496 ON p.id = li_118_496.entity_id AND li_118_496.entity_table = 'civicrm_participant' AND li_118_496.price_field_id = '118' AND li_118_496.price_field_value_id = '496' LEFT JOIN civicrm_line_item li_122_501 ON p.id = li_122_501.entity_id AND li_122_501.entity_table = 'civicrm_participant' AND li_122_501.price_field_id = '122' AND li_122_501.price_field_value_id = '501' LEFT JOIN civicrm_line_item li_122_500 ON p.id = li_122_500.entity_id AND li_122_500.entity_table = 'civicrm_participant' AND li_122_500.price_field_id = '122' AND li_122_500.price_field_value_id = '500' LEFT JOIN civicrm_line_item li_124_504 ON p.id = li_124_504.entity_id AND li_124_504.entity_table = 'civicrm_participant' AND li_124_504.price_field_id = '124' AND li_124_504.price_field_value_id = '504' LEFT JOIN civicrm_line_item li_124_505 ON p.id = li_124_505.entity_id AND li_124_505.entity_table = 'civicrm_participant' AND li_124_505.price_field_id = '124' AND li_124_505.price_field_value_id = '505' LEFT JOIN civicrm_line_item li_124_506 ON p.id = li_124_506.entity_id AND li_124_506.entity_table = 'civicrm_participant' AND li_124_506.price_field_id = '124' AND li_124_506.price_field_value_id = '506' LEFT JOIN civicrm_line_item li_124_503 ON p.id = li_124_503.entity_id AND li_124_503.entity_table = 'civicrm_participant' AND li_124_503.price_field_id = '124' AND li_124_503.price_field_value_id = '503' LEFT JOIN civicrm_line_item li_125_507 ON p.id = li_125_507.entity_id AND li_125_507.entity_table = 'civicrm_participant' AND li_125_507.price_field_id = '125' AND li_125_507.price_field_value_id = '507' LEFT JOIN civicrm_line_item li_126_508 ON p.id = li_126_508.entity_id AND li_126_508.entity_table = 'civicrm_participant' AND li_126_508.price_field_id = '126' AND li_126_508.price_field_value_id = '508' LEFT JOIN civicrm_line_item li_127_509 ON p.id = li_127_509.entity_id AND li_127_509.entity_table = 'civicrm_participant' AND li_127_509.price_field_id = '127' AND li_127_509.price_field_value_id = '509' LEFT JOIN civicrm_line_item li_128_510 ON p.id = li_128_510.entity_id AND li_128_510.entity_table = 'civicrm_participant' AND li_128_510.price_field_id = '128' AND li_128_510.price_field_value_id = '510' LEFT JOIN civicrm_line_item li_129_511 ON p.id = li_129_511.entity_id AND li_129_511.entity_table = 'civicrm_participant' AND li_129_511.price_field_id = '129' AND li_129_511.price_field_value_id = '511' LEFT JOIN civicrm_line_item li_130_512 ON p.id = li_130_512.entity_id AND li_130_512.entity_table = 'civicrm_participant' AND li_130_512.price_field_id = '130' AND li_130_512.price_field_value_id = '512' LEFT JOIN civicrm_line_item li_131_513 ON p.id = li_131_513.entity_id AND li_131_513.entity_table = 'civicrm_participant' AND li_131_513.price_field_id = '131' AND li_131_513.price_field_value_id = '513' LEFT JOIN civicrm_line_item li_132_517 ON p.id = li_132_517.entity_id AND li_132_517.entity_table = 'civicrm_participant' AND li_132_517.price_field_id = '132' AND li_132_517.price_field_value_id = '517' LEFT JOIN civicrm_line_item li_132_514 ON p.id = li_132_514.entity_id AND li_132_514.entity_table = 'civicrm_participant' AND li_132_514.price_field_id = '132' AND li_132_514.price_field_value_id = '514' LEFT JOIN civicrm_line_item li_133_518 ON p.id = li_133_518.entity_id AND li_133_518.entity_table = 'civicrm_participant' AND li_133_518.price_field_id = '133' AND li_133_518.price_field_value_id = '518' LEFT JOIN civicrm_line_item li_134_523 ON p.id = li_134_523.entity_id AND li_134_523.entity_table = 'civicrm_participant' AND li_134_523.price_field_id = '134' AND li_134_523.price_field_value_id = '523' LEFT JOIN civicrm_line_item li_134_522 ON p.id = li_134_522.entity_id AND li_134_522.entity_table = 'civicrm_participant' AND li_134_522.price_field_id = '134' AND li_134_522.price_field_value_id = '522' LEFT JOIN civicrm_line_item li_135_525 ON p.id = li_135_525.entity_id AND li_135_525.entity_table = 'civicrm_participant' AND li_135_525.price_field_id = '135' AND li_135_525.price_field_value_id = '525' LEFT JOIN civicrm_line_item li_135_524 ON p.id = li_135_524.entity_id AND li_135_524.entity_table = 'civicrm_participant' AND li_135_524.price_field_id = '135' AND li_135_524.price_field_value_id = '524' LEFT JOIN civicrm_line_item li_138_538 ON p.id = li_138_538.entity_id AND li_138_538.entity_table = 'civicrm_participant' AND li_138_538.price_field_id = '138' AND li_138_538.price_field_value_id = '538' LEFT JOIN civicrm_line_item li_138_537 ON p.id = li_138_537.entity_id AND li_138_537.entity_table = 'civicrm_participant' AND li_138_537.price_field_id = '138' AND li_138_537.price_field_value_id = '537' LEFT JOIN civicrm_line_item li_139_539 ON p.id = li_139_539.entity_id AND li_139_539.entity_table = 'civicrm_participant' AND li_139_539.price_field_id = '139' AND li_139_539.price_field_value_id = '539' LEFT JOIN civicrm_line_item li_139_540 ON p.id = li_139_540.entity_id AND li_139_540.entity_table = 'civicrm_participant' AND li_139_540.price_field_id = '139' AND li_139_540.price_field_value_id = '540' LEFT JOIN civicrm_value_fbe_event_data_25 ON p.id = civicrm_value_fbe_event_data_25.entity_id LEFT JOIN civicrm_value_young_farmer_gathering_registrat_37 ON p.id = civicrm_value_young_farmer_gathering_registrat_37.entity_id
  1211. WHERE ( e.id = 21 ) AND status.is_counted = 1 AND (p.is_test <> 1 ) AND (contact_a.is_deleted <> 1) group by p.id AND contact_a.id NOT IN (
  1212. SELECT contact_id FROM civicrm_group_contact
  1213. WHERE civicrm_group_contact.status = 'Removed'
  1214. AND civicrm_group_contact.group_id = 201 ) ); [nativecode=1116 ** Too many tables; MySQL can only use 61 tables in a join]"]
  1215. )
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!