moduleid=23&fields=areaid&condition=status=3 and areaid in (15,219,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,220,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,221,1869,1870,1871,1872,1873,1874,1875,1876,1877,222,1878,1879,1880,1881,1882,1883,1884,1885,223,1886,1887,1888,1889,1890,1891,1892,1893,224,1894,1895,1896,1897,1898,1899,1900,225,1901,1902,1903,1904,1905,1906,1907,1908,1909,226,1910,1911,1912,1913,1914,1915,227,1916,1917,1918,1919,1920,1921,228,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,229,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,230,1944,1945,1946,1947,1948,1949,1950,231,1951,1952,1953,1954,1955,1956)&pagesize=4000&group=areaid&template=list_select_city¤turl=https://quanguoweixiu.com/wxwd/sfjs/&showall=1&debug=1
SELECT areaid FROM dt_article_23 ya JOIN (SELECT itemid FROM dt_article_23 WHERE status=3 and areaid in (15,219,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,220,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,221,1869,1870,1871,1872,1873,1874,1875,1876,1877,222,1878,1879,1880,1881,1882,1883,1884,1885,223,1886,1887,1888,1889,1890,1891,1892,1893,224,1894,1895,1896,1897,1898,1899,1900,225,1901,1902,1903,1904,1905,1906,1907,1908,1909,226,1910,1911,1912,1913,1914,1915,227,1916,1917,1918,1919,1920,1921,228,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,229,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,230,1944,1945,1946,1947,1948,1949,1950,231,1951,1952,1953,1954,1955,1956) GROUP BY areaid LIMIT 0,4000) yb on ya.itemid=yb.itemid
全部
南京
