this
MySQL returned error
Error Description :
Error No : 1064
Description : 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 ' is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,act' at line 1
SQL Query
SELECT COUNT(`book`.id) AS CNT FROM `book` WHERE id!=0 AND book.id<>0 and book.active='yes' and city_id!='' and book.id in(0,397,863,271,233,4362,6191,967,784,6234,3997,5508,6427,6474,6426,6381,6388,233,6375,863,5719,397,714,6798,6390,713,6381,377,6082,386,392,6381,3841,382,323,4906,388,372,6380,374,2701,2474,7238,3860,378,4199,6740,3933,6809,7833,8215,7903,1984,5995,4878,6381,1766,1506,6617,926,2783,4146,6204,222,6178,1038,600,3841,4411,504,1770,388,1771,323,1767,1730,6742,1768,4156,6664,4452,512,1557,4185,6390,1351,4146,1770,6740,3874,4614,4146,2023,6034,6036,6596,4473,6381,6038,4791,7238,7505,435,5143,1765,6740,7238,3511,3874,508,1771,1767,7834,6740,7238,6482,7473,7837,7836,2786,3874,6023,7837,7138,6639,7354,6730,6684,4146,5535,1215,3511,7837,7834,6420,2282,6911,6967,389,6961,6966,1730,7897,1303,6951,3896,7266,8831,6197,8529,6743,8165,979,8585,8833,8833,3702,3702,6381,1537,6102,6845,7287,7090,7068,7108,7971,7072,7247,7946,7946,7107,7294,8044,8049,7906,7282,7282,8086,7279,8081,7662,7269,7939,7074,4983,8220,7940,8371,8371,8086,7077,8571,8206,8206,6381,6391,6175,6719,1492,6359,673,979,2605,3784,2520,7808,4121,5386,1165,7546,8682,8824,1764,6082,374,1664,6719,7437,858,857,397,1537,5910,376,382,379,6743,6144,4614,6751,388,6082,380,4302,379,391,376,377,382,385,390,3090,6742,3728,5371,381,386,6076,385,377,394,386,8168,387,376,8165,6750,393,384,375,388,6270,6066,372,379,390,3893,7199,6082,368,3879,7238,409,6749,365,8168,1557,392,389,8788,8785,8786,4639,8882,223,7923,4395,8878,2989,8787,6103,6746,367,2117,8877,6493,3428,8881,7239,8982,5770,8983,6204,7175,8358,6785,6144,6538,8856,6386,4714,386,8789,8880,8858,8855,9192,378,7300,6491,8651,3889,3896,3883,3885,4302,7214,3888,979,810,1165,8824,8857,8358,6359,5386,5297,9149,7599,7808,1266,1411,1685,4289,6527,6521,4293,6218,3891,3890,4294,3895,6532,3892,7693,3894,3882,8271,3897,8272,3893,3881,3884,3888,3883,8274,8273,8981,8982,546,554,6537,8980,6381,3885,8879,2701,6377,9698,9713,9709,9708,9710,9711,1766,9718,9435,8241,8246,9593,9592,8310,9684,8598,8249,9427,8243,9425,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,1453,2992,408,1663,2520,5827,7069,7123,7115,788,5806,7591,7576,7833,382,6189,6742,6582,8268,8401,8401,7097,7097,365,8267,4861,8580,8580,217,7548,8790,8394,8390,8390,8891,5882,8251,7897,9011,8839,8839,8438,2992,2992,9028,2992,8793,9139,8267,6743,6937,6933,6931,857,6545,8984,2594,2005,9488,2005,858,6922,6934,6935,6938,6744,2276,6912,2275,7134,8725,2274,9111,9891,8881,9190,8340,8882,990,6757,6936,6758,6746,6426,10328,10329,9149,6422,6523,6381,9386,524,10098,10961,6371,6175,2467,6151,1738,4289,7741,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,6832,735,8896,2989,222,7178,6181,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,6003,1766,4500,5769,4349,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,10682,11328,9390,11908,1265,11853,3105,3081,6821,10886,11749,4580,11744,11603,9505,11854,7214,8303,11439,10211,12001,11676,788,2748,11776,11720,9062,11452,9649,653,382,10417,6517,6376,6234,6989,9590,11206,10561,11080,11048,11046,11079,9591,10725,11078,10214,10559,10799,8883,10801,6381,7704,10797,11157,10200,10796,9430,11153,10795,10201,10558,9589,10216,10794,8596,10793,9587,11076,11155,11159,10562,11075,11139,10215,11081,8323,9424,8245,10791,10199,9588,10790,8241,9523,10981,8247,11036,8242,8311,8241,10606,8244,11161,11151,8249,8243,8324,8310,11158,11160,3875,10332,8339,10323,10325,8247,8341,10158,8314,11050,8242,8245,8244,11759,8241,10324,10329,10053,6354,9665,11617,10333,10331,11618,11242,10330,10326,10332,11050,10056) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC