How to find same/mutual/common entries of two users? : <p>I want to find all pages two users like (<code>status = 1</code>) or dislike (<code>status = 0</code>).</p>

<p>Structure <code>pages_likes</code>:</p>

<p><a href="https://i.stack.imgur.com/maVNL.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/maVNL.jpg" alt="enter image description here"></a></p>

<p>Assume my user id (<code>uid</code>) is <code>1</code> and I'm on the page of user with user id <code>uid = 2</code>, I want to select all <code>page_id</code> entries I have in common with that user.</p>

<p>How could I select or just count the amount of all that <code>page_id</code> entries we have in common?</p>
