Разработка веб-сайтов на субподряде

SELECT M34.`Message_ID` as `id`, M34.`PName`, M34.`PCity`, M561.`PCity` as `aPCity`, reg.`Region_Name`, M34.`Keyword`, M34.`Logo`, M34.`PPhone`, M34.`PhoneAccess`, M34.`PURL`, M34.`PStatusMail`, M34.`DeveloperType` as dtype, M561.`Phone` as `aPPhone`, M561.`PhoneAccess` as `aPhoneAccess`, M561.`PStatusMail` as `aPStatusMail`, M34.`PRating`, M34.`PCertCorporate`, M34.`PCertShop`, M34.`PCertGold`, M34.`PCertCommunity`, M34.`TechPartner`, M561.`Approved`, M34.`DealerServices`, M34.`SubcontractPrice` FROM `Message34` as M34 LEFT JOIN Message561 AS M561 ON (M34.Message_ID = PDealer) , `Classificator_Region` as `reg` WHERE reg.`Region_ID` = M34.`PCity` AND M34.Checked = 1 AND M34.ShowInRating = 0 AND M34.SubcontractPrice > 0 and (DATEDIFF(DATE(M34.PCertShop), NOW()) > 0 or DATEDIFF(DATE(M34.PCertCorporate), NOW()) > 0 OR DATEDIFF(DATE(M34.PCertCommunity), NOW()) > 0 or DATEDIFF(DATE(M34.PCertGold), NOW()) > 0 or M34.TechPartner = 1) AND M34.Message_ID IN (1,6,7,9,11,12,15,18,23,24,27,30,31,37,43,46,50,51,55,60,73,84,95,96,102,105,115,116,117,120,121,129,131,137,141,145,146,152,153,156,158,159,164,165,166,176,177,178,179,181,188,196,203,208,223,230,247,248,251,255,263,265,268,278,283,291,296,297,305,307,311,318,319,361,362,381,389,399,406,412,417,423,424,451,461,475,481,482,486,501,522,523,526,530,536,542,547,550,564,573,579,582,583,593,612,624,627,636,638,644,645,648,656,659,667,670,673,677,682,683,685,696,706,736,737,744,749,760,763,774,775,780,791,796,800,803,806,810,819,821,824,829,836,846,851,852,864,870,879,880,888,897,898,909,922,925,933,939,944,948,958,960,961,968,970,972,976,979,991,995,997,1004,1007,1015,1025,1030,1031,1040,1043,1044,1045,1050,1055,1067,1069,1079,1080,1081,1086,1093,1113,1118,1122,1126,1136,1138,1139,1143,1151,1153,1157,1161,1164,1168,1172,1177,1178,1179,1184,1186,1194,1195,1198,1204,1210,1214,1216,1220,1222,1224,1225,1228,1231,1232,1233,1242,1243,1245,1257,1264,1280,1281,1288,1291,1293,1296,1297,1301,1303,1311,1318,1323,1324,1326,1329,1333,1342,1348,1351,1357,1358,1361,1364,1368,1373,1374,1383,1391,1393,1397,1401,1402,1403,1414,1415,1416,1418,1424,1428,1429,1436,1438,1443,1446,1448,1449,1453,1454,1457,1464,1465,1467,1469,1470,1471,1475,1476,1479,1484,1488,1490,1491,1494,1498,1504,1506,1514,1517,1519,1522,1524,1527,1529,1535,1541,1542,1547,1548,1551,1552,1556,1557,1560,1561,1562,1564,1565,1569,1570,1571,1572,1573,1574,1575,1577,1579,1585,1588,1595,1599,1603,1610,1620,1621,1631,1632,1634,1636,1644,1649,1654,1679,1691,1696,1699,1709,1712,1714,1717,1726,1727,1729,1731,1732,1735,1744,1747,1751,1752,1758,1759,1775,1783,1790,1791,1797,1800,1802,1809,1810,1817,1818,1819,1820,1829,1830,1838,1841,1845,1847,1848,1852,1858,1859,1860,1862,1863,1864,1865,1872,1874,1879,1880,1890,1891,1892,1907,1909,1910,1917,1938,1939,1943,1944,1947,1950,1951,1958,1959,1962,1963,1964,1970,1973,1977,1979,1980,1982,1990,1994,1999,2011,2012,2013,2014,2028,2033,2035,2036,2041,2043,2050,2052,2055,2058,2060,2061,2071,2078,2081,2084,2085,2090,2091,2092,2093,2099,2108,2114,2116,2117,2121,2122,2123,2127,2139,2142,2146,2149,2151,2154,2161,2163,2173,2176,2184,2195,2200,2206,2212,2213,2215,2223,2224,2229,2230,2234,2237,2238,2239,2243,2246,2255,2272,2279,2280,2281,2282,2287,2288,2292,2297,2298,2302,2308,2309,2313,2318,2326,2341,2345,2349,2350,2355,2359,2362,2365,2369,2378,2387,2389,2396,2399,2400,2408,2413,2414,2418,2425,2427,2428,2430,2435,2453,2454,2455,2469,2471,2476,2486,2497,2509,2516,2518,2521,2529,2531,2533,2540,2546,2549,2553,2555,2562,2585,2590,2596,2614,2617,2627,2646,2651,2658,2662,2667,2671,2687,2696,2708,2714,2717,2720,2721,2728,2731,2732,2733,2737,2775,2786,2792,2794,2795,2796,2807,2817,2831,2835,2836,2840,2843,2857,2858,2860,2872,2883,2888,2900,2953,2970,2978,2981,2989,2995,3007,3012,3017,3023,3025,3033,3087,3090,3097,3099,3102,3108,3109,3116,3124,3137,3139,3145,3146,3154,3161,3167,3169,3171,3174,3177,3180,3199,3202,3205,3216,48,67,107,147,197,273,279,330,387,388,416,473,507,554,559,599,610,613,768,785,786,892,899,942,943,1035,1047,1066,1099,1111,1135,1137,1154,1162,1163,1189,1190,1203,1248,1254,1336,1340,1365,1396,1442,1626,1748,1929,2155,2174,2550,2683,2809,2849,2902,2923,3019,1710,2219,2336,2581,2914,2941,3118,3134,3138,3140,3141,3142,3143,3144,3147,3150,3151,3152,3155,3160,3162,3164,3165,3166,3172,3178,3182,3183,3184,3185,3186,3188,3189,3191,3193,3196,3198,3201,3208,3211,3213,3214,3215,3217,3220) GROUP BY `id` ORDER BY PRating DESC, `id` ASC LIMIT 0, 20