Difference between revisions of "Issuepedia:Code/lib/links"
< Issuepedia:Code | lib
Jump to navigation
Jump to search
(trying new code) |
(make max optional) |
||
| Line 105: | Line 105: | ||
<let name=sql>SELECT q1.* FROM qryW3_Titles_Catgs AS q1 LEFT JOIN qryW3_Titles_Catgs AS q2 ON q1.cl_from=q2.cl_from WHERE (q1.cl_to='Data/links') AND (q2.cl_to='</let> | <let name=sql>SELECT q1.* FROM qryW3_Titles_Catgs AS q1 LEFT JOIN qryW3_Titles_Catgs AS q2 ON q1.cl_from=q2.cl_from WHERE (q1.cl_to='Data/links') AND (q2.cl_to='</let> | ||
<let name=sql append copy=topic /> | <let name=sql append copy=topic /> | ||
| − | <let name=sql append>') ORDER BY page_title DESC LIMIT </let> | + | <let name=sql append>') ORDER BY page_title DESC</let> |
| + | <if flag=max> | ||
| + | <let name=sql append> LIMIT </let> | ||
| + | <let name=sql append copy=max /> | ||
| + | </if> | ||
<let name=sql append copy=max /> | <let name=sql append copy=max /> | ||