Converts a subquery to a join query.

The original subquery SELECTCOUNT (*) interval & #039; 1 & #039; andcreatetime & amp; gt; 1413533130andarea_codein (,) andmember_idin (original...

Select count (*) AS tp_count FROM sdb_ B2C _orders WHERE pay_status = '1' and createtime> 1413533130 and area_code in) and member_id in (select member_id from sdb_invite_invite where in_member_id = 14273 or in_member_id = 13742 or in_member_id = 14299) LIMIT 1

The execution result is22

Use connection query instead of the preceding subquery

Select count (*) AS tp_count FROM sdb_ B2C _orders AS bo INNER JOIN sdb_invite_invite AS ii ON bo. member_id = ii. in_member_id WHERE bo. pay_status = '1' AND bo. area_code IN (1030,1031, 1032,1033) AND bo. createtime & gt; 1413533130 AND ii. in_member_id IN (14273,13742, 14299)

The execution result is131

Reply content:

Original subquery

Select count (*) AS tp_count FROM sdb_ B2C _orders WHERE pay_status = '1' and createtime> 1413533130 and area_code in) and member_id in (select member_id from sdb_invite_invite where in_member_id = 14273 or in_member_id = 13742 or in_member_id = 14299) LIMIT 1

The execution result is22

Use connection query instead of the preceding subquery

Select count (*) AS tp_count FROM sdb_ B2C _orders AS bo INNER JOIN sdb_invite_invite AS ii ON bo. member_id = ii. in_member_id WHERE bo. pay_status = '1' AND bo. area_code IN (1030,1031, 1032,1033) AND bo. createtime & gt; 1413533130 AND ii. in_member_id IN (14273,13742, 14299)

The execution result is131

Repeated sdb_invite_invite.in_member_id records