moduleid=23&fields=areaid&condition=status=3 and areaid in (13,196,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,197,1656,1657,1658,1659,198,1660,1661,1662,1663,1664,1665,1666,1667,1668,199,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,200,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,201,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,202,1704,1705,1706,1707,1708,203,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,204,1721,1722,1723,1724,1725,205,1726,1727,1728,1729,1730,1731,1732,1733,206,1734,1735,1736,1737,1738,1739,207,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,208,1751,1752,1753,1754,1755,1756,1757,1758,1759,209,1760,1761,1762,1763,1764,1765,1766,1767,1768)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://aq.quanguoweixiu.com/wxwd_2/sfhun/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (13,196,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,197,1656,1657,1658,1659,198,1660,1661,1662,1663,1664,1665,1666,1667,1668,199,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,200,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,201,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,202,1704,1705,1706,1707,1708,203,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,204,1721,1722,1723,1724,1725,205,1726,1727,1728,1729,1730,1731,1732,1733,206,1734,1735,1736,1737,1738,1739,207,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,208,1751,1752,1753,1754,1755,1756,1757,1758,1759,209,1760,1761,1762,1763,1764,1765,1766,1767,1768) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid
全部
长沙
