Reply to thread

Message: <blockquote data-quote="Haid" data-source="post: 395564" data-attributes="member: 10450"><p>I think this should work but its 2am so!</p><p></p><p>[CODE]</p><p>SELECT *</p><p>FROM catalog_pages d1</p><p>WHERE (parent_id = "-1"</p><p>      AND min_rank = 4)</p><p>  OR (</p><p>        (SELECT parent_id</p><p>         FROM catalog_pages d2</p><p>         WHERE d1.id = d2.id) IN</p><p>        (SELECT id</p><p>         FROM catalog_pages</p><p>         WHERE min_rank = 4));</p><p>[/CODE]</p><p></p><p>Show me the results.</p></blockquote><p></p>

Verification

Top