CC's query
ActivePublic
Actions

Authored by • CCogdill_WMF on Apr 24 2015, 10:00 PM.

Tags

Referenced Files

	F156448: CC_s_query
	Apr 24 2015, 10:00 PM

Subscribers

None

	MariaDB [civicrm]> explain SELECT email FROM civicrm_email JOIN civicrm_contact ON civicrm_email.contact_id = civicrm_contact.id JOIN civicrm_contribution ON civicrm_contact.id = civicrm_contribution.contact_id INNER JOIN ccogdill.GCOrderID0315 ON civicrm_contribution.trxn_id LIKE CONCAT('%', ccogdill.GCOrderID0315.id, '%') WHERE civicrm_email.email IS NOT NULL;

	+------+-------------+----------------------+--------+--------------------------------------+------------------------------------+---------+----------------------------------+----------+-------------------------------------------------+
	\| id \| select_type \| table \| type \| possible_keys \| key \| key_len \| ref \| rows \| Extra \|
	+------+-------------+----------------------+--------+--------------------------------------+------------------------------------+---------+----------------------------------+----------+-------------------------------------------------+
	\| 1 \| SIMPLE \| GCOrderID0315 \| ALL \| NULL \| NULL \| NULL \| NULL \| 2249 \| \|
	\| 1 \| SIMPLE \| civicrm_email \| ALL \| UI_email,FK_civicrm_email_contact_id \| NULL \| NULL \| NULL \| 10827277 \| Using where; Using join buffer (flat, BNL join) \|
	\| 1 \| SIMPLE \| civicrm_contact \| eq_ref \| PRIMARY \| PRIMARY \| 4 \| civicrm.civicrm_email.contact_id \| 1 \| Using index \|
	\| 1 \| SIMPLE \| civicrm_contribution \| ref \| FK_civicrm_contribution_contact_id \| FK_civicrm_contribution_contact_id \| 4 \| civicrm.civicrm_email.contact_id \| 1 \| Using where \|
	+------+-------------+----------------------+--------+--------------------------------------+------------------------------------+---------+----------------------------------+----------+-------------------------------------------------+

Event Timeline

• CCogdill_WMF edited the content of this paste. (Show Details)Apr 24 2015, 10:00 PM

• CCogdill_WMF changed the title of this paste from untitled to CC's query .

• CCogdill_WMF updated the paste's language from autodetect to autodetect.

• CCogdill_WMF added a project: Fundraising-Backlog.

daniel mentioned this in T77983: [Story] Use localized unit symbols.May 23 2015, 2:40 PM

Jc3s5h mentioned this in T77982: Decide on implementation of Unit Selector widget.Jul 20 2015, 5:50 PM

• Jonas mentioned this in T86528: [RFC] Unit Localization.Aug 28 2015, 2:07 PM