| 116 | | . "FROM entity e " |
| 117 | | . "INNER JOIN phonenumber p ON e.id = p.entity_id " |
| 118 | | . "WHERE e.id IN (" |
| 119 | | . "SELECT b.id FROM (" |
| 120 | | . "SELECT a.*, ROWNUM AS doctrine_rownum " |
| 121 | | . "FROM (" |
| 122 | | . "SELECT DISTINCT e2.id " |
| 123 | | . "FROM entity e2 " |
| 124 | | . "INNER JOIN phonenumber p2 ON e2.id = p2.entity_id " |
| 125 | | . "WHERE (e2.type = 0)" |
| 126 | | . ") a" |
| 127 | | . " ) b " |
| 128 | | . "WHERE doctrine_rownum BETWEEN 3 AND 7" |
| 129 | | . ") AND (e.type = 0)"; |
| | 116 | . "FROM entity e " |
| | 117 | . "INNER JOIN phonenumber p ON e.id = p.entity_id " |
| | 118 | . "WHERE e.id IN (" |
| | 119 | . "SELECT b.id FROM (" |
| | 120 | . "SELECT a.*, ROWNUM AS doctrine_rownum " |
| | 121 | . "FROM (" |
| | 122 | . "SELECT DISTINCT e2.id " |
| | 123 | . "FROM entity e2 " |
| | 124 | . "INNER JOIN phonenumber p2 ON e2.id = p2.entity_id " |
| | 125 | . "WHERE (e2.type = 0)" |
| | 126 | . ") a" |
| | 127 | . " ) b " |
| | 128 | . "WHERE doctrine_rownum BETWEEN 3 AND 7" |
| | 129 | . ") AND (e.type = 0)"; |