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,10257,6695,10878,10865,10314,8514,2447,2753,8135,9533,4218,8305,6780,3549,2388,5334,8955,8019,5582,265,744,3850,2331,4964,4563,4164,4706,239,8995,9300,8628,8097,9647,5729,9864,9838,9897,9900,567,7634,576,7635,9381,10017,10041,10092,9617,10094,1912,2328,1029,1516,2052,5420,10141,6831,6899,1770,2117,1771,1766,6177,4535,9389,9387,6849,4125,9193,9235,10297,4563,10148,9914,4405,5917,9986,5305,933,2261,7299,9105,4947,3522,9126,8706,8560,10259,10535,8019,111,7822,9164,9065,10781,10236,4395,10021,8182,10877,10658,10974,464,10937,9164,9065,10956,4801,3261,1092,5839,9941,10922,10912,10923,8964,6197,9534,8003,6332,8278,10727,10563,10559,9231,10646,10812,9892,10044,10426,10487,6212,7843,10417,10489,7844,7845,3890,10545,10389,7196,384,10381,6443,10520,8579,10040,6517,6216,8242,10925,7704,10923,10729,10560,10199,10558,10557,10200,3894,3957,1764,8882,11080,4302,8274,8250,11091,4512,2555,8696,1086,4316,5003,10318,2039,4774,9386,2998,10486,6535,9493,11153,7299,10045,6143,10935,9903,10828,4827,5208,4645,9418,6986,10513,11106,10820,11198,11246,11067,11219,11230,10483,10924,11068,11071,8827,11069,11254,11296,11270,10921,11238,10931,11109,11306,6648,10930,6423,10642,4299,9591,11048,9888,2605,10923,10922,8002,10644,10561,7762,4293,11156,4287,11317,8596,7676,10201,11320,10645,11321,11158,6521,10562,10647,10643,7987,3070,6354,11008,9535,6689,3892,3071,3073,2643,10937,11324,11152,9147,11432,11467,11479,4146,10426,10331,10333,10158,10326,10324,10555,10335,10336,8591,6359,10725,10729,6510,6508,6509,6507,10519,9493,6532,6533,8899,11055,7189,11015,7185,6654,8897,11013,4386,7187,7184,11016,10278,10924,10920,6200,10925,2605,9909,7845,7844,10922,11037,7764,7843,7568,7570,7569,7764,4804,7567,9632,9633,6511,6515,11138,11139,8662,9232,2789,9536,2799,2816,4473,7165,2806,2824,7173,7174,4470,4486,7166,7168,7169,7167,10213,4463,4464,7163,7164,7170,11030,11031,10251,10254,9907,11032,9906,10043,10253,10256,11033,9592,11032,10255,9907,9970,10251,8246,8247,8241,10606,8245,1765,1770,11203,11204,11205,11207,11208,11209,1765,1771,1767,1769,11206,11208,10463,7870,5635,7604,5657,8883,4486,4463,4464,8662,7165,7169,11255,7168,11251,11252,11176,11186,3070,6354,11177,11175,3071,3073,6689,6688,11109,10232,9383,9867,7676,10931,10930,7600,10157,10155,10154,8432,9670,10156,9669,9670,9672,11178,11231,11229,11414,9665,10877,9720,10956,8717,8719,6730,11374,10827,2605,4390,10545,9137,10827,9951,7998,10895,10273,1769,10894,6010,2594,5799,8893,6983,10745,10569,11028,8900,5142,5373,9225,9338,7715,4234,8063,9082,9362,8644,3884,7121,8615,6134,8412,9264,7280,9398,2677,7984,7932,8306,8423,9662,9382,7661,7759,9658,9464,7662,9148,9659,5179,9844,7108,4947,7023,1533,3493,9563,1461,2995,2417,7986,4046,4769,10076,3863,8891,6781,8449,10026,10051,9220,10212,10077,10126,9821,2644,2455,10025,5454,10185,6209,3875,10270,6986,1370,7280,10275,10273,4906,956,7149,9444,10436,10063,9787,10506,9325,10149,10314,8782,9543,10523,9741,450,9533,10271,10578,9822,9747,180,4724,8972,8762,10768,9492,3891,1370,10767,7985,4762,10257,10890,8071,10854,9373,10882,9993,10888,10302,10881,8783,6102,10554,9608,6876,10887,7251,10190,3863,10789,10702,11130,9793,10078,10938,5251,8743,10965,10991,11025,11027,11188,11224,5331,11212,11268,11189,4778,11278,11196,11281,10670,10701,11038,11262,11329,11187,11337,5454,11108,11376,9795,10274,10412,10187,11402,11336,7913,8474,11215,10862,11455,9199,8423,11228,11524,9417,9308,11331,10839,4645,7261,7792,4791,10615,11449,10072,11511,4355,11633,8721,11302,7986,9817,9481,11628,11484,11700,9993,11038,9649,8366,7363,7094,11117,10818,11629,11760,4401,11797,3883,11758,11444,10891,11776,1371,2677,10360,11553,5331,11793,11327,2658,11105,11763,11101,9398,6904,721,11712,9554,585,8460,10716,10481,11743,2989,8388,11794,1198,8260,11957,11755,223,11622,173,11626,11801,3564,11884,11771,2894,11312,11915,11034,6367,10617,947,9910,10128,9941,10148,972,10063,10116,10283,10227,231,10284,10039,10188,6700,8139,10303,10319,10268,10473,4023,9406,10306,10526,10548,2841,10547,10569,5175,9031,10362,10268,10368,9900,10002,10499,10528,10048,9832,9945,10543,10021,9126,10735,10375,10665,10208,10266,9212,4234,10290,10935,2639,10938,10541,10990,10723,10289,10919,10783,10653,10912,10895,10116,10904,10880,10871,10894,11021,3787,10892,11226,11202,2393,10115,11233,11135,10657,10715,11163,972,10778,1268,11136,10085,11220,2390,10683,11104,11287,11314,10739,11353,10740,1181,11379,11172,9922,3482,10663,9249,11201,7869,10627,11324,11443,11377,11361,10653,11439,10130,11442,11388,11474,10893,4217,4527,9629,9354,9630,9939,11213,9235,5692,10085,10879,11285,4652,9666,10341,10864,766,2632,5179,2932,10548,10938,10284,9085,10782,9925,11219,11114,1145,9749,947,9699,8681,11379,9710,11314,9709,9116,9691,9473,10868,10107,9716,9707,9696,6731,11340,11442,11398,10367,9958,28,11228,9418,10904,10278,10892,57,9900,4178,30,9475,956,9655,1425,9675,2451,1741,9713,1210,2725,9473,5430,5251,11491,1198,1370,10368,11423,11476,7554,7754,10472,11446,501,9969,11266,11342,2995,4872,11371,7592,10240,4690,11598,11621,311,11456,8279,5255,10679,9963,10910,11661,2753,2253,4519,11476,11663,4519,8547,11551,11436,11413,9931,217,11620,11772,11773,9919,7910,10697,10724,11166,11719,9647,11657,4774,10673,4639,8358,8822,11847,10715,11769,9843,9872,9033,2052,10892,11825,3282,11382,11669,11383,11661,10832,11725,11293,10832,10714,3646,10364,11842,11348,11834,11620,4395,5997,8780,10978,11480,10091,1917,3698,3241,4099,1298,6832,2458,3595,1559,6779,5088,1498,2261,6248,3550,1257,1215,6560,3702,6588,3037,6732,252,3625,2337,6635,1521,5142,3327,2954,6793,5373,3542,4136,6104,5379,1349,6713,7016,4023,6684,5817,435,766,5339,3159,3437,971,6069,4460,4005,4258,4050,7019,7156,7138,6365,4878,1762,3080,1080,4125,249,752,322,1121,7230,7304,5460,7005,4178,4455,5020,1536,7126,7050,7238,4886,7761,1253,608,1698,4460,5545,7038,7840,6693,7354,7879,5236,2915,3725,7829,1038,7839,2705,7878,7760,7783,1371,6842,4652,7858,7640,361,2635,6663,7920,8031,8089,8094,7992,5349,4199,2387,5070,8095,3701,2294,3162,4218,2590,358,5247,8222,5885,5088,6478,4710,228,5764,2882,4766,5915,8611,1830,4217,2863,6001,7787,6941,6366,8442,4144,8829,6314,6686,2657,8548,4209,5362,6971,8555,6712,8809,2381,8938,9027,4082,9038,8837,7614,1318,8918,8687,36,1127,8910,9030,8947,6117,8901,9079,9195,8999,8902,9186,9052,8543,6981,7550,9220,7615,9086,7883,6642,9200,9248,8500,9346,9348,8805,8935,8800,9363,9321,9353,9453,7582,9372,9386,7758,9213,9402,8919,3165,9468,9335,7221,9558,2698,9471,9606,9541,9602,9377,1277,9552,9607,9638,9615,7856,9634,9554,9654,6858,9406,1699,9769,9668,8514,9825,9600,9800,9455,5484,7910,9454,7017,9374,9922,9116,9308,9221,9835,9945,9952,9964,5222,3302,5210,9986,7830,6824,9834,9814,9212,9937,10021,10018,10019,6113,10002,9910,9884,10001,9928,9896,9900,8933,61,3117,3134,9883,10039,9831,10062,9799,8006,10131,10116,10188,10129,9935,9639,8777,8776,10063,9258,239,9347,9352,8923,10173,10115,10057,10048,6010,10148,10245,9730,9951,10047,9942,9387,773,5692,5743,10243,10046,9879,10288,10283,10227,10130,10505,10284,10374,10528,10548,10373,10526,10376,10368,10375,10469,10674,10556,10394,10725,9593,10201,9591,10139,10562,9983,10199,11020,10938,9589,9587,10559,11028,9833,10892,10518,9407,10871,9588,10268,9430,11135,10894,10727,10472,11156,11021,11122,9832,11104,10750,11136,11154,11139,11220,11218,11154,1699,10225,10649,7599,10211,10738,9389,10956,11010,6845,11314,11324,10830,10266,11018,10289,11287,11288,11126,8586,11233,11406,11360,11379,11299,8390,10719,9814,11340,10463,11361,10565,11353,1537,11442,10526,10904,2992,11437,11378,10895,9193,11396,11382,10879,2506,11304,173,11351,11455,11493,3521,11409,10893,177,178,179,10314,11443,11495,11489,11522,11552,11598,9950,11599,11093,11377,11606,11480,11608,11342,11523,11600,11655,11658,11646,11285,11661,11620,11656,11453,10892,11722,11678,11691,11479,11289,9244,11681,11670,11201,9339,9381,11383,11491,10188,11621,11724,11488,11786,11785,11373,11107,11455,11764,11770,6704,93,10731,10721,11602,1969,11775,11202,11441,11851,9601,11848,11408,11784,11854,11828,11850,10798,7807,11363,9538,11872,9544,11964,11900,11899,11860,11965,11905,5334,3549,11272,9558,11228,8010,11353,1234,1210,1207,1198,1145,1056,956,947,923,57,28,3014,2995,2776,2725,2736,2677,2451,1741,1533,1425,1398,1370,9675,173,9418,4731,4519,3564,4600,4602,4603,4599,10454,10447,3189,10448,1616,566,466,9533,11655,11646,11719,11724,10278,11691,11741,9148,11645,11187,11509,11681,11647,30,24,10689,11785,11361,11703,11783,11787,11842,5193,11718,10904,10964,6874,11018,11834,11838,8955,8305,6780,4708,5334,8019,10892,4765,3549,9647,11906,11822,11287,1698,9928,10719,9922,11599,11900,11869,11871,11982,8172,9492,11845,11874,11921,9665,10868,9907,10314,10053,10544,10975,11221,8816,4325,8780,8520,529,532,9949,526,11485,11184,11375,7972,5961,11195,10236,8760,7219,11519,9863,8220,8983,8981,6743,3883,10222,1730,9165,9601,3898,9534,8982,6742,10167,6744,6746,6749,979,6359,7599,6768,5386,8879,9217,6750,390,8241,8334,10334,10336,10335,9920,10238,10194,10200,10263,8877,382,8330,8320,8339,8337,9891,9908,9113,10202,9111,8242,8873,8872,8649,10152,9112,9120,9431,8318,9114,9119,8326,8310,8247,8313,8309,8308,9633,5691,1685,5386,6195,1765,10546,10545,7845,9633,9903,9905,6533,2605,5386,1769,8824,10546,9909,9137,8824,1685,5784,10522,9137,9149,1770,8917,1771,1765,10925,8824,8489,7869,1967,9031,5770,4714,10645,10646,10750,11167,10925,10922,9985,10466,8592,5810,390,8784,8788,8881,10613,11051,11248,11247,8882,7134,7877,2071,9303,9350,2506,11239,4714,11022,375,8787,372,376,368,381,6066,387,8858,385,380,393,375,391,386,6082,378,8784,394,6270,8880,392,365,8878,8786,8789,10896,11088,11327,11329,11182,11231,11249,6375,11178,6271,6076,379,6537,11173,11176,11175,5332,1411,810,10521,11183,10827,1266,6535,11229,11174,11186,11252,11185,10921,11238,11519,11295,11296,6505,11318,11294,11239,11254,11301,11251,11585,11571,4923,10731,6600,11085,11665,4520,11666,11667,11085,8175,10278,7922,6354,6503,6523,11425,5383,11429,11085,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,9425,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,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,7055,10387,10381,10390,10390,10386,10386,10488,6762,6916,6752,6759,6754,6760,6761,6928,6918,7162,323,11003,8696,8693,8656,4305,4299,9483,4299,9483,4292,4293,10920,57,7953,10725,9590,11161,10199,9829,9533,9675,1052,450,8648,5821,4178,9418,9771,9277,3428,4901,7989,9676,207,28,57,173,923,956,8763,7773,9378,947,1207,10814,1095,2913,1370,10454,10229,233,1520,3059,10278,9661,9993,130,9207,11516,11324,11679,10938,11219,11455,4395,11669,1198,1210,1234,958,2736,2451,2995,1425,3595,311,466,5602,3646,9546,4778,10548,7777,11228,11621,566,11352,11812,272,9554,421,10091,3875,5454,8668,11361,5193,11785,435,6326,8967,11468,11620,9892,9149,6596,11150,3359,8205,8582,10858,7283,3895,8366,10947,8782,10948,4390,186,6768,1411,7024,7280,535,3896,3887,810,10944,9885,9601,8204,3894,1303,10829,3897,3885,3881,10000,10943,9959,9076,7155,7704,8201,11108,7986,8451,51,3085,7245,10827,4639,8712,7753,8228,8240,7752,10077,7147,7572,3070,7589,11225,11063,8272,6688,9095,10053,104,9095,10053,104,9579,11514,8640,10615,10008,8211,9867,10272,10232,10675,7172,10975,4659,11221,9222,9223,8812,9251,8812,9224,10887,7080,7088,10976,7600,11228,10278,9968,3908,11631,10930,9741,8971,6740,7153,11836,11762,7933,7238,9007,11707,7661,6629,1381,9255,8220,11628,10926,9817,7280) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC