API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 21st, 2011
129
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 188.14 KB | None | 0 0
raw download clone embed print report
  1. 0 email processed ran at: 2011-06-21 17:30:08 50.6108932495
  2. Array
  3. (
  4. [0] => SELECT config_backend, locales, locale_custom_strings
  5. FROM civicrm_domain
  6.  
  7. WHERE ( civicrm_domain.id = 1 )
  8.  
  9.  
  10.  
  11.  
  12. [1] => SELECT *
  13. FROM civicrm_uf_match
  14.  
  15. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  16.  
  17.  
  18.  
  19.  
  20. [2] => SELECT *
  21. FROM civicrm_uf_match
  22.  
  23. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  24.  
  25.  
  26.  
  27.  
  28. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  29. civicrm_group.id as id
  30. FROM civicrm_group
  31. INNER JOIN civicrm_mailing_group
  32. ON civicrm_mailing_group.entity_id = civicrm_group.id
  33. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  34. AND civicrm_mailing_group.group_type = 'Exclude'
  35. AND civicrm_mailing_group.mailing_id = 83
  36. AND civicrm_group.saved_search_id IS NOT null
  37. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  38. civicrm_group.id as id
  39. FROM civicrm_group
  40. INNER JOIN civicrm_mailing_group
  41. ON civicrm_mailing_group.entity_id = civicrm_group.id
  42. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  43. WHERE
  44. civicrm_mailing_group.group_type = 'Include'
  45. AND civicrm_mailing_group.search_id IS NULL
  46. AND civicrm_mailing_group.mailing_id = 83
  47. AND civicrm_group.saved_search_id IS NOT null
  48. [5] =>
  49. SELECT search_id, search_args, entity_id
  50. FROM civicrm_mailing_group
  51. WHERE civicrm_mailing_group.search_id IS NOT NULL
  52. AND civicrm_mailing_group.mailing_id = 83
  53.  
  54. [6] =>
  55. SELECT j.*
  56. FROM civicrm_mailing_job j,
  57. civicrm_mailing m
  58. WHERE m.id = j.mailing_id
  59.  
  60. AND j.is_test = 0
  61. AND ( ( j.start_date IS null
  62. AND j.scheduled_date <= 20110621173001
  63. AND j.status = 'Scheduled' )
  64. OR ( j.status = 'Running'
  65. AND j.end_date IS null ) )
  66. AND (j.job_type = 'child')
  67. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  68. ORDER BY j.mailing_id,
  69. j.id
  70.  
  71. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  72. civicrm_group.id as id
  73. FROM civicrm_group
  74. INNER JOIN civicrm_mailing_group
  75. ON civicrm_mailing_group.entity_id = civicrm_group.id
  76. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  77. AND civicrm_mailing_group.group_type = 'Exclude'
  78. AND civicrm_mailing_group.mailing_id = 83
  79. AND civicrm_group.saved_search_id IS NOT null
  80. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  81. civicrm_group.id as id
  82. FROM civicrm_group
  83. INNER JOIN civicrm_mailing_group
  84. ON civicrm_mailing_group.entity_id = civicrm_group.id
  85. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  86. WHERE
  87. civicrm_mailing_group.group_type = 'Include'
  88. AND civicrm_mailing_group.search_id IS NULL
  89. AND civicrm_mailing_group.mailing_id = 83
  90. AND civicrm_group.saved_search_id IS NOT null
  91. [9] =>
  92. SELECT search_id, search_args, entity_id
  93. FROM civicrm_mailing_group
  94. WHERE civicrm_mailing_group.search_id IS NOT NULL
  95. AND civicrm_mailing_group.mailing_id = 83
  96.  
  97. [10] => SELECT *
  98. FROM civicrm_preferences
  99.  
  100. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  101.  
  102.  
  103.  
  104.  
  105. [11] => SELECT *
  106. FROM civicrm_mailing
  107.  
  108. WHERE ( civicrm_mailing.id = 83 )
  109.  
  110.  
  111.  
  112.  
  113. [12] => SELECT *
  114. FROM civicrm_domain
  115.  
  116. WHERE ( civicrm_domain.id = 1 )
  117.  
  118.  
  119.  
  120.  
  121. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  122. ph.id as phone_id, ph.location_type_id as locationTypeId
  123. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  124. WHERE ev.id = 1
  125. AND loc.id = ev.loc_block_id
  126. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  127. AND ltype.id = ph.location_type_id
  128. ORDER BY ph.is_primary DESC, phone_id ASC
  129. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  130. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  131. WHERE ev.id = 1
  132. AND loc.id = ev.loc_block_id
  133. AND e.id IN (loc.email_id, loc.email_2_id)
  134. AND ltype.id = e.location_type_id
  135. ORDER BY e.is_primary DESC, email_id ASC
  136. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  137. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  138. WHERE ev.id = 1
  139. AND loc.id = ev.loc_block_id
  140. AND cim.id IN (loc.im_id, loc.im_2_id)
  141. AND ltype.id = cim.location_type_id
  142. ORDER BY cim.is_primary DESC, im_id ASC
  143. [16] =>
  144. SELECT civicrm_address.id as address_id
  145. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  146. WHERE ev.id = 1
  147. AND loc.id = ev.loc_block_id
  148. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  149. AND ltype.id = civicrm_address.location_type_id
  150. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  151. [17] =>
  152. SELECT CF.id as cfID,
  153. CF.uri as uri,
  154. CF.mime_type as mime_type,
  155. CEF.id as cefID
  156. FROM civicrm_file AS CF
  157. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  158. WHERE CEF.entity_table = 'civicrm_mailing'
  159. AND CEF.entity_id = 83
  160. [18] => SELECT *
  161. FROM civicrm_dedupe_rule_group
  162.  
  163. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  164.  
  165.  
  166.  
  167.  
  168. [19] =>
  169. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  170. FROM civicrm_contact_type subtype
  171. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  172. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  173. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  174. [20] =>
  175. SELECT a.operation, a.object_id
  176. FROM civicrm_acl_cache c, civicrm_acl a
  177. WHERE c.acl_id = a.id
  178. AND a.is_active = 1
  179. AND a.object_table = 'civicrm_custom_group'
  180. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  181. ORDER BY a.object_id
  182.  
  183. [21] =>
  184. SELECT a.operation, a.object_id
  185. FROM civicrm_acl_cache c, civicrm_acl a
  186. WHERE c.acl_id = a.id
  187. AND a.is_active = 1
  188. AND a.object_table = 'civicrm_custom_group'
  189. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  190. ORDER BY a.object_id
  191.  
  192. [22] =>
  193. SELECT a.operation, a.object_id
  194. FROM civicrm_acl_cache c, civicrm_acl a
  195. WHERE c.acl_id = a.id
  196. AND a.is_active = 1
  197. AND a.object_table = 'civicrm_custom_group'
  198. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  199. ORDER BY a.object_id
  200.  
  201. [23] =>
  202. SELECT a.operation, a.object_id
  203. FROM civicrm_acl_cache c, civicrm_acl a
  204. WHERE c.acl_id = a.id
  205. AND a.is_active = 1
  206. AND a.object_table = 'civicrm_custom_group'
  207. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  208. ORDER BY a.object_id
  209.  
  210. [24] =>
  211. SELECT a.operation, a.object_id
  212. FROM civicrm_acl_cache c, civicrm_acl a
  213. WHERE c.acl_id = a.id
  214. AND a.is_active = 1
  215. AND a.object_table = 'civicrm_custom_group'
  216. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  217. ORDER BY a.object_id
  218.  
  219. [25] =>
  220. SELECT a.operation, a.object_id
  221. FROM civicrm_acl_cache c, civicrm_acl a
  222. WHERE c.acl_id = a.id
  223. AND a.is_active = 1
  224. AND a.object_table = 'civicrm_custom_group'
  225. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  226. ORDER BY a.object_id
  227.  
  228. )
  229. Array
  230. (
  231. [0] => SELECT config_backend, locales, locale_custom_strings
  232. FROM civicrm_domain
  233.  
  234. WHERE ( civicrm_domain.id = 1 )
  235.  
  236.  
  237.  
  238.  
  239. [1] => SELECT *
  240. FROM civicrm_uf_match
  241.  
  242. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  243.  
  244.  
  245.  
  246.  
  247. [2] => SELECT *
  248. FROM civicrm_uf_match
  249.  
  250. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  251.  
  252.  
  253.  
  254.  
  255. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  256. civicrm_group.id as id
  257. FROM civicrm_group
  258. INNER JOIN civicrm_mailing_group
  259. ON civicrm_mailing_group.entity_id = civicrm_group.id
  260. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  261. AND civicrm_mailing_group.group_type = 'Exclude'
  262. AND civicrm_mailing_group.mailing_id = 83
  263. AND civicrm_group.saved_search_id IS NOT null
  264. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  265. civicrm_group.id as id
  266. FROM civicrm_group
  267. INNER JOIN civicrm_mailing_group
  268. ON civicrm_mailing_group.entity_id = civicrm_group.id
  269. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  270. WHERE
  271. civicrm_mailing_group.group_type = 'Include'
  272. AND civicrm_mailing_group.search_id IS NULL
  273. AND civicrm_mailing_group.mailing_id = 83
  274. AND civicrm_group.saved_search_id IS NOT null
  275. [5] =>
  276. SELECT search_id, search_args, entity_id
  277. FROM civicrm_mailing_group
  278. WHERE civicrm_mailing_group.search_id IS NOT NULL
  279. AND civicrm_mailing_group.mailing_id = 83
  280.  
  281. [6] =>
  282. SELECT j.*
  283. FROM civicrm_mailing_job j,
  284. civicrm_mailing m
  285. WHERE m.id = j.mailing_id
  286.  
  287. AND j.is_test = 0
  288. AND ( ( j.start_date IS null
  289. AND j.scheduled_date <= 20110621173001
  290. AND j.status = 'Scheduled' )
  291. OR ( j.status = 'Running'
  292. AND j.end_date IS null ) )
  293. AND (j.job_type = 'child')
  294. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  295. ORDER BY j.mailing_id,
  296. j.id
  297.  
  298. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  299. civicrm_group.id as id
  300. FROM civicrm_group
  301. INNER JOIN civicrm_mailing_group
  302. ON civicrm_mailing_group.entity_id = civicrm_group.id
  303. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  304. AND civicrm_mailing_group.group_type = 'Exclude'
  305. AND civicrm_mailing_group.mailing_id = 83
  306. AND civicrm_group.saved_search_id IS NOT null
  307. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  308. civicrm_group.id as id
  309. FROM civicrm_group
  310. INNER JOIN civicrm_mailing_group
  311. ON civicrm_mailing_group.entity_id = civicrm_group.id
  312. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  313. WHERE
  314. civicrm_mailing_group.group_type = 'Include'
  315. AND civicrm_mailing_group.search_id IS NULL
  316. AND civicrm_mailing_group.mailing_id = 83
  317. AND civicrm_group.saved_search_id IS NOT null
  318. [9] =>
  319. SELECT search_id, search_args, entity_id
  320. FROM civicrm_mailing_group
  321. WHERE civicrm_mailing_group.search_id IS NOT NULL
  322. AND civicrm_mailing_group.mailing_id = 83
  323.  
  324. [10] => SELECT *
  325. FROM civicrm_preferences
  326.  
  327. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  328.  
  329.  
  330.  
  331.  
  332. [11] => SELECT *
  333. FROM civicrm_mailing
  334.  
  335. WHERE ( civicrm_mailing.id = 83 )
  336.  
  337.  
  338.  
  339.  
  340. [12] => SELECT *
  341. FROM civicrm_domain
  342.  
  343. WHERE ( civicrm_domain.id = 1 )
  344.  
  345.  
  346.  
  347.  
  348. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  349. ph.id as phone_id, ph.location_type_id as locationTypeId
  350. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  351. WHERE ev.id = 1
  352. AND loc.id = ev.loc_block_id
  353. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  354. AND ltype.id = ph.location_type_id
  355. ORDER BY ph.is_primary DESC, phone_id ASC
  356. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  357. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  358. WHERE ev.id = 1
  359. AND loc.id = ev.loc_block_id
  360. AND e.id IN (loc.email_id, loc.email_2_id)
  361. AND ltype.id = e.location_type_id
  362. ORDER BY e.is_primary DESC, email_id ASC
  363. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  364. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  365. WHERE ev.id = 1
  366. AND loc.id = ev.loc_block_id
  367. AND cim.id IN (loc.im_id, loc.im_2_id)
  368. AND ltype.id = cim.location_type_id
  369. ORDER BY cim.is_primary DESC, im_id ASC
  370. [16] =>
  371. SELECT civicrm_address.id as address_id
  372. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  373. WHERE ev.id = 1
  374. AND loc.id = ev.loc_block_id
  375. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  376. AND ltype.id = civicrm_address.location_type_id
  377. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  378. [17] =>
  379. SELECT CF.id as cfID,
  380. CF.uri as uri,
  381. CF.mime_type as mime_type,
  382. CEF.id as cefID
  383. FROM civicrm_file AS CF
  384. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  385. WHERE CEF.entity_table = 'civicrm_mailing'
  386. AND CEF.entity_id = 83
  387. [18] => SELECT *
  388. FROM civicrm_dedupe_rule_group
  389.  
  390. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  391.  
  392.  
  393.  
  394.  
  395. [19] =>
  396. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  397. FROM civicrm_contact_type subtype
  398. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  399. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  400. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  401. [20] =>
  402. SELECT a.operation, a.object_id
  403. FROM civicrm_acl_cache c, civicrm_acl a
  404. WHERE c.acl_id = a.id
  405. AND a.is_active = 1
  406. AND a.object_table = 'civicrm_custom_group'
  407. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  408. ORDER BY a.object_id
  409.  
  410. [21] =>
  411. SELECT a.operation, a.object_id
  412. FROM civicrm_acl_cache c, civicrm_acl a
  413. WHERE c.acl_id = a.id
  414. AND a.is_active = 1
  415. AND a.object_table = 'civicrm_custom_group'
  416. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  417. ORDER BY a.object_id
  418.  
  419. [22] =>
  420. SELECT a.operation, a.object_id
  421. FROM civicrm_acl_cache c, civicrm_acl a
  422. WHERE c.acl_id = a.id
  423. AND a.is_active = 1
  424. AND a.object_table = 'civicrm_custom_group'
  425. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  426. ORDER BY a.object_id
  427.  
  428. [23] =>
  429. SELECT a.operation, a.object_id
  430. FROM civicrm_acl_cache c, civicrm_acl a
  431. WHERE c.acl_id = a.id
  432. AND a.is_active = 1
  433. AND a.object_table = 'civicrm_custom_group'
  434. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  435. ORDER BY a.object_id
  436.  
  437. [24] =>
  438. SELECT a.operation, a.object_id
  439. FROM civicrm_acl_cache c, civicrm_acl a
  440. WHERE c.acl_id = a.id
  441. AND a.is_active = 1
  442. AND a.object_table = 'civicrm_custom_group'
  443. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  444. ORDER BY a.object_id
  445.  
  446. [25] =>
  447. SELECT a.operation, a.object_id
  448. FROM civicrm_acl_cache c, civicrm_acl a
  449. WHERE c.acl_id = a.id
  450. AND a.is_active = 1
  451. AND a.object_table = 'civicrm_custom_group'
  452. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  453. ORDER BY a.object_id
  454.  
  455. [26] => SELECT *
  456. FROM civicrm_mail_settings
  457.  
  458. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  459.  
  460.  
  461.  
  462.  
  463. )
  464. Array
  465. (
  466. [0] => SELECT config_backend, locales, locale_custom_strings
  467. FROM civicrm_domain
  468.  
  469. WHERE ( civicrm_domain.id = 1 )
  470.  
  471.  
  472.  
  473.  
  474. [1] => SELECT *
  475. FROM civicrm_uf_match
  476.  
  477. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  478.  
  479.  
  480.  
  481.  
  482. [2] => SELECT *
  483. FROM civicrm_uf_match
  484.  
  485. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  486.  
  487.  
  488.  
  489.  
  490. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  491. civicrm_group.id as id
  492. FROM civicrm_group
  493. INNER JOIN civicrm_mailing_group
  494. ON civicrm_mailing_group.entity_id = civicrm_group.id
  495. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  496. AND civicrm_mailing_group.group_type = 'Exclude'
  497. AND civicrm_mailing_group.mailing_id = 83
  498. AND civicrm_group.saved_search_id IS NOT null
  499. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  500. civicrm_group.id as id
  501. FROM civicrm_group
  502. INNER JOIN civicrm_mailing_group
  503. ON civicrm_mailing_group.entity_id = civicrm_group.id
  504. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  505. WHERE
  506. civicrm_mailing_group.group_type = 'Include'
  507. AND civicrm_mailing_group.search_id IS NULL
  508. AND civicrm_mailing_group.mailing_id = 83
  509. AND civicrm_group.saved_search_id IS NOT null
  510. [5] =>
  511. SELECT search_id, search_args, entity_id
  512. FROM civicrm_mailing_group
  513. WHERE civicrm_mailing_group.search_id IS NOT NULL
  514. AND civicrm_mailing_group.mailing_id = 83
  515.  
  516. [6] =>
  517. SELECT j.*
  518. FROM civicrm_mailing_job j,
  519. civicrm_mailing m
  520. WHERE m.id = j.mailing_id
  521.  
  522. AND j.is_test = 0
  523. AND ( ( j.start_date IS null
  524. AND j.scheduled_date <= 20110621173001
  525. AND j.status = 'Scheduled' )
  526. OR ( j.status = 'Running'
  527. AND j.end_date IS null ) )
  528. AND (j.job_type = 'child')
  529. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  530. ORDER BY j.mailing_id,
  531. j.id
  532.  
  533. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  534. civicrm_group.id as id
  535. FROM civicrm_group
  536. INNER JOIN civicrm_mailing_group
  537. ON civicrm_mailing_group.entity_id = civicrm_group.id
  538. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  539. AND civicrm_mailing_group.group_type = 'Exclude'
  540. AND civicrm_mailing_group.mailing_id = 83
  541. AND civicrm_group.saved_search_id IS NOT null
  542. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  543. civicrm_group.id as id
  544. FROM civicrm_group
  545. INNER JOIN civicrm_mailing_group
  546. ON civicrm_mailing_group.entity_id = civicrm_group.id
  547. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  548. WHERE
  549. civicrm_mailing_group.group_type = 'Include'
  550. AND civicrm_mailing_group.search_id IS NULL
  551. AND civicrm_mailing_group.mailing_id = 83
  552. AND civicrm_group.saved_search_id IS NOT null
  553. [9] =>
  554. SELECT search_id, search_args, entity_id
  555. FROM civicrm_mailing_group
  556. WHERE civicrm_mailing_group.search_id IS NOT NULL
  557. AND civicrm_mailing_group.mailing_id = 83
  558.  
  559. [10] => SELECT *
  560. FROM civicrm_preferences
  561.  
  562. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  563.  
  564.  
  565.  
  566.  
  567. [11] => SELECT *
  568. FROM civicrm_mailing
  569.  
  570. WHERE ( civicrm_mailing.id = 83 )
  571.  
  572.  
  573.  
  574.  
  575. [12] => SELECT *
  576. FROM civicrm_domain
  577.  
  578. WHERE ( civicrm_domain.id = 1 )
  579.  
  580.  
  581.  
  582.  
  583. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  584. ph.id as phone_id, ph.location_type_id as locationTypeId
  585. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  586. WHERE ev.id = 1
  587. AND loc.id = ev.loc_block_id
  588. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  589. AND ltype.id = ph.location_type_id
  590. ORDER BY ph.is_primary DESC, phone_id ASC
  591. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  592. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  593. WHERE ev.id = 1
  594. AND loc.id = ev.loc_block_id
  595. AND e.id IN (loc.email_id, loc.email_2_id)
  596. AND ltype.id = e.location_type_id
  597. ORDER BY e.is_primary DESC, email_id ASC
  598. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  599. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  600. WHERE ev.id = 1
  601. AND loc.id = ev.loc_block_id
  602. AND cim.id IN (loc.im_id, loc.im_2_id)
  603. AND ltype.id = cim.location_type_id
  604. ORDER BY cim.is_primary DESC, im_id ASC
  605. [16] =>
  606. SELECT civicrm_address.id as address_id
  607. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  608. WHERE ev.id = 1
  609. AND loc.id = ev.loc_block_id
  610. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  611. AND ltype.id = civicrm_address.location_type_id
  612. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  613. [17] =>
  614. SELECT CF.id as cfID,
  615. CF.uri as uri,
  616. CF.mime_type as mime_type,
  617. CEF.id as cefID
  618. FROM civicrm_file AS CF
  619. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  620. WHERE CEF.entity_table = 'civicrm_mailing'
  621. AND CEF.entity_id = 83
  622. [18] => SELECT *
  623. FROM civicrm_dedupe_rule_group
  624.  
  625. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  626.  
  627.  
  628.  
  629.  
  630. [19] =>
  631. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  632. FROM civicrm_contact_type subtype
  633. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  634. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  635. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  636. [20] =>
  637. SELECT a.operation, a.object_id
  638. FROM civicrm_acl_cache c, civicrm_acl a
  639. WHERE c.acl_id = a.id
  640. AND a.is_active = 1
  641. AND a.object_table = 'civicrm_custom_group'
  642. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  643. ORDER BY a.object_id
  644.  
  645. [21] =>
  646. SELECT a.operation, a.object_id
  647. FROM civicrm_acl_cache c, civicrm_acl a
  648. WHERE c.acl_id = a.id
  649. AND a.is_active = 1
  650. AND a.object_table = 'civicrm_custom_group'
  651. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  652. ORDER BY a.object_id
  653.  
  654. [22] =>
  655. SELECT a.operation, a.object_id
  656. FROM civicrm_acl_cache c, civicrm_acl a
  657. WHERE c.acl_id = a.id
  658. AND a.is_active = 1
  659. AND a.object_table = 'civicrm_custom_group'
  660. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  661. ORDER BY a.object_id
  662.  
  663. [23] =>
  664. SELECT a.operation, a.object_id
  665. FROM civicrm_acl_cache c, civicrm_acl a
  666. WHERE c.acl_id = a.id
  667. AND a.is_active = 1
  668. AND a.object_table = 'civicrm_custom_group'
  669. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  670. ORDER BY a.object_id
  671.  
  672. [24] =>
  673. SELECT a.operation, a.object_id
  674. FROM civicrm_acl_cache c, civicrm_acl a
  675. WHERE c.acl_id = a.id
  676. AND a.is_active = 1
  677. AND a.object_table = 'civicrm_custom_group'
  678. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  679. ORDER BY a.object_id
  680.  
  681. [25] =>
  682. SELECT a.operation, a.object_id
  683. FROM civicrm_acl_cache c, civicrm_acl a
  684. WHERE c.acl_id = a.id
  685. AND a.is_active = 1
  686. AND a.object_table = 'civicrm_custom_group'
  687. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  688. ORDER BY a.object_id
  689.  
  690. [26] => SELECT *
  691. FROM civicrm_mail_settings
  692.  
  693. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  694.  
  695.  
  696.  
  697.  
  698. )
  699. Array
  700. (
  701. [0] => SELECT config_backend, locales, locale_custom_strings
  702. FROM civicrm_domain
  703.  
  704. WHERE ( civicrm_domain.id = 1 )
  705.  
  706.  
  707.  
  708.  
  709. [1] => SELECT *
  710. FROM civicrm_uf_match
  711.  
  712. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  713.  
  714.  
  715.  
  716.  
  717. [2] => SELECT *
  718. FROM civicrm_uf_match
  719.  
  720. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  721.  
  722.  
  723.  
  724.  
  725. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  726. civicrm_group.id as id
  727. FROM civicrm_group
  728. INNER JOIN civicrm_mailing_group
  729. ON civicrm_mailing_group.entity_id = civicrm_group.id
  730. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  731. AND civicrm_mailing_group.group_type = 'Exclude'
  732. AND civicrm_mailing_group.mailing_id = 83
  733. AND civicrm_group.saved_search_id IS NOT null
  734. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  735. civicrm_group.id as id
  736. FROM civicrm_group
  737. INNER JOIN civicrm_mailing_group
  738. ON civicrm_mailing_group.entity_id = civicrm_group.id
  739. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  740. WHERE
  741. civicrm_mailing_group.group_type = 'Include'
  742. AND civicrm_mailing_group.search_id IS NULL
  743. AND civicrm_mailing_group.mailing_id = 83
  744. AND civicrm_group.saved_search_id IS NOT null
  745. [5] =>
  746. SELECT search_id, search_args, entity_id
  747. FROM civicrm_mailing_group
  748. WHERE civicrm_mailing_group.search_id IS NOT NULL
  749. AND civicrm_mailing_group.mailing_id = 83
  750.  
  751. [6] =>
  752. SELECT j.*
  753. FROM civicrm_mailing_job j,
  754. civicrm_mailing m
  755. WHERE m.id = j.mailing_id
  756.  
  757. AND j.is_test = 0
  758. AND ( ( j.start_date IS null
  759. AND j.scheduled_date <= 20110621173001
  760. AND j.status = 'Scheduled' )
  761. OR ( j.status = 'Running'
  762. AND j.end_date IS null ) )
  763. AND (j.job_type = 'child')
  764. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  765. ORDER BY j.mailing_id,
  766. j.id
  767.  
  768. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  769. civicrm_group.id as id
  770. FROM civicrm_group
  771. INNER JOIN civicrm_mailing_group
  772. ON civicrm_mailing_group.entity_id = civicrm_group.id
  773. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  774. AND civicrm_mailing_group.group_type = 'Exclude'
  775. AND civicrm_mailing_group.mailing_id = 83
  776. AND civicrm_group.saved_search_id IS NOT null
  777. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  778. civicrm_group.id as id
  779. FROM civicrm_group
  780. INNER JOIN civicrm_mailing_group
  781. ON civicrm_mailing_group.entity_id = civicrm_group.id
  782. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  783. WHERE
  784. civicrm_mailing_group.group_type = 'Include'
  785. AND civicrm_mailing_group.search_id IS NULL
  786. AND civicrm_mailing_group.mailing_id = 83
  787. AND civicrm_group.saved_search_id IS NOT null
  788. [9] =>
  789. SELECT search_id, search_args, entity_id
  790. FROM civicrm_mailing_group
  791. WHERE civicrm_mailing_group.search_id IS NOT NULL
  792. AND civicrm_mailing_group.mailing_id = 83
  793.  
  794. [10] => SELECT *
  795. FROM civicrm_preferences
  796.  
  797. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  798.  
  799.  
  800.  
  801.  
  802. [11] => SELECT *
  803. FROM civicrm_mailing
  804.  
  805. WHERE ( civicrm_mailing.id = 83 )
  806.  
  807.  
  808.  
  809.  
  810. [12] => SELECT *
  811. FROM civicrm_domain
  812.  
  813. WHERE ( civicrm_domain.id = 1 )
  814.  
  815.  
  816.  
  817.  
  818. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  819. ph.id as phone_id, ph.location_type_id as locationTypeId
  820. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  821. WHERE ev.id = 1
  822. AND loc.id = ev.loc_block_id
  823. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  824. AND ltype.id = ph.location_type_id
  825. ORDER BY ph.is_primary DESC, phone_id ASC
  826. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  827. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  828. WHERE ev.id = 1
  829. AND loc.id = ev.loc_block_id
  830. AND e.id IN (loc.email_id, loc.email_2_id)
  831. AND ltype.id = e.location_type_id
  832. ORDER BY e.is_primary DESC, email_id ASC
  833. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  834. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  835. WHERE ev.id = 1
  836. AND loc.id = ev.loc_block_id
  837. AND cim.id IN (loc.im_id, loc.im_2_id)
  838. AND ltype.id = cim.location_type_id
  839. ORDER BY cim.is_primary DESC, im_id ASC
  840. [16] =>
  841. SELECT civicrm_address.id as address_id
  842. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  843. WHERE ev.id = 1
  844. AND loc.id = ev.loc_block_id
  845. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  846. AND ltype.id = civicrm_address.location_type_id
  847. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  848. [17] =>
  849. SELECT CF.id as cfID,
  850. CF.uri as uri,
  851. CF.mime_type as mime_type,
  852. CEF.id as cefID
  853. FROM civicrm_file AS CF
  854. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  855. WHERE CEF.entity_table = 'civicrm_mailing'
  856. AND CEF.entity_id = 83
  857. [18] => SELECT *
  858. FROM civicrm_dedupe_rule_group
  859.  
  860. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  861.  
  862.  
  863.  
  864.  
  865. [19] =>
  866. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  867. FROM civicrm_contact_type subtype
  868. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  869. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  870. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  871. [20] =>
  872. SELECT a.operation, a.object_id
  873. FROM civicrm_acl_cache c, civicrm_acl a
  874. WHERE c.acl_id = a.id
  875. AND a.is_active = 1
  876. AND a.object_table = 'civicrm_custom_group'
  877. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  878. ORDER BY a.object_id
  879.  
  880. [21] =>
  881. SELECT a.operation, a.object_id
  882. FROM civicrm_acl_cache c, civicrm_acl a
  883. WHERE c.acl_id = a.id
  884. AND a.is_active = 1
  885. AND a.object_table = 'civicrm_custom_group'
  886. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  887. ORDER BY a.object_id
  888.  
  889. [22] =>
  890. SELECT a.operation, a.object_id
  891. FROM civicrm_acl_cache c, civicrm_acl a
  892. WHERE c.acl_id = a.id
  893. AND a.is_active = 1
  894. AND a.object_table = 'civicrm_custom_group'
  895. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  896. ORDER BY a.object_id
  897.  
  898. [23] =>
  899. SELECT a.operation, a.object_id
  900. FROM civicrm_acl_cache c, civicrm_acl a
  901. WHERE c.acl_id = a.id
  902. AND a.is_active = 1
  903. AND a.object_table = 'civicrm_custom_group'
  904. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  905. ORDER BY a.object_id
  906.  
  907. [24] =>
  908. SELECT a.operation, a.object_id
  909. FROM civicrm_acl_cache c, civicrm_acl a
  910. WHERE c.acl_id = a.id
  911. AND a.is_active = 1
  912. AND a.object_table = 'civicrm_custom_group'
  913. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  914. ORDER BY a.object_id
  915.  
  916. [25] =>
  917. SELECT a.operation, a.object_id
  918. FROM civicrm_acl_cache c, civicrm_acl a
  919. WHERE c.acl_id = a.id
  920. AND a.is_active = 1
  921. AND a.object_table = 'civicrm_custom_group'
  922. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  923. ORDER BY a.object_id
  924.  
  925. [26] => SELECT *
  926. FROM civicrm_mail_settings
  927.  
  928. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  929.  
  930.  
  931.  
  932.  
  933. )
  934. Array
  935. (
  936. [0] => SELECT config_backend, locales, locale_custom_strings
  937. FROM civicrm_domain
  938.  
  939. WHERE ( civicrm_domain.id = 1 )
  940.  
  941.  
  942.  
  943.  
  944. [1] => SELECT *
  945. FROM civicrm_uf_match
  946.  
  947. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  948.  
  949.  
  950.  
  951.  
  952. [2] => SELECT *
  953. FROM civicrm_uf_match
  954.  
  955. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  956.  
  957.  
  958.  
  959.  
  960. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  961. civicrm_group.id as id
  962. FROM civicrm_group
  963. INNER JOIN civicrm_mailing_group
  964. ON civicrm_mailing_group.entity_id = civicrm_group.id
  965. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  966. AND civicrm_mailing_group.group_type = 'Exclude'
  967. AND civicrm_mailing_group.mailing_id = 83
  968. AND civicrm_group.saved_search_id IS NOT null
  969. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  970. civicrm_group.id as id
  971. FROM civicrm_group
  972. INNER JOIN civicrm_mailing_group
  973. ON civicrm_mailing_group.entity_id = civicrm_group.id
  974. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  975. WHERE
  976. civicrm_mailing_group.group_type = 'Include'
  977. AND civicrm_mailing_group.search_id IS NULL
  978. AND civicrm_mailing_group.mailing_id = 83
  979. AND civicrm_group.saved_search_id IS NOT null
  980. [5] =>
  981. SELECT search_id, search_args, entity_id
  982. FROM civicrm_mailing_group
  983. WHERE civicrm_mailing_group.search_id IS NOT NULL
  984. AND civicrm_mailing_group.mailing_id = 83
  985.  
  986. [6] =>
  987. SELECT j.*
  988. FROM civicrm_mailing_job j,
  989. civicrm_mailing m
  990. WHERE m.id = j.mailing_id
  991.  
  992. AND j.is_test = 0
  993. AND ( ( j.start_date IS null
  994. AND j.scheduled_date <= 20110621173001
  995. AND j.status = 'Scheduled' )
  996. OR ( j.status = 'Running'
  997. AND j.end_date IS null ) )
  998. AND (j.job_type = 'child')
  999. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  1000. ORDER BY j.mailing_id,
  1001. j.id
  1002.  
  1003. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1004. civicrm_group.id as id
  1005. FROM civicrm_group
  1006. INNER JOIN civicrm_mailing_group
  1007. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1008. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1009. AND civicrm_mailing_group.group_type = 'Exclude'
  1010. AND civicrm_mailing_group.mailing_id = 83
  1011. AND civicrm_group.saved_search_id IS NOT null
  1012. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1013. civicrm_group.id as id
  1014. FROM civicrm_group
  1015. INNER JOIN civicrm_mailing_group
  1016. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1017. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1018. WHERE
  1019. civicrm_mailing_group.group_type = 'Include'
  1020. AND civicrm_mailing_group.search_id IS NULL
  1021. AND civicrm_mailing_group.mailing_id = 83
  1022. AND civicrm_group.saved_search_id IS NOT null
  1023. [9] =>
  1024. SELECT search_id, search_args, entity_id
  1025. FROM civicrm_mailing_group
  1026. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1027. AND civicrm_mailing_group.mailing_id = 83
  1028.  
  1029. [10] => SELECT *
  1030. FROM civicrm_preferences
  1031.  
  1032. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  1033.  
  1034.  
  1035.  
  1036.  
  1037. [11] => SELECT *
  1038. FROM civicrm_mailing
  1039.  
  1040. WHERE ( civicrm_mailing.id = 83 )
  1041.  
  1042.  
  1043.  
  1044.  
  1045. [12] => SELECT *
  1046. FROM civicrm_domain
  1047.  
  1048. WHERE ( civicrm_domain.id = 1 )
  1049.  
  1050.  
  1051.  
  1052.  
  1053. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  1054. ph.id as phone_id, ph.location_type_id as locationTypeId
  1055. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  1056. WHERE ev.id = 1
  1057. AND loc.id = ev.loc_block_id
  1058. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  1059. AND ltype.id = ph.location_type_id
  1060. ORDER BY ph.is_primary DESC, phone_id ASC
  1061. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  1062. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  1063. WHERE ev.id = 1
  1064. AND loc.id = ev.loc_block_id
  1065. AND e.id IN (loc.email_id, loc.email_2_id)
  1066. AND ltype.id = e.location_type_id
  1067. ORDER BY e.is_primary DESC, email_id ASC
  1068. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  1069. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  1070. WHERE ev.id = 1
  1071. AND loc.id = ev.loc_block_id
  1072. AND cim.id IN (loc.im_id, loc.im_2_id)
  1073. AND ltype.id = cim.location_type_id
  1074. ORDER BY cim.is_primary DESC, im_id ASC
  1075. [16] =>
  1076. SELECT civicrm_address.id as address_id
  1077. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  1078. WHERE ev.id = 1
  1079. AND loc.id = ev.loc_block_id
  1080. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  1081. AND ltype.id = civicrm_address.location_type_id
  1082. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  1083. [17] =>
  1084. SELECT CF.id as cfID,
  1085. CF.uri as uri,
  1086. CF.mime_type as mime_type,
  1087. CEF.id as cefID
  1088. FROM civicrm_file AS CF
  1089. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  1090. WHERE CEF.entity_table = 'civicrm_mailing'
  1091. AND CEF.entity_id = 83
  1092. [18] => SELECT *
  1093. FROM civicrm_dedupe_rule_group
  1094.  
  1095. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  1096.  
  1097.  
  1098.  
  1099.  
  1100. [19] =>
  1101. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  1102. FROM civicrm_contact_type subtype
  1103. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  1104. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  1105. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  1106. [20] =>
  1107. SELECT a.operation, a.object_id
  1108. FROM civicrm_acl_cache c, civicrm_acl a
  1109. WHERE c.acl_id = a.id
  1110. AND a.is_active = 1
  1111. AND a.object_table = 'civicrm_custom_group'
  1112. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1113. ORDER BY a.object_id
  1114.  
  1115. [21] =>
  1116. SELECT a.operation, a.object_id
  1117. FROM civicrm_acl_cache c, civicrm_acl a
  1118. WHERE c.acl_id = a.id
  1119. AND a.is_active = 1
  1120. AND a.object_table = 'civicrm_custom_group'
  1121. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1122. ORDER BY a.object_id
  1123.  
  1124. [22] =>
  1125. SELECT a.operation, a.object_id
  1126. FROM civicrm_acl_cache c, civicrm_acl a
  1127. WHERE c.acl_id = a.id
  1128. AND a.is_active = 1
  1129. AND a.object_table = 'civicrm_custom_group'
  1130. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1131. ORDER BY a.object_id
  1132.  
  1133. [23] =>
  1134. SELECT a.operation, a.object_id
  1135. FROM civicrm_acl_cache c, civicrm_acl a
  1136. WHERE c.acl_id = a.id
  1137. AND a.is_active = 1
  1138. AND a.object_table = 'civicrm_custom_group'
  1139. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1140. ORDER BY a.object_id
  1141.  
  1142. [24] =>
  1143. SELECT a.operation, a.object_id
  1144. FROM civicrm_acl_cache c, civicrm_acl a
  1145. WHERE c.acl_id = a.id
  1146. AND a.is_active = 1
  1147. AND a.object_table = 'civicrm_custom_group'
  1148. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1149. ORDER BY a.object_id
  1150.  
  1151. [25] =>
  1152. SELECT a.operation, a.object_id
  1153. FROM civicrm_acl_cache c, civicrm_acl a
  1154. WHERE c.acl_id = a.id
  1155. AND a.is_active = 1
  1156. AND a.object_table = 'civicrm_custom_group'
  1157. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1158. ORDER BY a.object_id
  1159.  
  1160. [26] => SELECT *
  1161. FROM civicrm_mail_settings
  1162.  
  1163. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  1164.  
  1165.  
  1166.  
  1167.  
  1168. )
  1169. Array
  1170. (
  1171. [0] => SELECT config_backend, locales, locale_custom_strings
  1172. FROM civicrm_domain
  1173.  
  1174. WHERE ( civicrm_domain.id = 1 )
  1175.  
  1176.  
  1177.  
  1178.  
  1179. [1] => SELECT *
  1180. FROM civicrm_uf_match
  1181.  
  1182. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  1183.  
  1184.  
  1185.  
  1186.  
  1187. [2] => SELECT *
  1188. FROM civicrm_uf_match
  1189.  
  1190. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  1191.  
  1192.  
  1193.  
  1194.  
  1195. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1196. civicrm_group.id as id
  1197. FROM civicrm_group
  1198. INNER JOIN civicrm_mailing_group
  1199. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1200. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1201. AND civicrm_mailing_group.group_type = 'Exclude'
  1202. AND civicrm_mailing_group.mailing_id = 83
  1203. AND civicrm_group.saved_search_id IS NOT null
  1204. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1205. civicrm_group.id as id
  1206. FROM civicrm_group
  1207. INNER JOIN civicrm_mailing_group
  1208. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1209. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1210. WHERE
  1211. civicrm_mailing_group.group_type = 'Include'
  1212. AND civicrm_mailing_group.search_id IS NULL
  1213. AND civicrm_mailing_group.mailing_id = 83
  1214. AND civicrm_group.saved_search_id IS NOT null
  1215. [5] =>
  1216. SELECT search_id, search_args, entity_id
  1217. FROM civicrm_mailing_group
  1218. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1219. AND civicrm_mailing_group.mailing_id = 83
  1220.  
  1221. [6] =>
  1222. SELECT j.*
  1223. FROM civicrm_mailing_job j,
  1224. civicrm_mailing m
  1225. WHERE m.id = j.mailing_id
  1226.  
  1227. AND j.is_test = 0
  1228. AND ( ( j.start_date IS null
  1229. AND j.scheduled_date <= 20110621173001
  1230. AND j.status = 'Scheduled' )
  1231. OR ( j.status = 'Running'
  1232. AND j.end_date IS null ) )
  1233. AND (j.job_type = 'child')
  1234. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  1235. ORDER BY j.mailing_id,
  1236. j.id
  1237.  
  1238. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1239. civicrm_group.id as id
  1240. FROM civicrm_group
  1241. INNER JOIN civicrm_mailing_group
  1242. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1243. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1244. AND civicrm_mailing_group.group_type = 'Exclude'
  1245. AND civicrm_mailing_group.mailing_id = 83
  1246. AND civicrm_group.saved_search_id IS NOT null
  1247. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1248. civicrm_group.id as id
  1249. FROM civicrm_group
  1250. INNER JOIN civicrm_mailing_group
  1251. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1252. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1253. WHERE
  1254. civicrm_mailing_group.group_type = 'Include'
  1255. AND civicrm_mailing_group.search_id IS NULL
  1256. AND civicrm_mailing_group.mailing_id = 83
  1257. AND civicrm_group.saved_search_id IS NOT null
  1258. [9] =>
  1259. SELECT search_id, search_args, entity_id
  1260. FROM civicrm_mailing_group
  1261. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1262. AND civicrm_mailing_group.mailing_id = 83
  1263.  
  1264. [10] => SELECT *
  1265. FROM civicrm_preferences
  1266.  
  1267. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  1268.  
  1269.  
  1270.  
  1271.  
  1272. [11] => SELECT *
  1273. FROM civicrm_mailing
  1274.  
  1275. WHERE ( civicrm_mailing.id = 83 )
  1276.  
  1277.  
  1278.  
  1279.  
  1280. [12] => SELECT *
  1281. FROM civicrm_domain
  1282.  
  1283. WHERE ( civicrm_domain.id = 1 )
  1284.  
  1285.  
  1286.  
  1287.  
  1288. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  1289. ph.id as phone_id, ph.location_type_id as locationTypeId
  1290. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  1291. WHERE ev.id = 1
  1292. AND loc.id = ev.loc_block_id
  1293. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  1294. AND ltype.id = ph.location_type_id
  1295. ORDER BY ph.is_primary DESC, phone_id ASC
  1296. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  1297. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  1298. WHERE ev.id = 1
  1299. AND loc.id = ev.loc_block_id
  1300. AND e.id IN (loc.email_id, loc.email_2_id)
  1301. AND ltype.id = e.location_type_id
  1302. ORDER BY e.is_primary DESC, email_id ASC
  1303. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  1304. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  1305. WHERE ev.id = 1
  1306. AND loc.id = ev.loc_block_id
  1307. AND cim.id IN (loc.im_id, loc.im_2_id)
  1308. AND ltype.id = cim.location_type_id
  1309. ORDER BY cim.is_primary DESC, im_id ASC
  1310. [16] =>
  1311. SELECT civicrm_address.id as address_id
  1312. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  1313. WHERE ev.id = 1
  1314. AND loc.id = ev.loc_block_id
  1315. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  1316. AND ltype.id = civicrm_address.location_type_id
  1317. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  1318. [17] =>
  1319. SELECT CF.id as cfID,
  1320. CF.uri as uri,
  1321. CF.mime_type as mime_type,
  1322. CEF.id as cefID
  1323. FROM civicrm_file AS CF
  1324. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  1325. WHERE CEF.entity_table = 'civicrm_mailing'
  1326. AND CEF.entity_id = 83
  1327. [18] => SELECT *
  1328. FROM civicrm_dedupe_rule_group
  1329.  
  1330. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  1331.  
  1332.  
  1333.  
  1334.  
  1335. [19] =>
  1336. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  1337. FROM civicrm_contact_type subtype
  1338. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  1339. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  1340. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  1341. [20] =>
  1342. SELECT a.operation, a.object_id
  1343. FROM civicrm_acl_cache c, civicrm_acl a
  1344. WHERE c.acl_id = a.id
  1345. AND a.is_active = 1
  1346. AND a.object_table = 'civicrm_custom_group'
  1347. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1348. ORDER BY a.object_id
  1349.  
  1350. [21] =>
  1351. SELECT a.operation, a.object_id
  1352. FROM civicrm_acl_cache c, civicrm_acl a
  1353. WHERE c.acl_id = a.id
  1354. AND a.is_active = 1
  1355. AND a.object_table = 'civicrm_custom_group'
  1356. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1357. ORDER BY a.object_id
  1358.  
  1359. [22] =>
  1360. SELECT a.operation, a.object_id
  1361. FROM civicrm_acl_cache c, civicrm_acl a
  1362. WHERE c.acl_id = a.id
  1363. AND a.is_active = 1
  1364. AND a.object_table = 'civicrm_custom_group'
  1365. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1366. ORDER BY a.object_id
  1367.  
  1368. [23] =>
  1369. SELECT a.operation, a.object_id
  1370. FROM civicrm_acl_cache c, civicrm_acl a
  1371. WHERE c.acl_id = a.id
  1372. AND a.is_active = 1
  1373. AND a.object_table = 'civicrm_custom_group'
  1374. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1375. ORDER BY a.object_id
  1376.  
  1377. [24] =>
  1378. SELECT a.operation, a.object_id
  1379. FROM civicrm_acl_cache c, civicrm_acl a
  1380. WHERE c.acl_id = a.id
  1381. AND a.is_active = 1
  1382. AND a.object_table = 'civicrm_custom_group'
  1383. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1384. ORDER BY a.object_id
  1385.  
  1386. [25] =>
  1387. SELECT a.operation, a.object_id
  1388. FROM civicrm_acl_cache c, civicrm_acl a
  1389. WHERE c.acl_id = a.id
  1390. AND a.is_active = 1
  1391. AND a.object_table = 'civicrm_custom_group'
  1392. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1393. ORDER BY a.object_id
  1394.  
  1395. [26] => SELECT *
  1396. FROM civicrm_mail_settings
  1397.  
  1398. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  1399.  
  1400.  
  1401.  
  1402.  
  1403. )
  1404. Array
  1405. (
  1406. [0] => SELECT config_backend, locales, locale_custom_strings
  1407. FROM civicrm_domain
  1408.  
  1409. WHERE ( civicrm_domain.id = 1 )
  1410.  
  1411.  
  1412.  
  1413.  
  1414. [1] => SELECT *
  1415. FROM civicrm_uf_match
  1416.  
  1417. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  1418.  
  1419.  
  1420.  
  1421.  
  1422. [2] => SELECT *
  1423. FROM civicrm_uf_match
  1424.  
  1425. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  1426.  
  1427.  
  1428.  
  1429.  
  1430. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1431. civicrm_group.id as id
  1432. FROM civicrm_group
  1433. INNER JOIN civicrm_mailing_group
  1434. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1435. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1436. AND civicrm_mailing_group.group_type = 'Exclude'
  1437. AND civicrm_mailing_group.mailing_id = 83
  1438. AND civicrm_group.saved_search_id IS NOT null
  1439. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1440. civicrm_group.id as id
  1441. FROM civicrm_group
  1442. INNER JOIN civicrm_mailing_group
  1443. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1444. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1445. WHERE
  1446. civicrm_mailing_group.group_type = 'Include'
  1447. AND civicrm_mailing_group.search_id IS NULL
  1448. AND civicrm_mailing_group.mailing_id = 83
  1449. AND civicrm_group.saved_search_id IS NOT null
  1450. [5] =>
  1451. SELECT search_id, search_args, entity_id
  1452. FROM civicrm_mailing_group
  1453. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1454. AND civicrm_mailing_group.mailing_id = 83
  1455.  
  1456. [6] =>
  1457. SELECT j.*
  1458. FROM civicrm_mailing_job j,
  1459. civicrm_mailing m
  1460. WHERE m.id = j.mailing_id
  1461.  
  1462. AND j.is_test = 0
  1463. AND ( ( j.start_date IS null
  1464. AND j.scheduled_date <= 20110621173001
  1465. AND j.status = 'Scheduled' )
  1466. OR ( j.status = 'Running'
  1467. AND j.end_date IS null ) )
  1468. AND (j.job_type = 'child')
  1469. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  1470. ORDER BY j.mailing_id,
  1471. j.id
  1472.  
  1473. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1474. civicrm_group.id as id
  1475. FROM civicrm_group
  1476. INNER JOIN civicrm_mailing_group
  1477. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1478. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1479. AND civicrm_mailing_group.group_type = 'Exclude'
  1480. AND civicrm_mailing_group.mailing_id = 83
  1481. AND civicrm_group.saved_search_id IS NOT null
  1482. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1483. civicrm_group.id as id
  1484. FROM civicrm_group
  1485. INNER JOIN civicrm_mailing_group
  1486. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1487. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1488. WHERE
  1489. civicrm_mailing_group.group_type = 'Include'
  1490. AND civicrm_mailing_group.search_id IS NULL
  1491. AND civicrm_mailing_group.mailing_id = 83
  1492. AND civicrm_group.saved_search_id IS NOT null
  1493. [9] =>
  1494. SELECT search_id, search_args, entity_id
  1495. FROM civicrm_mailing_group
  1496. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1497. AND civicrm_mailing_group.mailing_id = 83
  1498.  
  1499. [10] => SELECT *
  1500. FROM civicrm_preferences
  1501.  
  1502. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  1503.  
  1504.  
  1505.  
  1506.  
  1507. [11] => SELECT *
  1508. FROM civicrm_mailing
  1509.  
  1510. WHERE ( civicrm_mailing.id = 83 )
  1511.  
  1512.  
  1513.  
  1514.  
  1515. [12] => SELECT *
  1516. FROM civicrm_domain
  1517.  
  1518. WHERE ( civicrm_domain.id = 1 )
  1519.  
  1520.  
  1521.  
  1522.  
  1523. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  1524. ph.id as phone_id, ph.location_type_id as locationTypeId
  1525. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  1526. WHERE ev.id = 1
  1527. AND loc.id = ev.loc_block_id
  1528. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  1529. AND ltype.id = ph.location_type_id
  1530. ORDER BY ph.is_primary DESC, phone_id ASC
  1531. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  1532. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  1533. WHERE ev.id = 1
  1534. AND loc.id = ev.loc_block_id
  1535. AND e.id IN (loc.email_id, loc.email_2_id)
  1536. AND ltype.id = e.location_type_id
  1537. ORDER BY e.is_primary DESC, email_id ASC
  1538. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  1539. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  1540. WHERE ev.id = 1
  1541. AND loc.id = ev.loc_block_id
  1542. AND cim.id IN (loc.im_id, loc.im_2_id)
  1543. AND ltype.id = cim.location_type_id
  1544. ORDER BY cim.is_primary DESC, im_id ASC
  1545. [16] =>
  1546. SELECT civicrm_address.id as address_id
  1547. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  1548. WHERE ev.id = 1
  1549. AND loc.id = ev.loc_block_id
  1550. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  1551. AND ltype.id = civicrm_address.location_type_id
  1552. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  1553. [17] =>
  1554. SELECT CF.id as cfID,
  1555. CF.uri as uri,
  1556. CF.mime_type as mime_type,
  1557. CEF.id as cefID
  1558. FROM civicrm_file AS CF
  1559. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  1560. WHERE CEF.entity_table = 'civicrm_mailing'
  1561. AND CEF.entity_id = 83
  1562. [18] => SELECT *
  1563. FROM civicrm_dedupe_rule_group
  1564.  
  1565. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  1566.  
  1567.  
  1568.  
  1569.  
  1570. [19] =>
  1571. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  1572. FROM civicrm_contact_type subtype
  1573. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  1574. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  1575. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  1576. [20] =>
  1577. SELECT a.operation, a.object_id
  1578. FROM civicrm_acl_cache c, civicrm_acl a
  1579. WHERE c.acl_id = a.id
  1580. AND a.is_active = 1
  1581. AND a.object_table = 'civicrm_custom_group'
  1582. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1583. ORDER BY a.object_id
  1584.  
  1585. [21] =>
  1586. SELECT a.operation, a.object_id
  1587. FROM civicrm_acl_cache c, civicrm_acl a
  1588. WHERE c.acl_id = a.id
  1589. AND a.is_active = 1
  1590. AND a.object_table = 'civicrm_custom_group'
  1591. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1592. ORDER BY a.object_id
  1593.  
  1594. [22] =>
  1595. SELECT a.operation, a.object_id
  1596. FROM civicrm_acl_cache c, civicrm_acl a
  1597. WHERE c.acl_id = a.id
  1598. AND a.is_active = 1
  1599. AND a.object_table = 'civicrm_custom_group'
  1600. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1601. ORDER BY a.object_id
  1602.  
  1603. [23] =>
  1604. SELECT a.operation, a.object_id
  1605. FROM civicrm_acl_cache c, civicrm_acl a
  1606. WHERE c.acl_id = a.id
  1607. AND a.is_active = 1
  1608. AND a.object_table = 'civicrm_custom_group'
  1609. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1610. ORDER BY a.object_id
  1611.  
  1612. [24] =>
  1613. SELECT a.operation, a.object_id
  1614. FROM civicrm_acl_cache c, civicrm_acl a
  1615. WHERE c.acl_id = a.id
  1616. AND a.is_active = 1
  1617. AND a.object_table = 'civicrm_custom_group'
  1618. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1619. ORDER BY a.object_id
  1620.  
  1621. [25] =>
  1622. SELECT a.operation, a.object_id
  1623. FROM civicrm_acl_cache c, civicrm_acl a
  1624. WHERE c.acl_id = a.id
  1625. AND a.is_active = 1
  1626. AND a.object_table = 'civicrm_custom_group'
  1627. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1628. ORDER BY a.object_id
  1629.  
  1630. [26] => SELECT *
  1631. FROM civicrm_mail_settings
  1632.  
  1633. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  1634.  
  1635.  
  1636.  
  1637.  
  1638. )
  1639. Array
  1640. (
  1641. [0] => SELECT config_backend, locales, locale_custom_strings
  1642. FROM civicrm_domain
  1643.  
  1644. WHERE ( civicrm_domain.id = 1 )
  1645.  
  1646.  
  1647.  
  1648.  
  1649. [1] => SELECT *
  1650. FROM civicrm_uf_match
  1651.  
  1652. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  1653.  
  1654.  
  1655.  
  1656.  
  1657. [2] => SELECT *
  1658. FROM civicrm_uf_match
  1659.  
  1660. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  1661.  
  1662.  
  1663.  
  1664.  
  1665. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1666. civicrm_group.id as id
  1667. FROM civicrm_group
  1668. INNER JOIN civicrm_mailing_group
  1669. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1670. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1671. AND civicrm_mailing_group.group_type = 'Exclude'
  1672. AND civicrm_mailing_group.mailing_id = 83
  1673. AND civicrm_group.saved_search_id IS NOT null
  1674. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1675. civicrm_group.id as id
  1676. FROM civicrm_group
  1677. INNER JOIN civicrm_mailing_group
  1678. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1679. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1680. WHERE
  1681. civicrm_mailing_group.group_type = 'Include'
  1682. AND civicrm_mailing_group.search_id IS NULL
  1683. AND civicrm_mailing_group.mailing_id = 83
  1684. AND civicrm_group.saved_search_id IS NOT null
  1685. [5] =>
  1686. SELECT search_id, search_args, entity_id
  1687. FROM civicrm_mailing_group
  1688. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1689. AND civicrm_mailing_group.mailing_id = 83
  1690.  
  1691. [6] =>
  1692. SELECT j.*
  1693. FROM civicrm_mailing_job j,
  1694. civicrm_mailing m
  1695. WHERE m.id = j.mailing_id
  1696.  
  1697. AND j.is_test = 0
  1698. AND ( ( j.start_date IS null
  1699. AND j.scheduled_date <= 20110621173001
  1700. AND j.status = 'Scheduled' )
  1701. OR ( j.status = 'Running'
  1702. AND j.end_date IS null ) )
  1703. AND (j.job_type = 'child')
  1704. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  1705. ORDER BY j.mailing_id,
  1706. j.id
  1707.  
  1708. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1709. civicrm_group.id as id
  1710. FROM civicrm_group
  1711. INNER JOIN civicrm_mailing_group
  1712. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1713. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1714. AND civicrm_mailing_group.group_type = 'Exclude'
  1715. AND civicrm_mailing_group.mailing_id = 83
  1716. AND civicrm_group.saved_search_id IS NOT null
  1717. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1718. civicrm_group.id as id
  1719. FROM civicrm_group
  1720. INNER JOIN civicrm_mailing_group
  1721. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1722. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1723. WHERE
  1724. civicrm_mailing_group.group_type = 'Include'
  1725. AND civicrm_mailing_group.search_id IS NULL
  1726. AND civicrm_mailing_group.mailing_id = 83
  1727. AND civicrm_group.saved_search_id IS NOT null
  1728. [9] =>
  1729. SELECT search_id, search_args, entity_id
  1730. FROM civicrm_mailing_group
  1731. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1732. AND civicrm_mailing_group.mailing_id = 83
  1733.  
  1734. [10] => SELECT *
  1735. FROM civicrm_preferences
  1736.  
  1737. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  1738.  
  1739.  
  1740.  
  1741.  
  1742. [11] => SELECT *
  1743. FROM civicrm_mailing
  1744.  
  1745. WHERE ( civicrm_mailing.id = 83 )
  1746.  
  1747.  
  1748.  
  1749.  
  1750. [12] => SELECT *
  1751. FROM civicrm_domain
  1752.  
  1753. WHERE ( civicrm_domain.id = 1 )
  1754.  
  1755.  
  1756.  
  1757.  
  1758. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  1759. ph.id as phone_id, ph.location_type_id as locationTypeId
  1760. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  1761. WHERE ev.id = 1
  1762. AND loc.id = ev.loc_block_id
  1763. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  1764. AND ltype.id = ph.location_type_id
  1765. ORDER BY ph.is_primary DESC, phone_id ASC
  1766. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  1767. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  1768. WHERE ev.id = 1
  1769. AND loc.id = ev.loc_block_id
  1770. AND e.id IN (loc.email_id, loc.email_2_id)
  1771. AND ltype.id = e.location_type_id
  1772. ORDER BY e.is_primary DESC, email_id ASC
  1773. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  1774. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  1775. WHERE ev.id = 1
  1776. AND loc.id = ev.loc_block_id
  1777. AND cim.id IN (loc.im_id, loc.im_2_id)
  1778. AND ltype.id = cim.location_type_id
  1779. ORDER BY cim.is_primary DESC, im_id ASC
  1780. [16] =>
  1781. SELECT civicrm_address.id as address_id
  1782. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  1783. WHERE ev.id = 1
  1784. AND loc.id = ev.loc_block_id
  1785. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  1786. AND ltype.id = civicrm_address.location_type_id
  1787. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  1788. [17] =>
  1789. SELECT CF.id as cfID,
  1790. CF.uri as uri,
  1791. CF.mime_type as mime_type,
  1792. CEF.id as cefID
  1793. FROM civicrm_file AS CF
  1794. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  1795. WHERE CEF.entity_table = 'civicrm_mailing'
  1796. AND CEF.entity_id = 83
  1797. [18] => SELECT *
  1798. FROM civicrm_dedupe_rule_group
  1799.  
  1800. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  1801.  
  1802.  
  1803.  
  1804.  
  1805. [19] =>
  1806. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  1807. FROM civicrm_contact_type subtype
  1808. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  1809. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  1810. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  1811. [20] =>
  1812. SELECT a.operation, a.object_id
  1813. FROM civicrm_acl_cache c, civicrm_acl a
  1814. WHERE c.acl_id = a.id
  1815. AND a.is_active = 1
  1816. AND a.object_table = 'civicrm_custom_group'
  1817. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1818. ORDER BY a.object_id
  1819.  
  1820. [21] =>
  1821. SELECT a.operation, a.object_id
  1822. FROM civicrm_acl_cache c, civicrm_acl a
  1823. WHERE c.acl_id = a.id
  1824. AND a.is_active = 1
  1825. AND a.object_table = 'civicrm_custom_group'
  1826. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1827. ORDER BY a.object_id
  1828.  
  1829. [22] =>
  1830. SELECT a.operation, a.object_id
  1831. FROM civicrm_acl_cache c, civicrm_acl a
  1832. WHERE c.acl_id = a.id
  1833. AND a.is_active = 1
  1834. AND a.object_table = 'civicrm_custom_group'
  1835. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1836. ORDER BY a.object_id
  1837.  
  1838. [23] =>
  1839. SELECT a.operation, a.object_id
  1840. FROM civicrm_acl_cache c, civicrm_acl a
  1841. WHERE c.acl_id = a.id
  1842. AND a.is_active = 1
  1843. AND a.object_table = 'civicrm_custom_group'
  1844. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1845. ORDER BY a.object_id
  1846.  
  1847. [24] =>
  1848. SELECT a.operation, a.object_id
  1849. FROM civicrm_acl_cache c, civicrm_acl a
  1850. WHERE c.acl_id = a.id
  1851. AND a.is_active = 1
  1852. AND a.object_table = 'civicrm_custom_group'
  1853. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1854. ORDER BY a.object_id
  1855.  
  1856. [25] =>
  1857. SELECT a.operation, a.object_id
  1858. FROM civicrm_acl_cache c, civicrm_acl a
  1859. WHERE c.acl_id = a.id
  1860. AND a.is_active = 1
  1861. AND a.object_table = 'civicrm_custom_group'
  1862. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  1863. ORDER BY a.object_id
  1864.  
  1865. [26] => SELECT *
  1866. FROM civicrm_mail_settings
  1867.  
  1868. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  1869.  
  1870.  
  1871.  
  1872.  
  1873. )
  1874. Array
  1875. (
  1876. [0] => SELECT config_backend, locales, locale_custom_strings
  1877. FROM civicrm_domain
  1878.  
  1879. WHERE ( civicrm_domain.id = 1 )
  1880.  
  1881.  
  1882.  
  1883.  
  1884. [1] => SELECT *
  1885. FROM civicrm_uf_match
  1886.  
  1887. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  1888.  
  1889.  
  1890.  
  1891.  
  1892. [2] => SELECT *
  1893. FROM civicrm_uf_match
  1894.  
  1895. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  1896.  
  1897.  
  1898.  
  1899.  
  1900. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1901. civicrm_group.id as id
  1902. FROM civicrm_group
  1903. INNER JOIN civicrm_mailing_group
  1904. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1905. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1906. AND civicrm_mailing_group.group_type = 'Exclude'
  1907. AND civicrm_mailing_group.mailing_id = 83
  1908. AND civicrm_group.saved_search_id IS NOT null
  1909. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1910. civicrm_group.id as id
  1911. FROM civicrm_group
  1912. INNER JOIN civicrm_mailing_group
  1913. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1914. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1915. WHERE
  1916. civicrm_mailing_group.group_type = 'Include'
  1917. AND civicrm_mailing_group.search_id IS NULL
  1918. AND civicrm_mailing_group.mailing_id = 83
  1919. AND civicrm_group.saved_search_id IS NOT null
  1920. [5] =>
  1921. SELECT search_id, search_args, entity_id
  1922. FROM civicrm_mailing_group
  1923. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1924. AND civicrm_mailing_group.mailing_id = 83
  1925.  
  1926. [6] =>
  1927. SELECT j.*
  1928. FROM civicrm_mailing_job j,
  1929. civicrm_mailing m
  1930. WHERE m.id = j.mailing_id
  1931.  
  1932. AND j.is_test = 0
  1933. AND ( ( j.start_date IS null
  1934. AND j.scheduled_date <= 20110621173001
  1935. AND j.status = 'Scheduled' )
  1936. OR ( j.status = 'Running'
  1937. AND j.end_date IS null ) )
  1938. AND (j.job_type = 'child')
  1939. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  1940. ORDER BY j.mailing_id,
  1941. j.id
  1942.  
  1943. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1944. civicrm_group.id as id
  1945. FROM civicrm_group
  1946. INNER JOIN civicrm_mailing_group
  1947. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1948. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  1949. AND civicrm_mailing_group.group_type = 'Exclude'
  1950. AND civicrm_mailing_group.mailing_id = 83
  1951. AND civicrm_group.saved_search_id IS NOT null
  1952. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  1953. civicrm_group.id as id
  1954. FROM civicrm_group
  1955. INNER JOIN civicrm_mailing_group
  1956. ON civicrm_mailing_group.entity_id = civicrm_group.id
  1957. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  1958. WHERE
  1959. civicrm_mailing_group.group_type = 'Include'
  1960. AND civicrm_mailing_group.search_id IS NULL
  1961. AND civicrm_mailing_group.mailing_id = 83
  1962. AND civicrm_group.saved_search_id IS NOT null
  1963. [9] =>
  1964. SELECT search_id, search_args, entity_id
  1965. FROM civicrm_mailing_group
  1966. WHERE civicrm_mailing_group.search_id IS NOT NULL
  1967. AND civicrm_mailing_group.mailing_id = 83
  1968.  
  1969. [10] => SELECT *
  1970. FROM civicrm_preferences
  1971.  
  1972. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  1973.  
  1974.  
  1975.  
  1976.  
  1977. [11] => SELECT *
  1978. FROM civicrm_mailing
  1979.  
  1980. WHERE ( civicrm_mailing.id = 83 )
  1981.  
  1982.  
  1983.  
  1984.  
  1985. [12] => SELECT *
  1986. FROM civicrm_domain
  1987.  
  1988. WHERE ( civicrm_domain.id = 1 )
  1989.  
  1990.  
  1991.  
  1992.  
  1993. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  1994. ph.id as phone_id, ph.location_type_id as locationTypeId
  1995. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  1996. WHERE ev.id = 1
  1997. AND loc.id = ev.loc_block_id
  1998. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  1999. AND ltype.id = ph.location_type_id
  2000. ORDER BY ph.is_primary DESC, phone_id ASC
  2001. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  2002. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  2003. WHERE ev.id = 1
  2004. AND loc.id = ev.loc_block_id
  2005. AND e.id IN (loc.email_id, loc.email_2_id)
  2006. AND ltype.id = e.location_type_id
  2007. ORDER BY e.is_primary DESC, email_id ASC
  2008. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  2009. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  2010. WHERE ev.id = 1
  2011. AND loc.id = ev.loc_block_id
  2012. AND cim.id IN (loc.im_id, loc.im_2_id)
  2013. AND ltype.id = cim.location_type_id
  2014. ORDER BY cim.is_primary DESC, im_id ASC
  2015. [16] =>
  2016. SELECT civicrm_address.id as address_id
  2017. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  2018. WHERE ev.id = 1
  2019. AND loc.id = ev.loc_block_id
  2020. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  2021. AND ltype.id = civicrm_address.location_type_id
  2022. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  2023. [17] =>
  2024. SELECT CF.id as cfID,
  2025. CF.uri as uri,
  2026. CF.mime_type as mime_type,
  2027. CEF.id as cefID
  2028. FROM civicrm_file AS CF
  2029. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  2030. WHERE CEF.entity_table = 'civicrm_mailing'
  2031. AND CEF.entity_id = 83
  2032. [18] => SELECT *
  2033. FROM civicrm_dedupe_rule_group
  2034.  
  2035. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  2036.  
  2037.  
  2038.  
  2039.  
  2040. [19] =>
  2041. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  2042. FROM civicrm_contact_type subtype
  2043. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  2044. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  2045. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  2046. [20] =>
  2047. SELECT a.operation, a.object_id
  2048. FROM civicrm_acl_cache c, civicrm_acl a
  2049. WHERE c.acl_id = a.id
  2050. AND a.is_active = 1
  2051. AND a.object_table = 'civicrm_custom_group'
  2052. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2053. ORDER BY a.object_id
  2054.  
  2055. [21] =>
  2056. SELECT a.operation, a.object_id
  2057. FROM civicrm_acl_cache c, civicrm_acl a
  2058. WHERE c.acl_id = a.id
  2059. AND a.is_active = 1
  2060. AND a.object_table = 'civicrm_custom_group'
  2061. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2062. ORDER BY a.object_id
  2063.  
  2064. [22] =>
  2065. SELECT a.operation, a.object_id
  2066. FROM civicrm_acl_cache c, civicrm_acl a
  2067. WHERE c.acl_id = a.id
  2068. AND a.is_active = 1
  2069. AND a.object_table = 'civicrm_custom_group'
  2070. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2071. ORDER BY a.object_id
  2072.  
  2073. [23] =>
  2074. SELECT a.operation, a.object_id
  2075. FROM civicrm_acl_cache c, civicrm_acl a
  2076. WHERE c.acl_id = a.id
  2077. AND a.is_active = 1
  2078. AND a.object_table = 'civicrm_custom_group'
  2079. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2080. ORDER BY a.object_id
  2081.  
  2082. [24] =>
  2083. SELECT a.operation, a.object_id
  2084. FROM civicrm_acl_cache c, civicrm_acl a
  2085. WHERE c.acl_id = a.id
  2086. AND a.is_active = 1
  2087. AND a.object_table = 'civicrm_custom_group'
  2088. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2089. ORDER BY a.object_id
  2090.  
  2091. [25] =>
  2092. SELECT a.operation, a.object_id
  2093. FROM civicrm_acl_cache c, civicrm_acl a
  2094. WHERE c.acl_id = a.id
  2095. AND a.is_active = 1
  2096. AND a.object_table = 'civicrm_custom_group'
  2097. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2098. ORDER BY a.object_id
  2099.  
  2100. [26] => SELECT *
  2101. FROM civicrm_mail_settings
  2102.  
  2103. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  2104.  
  2105.  
  2106.  
  2107.  
  2108. )
  2109. Array
  2110. (
  2111. [0] => SELECT config_backend, locales, locale_custom_strings
  2112. FROM civicrm_domain
  2113.  
  2114. WHERE ( civicrm_domain.id = 1 )
  2115.  
  2116.  
  2117.  
  2118.  
  2119. [1] => SELECT *
  2120. FROM civicrm_uf_match
  2121.  
  2122. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  2123.  
  2124.  
  2125.  
  2126.  
  2127. [2] => SELECT *
  2128. FROM civicrm_uf_match
  2129.  
  2130. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  2131.  
  2132.  
  2133.  
  2134.  
  2135. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2136. civicrm_group.id as id
  2137. FROM civicrm_group
  2138. INNER JOIN civicrm_mailing_group
  2139. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2140. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  2141. AND civicrm_mailing_group.group_type = 'Exclude'
  2142. AND civicrm_mailing_group.mailing_id = 83
  2143. AND civicrm_group.saved_search_id IS NOT null
  2144. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2145. civicrm_group.id as id
  2146. FROM civicrm_group
  2147. INNER JOIN civicrm_mailing_group
  2148. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2149. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  2150. WHERE
  2151. civicrm_mailing_group.group_type = 'Include'
  2152. AND civicrm_mailing_group.search_id IS NULL
  2153. AND civicrm_mailing_group.mailing_id = 83
  2154. AND civicrm_group.saved_search_id IS NOT null
  2155. [5] =>
  2156. SELECT search_id, search_args, entity_id
  2157. FROM civicrm_mailing_group
  2158. WHERE civicrm_mailing_group.search_id IS NOT NULL
  2159. AND civicrm_mailing_group.mailing_id = 83
  2160.  
  2161. [6] =>
  2162. SELECT j.*
  2163. FROM civicrm_mailing_job j,
  2164. civicrm_mailing m
  2165. WHERE m.id = j.mailing_id
  2166.  
  2167. AND j.is_test = 0
  2168. AND ( ( j.start_date IS null
  2169. AND j.scheduled_date <= 20110621173001
  2170. AND j.status = 'Scheduled' )
  2171. OR ( j.status = 'Running'
  2172. AND j.end_date IS null ) )
  2173. AND (j.job_type = 'child')
  2174. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  2175. ORDER BY j.mailing_id,
  2176. j.id
  2177.  
  2178. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2179. civicrm_group.id as id
  2180. FROM civicrm_group
  2181. INNER JOIN civicrm_mailing_group
  2182. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2183. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  2184. AND civicrm_mailing_group.group_type = 'Exclude'
  2185. AND civicrm_mailing_group.mailing_id = 83
  2186. AND civicrm_group.saved_search_id IS NOT null
  2187. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2188. civicrm_group.id as id
  2189. FROM civicrm_group
  2190. INNER JOIN civicrm_mailing_group
  2191. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2192. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  2193. WHERE
  2194. civicrm_mailing_group.group_type = 'Include'
  2195. AND civicrm_mailing_group.search_id IS NULL
  2196. AND civicrm_mailing_group.mailing_id = 83
  2197. AND civicrm_group.saved_search_id IS NOT null
  2198. [9] =>
  2199. SELECT search_id, search_args, entity_id
  2200. FROM civicrm_mailing_group
  2201. WHERE civicrm_mailing_group.search_id IS NOT NULL
  2202. AND civicrm_mailing_group.mailing_id = 83
  2203.  
  2204. [10] => SELECT *
  2205. FROM civicrm_preferences
  2206.  
  2207. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  2208.  
  2209.  
  2210.  
  2211.  
  2212. [11] => SELECT *
  2213. FROM civicrm_mailing
  2214.  
  2215. WHERE ( civicrm_mailing.id = 83 )
  2216.  
  2217.  
  2218.  
  2219.  
  2220. [12] => SELECT *
  2221. FROM civicrm_domain
  2222.  
  2223. WHERE ( civicrm_domain.id = 1 )
  2224.  
  2225.  
  2226.  
  2227.  
  2228. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  2229. ph.id as phone_id, ph.location_type_id as locationTypeId
  2230. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  2231. WHERE ev.id = 1
  2232. AND loc.id = ev.loc_block_id
  2233. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  2234. AND ltype.id = ph.location_type_id
  2235. ORDER BY ph.is_primary DESC, phone_id ASC
  2236. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  2237. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  2238. WHERE ev.id = 1
  2239. AND loc.id = ev.loc_block_id
  2240. AND e.id IN (loc.email_id, loc.email_2_id)
  2241. AND ltype.id = e.location_type_id
  2242. ORDER BY e.is_primary DESC, email_id ASC
  2243. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  2244. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  2245. WHERE ev.id = 1
  2246. AND loc.id = ev.loc_block_id
  2247. AND cim.id IN (loc.im_id, loc.im_2_id)
  2248. AND ltype.id = cim.location_type_id
  2249. ORDER BY cim.is_primary DESC, im_id ASC
  2250. [16] =>
  2251. SELECT civicrm_address.id as address_id
  2252. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  2253. WHERE ev.id = 1
  2254. AND loc.id = ev.loc_block_id
  2255. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  2256. AND ltype.id = civicrm_address.location_type_id
  2257. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  2258. [17] =>
  2259. SELECT CF.id as cfID,
  2260. CF.uri as uri,
  2261. CF.mime_type as mime_type,
  2262. CEF.id as cefID
  2263. FROM civicrm_file AS CF
  2264. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  2265. WHERE CEF.entity_table = 'civicrm_mailing'
  2266. AND CEF.entity_id = 83
  2267. [18] => SELECT *
  2268. FROM civicrm_dedupe_rule_group
  2269.  
  2270. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  2271.  
  2272.  
  2273.  
  2274.  
  2275. [19] =>
  2276. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  2277. FROM civicrm_contact_type subtype
  2278. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  2279. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  2280. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  2281. [20] =>
  2282. SELECT a.operation, a.object_id
  2283. FROM civicrm_acl_cache c, civicrm_acl a
  2284. WHERE c.acl_id = a.id
  2285. AND a.is_active = 1
  2286. AND a.object_table = 'civicrm_custom_group'
  2287. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2288. ORDER BY a.object_id
  2289.  
  2290. [21] =>
  2291. SELECT a.operation, a.object_id
  2292. FROM civicrm_acl_cache c, civicrm_acl a
  2293. WHERE c.acl_id = a.id
  2294. AND a.is_active = 1
  2295. AND a.object_table = 'civicrm_custom_group'
  2296. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2297. ORDER BY a.object_id
  2298.  
  2299. [22] =>
  2300. SELECT a.operation, a.object_id
  2301. FROM civicrm_acl_cache c, civicrm_acl a
  2302. WHERE c.acl_id = a.id
  2303. AND a.is_active = 1
  2304. AND a.object_table = 'civicrm_custom_group'
  2305. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2306. ORDER BY a.object_id
  2307.  
  2308. [23] =>
  2309. SELECT a.operation, a.object_id
  2310. FROM civicrm_acl_cache c, civicrm_acl a
  2311. WHERE c.acl_id = a.id
  2312. AND a.is_active = 1
  2313. AND a.object_table = 'civicrm_custom_group'
  2314. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2315. ORDER BY a.object_id
  2316.  
  2317. [24] =>
  2318. SELECT a.operation, a.object_id
  2319. FROM civicrm_acl_cache c, civicrm_acl a
  2320. WHERE c.acl_id = a.id
  2321. AND a.is_active = 1
  2322. AND a.object_table = 'civicrm_custom_group'
  2323. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2324. ORDER BY a.object_id
  2325.  
  2326. [25] =>
  2327. SELECT a.operation, a.object_id
  2328. FROM civicrm_acl_cache c, civicrm_acl a
  2329. WHERE c.acl_id = a.id
  2330. AND a.is_active = 1
  2331. AND a.object_table = 'civicrm_custom_group'
  2332. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2333. ORDER BY a.object_id
  2334.  
  2335. [26] => SELECT *
  2336. FROM civicrm_mail_settings
  2337.  
  2338. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  2339.  
  2340.  
  2341.  
  2342.  
  2343. )
  2344. Array
  2345. (
  2346. [0] => SELECT config_backend, locales, locale_custom_strings
  2347. FROM civicrm_domain
  2348.  
  2349. WHERE ( civicrm_domain.id = 1 )
  2350.  
  2351.  
  2352.  
  2353.  
  2354. [1] => SELECT *
  2355. FROM civicrm_uf_match
  2356.  
  2357. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  2358.  
  2359.  
  2360.  
  2361.  
  2362. [2] => SELECT *
  2363. FROM civicrm_uf_match
  2364.  
  2365. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  2366.  
  2367.  
  2368.  
  2369.  
  2370. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2371. civicrm_group.id as id
  2372. FROM civicrm_group
  2373. INNER JOIN civicrm_mailing_group
  2374. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2375. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  2376. AND civicrm_mailing_group.group_type = 'Exclude'
  2377. AND civicrm_mailing_group.mailing_id = 83
  2378. AND civicrm_group.saved_search_id IS NOT null
  2379. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2380. civicrm_group.id as id
  2381. FROM civicrm_group
  2382. INNER JOIN civicrm_mailing_group
  2383. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2384. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  2385. WHERE
  2386. civicrm_mailing_group.group_type = 'Include'
  2387. AND civicrm_mailing_group.search_id IS NULL
  2388. AND civicrm_mailing_group.mailing_id = 83
  2389. AND civicrm_group.saved_search_id IS NOT null
  2390. [5] =>
  2391. SELECT search_id, search_args, entity_id
  2392. FROM civicrm_mailing_group
  2393. WHERE civicrm_mailing_group.search_id IS NOT NULL
  2394. AND civicrm_mailing_group.mailing_id = 83
  2395.  
  2396. [6] =>
  2397. SELECT j.*
  2398. FROM civicrm_mailing_job j,
  2399. civicrm_mailing m
  2400. WHERE m.id = j.mailing_id
  2401.  
  2402. AND j.is_test = 0
  2403. AND ( ( j.start_date IS null
  2404. AND j.scheduled_date <= 20110621173001
  2405. AND j.status = 'Scheduled' )
  2406. OR ( j.status = 'Running'
  2407. AND j.end_date IS null ) )
  2408. AND (j.job_type = 'child')
  2409. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  2410. ORDER BY j.mailing_id,
  2411. j.id
  2412.  
  2413. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2414. civicrm_group.id as id
  2415. FROM civicrm_group
  2416. INNER JOIN civicrm_mailing_group
  2417. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2418. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  2419. AND civicrm_mailing_group.group_type = 'Exclude'
  2420. AND civicrm_mailing_group.mailing_id = 83
  2421. AND civicrm_group.saved_search_id IS NOT null
  2422. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2423. civicrm_group.id as id
  2424. FROM civicrm_group
  2425. INNER JOIN civicrm_mailing_group
  2426. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2427. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  2428. WHERE
  2429. civicrm_mailing_group.group_type = 'Include'
  2430. AND civicrm_mailing_group.search_id IS NULL
  2431. AND civicrm_mailing_group.mailing_id = 83
  2432. AND civicrm_group.saved_search_id IS NOT null
  2433. [9] =>
  2434. SELECT search_id, search_args, entity_id
  2435. FROM civicrm_mailing_group
  2436. WHERE civicrm_mailing_group.search_id IS NOT NULL
  2437. AND civicrm_mailing_group.mailing_id = 83
  2438.  
  2439. [10] => SELECT *
  2440. FROM civicrm_preferences
  2441.  
  2442. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  2443.  
  2444.  
  2445.  
  2446.  
  2447. [11] => SELECT *
  2448. FROM civicrm_mailing
  2449.  
  2450. WHERE ( civicrm_mailing.id = 83 )
  2451.  
  2452.  
  2453.  
  2454.  
  2455. [12] => SELECT *
  2456. FROM civicrm_domain
  2457.  
  2458. WHERE ( civicrm_domain.id = 1 )
  2459.  
  2460.  
  2461.  
  2462.  
  2463. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  2464. ph.id as phone_id, ph.location_type_id as locationTypeId
  2465. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  2466. WHERE ev.id = 1
  2467. AND loc.id = ev.loc_block_id
  2468. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  2469. AND ltype.id = ph.location_type_id
  2470. ORDER BY ph.is_primary DESC, phone_id ASC
  2471. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  2472. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  2473. WHERE ev.id = 1
  2474. AND loc.id = ev.loc_block_id
  2475. AND e.id IN (loc.email_id, loc.email_2_id)
  2476. AND ltype.id = e.location_type_id
  2477. ORDER BY e.is_primary DESC, email_id ASC
  2478. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  2479. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  2480. WHERE ev.id = 1
  2481. AND loc.id = ev.loc_block_id
  2482. AND cim.id IN (loc.im_id, loc.im_2_id)
  2483. AND ltype.id = cim.location_type_id
  2484. ORDER BY cim.is_primary DESC, im_id ASC
  2485. [16] =>
  2486. SELECT civicrm_address.id as address_id
  2487. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  2488. WHERE ev.id = 1
  2489. AND loc.id = ev.loc_block_id
  2490. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  2491. AND ltype.id = civicrm_address.location_type_id
  2492. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  2493. [17] =>
  2494. SELECT CF.id as cfID,
  2495. CF.uri as uri,
  2496. CF.mime_type as mime_type,
  2497. CEF.id as cefID
  2498. FROM civicrm_file AS CF
  2499. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  2500. WHERE CEF.entity_table = 'civicrm_mailing'
  2501. AND CEF.entity_id = 83
  2502. [18] => SELECT *
  2503. FROM civicrm_dedupe_rule_group
  2504.  
  2505. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  2506.  
  2507.  
  2508.  
  2509.  
  2510. [19] =>
  2511. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  2512. FROM civicrm_contact_type subtype
  2513. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  2514. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  2515. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  2516. [20] =>
  2517. SELECT a.operation, a.object_id
  2518. FROM civicrm_acl_cache c, civicrm_acl a
  2519. WHERE c.acl_id = a.id
  2520. AND a.is_active = 1
  2521. AND a.object_table = 'civicrm_custom_group'
  2522. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2523. ORDER BY a.object_id
  2524.  
  2525. [21] =>
  2526. SELECT a.operation, a.object_id
  2527. FROM civicrm_acl_cache c, civicrm_acl a
  2528. WHERE c.acl_id = a.id
  2529. AND a.is_active = 1
  2530. AND a.object_table = 'civicrm_custom_group'
  2531. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2532. ORDER BY a.object_id
  2533.  
  2534. [22] =>
  2535. SELECT a.operation, a.object_id
  2536. FROM civicrm_acl_cache c, civicrm_acl a
  2537. WHERE c.acl_id = a.id
  2538. AND a.is_active = 1
  2539. AND a.object_table = 'civicrm_custom_group'
  2540. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2541. ORDER BY a.object_id
  2542.  
  2543. [23] =>
  2544. SELECT a.operation, a.object_id
  2545. FROM civicrm_acl_cache c, civicrm_acl a
  2546. WHERE c.acl_id = a.id
  2547. AND a.is_active = 1
  2548. AND a.object_table = 'civicrm_custom_group'
  2549. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2550. ORDER BY a.object_id
  2551.  
  2552. [24] =>
  2553. SELECT a.operation, a.object_id
  2554. FROM civicrm_acl_cache c, civicrm_acl a
  2555. WHERE c.acl_id = a.id
  2556. AND a.is_active = 1
  2557. AND a.object_table = 'civicrm_custom_group'
  2558. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2559. ORDER BY a.object_id
  2560.  
  2561. [25] =>
  2562. SELECT a.operation, a.object_id
  2563. FROM civicrm_acl_cache c, civicrm_acl a
  2564. WHERE c.acl_id = a.id
  2565. AND a.is_active = 1
  2566. AND a.object_table = 'civicrm_custom_group'
  2567. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2568. ORDER BY a.object_id
  2569.  
  2570. [26] => SELECT *
  2571. FROM civicrm_mail_settings
  2572.  
  2573. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  2574.  
  2575.  
  2576.  
  2577.  
  2578. [27] =>
  2579. SELECT v.label as label ,v.value as value
  2580. FROM civicrm_option_value v,
  2581. civicrm_option_group g
  2582. WHERE v.option_group_id = g.id
  2583. AND g.name = 'activity_type'
  2584. AND v.is_active = 1
  2585. AND g.is_active = 1
  2586. AND v.name = 'Bulk Email'
  2587.  
  2588. [28] =>
  2589. SELECT a.operation, a.object_id
  2590. FROM civicrm_acl_cache c, civicrm_acl a
  2591. WHERE c.acl_id = a.id
  2592. AND a.is_active = 1
  2593. AND a.object_table = 'civicrm_custom_group'
  2594. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2595. ORDER BY a.object_id
  2596.  
  2597. [29] =>
  2598. SELECT v.label as label ,v.value as value
  2599. FROM civicrm_option_value v,
  2600. civicrm_option_group g
  2601. WHERE v.option_group_id = g.id
  2602. AND g.name = 'activity_type'
  2603. AND v.is_active = 1
  2604. AND g.is_active = 1
  2605. AND v.name = 'Email'
  2606.  
  2607. [30] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2608. civicrm_group.id as id
  2609. FROM civicrm_group
  2610. INNER JOIN civicrm_mailing_group
  2611. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2612. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  2613. AND civicrm_mailing_group.group_type = 'Exclude'
  2614. AND civicrm_mailing_group.mailing_id = 83
  2615. AND civicrm_group.saved_search_id IS NOT null
  2616. [31] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2617. civicrm_group.id as id
  2618. FROM civicrm_group
  2619. INNER JOIN civicrm_mailing_group
  2620. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2621. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  2622. WHERE
  2623. civicrm_mailing_group.group_type = 'Include'
  2624. AND civicrm_mailing_group.search_id IS NULL
  2625. AND civicrm_mailing_group.mailing_id = 83
  2626. AND civicrm_group.saved_search_id IS NOT null
  2627. [32] =>
  2628. SELECT search_id, search_args, entity_id
  2629. FROM civicrm_mailing_group
  2630. WHERE civicrm_mailing_group.search_id IS NOT NULL
  2631. AND civicrm_mailing_group.mailing_id = 83
  2632.  
  2633. [33] => SELECT *
  2634. FROM civicrm_mailing
  2635.  
  2636. WHERE ( civicrm_mailing.id = 83 )
  2637.  
  2638.  
  2639.  
  2640.  
  2641. [34] =>
  2642. SELECT CF.id as cfID,
  2643. CF.uri as uri,
  2644. CF.mime_type as mime_type,
  2645. CEF.id as cefID
  2646. FROM civicrm_file AS CF
  2647. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  2648. WHERE CEF.entity_table = 'civicrm_mailing'
  2649. AND CEF.entity_id = 83
  2650. [35] =>
  2651. SELECT a.operation, a.object_id
  2652. FROM civicrm_acl_cache c, civicrm_acl a
  2653. WHERE c.acl_id = a.id
  2654. AND a.is_active = 1
  2655. AND a.object_table = 'civicrm_custom_group'
  2656. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2657. ORDER BY a.object_id
  2658.  
  2659. [36] =>
  2660. SELECT a.operation, a.object_id
  2661. FROM civicrm_acl_cache c, civicrm_acl a
  2662. WHERE c.acl_id = a.id
  2663. AND a.is_active = 1
  2664. AND a.object_table = 'civicrm_custom_group'
  2665. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2666. ORDER BY a.object_id
  2667.  
  2668. )
  2669. Array
  2670. (
  2671. [0] => SELECT config_backend, locales, locale_custom_strings
  2672. FROM civicrm_domain
  2673.  
  2674. WHERE ( civicrm_domain.id = 1 )
  2675.  
  2676.  
  2677.  
  2678.  
  2679. [1] => SELECT *
  2680. FROM civicrm_uf_match
  2681.  
  2682. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  2683.  
  2684.  
  2685.  
  2686.  
  2687. [2] => SELECT *
  2688. FROM civicrm_uf_match
  2689.  
  2690. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  2691.  
  2692.  
  2693.  
  2694.  
  2695. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2696. civicrm_group.id as id
  2697. FROM civicrm_group
  2698. INNER JOIN civicrm_mailing_group
  2699. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2700. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  2701. AND civicrm_mailing_group.group_type = 'Exclude'
  2702. AND civicrm_mailing_group.mailing_id = 83
  2703. AND civicrm_group.saved_search_id IS NOT null
  2704. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2705. civicrm_group.id as id
  2706. FROM civicrm_group
  2707. INNER JOIN civicrm_mailing_group
  2708. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2709. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  2710. WHERE
  2711. civicrm_mailing_group.group_type = 'Include'
  2712. AND civicrm_mailing_group.search_id IS NULL
  2713. AND civicrm_mailing_group.mailing_id = 83
  2714. AND civicrm_group.saved_search_id IS NOT null
  2715. [5] =>
  2716. SELECT search_id, search_args, entity_id
  2717. FROM civicrm_mailing_group
  2718. WHERE civicrm_mailing_group.search_id IS NOT NULL
  2719. AND civicrm_mailing_group.mailing_id = 83
  2720.  
  2721. [6] =>
  2722. SELECT j.*
  2723. FROM civicrm_mailing_job j,
  2724. civicrm_mailing m
  2725. WHERE m.id = j.mailing_id
  2726.  
  2727. AND j.is_test = 0
  2728. AND ( ( j.start_date IS null
  2729. AND j.scheduled_date <= 20110621173001
  2730. AND j.status = 'Scheduled' )
  2731. OR ( j.status = 'Running'
  2732. AND j.end_date IS null ) )
  2733. AND (j.job_type = 'child')
  2734. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  2735. ORDER BY j.mailing_id,
  2736. j.id
  2737.  
  2738. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2739. civicrm_group.id as id
  2740. FROM civicrm_group
  2741. INNER JOIN civicrm_mailing_group
  2742. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2743. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  2744. AND civicrm_mailing_group.group_type = 'Exclude'
  2745. AND civicrm_mailing_group.mailing_id = 83
  2746. AND civicrm_group.saved_search_id IS NOT null
  2747. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2748. civicrm_group.id as id
  2749. FROM civicrm_group
  2750. INNER JOIN civicrm_mailing_group
  2751. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2752. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  2753. WHERE
  2754. civicrm_mailing_group.group_type = 'Include'
  2755. AND civicrm_mailing_group.search_id IS NULL
  2756. AND civicrm_mailing_group.mailing_id = 83
  2757. AND civicrm_group.saved_search_id IS NOT null
  2758. [9] =>
  2759. SELECT search_id, search_args, entity_id
  2760. FROM civicrm_mailing_group
  2761. WHERE civicrm_mailing_group.search_id IS NOT NULL
  2762. AND civicrm_mailing_group.mailing_id = 83
  2763.  
  2764. [10] => SELECT *
  2765. FROM civicrm_preferences
  2766.  
  2767. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  2768.  
  2769.  
  2770.  
  2771.  
  2772. [11] => SELECT *
  2773. FROM civicrm_mailing
  2774.  
  2775. WHERE ( civicrm_mailing.id = 83 )
  2776.  
  2777.  
  2778.  
  2779.  
  2780. [12] => SELECT *
  2781. FROM civicrm_domain
  2782.  
  2783. WHERE ( civicrm_domain.id = 1 )
  2784.  
  2785.  
  2786.  
  2787.  
  2788. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  2789. ph.id as phone_id, ph.location_type_id as locationTypeId
  2790. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  2791. WHERE ev.id = 1
  2792. AND loc.id = ev.loc_block_id
  2793. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  2794. AND ltype.id = ph.location_type_id
  2795. ORDER BY ph.is_primary DESC, phone_id ASC
  2796. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  2797. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  2798. WHERE ev.id = 1
  2799. AND loc.id = ev.loc_block_id
  2800. AND e.id IN (loc.email_id, loc.email_2_id)
  2801. AND ltype.id = e.location_type_id
  2802. ORDER BY e.is_primary DESC, email_id ASC
  2803. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  2804. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  2805. WHERE ev.id = 1
  2806. AND loc.id = ev.loc_block_id
  2807. AND cim.id IN (loc.im_id, loc.im_2_id)
  2808. AND ltype.id = cim.location_type_id
  2809. ORDER BY cim.is_primary DESC, im_id ASC
  2810. [16] =>
  2811. SELECT civicrm_address.id as address_id
  2812. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  2813. WHERE ev.id = 1
  2814. AND loc.id = ev.loc_block_id
  2815. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  2816. AND ltype.id = civicrm_address.location_type_id
  2817. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  2818. [17] =>
  2819. SELECT CF.id as cfID,
  2820. CF.uri as uri,
  2821. CF.mime_type as mime_type,
  2822. CEF.id as cefID
  2823. FROM civicrm_file AS CF
  2824. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  2825. WHERE CEF.entity_table = 'civicrm_mailing'
  2826. AND CEF.entity_id = 83
  2827. [18] => SELECT *
  2828. FROM civicrm_dedupe_rule_group
  2829.  
  2830. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  2831.  
  2832.  
  2833.  
  2834.  
  2835. [19] =>
  2836. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  2837. FROM civicrm_contact_type subtype
  2838. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  2839. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  2840. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  2841. [20] =>
  2842. SELECT a.operation, a.object_id
  2843. FROM civicrm_acl_cache c, civicrm_acl a
  2844. WHERE c.acl_id = a.id
  2845. AND a.is_active = 1
  2846. AND a.object_table = 'civicrm_custom_group'
  2847. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2848. ORDER BY a.object_id
  2849.  
  2850. [21] =>
  2851. SELECT a.operation, a.object_id
  2852. FROM civicrm_acl_cache c, civicrm_acl a
  2853. WHERE c.acl_id = a.id
  2854. AND a.is_active = 1
  2855. AND a.object_table = 'civicrm_custom_group'
  2856. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2857. ORDER BY a.object_id
  2858.  
  2859. [22] =>
  2860. SELECT a.operation, a.object_id
  2861. FROM civicrm_acl_cache c, civicrm_acl a
  2862. WHERE c.acl_id = a.id
  2863. AND a.is_active = 1
  2864. AND a.object_table = 'civicrm_custom_group'
  2865. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2866. ORDER BY a.object_id
  2867.  
  2868. [23] =>
  2869. SELECT a.operation, a.object_id
  2870. FROM civicrm_acl_cache c, civicrm_acl a
  2871. WHERE c.acl_id = a.id
  2872. AND a.is_active = 1
  2873. AND a.object_table = 'civicrm_custom_group'
  2874. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2875. ORDER BY a.object_id
  2876.  
  2877. [24] =>
  2878. SELECT a.operation, a.object_id
  2879. FROM civicrm_acl_cache c, civicrm_acl a
  2880. WHERE c.acl_id = a.id
  2881. AND a.is_active = 1
  2882. AND a.object_table = 'civicrm_custom_group'
  2883. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2884. ORDER BY a.object_id
  2885.  
  2886. [25] =>
  2887. SELECT a.operation, a.object_id
  2888. FROM civicrm_acl_cache c, civicrm_acl a
  2889. WHERE c.acl_id = a.id
  2890. AND a.is_active = 1
  2891. AND a.object_table = 'civicrm_custom_group'
  2892. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2893. ORDER BY a.object_id
  2894.  
  2895. [26] => SELECT *
  2896. FROM civicrm_mail_settings
  2897.  
  2898. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  2899.  
  2900.  
  2901.  
  2902.  
  2903. [27] =>
  2904. SELECT v.label as label ,v.value as value
  2905. FROM civicrm_option_value v,
  2906. civicrm_option_group g
  2907. WHERE v.option_group_id = g.id
  2908. AND g.name = 'activity_type'
  2909. AND v.is_active = 1
  2910. AND g.is_active = 1
  2911. AND v.name = 'Bulk Email'
  2912.  
  2913. [28] =>
  2914. SELECT a.operation, a.object_id
  2915. FROM civicrm_acl_cache c, civicrm_acl a
  2916. WHERE c.acl_id = a.id
  2917. AND a.is_active = 1
  2918. AND a.object_table = 'civicrm_custom_group'
  2919. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2920. ORDER BY a.object_id
  2921.  
  2922. [29] =>
  2923. SELECT v.label as label ,v.value as value
  2924. FROM civicrm_option_value v,
  2925. civicrm_option_group g
  2926. WHERE v.option_group_id = g.id
  2927. AND g.name = 'activity_type'
  2928. AND v.is_active = 1
  2929. AND g.is_active = 1
  2930. AND v.name = 'Email'
  2931.  
  2932. [30] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2933. civicrm_group.id as id
  2934. FROM civicrm_group
  2935. INNER JOIN civicrm_mailing_group
  2936. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2937. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  2938. AND civicrm_mailing_group.group_type = 'Exclude'
  2939. AND civicrm_mailing_group.mailing_id = 83
  2940. AND civicrm_group.saved_search_id IS NOT null
  2941. [31] => SELECT civicrm_group.saved_search_id as saved_search_id,
  2942. civicrm_group.id as id
  2943. FROM civicrm_group
  2944. INNER JOIN civicrm_mailing_group
  2945. ON civicrm_mailing_group.entity_id = civicrm_group.id
  2946. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  2947. WHERE
  2948. civicrm_mailing_group.group_type = 'Include'
  2949. AND civicrm_mailing_group.search_id IS NULL
  2950. AND civicrm_mailing_group.mailing_id = 83
  2951. AND civicrm_group.saved_search_id IS NOT null
  2952. [32] =>
  2953. SELECT search_id, search_args, entity_id
  2954. FROM civicrm_mailing_group
  2955. WHERE civicrm_mailing_group.search_id IS NOT NULL
  2956. AND civicrm_mailing_group.mailing_id = 83
  2957.  
  2958. [33] => SELECT *
  2959. FROM civicrm_mailing
  2960.  
  2961. WHERE ( civicrm_mailing.id = 83 )
  2962.  
  2963.  
  2964.  
  2965.  
  2966. [34] =>
  2967. SELECT CF.id as cfID,
  2968. CF.uri as uri,
  2969. CF.mime_type as mime_type,
  2970. CEF.id as cefID
  2971. FROM civicrm_file AS CF
  2972. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  2973. WHERE CEF.entity_table = 'civicrm_mailing'
  2974. AND CEF.entity_id = 83
  2975. [35] =>
  2976. SELECT a.operation, a.object_id
  2977. FROM civicrm_acl_cache c, civicrm_acl a
  2978. WHERE c.acl_id = a.id
  2979. AND a.is_active = 1
  2980. AND a.object_table = 'civicrm_custom_group'
  2981. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2982. ORDER BY a.object_id
  2983.  
  2984. [36] =>
  2985. SELECT a.operation, a.object_id
  2986. FROM civicrm_acl_cache c, civicrm_acl a
  2987. WHERE c.acl_id = a.id
  2988. AND a.is_active = 1
  2989. AND a.object_table = 'civicrm_custom_group'
  2990. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  2991. ORDER BY a.object_id
  2992.  
  2993. )
  2994. Array
  2995. (
  2996. [0] => SELECT config_backend, locales, locale_custom_strings
  2997. FROM civicrm_domain
  2998.  
  2999. WHERE ( civicrm_domain.id = 1 )
  3000.  
  3001.  
  3002.  
  3003.  
  3004. [1] => SELECT *
  3005. FROM civicrm_uf_match
  3006.  
  3007. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  3008.  
  3009.  
  3010.  
  3011.  
  3012. [2] => SELECT *
  3013. FROM civicrm_uf_match
  3014.  
  3015. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  3016.  
  3017.  
  3018.  
  3019.  
  3020. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3021. civicrm_group.id as id
  3022. FROM civicrm_group
  3023. INNER JOIN civicrm_mailing_group
  3024. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3025. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3026. AND civicrm_mailing_group.group_type = 'Exclude'
  3027. AND civicrm_mailing_group.mailing_id = 83
  3028. AND civicrm_group.saved_search_id IS NOT null
  3029. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3030. civicrm_group.id as id
  3031. FROM civicrm_group
  3032. INNER JOIN civicrm_mailing_group
  3033. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3034. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3035. WHERE
  3036. civicrm_mailing_group.group_type = 'Include'
  3037. AND civicrm_mailing_group.search_id IS NULL
  3038. AND civicrm_mailing_group.mailing_id = 83
  3039. AND civicrm_group.saved_search_id IS NOT null
  3040. [5] =>
  3041. SELECT search_id, search_args, entity_id
  3042. FROM civicrm_mailing_group
  3043. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3044. AND civicrm_mailing_group.mailing_id = 83
  3045.  
  3046. [6] =>
  3047. SELECT j.*
  3048. FROM civicrm_mailing_job j,
  3049. civicrm_mailing m
  3050. WHERE m.id = j.mailing_id
  3051.  
  3052. AND j.is_test = 0
  3053. AND ( ( j.start_date IS null
  3054. AND j.scheduled_date <= 20110621173001
  3055. AND j.status = 'Scheduled' )
  3056. OR ( j.status = 'Running'
  3057. AND j.end_date IS null ) )
  3058. AND (j.job_type = 'child')
  3059. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  3060. ORDER BY j.mailing_id,
  3061. j.id
  3062.  
  3063. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3064. civicrm_group.id as id
  3065. FROM civicrm_group
  3066. INNER JOIN civicrm_mailing_group
  3067. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3068. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3069. AND civicrm_mailing_group.group_type = 'Exclude'
  3070. AND civicrm_mailing_group.mailing_id = 83
  3071. AND civicrm_group.saved_search_id IS NOT null
  3072. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3073. civicrm_group.id as id
  3074. FROM civicrm_group
  3075. INNER JOIN civicrm_mailing_group
  3076. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3077. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3078. WHERE
  3079. civicrm_mailing_group.group_type = 'Include'
  3080. AND civicrm_mailing_group.search_id IS NULL
  3081. AND civicrm_mailing_group.mailing_id = 83
  3082. AND civicrm_group.saved_search_id IS NOT null
  3083. [9] =>
  3084. SELECT search_id, search_args, entity_id
  3085. FROM civicrm_mailing_group
  3086. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3087. AND civicrm_mailing_group.mailing_id = 83
  3088.  
  3089. [10] => SELECT *
  3090. FROM civicrm_preferences
  3091.  
  3092. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  3093.  
  3094.  
  3095.  
  3096.  
  3097. [11] => SELECT *
  3098. FROM civicrm_mailing
  3099.  
  3100. WHERE ( civicrm_mailing.id = 83 )
  3101.  
  3102.  
  3103.  
  3104.  
  3105. [12] => SELECT *
  3106. FROM civicrm_domain
  3107.  
  3108. WHERE ( civicrm_domain.id = 1 )
  3109.  
  3110.  
  3111.  
  3112.  
  3113. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  3114. ph.id as phone_id, ph.location_type_id as locationTypeId
  3115. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  3116. WHERE ev.id = 1
  3117. AND loc.id = ev.loc_block_id
  3118. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  3119. AND ltype.id = ph.location_type_id
  3120. ORDER BY ph.is_primary DESC, phone_id ASC
  3121. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  3122. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  3123. WHERE ev.id = 1
  3124. AND loc.id = ev.loc_block_id
  3125. AND e.id IN (loc.email_id, loc.email_2_id)
  3126. AND ltype.id = e.location_type_id
  3127. ORDER BY e.is_primary DESC, email_id ASC
  3128. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  3129. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  3130. WHERE ev.id = 1
  3131. AND loc.id = ev.loc_block_id
  3132. AND cim.id IN (loc.im_id, loc.im_2_id)
  3133. AND ltype.id = cim.location_type_id
  3134. ORDER BY cim.is_primary DESC, im_id ASC
  3135. [16] =>
  3136. SELECT civicrm_address.id as address_id
  3137. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  3138. WHERE ev.id = 1
  3139. AND loc.id = ev.loc_block_id
  3140. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  3141. AND ltype.id = civicrm_address.location_type_id
  3142. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  3143. [17] =>
  3144. SELECT CF.id as cfID,
  3145. CF.uri as uri,
  3146. CF.mime_type as mime_type,
  3147. CEF.id as cefID
  3148. FROM civicrm_file AS CF
  3149. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  3150. WHERE CEF.entity_table = 'civicrm_mailing'
  3151. AND CEF.entity_id = 83
  3152. [18] => SELECT *
  3153. FROM civicrm_dedupe_rule_group
  3154.  
  3155. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  3156.  
  3157.  
  3158.  
  3159.  
  3160. [19] =>
  3161. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  3162. FROM civicrm_contact_type subtype
  3163. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  3164. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  3165. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  3166. [20] =>
  3167. SELECT a.operation, a.object_id
  3168. FROM civicrm_acl_cache c, civicrm_acl a
  3169. WHERE c.acl_id = a.id
  3170. AND a.is_active = 1
  3171. AND a.object_table = 'civicrm_custom_group'
  3172. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3173. ORDER BY a.object_id
  3174.  
  3175. [21] =>
  3176. SELECT a.operation, a.object_id
  3177. FROM civicrm_acl_cache c, civicrm_acl a
  3178. WHERE c.acl_id = a.id
  3179. AND a.is_active = 1
  3180. AND a.object_table = 'civicrm_custom_group'
  3181. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3182. ORDER BY a.object_id
  3183.  
  3184. [22] =>
  3185. SELECT a.operation, a.object_id
  3186. FROM civicrm_acl_cache c, civicrm_acl a
  3187. WHERE c.acl_id = a.id
  3188. AND a.is_active = 1
  3189. AND a.object_table = 'civicrm_custom_group'
  3190. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3191. ORDER BY a.object_id
  3192.  
  3193. [23] =>
  3194. SELECT a.operation, a.object_id
  3195. FROM civicrm_acl_cache c, civicrm_acl a
  3196. WHERE c.acl_id = a.id
  3197. AND a.is_active = 1
  3198. AND a.object_table = 'civicrm_custom_group'
  3199. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3200. ORDER BY a.object_id
  3201.  
  3202. [24] =>
  3203. SELECT a.operation, a.object_id
  3204. FROM civicrm_acl_cache c, civicrm_acl a
  3205. WHERE c.acl_id = a.id
  3206. AND a.is_active = 1
  3207. AND a.object_table = 'civicrm_custom_group'
  3208. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3209. ORDER BY a.object_id
  3210.  
  3211. [25] =>
  3212. SELECT a.operation, a.object_id
  3213. FROM civicrm_acl_cache c, civicrm_acl a
  3214. WHERE c.acl_id = a.id
  3215. AND a.is_active = 1
  3216. AND a.object_table = 'civicrm_custom_group'
  3217. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3218. ORDER BY a.object_id
  3219.  
  3220. [26] => SELECT *
  3221. FROM civicrm_mail_settings
  3222.  
  3223. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  3224.  
  3225.  
  3226.  
  3227.  
  3228. [27] =>
  3229. SELECT v.label as label ,v.value as value
  3230. FROM civicrm_option_value v,
  3231. civicrm_option_group g
  3232. WHERE v.option_group_id = g.id
  3233. AND g.name = 'activity_type'
  3234. AND v.is_active = 1
  3235. AND g.is_active = 1
  3236. AND v.name = 'Bulk Email'
  3237.  
  3238. [28] =>
  3239. SELECT a.operation, a.object_id
  3240. FROM civicrm_acl_cache c, civicrm_acl a
  3241. WHERE c.acl_id = a.id
  3242. AND a.is_active = 1
  3243. AND a.object_table = 'civicrm_custom_group'
  3244. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3245. ORDER BY a.object_id
  3246.  
  3247. [29] =>
  3248. SELECT v.label as label ,v.value as value
  3249. FROM civicrm_option_value v,
  3250. civicrm_option_group g
  3251. WHERE v.option_group_id = g.id
  3252. AND g.name = 'activity_type'
  3253. AND v.is_active = 1
  3254. AND g.is_active = 1
  3255. AND v.name = 'Email'
  3256.  
  3257. [30] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3258. civicrm_group.id as id
  3259. FROM civicrm_group
  3260. INNER JOIN civicrm_mailing_group
  3261. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3262. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3263. AND civicrm_mailing_group.group_type = 'Exclude'
  3264. AND civicrm_mailing_group.mailing_id = 83
  3265. AND civicrm_group.saved_search_id IS NOT null
  3266. [31] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3267. civicrm_group.id as id
  3268. FROM civicrm_group
  3269. INNER JOIN civicrm_mailing_group
  3270. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3271. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3272. WHERE
  3273. civicrm_mailing_group.group_type = 'Include'
  3274. AND civicrm_mailing_group.search_id IS NULL
  3275. AND civicrm_mailing_group.mailing_id = 83
  3276. AND civicrm_group.saved_search_id IS NOT null
  3277. [32] =>
  3278. SELECT search_id, search_args, entity_id
  3279. FROM civicrm_mailing_group
  3280. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3281. AND civicrm_mailing_group.mailing_id = 83
  3282.  
  3283. [33] => SELECT *
  3284. FROM civicrm_mailing
  3285.  
  3286. WHERE ( civicrm_mailing.id = 83 )
  3287.  
  3288.  
  3289.  
  3290.  
  3291. [34] =>
  3292. SELECT CF.id as cfID,
  3293. CF.uri as uri,
  3294. CF.mime_type as mime_type,
  3295. CEF.id as cefID
  3296. FROM civicrm_file AS CF
  3297. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  3298. WHERE CEF.entity_table = 'civicrm_mailing'
  3299. AND CEF.entity_id = 83
  3300. [35] =>
  3301. SELECT a.operation, a.object_id
  3302. FROM civicrm_acl_cache c, civicrm_acl a
  3303. WHERE c.acl_id = a.id
  3304. AND a.is_active = 1
  3305. AND a.object_table = 'civicrm_custom_group'
  3306. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3307. ORDER BY a.object_id
  3308.  
  3309. [36] =>
  3310. SELECT a.operation, a.object_id
  3311. FROM civicrm_acl_cache c, civicrm_acl a
  3312. WHERE c.acl_id = a.id
  3313. AND a.is_active = 1
  3314. AND a.object_table = 'civicrm_custom_group'
  3315. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3316. ORDER BY a.object_id
  3317.  
  3318. )
  3319. Array
  3320. (
  3321. [0] => SELECT config_backend, locales, locale_custom_strings
  3322. FROM civicrm_domain
  3323.  
  3324. WHERE ( civicrm_domain.id = 1 )
  3325.  
  3326.  
  3327.  
  3328.  
  3329. [1] => SELECT *
  3330. FROM civicrm_uf_match
  3331.  
  3332. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  3333.  
  3334.  
  3335.  
  3336.  
  3337. [2] => SELECT *
  3338. FROM civicrm_uf_match
  3339.  
  3340. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  3341.  
  3342.  
  3343.  
  3344.  
  3345. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3346. civicrm_group.id as id
  3347. FROM civicrm_group
  3348. INNER JOIN civicrm_mailing_group
  3349. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3350. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3351. AND civicrm_mailing_group.group_type = 'Exclude'
  3352. AND civicrm_mailing_group.mailing_id = 83
  3353. AND civicrm_group.saved_search_id IS NOT null
  3354. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3355. civicrm_group.id as id
  3356. FROM civicrm_group
  3357. INNER JOIN civicrm_mailing_group
  3358. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3359. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3360. WHERE
  3361. civicrm_mailing_group.group_type = 'Include'
  3362. AND civicrm_mailing_group.search_id IS NULL
  3363. AND civicrm_mailing_group.mailing_id = 83
  3364. AND civicrm_group.saved_search_id IS NOT null
  3365. [5] =>
  3366. SELECT search_id, search_args, entity_id
  3367. FROM civicrm_mailing_group
  3368. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3369. AND civicrm_mailing_group.mailing_id = 83
  3370.  
  3371. [6] =>
  3372. SELECT j.*
  3373. FROM civicrm_mailing_job j,
  3374. civicrm_mailing m
  3375. WHERE m.id = j.mailing_id
  3376.  
  3377. AND j.is_test = 0
  3378. AND ( ( j.start_date IS null
  3379. AND j.scheduled_date <= 20110621173001
  3380. AND j.status = 'Scheduled' )
  3381. OR ( j.status = 'Running'
  3382. AND j.end_date IS null ) )
  3383. AND (j.job_type = 'child')
  3384. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  3385. ORDER BY j.mailing_id,
  3386. j.id
  3387.  
  3388. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3389. civicrm_group.id as id
  3390. FROM civicrm_group
  3391. INNER JOIN civicrm_mailing_group
  3392. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3393. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3394. AND civicrm_mailing_group.group_type = 'Exclude'
  3395. AND civicrm_mailing_group.mailing_id = 83
  3396. AND civicrm_group.saved_search_id IS NOT null
  3397. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3398. civicrm_group.id as id
  3399. FROM civicrm_group
  3400. INNER JOIN civicrm_mailing_group
  3401. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3402. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3403. WHERE
  3404. civicrm_mailing_group.group_type = 'Include'
  3405. AND civicrm_mailing_group.search_id IS NULL
  3406. AND civicrm_mailing_group.mailing_id = 83
  3407. AND civicrm_group.saved_search_id IS NOT null
  3408. [9] =>
  3409. SELECT search_id, search_args, entity_id
  3410. FROM civicrm_mailing_group
  3411. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3412. AND civicrm_mailing_group.mailing_id = 83
  3413.  
  3414. [10] => SELECT *
  3415. FROM civicrm_preferences
  3416.  
  3417. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  3418.  
  3419.  
  3420.  
  3421.  
  3422. [11] => SELECT *
  3423. FROM civicrm_mailing
  3424.  
  3425. WHERE ( civicrm_mailing.id = 83 )
  3426.  
  3427.  
  3428.  
  3429.  
  3430. [12] => SELECT *
  3431. FROM civicrm_domain
  3432.  
  3433. WHERE ( civicrm_domain.id = 1 )
  3434.  
  3435.  
  3436.  
  3437.  
  3438. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  3439. ph.id as phone_id, ph.location_type_id as locationTypeId
  3440. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  3441. WHERE ev.id = 1
  3442. AND loc.id = ev.loc_block_id
  3443. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  3444. AND ltype.id = ph.location_type_id
  3445. ORDER BY ph.is_primary DESC, phone_id ASC
  3446. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  3447. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  3448. WHERE ev.id = 1
  3449. AND loc.id = ev.loc_block_id
  3450. AND e.id IN (loc.email_id, loc.email_2_id)
  3451. AND ltype.id = e.location_type_id
  3452. ORDER BY e.is_primary DESC, email_id ASC
  3453. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  3454. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  3455. WHERE ev.id = 1
  3456. AND loc.id = ev.loc_block_id
  3457. AND cim.id IN (loc.im_id, loc.im_2_id)
  3458. AND ltype.id = cim.location_type_id
  3459. ORDER BY cim.is_primary DESC, im_id ASC
  3460. [16] =>
  3461. SELECT civicrm_address.id as address_id
  3462. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  3463. WHERE ev.id = 1
  3464. AND loc.id = ev.loc_block_id
  3465. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  3466. AND ltype.id = civicrm_address.location_type_id
  3467. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  3468. [17] =>
  3469. SELECT CF.id as cfID,
  3470. CF.uri as uri,
  3471. CF.mime_type as mime_type,
  3472. CEF.id as cefID
  3473. FROM civicrm_file AS CF
  3474. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  3475. WHERE CEF.entity_table = 'civicrm_mailing'
  3476. AND CEF.entity_id = 83
  3477. [18] => SELECT *
  3478. FROM civicrm_dedupe_rule_group
  3479.  
  3480. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  3481.  
  3482.  
  3483.  
  3484.  
  3485. [19] =>
  3486. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  3487. FROM civicrm_contact_type subtype
  3488. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  3489. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  3490. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  3491. [20] =>
  3492. SELECT a.operation, a.object_id
  3493. FROM civicrm_acl_cache c, civicrm_acl a
  3494. WHERE c.acl_id = a.id
  3495. AND a.is_active = 1
  3496. AND a.object_table = 'civicrm_custom_group'
  3497. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3498. ORDER BY a.object_id
  3499.  
  3500. [21] =>
  3501. SELECT a.operation, a.object_id
  3502. FROM civicrm_acl_cache c, civicrm_acl a
  3503. WHERE c.acl_id = a.id
  3504. AND a.is_active = 1
  3505. AND a.object_table = 'civicrm_custom_group'
  3506. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3507. ORDER BY a.object_id
  3508.  
  3509. [22] =>
  3510. SELECT a.operation, a.object_id
  3511. FROM civicrm_acl_cache c, civicrm_acl a
  3512. WHERE c.acl_id = a.id
  3513. AND a.is_active = 1
  3514. AND a.object_table = 'civicrm_custom_group'
  3515. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3516. ORDER BY a.object_id
  3517.  
  3518. [23] =>
  3519. SELECT a.operation, a.object_id
  3520. FROM civicrm_acl_cache c, civicrm_acl a
  3521. WHERE c.acl_id = a.id
  3522. AND a.is_active = 1
  3523. AND a.object_table = 'civicrm_custom_group'
  3524. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3525. ORDER BY a.object_id
  3526.  
  3527. [24] =>
  3528. SELECT a.operation, a.object_id
  3529. FROM civicrm_acl_cache c, civicrm_acl a
  3530. WHERE c.acl_id = a.id
  3531. AND a.is_active = 1
  3532. AND a.object_table = 'civicrm_custom_group'
  3533. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3534. ORDER BY a.object_id
  3535.  
  3536. [25] =>
  3537. SELECT a.operation, a.object_id
  3538. FROM civicrm_acl_cache c, civicrm_acl a
  3539. WHERE c.acl_id = a.id
  3540. AND a.is_active = 1
  3541. AND a.object_table = 'civicrm_custom_group'
  3542. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3543. ORDER BY a.object_id
  3544.  
  3545. [26] => SELECT *
  3546. FROM civicrm_mail_settings
  3547.  
  3548. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  3549.  
  3550.  
  3551.  
  3552.  
  3553. [27] =>
  3554. SELECT v.label as label ,v.value as value
  3555. FROM civicrm_option_value v,
  3556. civicrm_option_group g
  3557. WHERE v.option_group_id = g.id
  3558. AND g.name = 'activity_type'
  3559. AND v.is_active = 1
  3560. AND g.is_active = 1
  3561. AND v.name = 'Bulk Email'
  3562.  
  3563. [28] =>
  3564. SELECT a.operation, a.object_id
  3565. FROM civicrm_acl_cache c, civicrm_acl a
  3566. WHERE c.acl_id = a.id
  3567. AND a.is_active = 1
  3568. AND a.object_table = 'civicrm_custom_group'
  3569. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3570. ORDER BY a.object_id
  3571.  
  3572. [29] =>
  3573. SELECT v.label as label ,v.value as value
  3574. FROM civicrm_option_value v,
  3575. civicrm_option_group g
  3576. WHERE v.option_group_id = g.id
  3577. AND g.name = 'activity_type'
  3578. AND v.is_active = 1
  3579. AND g.is_active = 1
  3580. AND v.name = 'Email'
  3581.  
  3582. [30] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3583. civicrm_group.id as id
  3584. FROM civicrm_group
  3585. INNER JOIN civicrm_mailing_group
  3586. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3587. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3588. AND civicrm_mailing_group.group_type = 'Exclude'
  3589. AND civicrm_mailing_group.mailing_id = 83
  3590. AND civicrm_group.saved_search_id IS NOT null
  3591. [31] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3592. civicrm_group.id as id
  3593. FROM civicrm_group
  3594. INNER JOIN civicrm_mailing_group
  3595. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3596. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3597. WHERE
  3598. civicrm_mailing_group.group_type = 'Include'
  3599. AND civicrm_mailing_group.search_id IS NULL
  3600. AND civicrm_mailing_group.mailing_id = 83
  3601. AND civicrm_group.saved_search_id IS NOT null
  3602. [32] =>
  3603. SELECT search_id, search_args, entity_id
  3604. FROM civicrm_mailing_group
  3605. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3606. AND civicrm_mailing_group.mailing_id = 83
  3607.  
  3608. [33] => SELECT *
  3609. FROM civicrm_mailing
  3610.  
  3611. WHERE ( civicrm_mailing.id = 83 )
  3612.  
  3613.  
  3614.  
  3615.  
  3616. [34] =>
  3617. SELECT CF.id as cfID,
  3618. CF.uri as uri,
  3619. CF.mime_type as mime_type,
  3620. CEF.id as cefID
  3621. FROM civicrm_file AS CF
  3622. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  3623. WHERE CEF.entity_table = 'civicrm_mailing'
  3624. AND CEF.entity_id = 83
  3625. [35] =>
  3626. SELECT a.operation, a.object_id
  3627. FROM civicrm_acl_cache c, civicrm_acl a
  3628. WHERE c.acl_id = a.id
  3629. AND a.is_active = 1
  3630. AND a.object_table = 'civicrm_custom_group'
  3631. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3632. ORDER BY a.object_id
  3633.  
  3634. [36] =>
  3635. SELECT a.operation, a.object_id
  3636. FROM civicrm_acl_cache c, civicrm_acl a
  3637. WHERE c.acl_id = a.id
  3638. AND a.is_active = 1
  3639. AND a.object_table = 'civicrm_custom_group'
  3640. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3641. ORDER BY a.object_id
  3642.  
  3643. )
  3644. Array
  3645. (
  3646. [0] => SELECT config_backend, locales, locale_custom_strings
  3647. FROM civicrm_domain
  3648.  
  3649. WHERE ( civicrm_domain.id = 1 )
  3650.  
  3651.  
  3652.  
  3653.  
  3654. [1] => SELECT *
  3655. FROM civicrm_uf_match
  3656.  
  3657. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  3658.  
  3659.  
  3660.  
  3661.  
  3662. [2] => SELECT *
  3663. FROM civicrm_uf_match
  3664.  
  3665. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  3666.  
  3667.  
  3668.  
  3669.  
  3670. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3671. civicrm_group.id as id
  3672. FROM civicrm_group
  3673. INNER JOIN civicrm_mailing_group
  3674. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3675. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3676. AND civicrm_mailing_group.group_type = 'Exclude'
  3677. AND civicrm_mailing_group.mailing_id = 83
  3678. AND civicrm_group.saved_search_id IS NOT null
  3679. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3680. civicrm_group.id as id
  3681. FROM civicrm_group
  3682. INNER JOIN civicrm_mailing_group
  3683. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3684. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3685. WHERE
  3686. civicrm_mailing_group.group_type = 'Include'
  3687. AND civicrm_mailing_group.search_id IS NULL
  3688. AND civicrm_mailing_group.mailing_id = 83
  3689. AND civicrm_group.saved_search_id IS NOT null
  3690. [5] =>
  3691. SELECT search_id, search_args, entity_id
  3692. FROM civicrm_mailing_group
  3693. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3694. AND civicrm_mailing_group.mailing_id = 83
  3695.  
  3696. [6] =>
  3697. SELECT j.*
  3698. FROM civicrm_mailing_job j,
  3699. civicrm_mailing m
  3700. WHERE m.id = j.mailing_id
  3701.  
  3702. AND j.is_test = 0
  3703. AND ( ( j.start_date IS null
  3704. AND j.scheduled_date <= 20110621173001
  3705. AND j.status = 'Scheduled' )
  3706. OR ( j.status = 'Running'
  3707. AND j.end_date IS null ) )
  3708. AND (j.job_type = 'child')
  3709. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  3710. ORDER BY j.mailing_id,
  3711. j.id
  3712.  
  3713. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3714. civicrm_group.id as id
  3715. FROM civicrm_group
  3716. INNER JOIN civicrm_mailing_group
  3717. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3718. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3719. AND civicrm_mailing_group.group_type = 'Exclude'
  3720. AND civicrm_mailing_group.mailing_id = 83
  3721. AND civicrm_group.saved_search_id IS NOT null
  3722. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3723. civicrm_group.id as id
  3724. FROM civicrm_group
  3725. INNER JOIN civicrm_mailing_group
  3726. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3727. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3728. WHERE
  3729. civicrm_mailing_group.group_type = 'Include'
  3730. AND civicrm_mailing_group.search_id IS NULL
  3731. AND civicrm_mailing_group.mailing_id = 83
  3732. AND civicrm_group.saved_search_id IS NOT null
  3733. [9] =>
  3734. SELECT search_id, search_args, entity_id
  3735. FROM civicrm_mailing_group
  3736. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3737. AND civicrm_mailing_group.mailing_id = 83
  3738.  
  3739. [10] => SELECT *
  3740. FROM civicrm_preferences
  3741.  
  3742. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  3743.  
  3744.  
  3745.  
  3746.  
  3747. [11] => SELECT *
  3748. FROM civicrm_mailing
  3749.  
  3750. WHERE ( civicrm_mailing.id = 83 )
  3751.  
  3752.  
  3753.  
  3754.  
  3755. [12] => SELECT *
  3756. FROM civicrm_domain
  3757.  
  3758. WHERE ( civicrm_domain.id = 1 )
  3759.  
  3760.  
  3761.  
  3762.  
  3763. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  3764. ph.id as phone_id, ph.location_type_id as locationTypeId
  3765. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  3766. WHERE ev.id = 1
  3767. AND loc.id = ev.loc_block_id
  3768. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  3769. AND ltype.id = ph.location_type_id
  3770. ORDER BY ph.is_primary DESC, phone_id ASC
  3771. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  3772. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  3773. WHERE ev.id = 1
  3774. AND loc.id = ev.loc_block_id
  3775. AND e.id IN (loc.email_id, loc.email_2_id)
  3776. AND ltype.id = e.location_type_id
  3777. ORDER BY e.is_primary DESC, email_id ASC
  3778. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  3779. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  3780. WHERE ev.id = 1
  3781. AND loc.id = ev.loc_block_id
  3782. AND cim.id IN (loc.im_id, loc.im_2_id)
  3783. AND ltype.id = cim.location_type_id
  3784. ORDER BY cim.is_primary DESC, im_id ASC
  3785. [16] =>
  3786. SELECT civicrm_address.id as address_id
  3787. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  3788. WHERE ev.id = 1
  3789. AND loc.id = ev.loc_block_id
  3790. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  3791. AND ltype.id = civicrm_address.location_type_id
  3792. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  3793. [17] =>
  3794. SELECT CF.id as cfID,
  3795. CF.uri as uri,
  3796. CF.mime_type as mime_type,
  3797. CEF.id as cefID
  3798. FROM civicrm_file AS CF
  3799. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  3800. WHERE CEF.entity_table = 'civicrm_mailing'
  3801. AND CEF.entity_id = 83
  3802. [18] => SELECT *
  3803. FROM civicrm_dedupe_rule_group
  3804.  
  3805. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  3806.  
  3807.  
  3808.  
  3809.  
  3810. [19] =>
  3811. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  3812. FROM civicrm_contact_type subtype
  3813. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  3814. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  3815. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  3816. [20] =>
  3817. SELECT a.operation, a.object_id
  3818. FROM civicrm_acl_cache c, civicrm_acl a
  3819. WHERE c.acl_id = a.id
  3820. AND a.is_active = 1
  3821. AND a.object_table = 'civicrm_custom_group'
  3822. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3823. ORDER BY a.object_id
  3824.  
  3825. [21] =>
  3826. SELECT a.operation, a.object_id
  3827. FROM civicrm_acl_cache c, civicrm_acl a
  3828. WHERE c.acl_id = a.id
  3829. AND a.is_active = 1
  3830. AND a.object_table = 'civicrm_custom_group'
  3831. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3832. ORDER BY a.object_id
  3833.  
  3834. [22] =>
  3835. SELECT a.operation, a.object_id
  3836. FROM civicrm_acl_cache c, civicrm_acl a
  3837. WHERE c.acl_id = a.id
  3838. AND a.is_active = 1
  3839. AND a.object_table = 'civicrm_custom_group'
  3840. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3841. ORDER BY a.object_id
  3842.  
  3843. [23] =>
  3844. SELECT a.operation, a.object_id
  3845. FROM civicrm_acl_cache c, civicrm_acl a
  3846. WHERE c.acl_id = a.id
  3847. AND a.is_active = 1
  3848. AND a.object_table = 'civicrm_custom_group'
  3849. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3850. ORDER BY a.object_id
  3851.  
  3852. [24] =>
  3853. SELECT a.operation, a.object_id
  3854. FROM civicrm_acl_cache c, civicrm_acl a
  3855. WHERE c.acl_id = a.id
  3856. AND a.is_active = 1
  3857. AND a.object_table = 'civicrm_custom_group'
  3858. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3859. ORDER BY a.object_id
  3860.  
  3861. [25] =>
  3862. SELECT a.operation, a.object_id
  3863. FROM civicrm_acl_cache c, civicrm_acl a
  3864. WHERE c.acl_id = a.id
  3865. AND a.is_active = 1
  3866. AND a.object_table = 'civicrm_custom_group'
  3867. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3868. ORDER BY a.object_id
  3869.  
  3870. [26] => SELECT *
  3871. FROM civicrm_mail_settings
  3872.  
  3873. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  3874.  
  3875.  
  3876.  
  3877.  
  3878. [27] =>
  3879. SELECT v.label as label ,v.value as value
  3880. FROM civicrm_option_value v,
  3881. civicrm_option_group g
  3882. WHERE v.option_group_id = g.id
  3883. AND g.name = 'activity_type'
  3884. AND v.is_active = 1
  3885. AND g.is_active = 1
  3886. AND v.name = 'Bulk Email'
  3887.  
  3888. [28] =>
  3889. SELECT a.operation, a.object_id
  3890. FROM civicrm_acl_cache c, civicrm_acl a
  3891. WHERE c.acl_id = a.id
  3892. AND a.is_active = 1
  3893. AND a.object_table = 'civicrm_custom_group'
  3894. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3895. ORDER BY a.object_id
  3896.  
  3897. [29] =>
  3898. SELECT v.label as label ,v.value as value
  3899. FROM civicrm_option_value v,
  3900. civicrm_option_group g
  3901. WHERE v.option_group_id = g.id
  3902. AND g.name = 'activity_type'
  3903. AND v.is_active = 1
  3904. AND g.is_active = 1
  3905. AND v.name = 'Email'
  3906.  
  3907. [30] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3908. civicrm_group.id as id
  3909. FROM civicrm_group
  3910. INNER JOIN civicrm_mailing_group
  3911. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3912. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  3913. AND civicrm_mailing_group.group_type = 'Exclude'
  3914. AND civicrm_mailing_group.mailing_id = 83
  3915. AND civicrm_group.saved_search_id IS NOT null
  3916. [31] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3917. civicrm_group.id as id
  3918. FROM civicrm_group
  3919. INNER JOIN civicrm_mailing_group
  3920. ON civicrm_mailing_group.entity_id = civicrm_group.id
  3921. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  3922. WHERE
  3923. civicrm_mailing_group.group_type = 'Include'
  3924. AND civicrm_mailing_group.search_id IS NULL
  3925. AND civicrm_mailing_group.mailing_id = 83
  3926. AND civicrm_group.saved_search_id IS NOT null
  3927. [32] =>
  3928. SELECT search_id, search_args, entity_id
  3929. FROM civicrm_mailing_group
  3930. WHERE civicrm_mailing_group.search_id IS NOT NULL
  3931. AND civicrm_mailing_group.mailing_id = 83
  3932.  
  3933. [33] => SELECT *
  3934. FROM civicrm_mailing
  3935.  
  3936. WHERE ( civicrm_mailing.id = 83 )
  3937.  
  3938.  
  3939.  
  3940.  
  3941. [34] =>
  3942. SELECT CF.id as cfID,
  3943. CF.uri as uri,
  3944. CF.mime_type as mime_type,
  3945. CEF.id as cefID
  3946. FROM civicrm_file AS CF
  3947. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  3948. WHERE CEF.entity_table = 'civicrm_mailing'
  3949. AND CEF.entity_id = 83
  3950. [35] =>
  3951. SELECT a.operation, a.object_id
  3952. FROM civicrm_acl_cache c, civicrm_acl a
  3953. WHERE c.acl_id = a.id
  3954. AND a.is_active = 1
  3955. AND a.object_table = 'civicrm_custom_group'
  3956. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3957. ORDER BY a.object_id
  3958.  
  3959. [36] =>
  3960. SELECT a.operation, a.object_id
  3961. FROM civicrm_acl_cache c, civicrm_acl a
  3962. WHERE c.acl_id = a.id
  3963. AND a.is_active = 1
  3964. AND a.object_table = 'civicrm_custom_group'
  3965. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  3966. ORDER BY a.object_id
  3967.  
  3968. )
  3969. Array
  3970. (
  3971. [0] => SELECT config_backend, locales, locale_custom_strings
  3972. FROM civicrm_domain
  3973.  
  3974. WHERE ( civicrm_domain.id = 1 )
  3975.  
  3976.  
  3977.  
  3978.  
  3979. [1] => SELECT *
  3980. FROM civicrm_uf_match
  3981.  
  3982. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  3983.  
  3984.  
  3985.  
  3986.  
  3987. [2] => SELECT *
  3988. FROM civicrm_uf_match
  3989.  
  3990. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  3991.  
  3992.  
  3993.  
  3994.  
  3995. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  3996. civicrm_group.id as id
  3997. FROM civicrm_group
  3998. INNER JOIN civicrm_mailing_group
  3999. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4000. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  4001. AND civicrm_mailing_group.group_type = 'Exclude'
  4002. AND civicrm_mailing_group.mailing_id = 83
  4003. AND civicrm_group.saved_search_id IS NOT null
  4004. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4005. civicrm_group.id as id
  4006. FROM civicrm_group
  4007. INNER JOIN civicrm_mailing_group
  4008. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4009. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  4010. WHERE
  4011. civicrm_mailing_group.group_type = 'Include'
  4012. AND civicrm_mailing_group.search_id IS NULL
  4013. AND civicrm_mailing_group.mailing_id = 83
  4014. AND civicrm_group.saved_search_id IS NOT null
  4015. [5] =>
  4016. SELECT search_id, search_args, entity_id
  4017. FROM civicrm_mailing_group
  4018. WHERE civicrm_mailing_group.search_id IS NOT NULL
  4019. AND civicrm_mailing_group.mailing_id = 83
  4020.  
  4021. [6] =>
  4022. SELECT j.*
  4023. FROM civicrm_mailing_job j,
  4024. civicrm_mailing m
  4025. WHERE m.id = j.mailing_id
  4026.  
  4027. AND j.is_test = 0
  4028. AND ( ( j.start_date IS null
  4029. AND j.scheduled_date <= 20110621173001
  4030. AND j.status = 'Scheduled' )
  4031. OR ( j.status = 'Running'
  4032. AND j.end_date IS null ) )
  4033. AND (j.job_type = 'child')
  4034. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  4035. ORDER BY j.mailing_id,
  4036. j.id
  4037.  
  4038. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4039. civicrm_group.id as id
  4040. FROM civicrm_group
  4041. INNER JOIN civicrm_mailing_group
  4042. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4043. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  4044. AND civicrm_mailing_group.group_type = 'Exclude'
  4045. AND civicrm_mailing_group.mailing_id = 83
  4046. AND civicrm_group.saved_search_id IS NOT null
  4047. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4048. civicrm_group.id as id
  4049. FROM civicrm_group
  4050. INNER JOIN civicrm_mailing_group
  4051. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4052. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  4053. WHERE
  4054. civicrm_mailing_group.group_type = 'Include'
  4055. AND civicrm_mailing_group.search_id IS NULL
  4056. AND civicrm_mailing_group.mailing_id = 83
  4057. AND civicrm_group.saved_search_id IS NOT null
  4058. [9] =>
  4059. SELECT search_id, search_args, entity_id
  4060. FROM civicrm_mailing_group
  4061. WHERE civicrm_mailing_group.search_id IS NOT NULL
  4062. AND civicrm_mailing_group.mailing_id = 83
  4063.  
  4064. [10] => SELECT *
  4065. FROM civicrm_preferences
  4066.  
  4067. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  4068.  
  4069.  
  4070.  
  4071.  
  4072. [11] => SELECT *
  4073. FROM civicrm_mailing
  4074.  
  4075. WHERE ( civicrm_mailing.id = 83 )
  4076.  
  4077.  
  4078.  
  4079.  
  4080. [12] => SELECT *
  4081. FROM civicrm_domain
  4082.  
  4083. WHERE ( civicrm_domain.id = 1 )
  4084.  
  4085.  
  4086.  
  4087.  
  4088. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  4089. ph.id as phone_id, ph.location_type_id as locationTypeId
  4090. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  4091. WHERE ev.id = 1
  4092. AND loc.id = ev.loc_block_id
  4093. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  4094. AND ltype.id = ph.location_type_id
  4095. ORDER BY ph.is_primary DESC, phone_id ASC
  4096. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  4097. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  4098. WHERE ev.id = 1
  4099. AND loc.id = ev.loc_block_id
  4100. AND e.id IN (loc.email_id, loc.email_2_id)
  4101. AND ltype.id = e.location_type_id
  4102. ORDER BY e.is_primary DESC, email_id ASC
  4103. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  4104. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  4105. WHERE ev.id = 1
  4106. AND loc.id = ev.loc_block_id
  4107. AND cim.id IN (loc.im_id, loc.im_2_id)
  4108. AND ltype.id = cim.location_type_id
  4109. ORDER BY cim.is_primary DESC, im_id ASC
  4110. [16] =>
  4111. SELECT civicrm_address.id as address_id
  4112. FROM civicrm_loc_block loc, civicrm_location_type ltype, civicrm_address, civicrm_domain ev
  4113. WHERE ev.id = 1
  4114. AND loc.id = ev.loc_block_id
  4115. AND civicrm_address.id IN (loc.address_id, loc.address_2_id)
  4116. AND ltype.id = civicrm_address.location_type_id
  4117. ORDER BY civicrm_address.is_primary DESC, civicrm_address.location_type_id DESC, address_id ASC
  4118. [17] =>
  4119. SELECT CF.id as cfID,
  4120. CF.uri as uri,
  4121. CF.mime_type as mime_type,
  4122. CEF.id as cefID
  4123. FROM civicrm_file AS CF
  4124. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  4125. WHERE CEF.entity_table = 'civicrm_mailing'
  4126. AND CEF.entity_id = 83
  4127. [18] => SELECT *
  4128. FROM civicrm_dedupe_rule_group
  4129.  
  4130. WHERE ( civicrm_dedupe_rule_group.contact_type = 'Individual' ) AND ( civicrm_dedupe_rule_group.level = 'Strict' ) AND ( civicrm_dedupe_rule_group.is_default = 1 )
  4131.  
  4132.  
  4133.  
  4134.  
  4135. [19] =>
  4136. SELECT subtype.*, parent.name as parent, parent.label as parent_label
  4137. FROM civicrm_contact_type subtype
  4138. INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
  4139. WHERE subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL
  4140. AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id
  4141. [20] =>
  4142. SELECT a.operation, a.object_id
  4143. FROM civicrm_acl_cache c, civicrm_acl a
  4144. WHERE c.acl_id = a.id
  4145. AND a.is_active = 1
  4146. AND a.object_table = 'civicrm_custom_group'
  4147. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4148. ORDER BY a.object_id
  4149.  
  4150. [21] =>
  4151. SELECT a.operation, a.object_id
  4152. FROM civicrm_acl_cache c, civicrm_acl a
  4153. WHERE c.acl_id = a.id
  4154. AND a.is_active = 1
  4155. AND a.object_table = 'civicrm_custom_group'
  4156. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4157. ORDER BY a.object_id
  4158.  
  4159. [22] =>
  4160. SELECT a.operation, a.object_id
  4161. FROM civicrm_acl_cache c, civicrm_acl a
  4162. WHERE c.acl_id = a.id
  4163. AND a.is_active = 1
  4164. AND a.object_table = 'civicrm_custom_group'
  4165. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4166. ORDER BY a.object_id
  4167.  
  4168. [23] =>
  4169. SELECT a.operation, a.object_id
  4170. FROM civicrm_acl_cache c, civicrm_acl a
  4171. WHERE c.acl_id = a.id
  4172. AND a.is_active = 1
  4173. AND a.object_table = 'civicrm_custom_group'
  4174. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4175. ORDER BY a.object_id
  4176.  
  4177. [24] =>
  4178. SELECT a.operation, a.object_id
  4179. FROM civicrm_acl_cache c, civicrm_acl a
  4180. WHERE c.acl_id = a.id
  4181. AND a.is_active = 1
  4182. AND a.object_table = 'civicrm_custom_group'
  4183. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4184. ORDER BY a.object_id
  4185.  
  4186. [25] =>
  4187. SELECT a.operation, a.object_id
  4188. FROM civicrm_acl_cache c, civicrm_acl a
  4189. WHERE c.acl_id = a.id
  4190. AND a.is_active = 1
  4191. AND a.object_table = 'civicrm_custom_group'
  4192. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4193. ORDER BY a.object_id
  4194.  
  4195. [26] => SELECT *
  4196. FROM civicrm_mail_settings
  4197.  
  4198. WHERE ( civicrm_mail_settings.domain_id = 1 ) AND ( civicrm_mail_settings.is_default = 1 )
  4199.  
  4200.  
  4201.  
  4202.  
  4203. [27] =>
  4204. SELECT v.label as label ,v.value as value
  4205. FROM civicrm_option_value v,
  4206. civicrm_option_group g
  4207. WHERE v.option_group_id = g.id
  4208. AND g.name = 'activity_type'
  4209. AND v.is_active = 1
  4210. AND g.is_active = 1
  4211. AND v.name = 'Bulk Email'
  4212.  
  4213. [28] =>
  4214. SELECT a.operation, a.object_id
  4215. FROM civicrm_acl_cache c, civicrm_acl a
  4216. WHERE c.acl_id = a.id
  4217. AND a.is_active = 1
  4218. AND a.object_table = 'civicrm_custom_group'
  4219. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4220. ORDER BY a.object_id
  4221.  
  4222. [29] =>
  4223. SELECT v.label as label ,v.value as value
  4224. FROM civicrm_option_value v,
  4225. civicrm_option_group g
  4226. WHERE v.option_group_id = g.id
  4227. AND g.name = 'activity_type'
  4228. AND v.is_active = 1
  4229. AND g.is_active = 1
  4230. AND v.name = 'Email'
  4231.  
  4232. [30] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4233. civicrm_group.id as id
  4234. FROM civicrm_group
  4235. INNER JOIN civicrm_mailing_group
  4236. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4237. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  4238. AND civicrm_mailing_group.group_type = 'Exclude'
  4239. AND civicrm_mailing_group.mailing_id = 83
  4240. AND civicrm_group.saved_search_id IS NOT null
  4241. [31] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4242. civicrm_group.id as id
  4243. FROM civicrm_group
  4244. INNER JOIN civicrm_mailing_group
  4245. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4246. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  4247. WHERE
  4248. civicrm_mailing_group.group_type = 'Include'
  4249. AND civicrm_mailing_group.search_id IS NULL
  4250. AND civicrm_mailing_group.mailing_id = 83
  4251. AND civicrm_group.saved_search_id IS NOT null
  4252. [32] =>
  4253. SELECT search_id, search_args, entity_id
  4254. FROM civicrm_mailing_group
  4255. WHERE civicrm_mailing_group.search_id IS NOT NULL
  4256. AND civicrm_mailing_group.mailing_id = 83
  4257.  
  4258. [33] => SELECT *
  4259. FROM civicrm_mailing
  4260.  
  4261. WHERE ( civicrm_mailing.id = 83 )
  4262.  
  4263.  
  4264.  
  4265.  
  4266. [34] =>
  4267. SELECT CF.id as cfID,
  4268. CF.uri as uri,
  4269. CF.mime_type as mime_type,
  4270. CEF.id as cefID
  4271. FROM civicrm_file AS CF
  4272. LEFT JOIN civicrm_entity_file AS CEF ON ( CEF.file_id = CF.id )
  4273. WHERE CEF.entity_table = 'civicrm_mailing'
  4274. AND CEF.entity_id = 83
  4275. [35] =>
  4276. SELECT a.operation, a.object_id
  4277. FROM civicrm_acl_cache c, civicrm_acl a
  4278. WHERE c.acl_id = a.id
  4279. AND a.is_active = 1
  4280. AND a.object_table = 'civicrm_custom_group'
  4281. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4282. ORDER BY a.object_id
  4283.  
  4284. [36] =>
  4285. SELECT a.operation, a.object_id
  4286. FROM civicrm_acl_cache c, civicrm_acl a
  4287. WHERE c.acl_id = a.id
  4288. AND a.is_active = 1
  4289. AND a.object_table = 'civicrm_custom_group'
  4290. AND a.id IN ( 1,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,63,64,65,66,2,3,4,5,6,7,8,56,57,58,59,60,61,62 )
  4291. ORDER BY a.object_id
  4292.  
  4293. )
  4294. Array
  4295. (
  4296. [0] => SELECT config_backend, locales, locale_custom_strings
  4297. FROM civicrm_domain
  4298.  
  4299. WHERE ( civicrm_domain.id = 1 )
  4300.  
  4301.  
  4302.  
  4303.  
  4304. [1] => SELECT *
  4305. FROM civicrm_uf_match
  4306.  
  4307. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  4308.  
  4309.  
  4310.  
  4311.  
  4312. [2] => SELECT *
  4313. FROM civicrm_uf_match
  4314.  
  4315. WHERE ( civicrm_uf_match.domain_id = 1 ) AND ( civicrm_uf_match.uf_id = 1 )
  4316.  
  4317.  
  4318.  
  4319.  
  4320. [3] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4321. civicrm_group.id as id
  4322. FROM civicrm_group
  4323. INNER JOIN civicrm_mailing_group
  4324. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4325. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  4326. AND civicrm_mailing_group.group_type = 'Exclude'
  4327. AND civicrm_mailing_group.mailing_id = 83
  4328. AND civicrm_group.saved_search_id IS NOT null
  4329. [4] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4330. civicrm_group.id as id
  4331. FROM civicrm_group
  4332. INNER JOIN civicrm_mailing_group
  4333. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4334. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  4335. WHERE
  4336. civicrm_mailing_group.group_type = 'Include'
  4337. AND civicrm_mailing_group.search_id IS NULL
  4338. AND civicrm_mailing_group.mailing_id = 83
  4339. AND civicrm_group.saved_search_id IS NOT null
  4340. [5] =>
  4341. SELECT search_id, search_args, entity_id
  4342. FROM civicrm_mailing_group
  4343. WHERE civicrm_mailing_group.search_id IS NOT NULL
  4344. AND civicrm_mailing_group.mailing_id = 83
  4345.  
  4346. [6] =>
  4347. SELECT j.*
  4348. FROM civicrm_mailing_job j,
  4349. civicrm_mailing m
  4350. WHERE m.id = j.mailing_id
  4351.  
  4352. AND j.is_test = 0
  4353. AND ( ( j.start_date IS null
  4354. AND j.scheduled_date <= 20110621173001
  4355. AND j.status = 'Scheduled' )
  4356. OR ( j.status = 'Running'
  4357. AND j.end_date IS null ) )
  4358. AND (j.job_type = 'child')
  4359. AND m.id IN ( 4,5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,73,74,75,76,77,78,79,80,81,82,83 )
  4360. ORDER BY j.mailing_id,
  4361. j.id
  4362.  
  4363. [7] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4364. civicrm_group.id as id
  4365. FROM civicrm_group
  4366. INNER JOIN civicrm_mailing_group
  4367. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4368. WHERE civicrm_mailing_group.entity_table = 'civicrm_group'
  4369. AND civicrm_mailing_group.group_type = 'Exclude'
  4370. AND civicrm_mailing_group.mailing_id = 83
  4371. AND civicrm_group.saved_search_id IS NOT null
  4372. [8] => SELECT civicrm_group.saved_search_id as saved_search_id,
  4373. civicrm_group.id as id
  4374. FROM civicrm_group
  4375. INNER JOIN civicrm_mailing_group
  4376. ON civicrm_mailing_group.entity_id = civicrm_group.id
  4377. AND civicrm_mailing_group.entity_table = 'civicrm_group'
  4378. WHERE
  4379. civicrm_mailing_group.group_type = 'Include'
  4380. AND civicrm_mailing_group.search_id IS NULL
  4381. AND civicrm_mailing_group.mailing_id = 83
  4382. AND civicrm_group.saved_search_id IS NOT null
  4383. [9] =>
  4384. SELECT search_id, search_args, entity_id
  4385. FROM civicrm_mailing_group
  4386. WHERE civicrm_mailing_group.search_id IS NOT NULL
  4387. AND civicrm_mailing_group.mailing_id = 83
  4388.  
  4389. [10] => SELECT *
  4390. FROM civicrm_preferences
  4391.  
  4392. WHERE ( civicrm_preferences.domain_id = 1 ) AND ( civicrm_preferences.is_domain = 1 )
  4393.  
  4394.  
  4395.  
  4396.  
  4397. [11] => SELECT *
  4398. FROM civicrm_mailing
  4399.  
  4400. WHERE ( civicrm_mailing.id = 83 )
  4401.  
  4402.  
  4403.  
  4404.  
  4405. [12] => SELECT *
  4406. FROM civicrm_domain
  4407.  
  4408. WHERE ( civicrm_domain.id = 1 )
  4409.  
  4410.  
  4411.  
  4412.  
  4413. [13] => SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,
  4414. ph.id as phone_id, ph.location_type_id as locationTypeId
  4415. FROM civicrm_loc_block loc, civicrm_phone ph, civicrm_location_type ltype, civicrm_domain ev
  4416. WHERE ev.id = 1
  4417. AND loc.id = ev.loc_block_id
  4418. AND ph.id IN (loc.phone_id, loc.phone_2_id)
  4419. AND ltype.id = ph.location_type_id
  4420. ORDER BY ph.is_primary DESC, phone_id ASC
  4421. [14] => SELECT email, ltype.name as locationType, e.is_primary as is_primary, e.on_hold as on_hold,e.id as email_id, e.location_type_id as locationTypeId
  4422. FROM civicrm_loc_block loc, civicrm_email e, civicrm_location_type ltype, civicrm_domain ev
  4423. WHERE ev.id = 1
  4424. AND loc.id = ev.loc_block_id
  4425. AND e.id IN (loc.email_id, loc.email_2_id)
  4426. AND ltype.id = e.location_type_id
  4427. ORDER BY e.is_primary DESC, email_id ASC
  4428. [15] => SELECT cim.name as im, ltype.name as locationType, cim.is_primary as is_primary, cim.id as im_id, cim.location_type_id as locationTypeId
  4429. FROM civicrm_loc_block loc, civicrm_im cim, civicrm_location_type ltype, civicrm_domain ev
  4430. WHERE ev.id = 1
  4431. AND loc.id = ev.loc_block_id
  4432. AND cim.id IN (loc.im_id, loc.im_2_id)
  4433. AND ltype.id = cim.location_type_id
  4434. ORDER BY cim.is_primary DESC, im_id ASC
  4435. [16] =>
  4436. SELECT civicrm_address.id as address_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!