I have a query that works something like this (MySQL):

Query:

```
SELECT a, b, c, d FROM xTable WHERE d=(
    SELECT MAX(d) FROM xTable WHERE uid=1
) AND c=0

```

Sample:

```
--xTable--
|  a  |  b  |  c  |  d  | uid |
| 30  | str | 20  | 32  | 1   |
| 36  | abc | 0   | 32  | 1   |
| 20  | ... | 40  | 33  | 1   |
| 19  | dsi | 0   | 34  | 1   |
| 68  |aeasd| 0   | 34  | 1   |
| 112 |3eids| 224 | 34  | 1   |

```

I want only the rows with the biggest d (34) and uid=X, but only the ones with c=0.

Is there a way to replicate this query without subqueries?