CAML Query to get approved items and items submitted before today is failing

Question

I do not have a CAML Builder installed so just wanted to freehand this code. However I find that it is failing.

<View>
<Query>
    <Where>
        <And>
            <Leq>
            <FieldRef Name=\'StartDate\' />
            <Value Type=\'DateTime\'><Today />
            </Value>
            </Leq>
        </And>
        <And>
            <Eq>
            <FieldRef Name="_ModerationStatus" />
            <Value Type="ModStat">0</Value>
            </Eq>
        </And>
    </Where>
<OrderBy>
<FieldRef Name=\'StartDate\' Ascending=\'FALSE\'/>
</OrderBy>
</Query>
<RowLimit>1</RowLimit>

Answer 1

<View>
<Query>
    <Where>
        <And>
            <Leq>
               <FieldRef Name=\'StartDate\' />
               <Value Type=\'DateTime\'><Today />
               </Value>
            </Leq>          
            <Eq>
               <FieldRef Name="_ModerationStatus" />
               <Value Type="ModStat">0</Value>
            </Eq>
        </And>
    </Where>
<OrderBy>
<FieldRef Name=\'StartDate\' Ascending=\'FALSE\'/>
</OrderBy>
</Query>
<RowLimit>1</RowLimit>

Nesting of And condition was wrong.

Check my answer on how to write nested query