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,7160,3850,5947,1738,7605,6656,4320,840,5362,8150,8531,8674,6144,7599,3358,6971,8345,6997,650,9602,455,8340,7194,6386,7196,6191,9111,8599,8248,9165,8244,8883,9114,6146,8246,8881,1266,858,9119,9120,8341,8307,6375,8247,8311,8699,3891,8700,8242,8873,9424,8337,9433,9432,9431,8334,9534,9536,1462,8326,3402,9592,5770,9114,9414,9411,8342,9518,9427,9144,9522,9517,9426,8332,8335,1990,8598,9412,8249,8317,8328,9409,6382,8245,380,8596,9436,9386,9428,9480,8874,6139,9500,9183,9535,6371,9590,381,9591,8333,3883,9588,3891,3882,3884,3892,3881,6526,3890,3896,3893,9587,3894,8168,8597,8323,8243,8241,9589,9588,9416,8326,8325,8319,8316,8329,9434,9408,9412,8324,9908,8330,10102,10101,9868,10096,10099,10137,10139,10140,10147,10136,10138,10152,10153,10151,10198,10200,10195,10199,10202,10213,10217,10214,10216,10201,10215,4294,10194,10218,8649,10197,4296,4291,4292,10280,4282,4293,10098,4293,9633,10098,10333,10331,10330,10333,10331,10332,10323,4305,10324,9429,6201,10336,6199,9631,10322,10193,10100,10551,10328,10557,10560,10563,10607,10555,10556,7189,10326,10327,10562,10335,10103,1770,1767,1771,1769,1768,1766,10646,10643,10753,10647,5756,8894,10645,10639,10641,10752,10640,9880,10644,8887,5863,6820,6727,10874,10962,11073,1371,6743,6523,6141,6141,6396,4519,1746,5602,5602,2677,924,924,6149,6377,3895,6622,6622,4788,1398,7670,7670,5995,1764,1764,4079,7593,7593,6151,1730,8220,8220,7072,8067,6809,7082,7082,8233,1198,3803,7068,1992,5998,4770,8326,8244,3850,8245,8268,8329,8247,3392,1234,8246,1049,6659,7093,4519,4519,7878,7878,7656,7656,6521,9381,9381,7108,8002,8002,7761,7761,8793,8793,9548,9548,6146,6800,5997,3872,9189,9554,6526,9376,9376,9558,9558,9537,979,8560,6381,271,539,2729,7304,2729,9438,7903,9300,9480,3647,1215,8306,4598,8874,4598,8241,8244,8706,9182,9349,8337,7928,6768,9417,8245,9898,8922,7,9017,9432,9632,9296,10056,9296,9096,1165,222,3883,10292,810,10259,810,6359,9864,10337,6272,10337,10072,9959,3358,6348,10640,8144,4301,10738,10667,10976,7833,9777,10814,11037,11130,11121,10951,272,10937,10954,9880,11323,6354,10007,2530,104,374,8490,11496,9277,2117,11272,11439,11690,11721,10533,1385,1402,11734,10269,10836,8830,10362,7238,546,6658,857,5742,5733,4716,4437,2041,3863,550,8220,6381,553,7539,529,7149,8440,532,539,323,313,397,860,6386,549,8542,5853,6769,526,7704,538,528,525,7704,5853,540,551,864,544,1730,545,531,543,391,535,541,387,536,382,1271,4769,376,524,377,365,376,374,6270,384,2856,8787,368,6066,6082,385,394,6197,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,6526,8496,3879,7588,8989,8530,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,9437,9435,8244,9438,8340,3879,8699,8874,5770,8316,9146,9414,9409,8700,8245,9436,9408,9184,8883,8329,8247,9182,9415,8332,8318,8324,8326,8319,8241,9592,9183,9428,8248,9431,9894,9150,9143,9534,9190,9908,10045,6768,9300,7632,9154,6396,4501,10056,9792,9891,9155,9156,9217,10202,9156,10198,9854,9217,9502,10193,9502,10193,10197,10195,9147,8333,8335,10099,10102,9151,8330,10218,10147,10333,10322,10323,10217,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,8315,9182,8315,9182,8247,8340,8700,9408,8324,8244,8329,8325,8246,9233,9587,9183,9426,9111,9113,8249,8248,8245,8241,8873,8872,9427,9433,9436,551,8882,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,3036,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,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,9903,9084,10151,10202,8328,9415,9792,9414,9424,9435,9434,8585,8586,8244,9436,10322,9426,9535,10200,10139,10201,10197,10215,1768,8387,381,380,10199,375,7188,394,372,376,10217,176,9430,10322,4390,10545,1411,9137,4512,10521,10562,9587,10556,9589,9588,1266,8334,8337,10559,8342,10558,10557,10607,9429,10463,14,8341,10555,9593,10194,10561,9431,6066,9426,9436,10552,10551,10218,384,10330,10332,10331,4304,390,4684,9424,9483,9433,9427,10563,4302,10606,4286,4287,4291,4305,10728,7963,10519,1557,7698,7844,7311,7608,7610,6498,9631,7693,7694,7695,7845,7843,7696,7868,9536,4804,6653,7176,7179,7180,7182,7187,6652,7176,7178,7179,7181,11015,11014,7183,11013,7189,4386,6654,7184,7185,7186,11016,5635,8899,10796,10797,10926,10975,10930,7600,11109,10928,10927,7676,11082,10931,8681,6221,8698,6223,11251,11229,10925,10920,11186,11184,11182,11231,11177,11179,11181,11252,11175,11176,10921,6518,11173,11174,11037,11183,6519,6523,11178,1704,3442,7698,7843,7844,7845,7868,11185,10924,4297,4298,4299,9631,7843,6220,3883,3896,3891,3893,6493,3885,3890,8273,3887,3894,3897,3892,3888,3884,3889,3895,8274,10922,6537,6505,4296,6506,6536,6534,6535,6532,6538,6197,3515,10923,529,541,531,545,542,540,539,538,537,536,532,543,528,527,526,6042,553,550,548,547,554,9665,10053,10544,10975,11221,10948,549,535,524,10947,8240,6533,6532,6042,551,11241,10194,525,8332,9432,9435,10326,11240,11156,9431,9434,11241,9427,9428,11242,11406,11405,10326,8243,10606,547,11153,10560,11160,8327,8311,9416,9412,9409,11046,11151,11154,10556,10201,10139,11161,11054,11055,11139,11152,10559,10562,9593,9908,10136,9891,9894,10096,10101,10103,10102,11154,10100,11407,8245,9414,8325,8319,9415,8332,8318,8307,8249,9410,8248,9424,8247,9426,8246,8308,9182,9414,10326,11153,272,4146,2781,3874,2779,2780,2785,6443,10963,2787,2791,9436,2778,4224,9589,9183,8883,8330,10926,10927,10931,9383,9867,11109,8945,8946,6688,10232,7600,10928,7636,810,8327,9430,9592,10137,10645,10643,10641,10639,6198,6199,11430,11252,11176,11218,11493,8586,8682,9084,7546,9407,9920,10565,11147,10238,7694,8584,8585,10463,179,178,177,11324,11219,10938,10750,7631,11019,8618,7870,9993,11455,7810,9655,9554,8443,8050,11369,9520,9522,4752,10229,958,3493,7761,8793,9925,2261,8222,9195,3595,7019,9661,6710,3059,6876,1461,1520,11644,9418,180,233,10278,10823,566,173,28,11228,1370,1210,1207,956,1056,466,3872,2451,1741,923,57,1533,3392,1234,1145,3189,2725,1398,2736,9675,1198,2776,1425,9533,2677,2995,3014,4762,4784,4785,173,5089,4788,4690,8894,5756,5112,5143,3189,2992,5756,5251,7172,1537,7304,9453,9052,24,3327,3860,10526,4234,8798,8893,501,4701,5996,10375,3048,11812,5179,3989,766,6261,4708,3830,9378,4779,947,4731,4519,4029,8220,6740,2632,9300,10836,11121,5799,10056,11690,9879,9030,1616,9980,10050,10473,10065,11020,11235,8999,9937,10568,5339,5545,11495,7126,7920,8548,5817,7883,4460,608,2933,1699,6858,3080,7839,9372,10243,11784,1347,4258,11747,11748,11872,11493,11899,11722,11836,11644,11869,11816,6117,9648,10930,9657,11838,10734,11593,10744,8885,7807,6821,11354,9555,11871,8436,5995,11355,254,11981,2294,10569,10543,7919,11965,11356,11873,3066,11984,11357,7238,11645,8220,3244,3003,11423,10342,7592,3376,10558,10559,8243,8241,10556,8246,10333,10555,10546,7599,10563,10521,1685,1411,10327,10522,8249,8308,8312,8313,8315,8316,8320,8326,1266,810,10502,10565,9920,9407,6425,6424,10325,8618,8584,7870,8586,7546,10238,8682,9084,10488,9867,7631,8333,8329,8331,10336,10561,7638,5332,10519,1556,10328,10489,2605,9383,10545,10821,3875,1770,1768,1771,1765,1766,1767,8007,8159,2932,8825,10427,10612,10866,10931,7676,7600,10930,1768,10929,10799,10800,10963,10928,10840,7676,10927,10926,10828,3889,3890,3891,3892,3893,3894,3895,3896,3897,10725,10216,10159,1769,10849,1766,8585,10637,9679,11069,11019,11049,11047,10526,11008,8002,11071,11137,8154,11048,10526,11055,7810,8971,9165,735,1730,11139,11046,11138,11057,11203,11192,11191,11186,11185,11183,11181,11182,11175,11184,11177,8311,11221,11229,11243,9665,11244,10544,10053,8162,2488,11221,10975,11245,7734,11246,11241,11218,4752,8703,11190,11193,9278,11406,11407,11161,11242,10326,11046,11151,11153,11154,10560,9424,9426,9428,9431,9434,9432,9435,8324,10562,10201,10139,8162,8161,11156,11405,11160,11240,10329,10330,10331,10324,11695,11696,11697,11617,11050,11677,11320,11321,11357,11356,11355,11694,11722,11356,11467,11318,11319,11723,7610,7608,7868,5691,7693,11317,7311,848,7580,3442,3515,1704,7697,7696,7695,7694,11611,11354,11618,11836,6800,8002,11068,11067,8154,11071,11799,11069,10640,10641,10642,10643,10644,10639,10645,10646,10752,11252,11251,11461,11493,11228,2677,10647,11922,3874,11432,9590,10563,10923,10140,10147,8308,10924,9435,9436,726,5864,6504,10594,10596,3066,10600,8885,7014,6381,10522,10922,8586,8682,9920,8618,7891,10612,6191,10996,10998,10193,10197,10195,10200,10597,10640,10641,11054,10645,10639,10838,10753,11139,10999,11011,11012,10993,9410,9411,9416,9429,9430,10139,10151,10153,10176,10637,10199,10642,11055,11138,9232,11049,10799,8875,9113,9114,9182,11157,11158,11159,11160,11154,8662,11155,11057,11153,11156,10800,11008,9587,8325,8596,11152,10201,8324,10557,10556,10558,10559,10561,11161,10562,9589,9593,11242,11240,11046,10801,9588,10333,11238,11207,11151,11218,10727,11149,11241,9781,10646,11204,3784,7568,7569,7570,8330,8331,8336,8339,8341,9633,11209,11244,11245,10644,9087,10337,4804,6221,6497,6214,6220,6216,6501,6218,6215,6499,6212,2720,11203,11269,11205,9593,10323,11183,11178,11231,10326,10198,11184,9137,11301,11206,11176,10102,11009,8309,10096,10322,8872,8242,8327,9424,10334,9891,10218,8335,10214,8329,10920,10646,11320,11322,6538,6534,6532,6533,6536,6505,6506,11318,8883,1730,7169,10827,10828,10750,10829,9426,4714,11242,11167,11238,11295,10139,10752,810,1266,10725,10729,10522,11317,10557,9430,9592,9535,9894,10101,10102,10326,11405,11157,10556,11048,3896,3895,3893,3889,3885,3883,8272,6493,3897,3894,533,532,528,527,526,525,551,550,548,542,541,540,3892,3891,6042,553,539,531,524,3890,3888,3887,3884,11296,4510,6381,11430,7986,7987,537,8274,10137,11467,10321,8764,4558,8111,11432,3881,11407,10324,11022,6214,6223,10801,11247,10643,10647,8273,10466,8682,7546,11161,11405,4791,6223,11493,6518,6519,6535,6537,6372,6371,11294,6498,11254,6496,11139,10560,10201,6215,4555,9108,10822,11394,11584,11585,11586,11590,10216,10562,11574,11591,8335,8329,9412,9409,8332,9427,9428,11617,11624,11625,9431,9432,11616,11615,11241,11589,11591,11601,11375,11650,11425,11575,11580,9905,11588,11592,11229,10921,11173,11174,6521,11429,553,551,550,542,541,540,539,537,533,532,531,528,527,526,524,545,543,538,535,529,554,549,547,9520,9521,9587,11321,11611,7546,11493,1768,1769,9880,1766,9920,11427,11697,8294,10321,3066,8294,6212,6501,6496,6214,6221,8883,6223,6222,6216,10216,11054,11156,11154,10639,11723,11618,11677,11759,8340,8334,6042,3883,6456,323,6453,6455,6454,6390,11650,6995,10371,10138,8331,8320,8327,11571,11030,11696,11031,11695,11032,11461,11460,11033,11406,10925,8273,11799,10520,8585,9149,4390,8154,11069,10257,10521,11078,11079,11080,11081,11077,11051,11791,6354,11576,7194,673,11075,10797,3070,3073,10053,10975,10544,11221,11587,9426,8333,11161,10332,10325,11759,8244,8339,8243,9427,11138,8246,10329,11615,10323,10217,11242,10158,11050,11677,9434,5389,10333,8649,9435,10326,10327,10330,10202,10324,8249,8597,8241,10195,10551,8585,8242,10607,10218,10969,10799,10970,11137,11617,11240,8598,11618,8245,10336,7697,7694,7695,11694,7868,10332,11624,7695,11694,3073,10326,10325,6354,8332,3895,3896,3888,3887,8274,3889,3893,3885,8273,6493,3897,3891,8272,3883,3894,3884,8946,10327,10328,10329,10330,10331,10323,8248,10333,10606,9119,8585,9908,10194,8882,8290,8339,9588,9587,8330,9430,9429,8682,11722,11242,11677,8586,8618,9407,9920,9589,10200,10199,10801,11160,10557,11617,11615,11759,11618,10214,10215,10158,10096,10137,10138,10099,11156,11625,8314,11139,11151,11934,11154,9409,10562,10103,10100,10556,10559,11932,11933,11153,10101,9593,10102,10139,11406,8324,9427,9428,9891,10153,10195,10197,510,7772,7770,7771,511,512,512,7637,10558,9894,9410,8241,10332,10325,10326,10327,10725,10329,10328,10330,10331,10333,8329,11241,11407,9592,11046,9593) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC