Не ищет площадки при заданном параметре "Текст страницы:"

[kozlodoy]

Вот, что выдает

Warning: join() [function.join]: Bad arguments. in /usr/home/a38002/sape.ru/html/orders.php on line 596

Notice: USER_ID: 2910 | URI: /orders.php?act=s_order&link_id=492979 Query: SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS p.id FROM linker_pages p, linker_sites s left join linker_categories c on (c.id=s.category_id) WHERE s.id = p.site_id AND s.status_s = 2 AND p.status_s = 1 AND ( p.n_placements < CASE WHEN p.level=1 THEN s.max_per_page WHEN p.level=2 THEN s.max_per_page_2 ELSE s.max_per_page_3 END ) AND s.id NOT IN (тоже много кода.... 4782, 4794, 4802, 4814, 4816, 4862, 4869, 4956, 5023, 5031, 5039, in /usr/home/a38002/sape.ru/html/_includes/DB.php on line 328

Query: SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS p.id FROM linker_pages p, linker_sites s left join linker_categories c on (c.id=s.category_id) WHERE s.id = p.site_id AND s.status_s = 2 AND p.status_s = 1 AND ( p.n_placements < CASE WHEN p.level=1 THEN s.max_per_page WHEN p.level=2 THEN s.max_per_page_2 ELSE s.max_per_page_3 END ) AND s.id NOT IN (128, 182, 183, 186, 344, 391, 568, 628, 659, 723, 733, 820, 821, 878, 968, 1080, 1093, 1104, 1114, 1116, 1117, 1126, 1137, 1157, 1186, 1248, 1249, 1307, 1381, 1385, 1454, 1466, 1588, ..........................................._МНОГО ТАКИХ ID...... НЕ ВМЕЩАЕТСЯ В САБЖ.............._85655, 0) AND (s.flag_not_for_sale = 0 OR (s.flag_not_for_sale = 1 AND s.user_id = 2910) ) AND p.price > 0 AND s.id NOT IN (69990,71273,99612,1466,1911,27099,29505,64560,132 32,42450,44764,49854,49941,50566,50634,50774,50777 ,50795,62803,62817,64842,64845,64848,64849,64855,6 4859,64861,64865,64867,64868,64869,76767,77148,958 37,50419,103704,4790,4810,4923,4926,5015,8303,8307 ,8613,14671,17400,17604,75703,76184,5687,5690,5691 ,8445,12702,21223,22188,22190,32783,35711,35721,35 732,35734,35736,35738,35739,35745,49556,53575,8013 7,88907,88908,88909,99045,99053,31699,55048,79114, 82625,90880,90926,91308,91350,93331,105177,105907, 107477,108221,108280,108281,9451,11140,49797,71317 ,3505,3826,3827,3828,3837,3838,3839,3840,3842,3843 ,3844,3845,4329,4331,4332,20861,20865,20869,20873, 20877,20923,20939,20951,22545,23552,23555,23556,23 562,25292,41972,41975,41976,41980,41981,41987,8037 0,81357,82521,84270,86529,86535,97482,97565,109318 ,72695,75284,22868,23442,33218,34403,36407,41961,6 8404,68656,84931,23607,40162,42493,42499,42504,425 10,44676,47423,53361,60115,69877,36355,55785,10068 2,106284,14317,14323,36821,37334,38917,39906,40168 ,40195,40204,42326,42513,42613,42615,42772,42914,4 3489,43496,45045,45050,45125,45245,45254,45274,465 26,46541,46548,46556,51114,51669,51671,63930,89058 ,36963,39454,41703,48643,79192,80053,82806,39815,3 9862,39866,39928,40012,40210,40518,64762,92258,651 61,91381,53717,53995,87842,76516,76539,76545,76550 ,76573,78696,78697,78701,78702,90114,90127,90129,9 0130,97161,108053,82492,87382,91945) AND s.id NOT IN (77549,95843,21079,43146,83273,11716,12397,....... .........,0,104918,107499,559,4822,20352,71135,306 72,48469,56783,103213,8645,68918,57548,94239,99457 ,38411,53782,58798,81037,84091,32867,48592,93131,2 4760,2462,91951,107157,107824,56896,59638,31199,64 6,13541,48399,85970,107768,110186,21999,5088,8449, 9435,10969,10971,10968,17194,19352,21927,29509,342 95,40612,40615,40616,48494,48516,53518,53821,54519 ,60351,62135,62384,62672,62991,66625,71612,71806,2 1582,76982,83163,47619,86564,90623,93232,94647,969 26,105342,107960,108187,108399,108415,109242,95142 ,110619,584,2897,5878,8490,9722,10449,15763,20624, 43807,52060,52574,52626,53527,55299,67620,68812,82 825,102860,101290,108140,108541,108966,109057,6081 7,582,1826,6288,18007,38030,38034,38037,38040,2692 2,53694,37858,59807,64973,91835,92833,96309,86167, 30097,101812,31748,6731,16897,22377,25073,36885,52 565,53893,23210,81080,87930,91929,92667,93434,9599 5,102074,103755,62848,108407,105426,97872,87431,38 29,5487,33546,33878,49153,60548,61704,73305,78309, 84535,87516,90744,94188,98450,105844,106305,14046, 109895,105404,14344,29007,10546,47647,66212,4595,1 012,28664,45215,68281,82263,96478,95873,5606,46986 ,1681,20402,8982,84175,9197,69683,26892,11378,9391 3,17231,108090,59835,36757,65579,15034,19665,10201 9,102020,4118,27717,107413,4119,4394,29253,7261,39 625,28277,27589,40856,32333,74327,95958,25226,8056 5,40942,23269,36030,48656,5813,34896,27499,51705,9 033,27145,26667,69076,37600,28227,2108,1465,16383, 17020,18576,19260,24069,26544,39870,42217,55993,61 569,65173,35858,71695,81197,43190,90281,97778,1040 16,10066,107272,51956,108369,4967,22393,23879,4526 5,46452,26949,35668,83374,59172,9167,51385,64529,7 9933,81799,92315,97600,97773,106804,8688,2926,2733 3,28600,15756,3449,5384,7070,19068,20856,29963,304 39,42690,52464,34223,70109,71275,81815,91632,92052 ,336,1213,5569,105382,2858,9529,14992,18831,25930, 22347,36138,36427,40471,40473,40477,41246,41552,42 437,42436,44538,44539,44541,44543,44542,44669,4584 3,46675,47155,47158,47159,48315,59903,62302,2323,3 5097,71967,81341,48186,90171,92899,101837,104833,1 05006,105746,33139,51915,55322,5255,32350,81069,42 96,26130,40510,68172,105482,2371,14001,1008,40753, 50083,50931,60047,71795,99264,4404,105128,15833,15 350,17101,23302,65505,67108,33732,104025,105801,56 10,71537,27156,4267,11069,21057,31803,40919,55014, 49289,27469,109292,2783,16841,37425,39385,53368,77 624,92892,95787,38956,84626,64972,22497,71123,2959 ,24258,38782,39236,55589,64704,73202,80935,83838,9 3878,97530,87325,106235,106641,52606,1302,95970,15 680,64432,25203,959,5400,8437,31273,31955,57956,60 040,61674,65791,81569,86908,90224,95861,100478,100 849,102916,100018,63869,31940,15743,46062,64606,12 472,1718,53532,71471,86213,99764,38425,15093,65112 ,1685,8252,33833,35079,77333,100973,2294,28827,994 8,44188,44197,44199,61738,42190,106724,67832,70631 ,20085,4169,5103,6000,15217,29107,40429,57374,5845 4,6307,29351,51240,77831,81214,12130,101011,3484,4 392,2867,84654,84314,106391,11442,27987,6077,53916 ,60772,79406,86034,96178,51011,13293,72330,21114,2 4225,105469,4275,75080,8502,97941,1236,63654,11733 ,105360,67977,24354,50664,95035,1237,8850,10751,68 425,29996,94279,18466,53454,85206,64753,40602,5465 3,57014,69608,5004,4980,2738,82700,13166,28346,935 1,35684,62127,4039,86660,33984,105054,16259,16617, 19719,37189,47731,63618,66357,95860,106820,6909,15 218,3006,5030,4527,21031,25435,32653,34116,36737,4 2713,36390,57328,64220,67280,78194,87279,49859,986 37,99347,101055,88303,84569,953,32834,49958,104522 ,107036,3808,2114,2501,5877,7193,8487,8985,13690,4 6244,41412,83816,9565,9739,23299,24236,34868,43606 ,63832,67807,102018,20305,26065,48170,18601,107116 ,12315,52998,57541,6506,50730,65823,51905,28476,61 602,25229,92126,9018,4422,33501,59926,15408,28613, 28859,28718,30653,75741,90078,43362,13024,1993,880 6,7785,10773,17593,98650,20798,42388,92888,6685,35 54,1708,9407,1654,10357,10426,15994,40054,12021,23 251,4323,19436,58866,9457,28055,2809,104631,1183,6 324,9844,19855,27118,29413,40047,53043,40217,76558 ,84076,95255,95496,60956,22320,37114,102746,786,35 03,3970,6021,52415,79613,103216,10555,9944,85284,5 0479,80173,80788,60611,98254,77001,12711,15231,289 65,29220,28289,38139,19201,91691,41765,23587,992,4 0927,1687,4395,50882,77418,51799,8679,34681,2748,3 7288,21812,95275,95458,97038,105293,54250,2642,353 28,62294,1367,40983,58994,65024,78953,81638,15354, 26497,103020,33073,22067,97793,85577,1315,2904,495 7,19789,25965,32733,40026,26979,50458,62146,72130, 103360,97241,3510,122,1106,1115,1275,1774,2590,100 07,2594,3628,5570,5086,6703,2880,9287,9315,9316,98 56,11856,19242,45195,41817,47323,18070,19240,19244 ,24847,53772,53796,59353,75369,91445,21091,2800,30 338,23291,38154,97798,5611,14947,9470,14955,24666, 41564,95083,4556,21677,41447,5319,9479,1462,41258, 35576,17952,23799,63160,28572,61755,91016,106639,1 107,948,6981,42448,49235,63756,11704,78852,99789,1 02957,106929,9878,16267,21958,8919,7519,5952,20284 ,40930,34428,34237,28021,110324,36152,41568,54879, 23313,1180,5273,28461,104334,104068,58659,64177,78 784,97370,34686,40554,43567,15004,104148,2372,2019 0,33395,37040,51157,80334,82136,86463,85161,13269, 28870,8923,14806,3991,19479,30163,44044,19236,2733 9,36956,24218,46445,24446,52916,15026,27213,60701, 77101,86013,97862,98065,22785,101700,101875,104500 ,40742,25232,3942,11220,13102,16603,22589,22610,16 478,27361,13423,28636,31178,32280,23460,39531,2894 8,42584,20942,49228,49230,69206,36107,87663,90179, 94077,94179,29149,29464,97392,97966,100238,101196, 102720,102904,103440,105409,57955,23685,29009,2431 6,70270,80140,80469,34866,76989,3823,24811,29861,8 3478,44023,99266,99814,68038,101777,34278,41651,10 3954,12799,28715,1655,52784,39777,21346,41400,4190 0,38612,59998,13316,48402,62850,27670,58683,97071, 59898,1735,16295,6727,11944,85406,74511,17089,2481 ,99855,103995,31471,78972,15631,94266,101977,10624 3,4791,12135,12707,15214,19086,22384,23010,40957,4 7215,86203,88514,88680,105778,28873,976,5583,7001, 24223,15472,27807,23388,1160,1682,11373,18911,2892 2,31196,58944,65230,82450,82451,51688,104189,10575 6,99267,8283,24812,30108,52659,29403,94150,98379,1 03501,75404,18698,38032,81940,71521,41633,43712,86 802,98366,25545,1132,36097,14766,17016,16539,3788, 33377,25718,80784,16443,33493,34960,100273,10855,8 280,77399,42063,33295,58449,44989,8401,39891,63676 ,69942,50601,36863,101423,44459,99499,31824,11314, 90165,96385,5887,24311,47542,2658,22066,31541,5976 9,104563,599,38743,19656,101266,93029,36394,88670, 106345,20463,68434,86975,62171,60786,98869,5787,10 5043,43732,107159,21493,92387,95543,105371,7181,0) AND p.id NOT IN (22879808,27353466,31065027,10798909,30698290,3069 8366,30698305,30698384,2474751,2614943,2616251,428 0587,4570117,4945872,4946262,7059848,7747741,78033 73,9913937,10166967,10987972,17483102,19270535,275 74055,29270505,30921593,30921615,31347683,3667907, 10803340,26027889,28710973,2430320,7318822,2569610 9,26033112,26172957,27896453,27972310,5558590,2558 8920,28506817,28985953,29860080,29860937,30736251, 27354439,71527,3231395,3231442,4543365,19518435,71 82306,12482750,15034344,29283450,12718513,18834210 ,19525863,26809178,28226913,9149696,14259032,12482 780,15536356,22816585,23719862,7824492,12513539,15 034191,26538684,5702796,502745,26205953,30637602,3 0793359,15759373,18816552,7297185,7294829,69736,31 21428,12458502,30297006,30788992,31502184,30793345 ,4810151,1015487,1528598,1963244,2326430,2326517,2 632018,3931973,4308541,4798672,6916867,8241524,987 7670,9879618,9880069,12497003,12502779,14165284,14 286825,14525951,15961994,16508562,16592998,1669341 1,16781934,17989291,19690219,19738990,20551958,214 75078,23471480,24285702,24500068,25781896,26564022 ,27004601,27505678,30001668,30828209,30909552,3095 4024,30957417,31236956,31403609,31642692,59775,523 451,1198176,1561930,2008934,2195577,3598662,457276 7,11052926,13596275,13790863,13806674,14169479,147 26233,18395601,18804121,23406477,29168419,29589173 ,30896106,31025797,31150388,31177891,16145581,5447 7,1212739,1344300,4100213,9080361,9081123,9082076, 9082648,11179831,14232805,15055833,15829740,173918 08,26178972,26495201,27434914,27709715,28932808,28 979333,31249947,1393524,3879986,4902298,5772844,88 52970,13790133,14307557,15302539,22825793,24975089 ,26197187,26436055,26638507,27405315,29037596,2945 0361,30567017,30956227,31106912,31229927,24801566, 652610,1087228,8001099,8537461,12688437,16016658,1 6382308,20328017,21894299,23809321,24839685,258383 95,26798377,28614578,30127498,30265246,16374395,31 449642,30058300,3306950,26965747,2228376,12280040, 17859506,884794,167433,6694878,11569890,18535901,2 3220354,27456672,27368935,1139503,12054511,305673, 4610007,1874961,30584680,17863737,11841045,1901431 8,6280822,2386045,26692594,31144399,3938236,269630 84,30871745,24019569,8823368,17624301,19272849,438 7455,29023936,29023938,726394,6483500,30711714,726 851,822699,6831674,2058853,27908378,6597916,116906 66,29455821,7614796,23053616,27400946,24997058,227 05244,10052290,5229494,10174892,12547302,17813616, 25933372,6422781,15960584,1906252,6338874,6338913, 6178327,19433855,8993180,19434673,6600661,364101,1 924665,3720360,3893749,4162029,4296431,5462353,613 5842,9544315,10420224,14866269,16353271,17498717,1 9500161,19708426,22868052,25019125,25718494,277484 55,29546774,30257601,30680037,25667200,30948992,98 2303,4909215,5402878,11594667,11920441,17344859,22 045950,23511214,23810120,7607145,13462210,17348721 ,22507775,23095437,26337723,27711281,27746101,3048 7895,1656784,17278186,6369325,6369180,11022516,436 2009,616081,1062242,1459870,4272431,5535089,701050 9,7115311,10652928,13756286,14550783,19211742,1957 3312,23104896,26122047,26241021,85574,214084,11242 52,726438,30008845,31036897,525510,1992597,3344506 ,4207214,5999850,7038345,8679735,8743161,9802548,9 803601,9804828,10162204,10225387,10535004,10536540 ,11398887,11399373,11399879,11400802,11400839,1141 7404,11802242,11976955,12099813,12100163,12100544, 12420825,15856056,17153815,19543436,20707383,21420 682,22917089,23026048,25676287,26505808,28982531,2 9839097,29887654,30111332,10846399,13574096,147271 29,3215320,7601153,22823323,790981,9069200,9834875 ,18471314,30052892,416296,3172796,4513859,9965753, 12981838,13336817,15878196,19745822,28143867,29838 210,29928861,3609736,3462655,3910848,5240757,17607 931,18195530,25646344,29551227,30120356,1140207,19 672939,6341128,783653,2341872,4649108,7404130,1004 8733,14658691,16743355,6419274,31262008,497462,387 2243,8965692,9304436,15053808,22693884,26505218,27 340324,28474620,28576325,30270649,4929407,19511343 ,543548,5523818,9206656,9284442,14788514,17306666, 20294384,22800658,23647796,26686860,27699174,29874 581,30234166,30400695,13796711,24024237,27402980,3 582800,18774207,6041479,8995291,534231,1066004,299 3714,7301693,7469160,15318102,15875426,16372391,17 676809,22983362,24611828,25679778,27362484,2855511 9,28650679,29183421,29865944,17046840,7467461,3597 116,11852134,17262355,30014036,4651867,14171502,19 659569,24345708,29455015,29358166,9150491,14667444 ,17490073,310134,1590138,8092910,8417220,21801651, 28668103,412386,6738145,11168555,13195549,13201523 ,13201671,16395988,25382921,30450525,18357755,1941 0611,4472961,749537,1025136,1233190,3414260,680675 6,9779271,15191994,15423878,1329293,6865266,134175 89,21733036,22876660,26823608,28698205,1656488,757 539,822364,1022197,23852672,24196294,30312711,2401 636,20541073,1254639,14315472,16117509,16596078,22 175854,24278250,27427178,28319129,28933336,2945599 9,28935764,5508845,30046427,786819,20950374,425218 3,27778826,28319214,6682375,224431,16990840,248895 0,30005436,18381364,8826535,18381909,13253681,2712 6657,253120,1840192,2282060,18661479,6041718,70195 36,26832071,4929032,19510832,4142355,20546227,2401 9897,17324023,9872262,14563044,15124165,18989299,9 89069,1398228,4631984,23376565,6690619,11422257,66 27783,2137086,8561337,17141302,20546235,22077939,2 4533959,28993351,29900092,3689897,3804330,4386251, 4402885,4407826,8934986,12297749,16947929,17895498 ,27361619,30517829,30564036,3415289,549714,996366, 1076971,4646894,5921476,7711844,8193838,11926611,1 2723399,14558096,15181229,15285758,17105339,182906 57,21837900,24742995,26949362,27972388,28181992,28 718547,28984096,29295616,148952,7797794,12937155,2 9749028,30590976,650153,354232,450514,1195853,1471 891,1563066,1872785,3134909,11877045,20859945,2364 3959,1995239,17667005,5238170,5509435,8544595,1097 9351,17040714,18433493,29023729,4536301,6036404,12 403809,4163879,30619873,2602072,17120506,15234334, 1364970,13282582,17692927,13571323,16922740,163597 93,5844788,26311195,1907196,6622572,7975511,158642 41,3489939,6685153,6742234,6706178,6742446,7183848 ,21140709,25633960,10846302,3043409,347399,1723458 ,6964100,2286184,3991548,27966292,4711481,10513260 ,26504982,1657891,1432580,2344813,1955851,18918247 ,2161076,2181588,3640235,9622924,2542942,5226061,7 95151,4329624,15543045,18825184,24890942,4386301,2 3026441,29806655,204315,1331973,2045254,4435522,63 28838,6900384,9609905,9609998,13977593,14234346,21 372445,23712652,27191803,27247502,30022351,4866746 ,8910497,29138191,1872904,2010468,91923,626248,682 176,3870075,18827980,22247003,30314545,2231403,849 6123,24041786,13194557,22596018,22769774,24128711, 27862424,30011808,2653497,12181571,6759683,6827685 ,6747552,9109623,19832564,26138323,10291765,913961 1,1334778,19215969,309264,822726,13328704,22606740 ,13551633,1846256,8541369,490769,8946812,10242655, 27197173,27229855,27573458,29991239,14426915,46689 7,8954042,16555395,243147,10060478,15561994,174188 92,22068349,28810642,3462141,6133142,29214174,3026 1211,4817732,27752292,24143963,148400,246119,52631 7,981334,4421865,6010777,7746908,9603037,15222672, 15950319,16512950,19853118,29319067,29864874,64421 7,14580,188230,189978,230009,321404,462241,2095180 ,8496469,503759,639505,1125285,1380637,1388354,143 3182,1939184,1941474,1941672,2050873,2520667,42916 24,11561425,12149867,12153313,4115918,4290926,4292 091,5722045,14256489,14269723,15716210,21027623,26 019642,28347968,28584091,6369036,12319514,4163821, 5234188,9111974,27754500,15888911,3331175,1985461, 3332682,5683333,27368233,27140017,868525,5533771,1 0203298,1907152,1980400,503596,10163866,8498592,20 50775,23785410,5387511,16848429,6678720,16403398,2 5920603,30403702,30591986,6623393,188503,2630421,6 444311,10540194,12709850,17009037,18797619,2204183 4,28331607,29192155,30560258,2059852,2181583,36920 73,13592028,1855356,2162484,4255813,4520096,100585 74,13735436,29500272,6533450,31537336,8691478,1023 1093,14614180,5243564,203871,1846407,1040732,66501 25,29696949,29576359,15493079,24996359,25949019,27 670959,8344981,9842367,10975180,3451371,29629307,4 16605,4502926,7948692,8884713,13393210,22639584,23 193277,24449164,24005572,3077703,3077853,10066521, 1855630,3290415,3967793,4342106,7043849,11192232,4 289632,6371569,8862367,5506876,11920023,12611508,1 3928175,16346370,18620698,19689805,21511534,242748 86,27768091,27803953,28798072,28947665,28989102,29 737614,30020782,5848507,678336,2364429,3062168,379 7029,4948476,4953370,5525340,6827642,6373738,66026 99,6688154,7293227,7581585,8903344,9343771,1058328 3,10605624,12612141,12707960,12708329,18851750,193 12681,24908639,25662480,25662575,26758455,26792652 ,27030930,27344781,27674598,27781492,28497955,2874 8897,29132128,29180282,29352758,30020892,15312142, 5336126,6771959,17659640,19240771,22585327,2269195 3,8375309,21478156,652285,5718147,6988892,23527092 ,24128507,28144574,28336311,18396881,28967602,8233 869,10259537,29504274,2673112,6705422,294038,13856 648,9518467,4704539,10192737,10320249,15299014,158 69019,5717506,12474876,16755985,20561673,15501179, 27587326,27587385,15854077,30255058,3697195,139213 3,2525055,24086189,22598365,3907399,24293798,28344 582,29533969,8023241,22075302,23150167,26823703,29 014933,30225454,942330,2570996,2651609,3413322,427 5050,4907809,5163657,11022739,12116829,24347356,25 236614,25271932,30128812,6745874,159911,1126364,14 34709,5506888,5623221,6494896,6474975,207864,30625 1,2385708,4242600,6754038,7294118,15557049,1750911 6,23297350,23297447,24002517,29676551,30112403,303 05247,1595224,5718331,7026691,14548509,18327856,26 787479,27887109,29367321,30576501,4178029,9080490, 23153038,26028157,10252151,11013603,11013611,24584 883,27878168,5956304,4560056,8671951,3259903,38931 24,2006812,3780008,3967582,8887051,5968546,2276784 3,3739923,7968146,20707005,28504105,3489622,159361 8,21593067,10364236,7916035,15416172,11499034,1579 937,9547920,16960159,19106760,22670534,25643975,28 805998,11370482,28230433,7407647,2380604,25660446, 27448459,1205260,5548354,12226274,469584,4817710,7 365113,15813720,29758576,64131,9692537,4385129,287 61593,26523044,8733983,25270452,30278966,21667407, 18662531,24647039,16522479,16124767,28029157,11771 32,29898317,11025875,30638656,4726985,26365579,272 68443,28369323,22768895,30006642,1474661,18662511, 0) AND /* BP */ 1=1 AND s.category_id IN (43, 15, 10, 41, 42, 55, 40, 16, 39, 14, 1, 8, 5, 23, 12, 54, 27, 21, 49, 25, 19, 34, 47, 32, 2, 28, 35, 31, 11, 37, 45, 29, 50, 13, 20, 3, 30, 17, 9, 18, 26, 44, 22, 36, 4, 24, 53, 7, 38, 6) AND s.flag_blocked_in_yandex = 0 AND s.user_id != 2910 AND p.id IN () ORDER BY p.pr DESC, p.price ASC LIMIT 10000 | MySQL Error #1064 occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY p.pr DESC, p.price ASC LIMIT 10000' at line 27