thisMySQL 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,446,947,6659,4598,1533,4087,4731,2451,4519,3803,4872,4645,3872,5331,223,5251,4690,1181,1121,4125,6669,4931,5576,6568,1351,743,4598,3048,4599,6792,5629,5175,2246,1586,1196,4599,6858,6947,5266,739,7138,6708,5636,1487,504,834,2841,6732,5215,1196,405,360,573,529,546,547,7138,545,7883,2933,608,2294,3080,1347,1766,2727,6656,3402,4834,5551,2685,986,231,1730,6145,6146,4614,6311,1398,5756,6214,6497,6489,5093,6223,6496,1234,946,6212,5947,3302,2776,6261,3479,6214,1741,2677,6221,6501,6212,8000,6496,1245,2696,8023,7638,8233,7304,3904,8485,8220,1645,8628,8306,8783,8933,8361,3287,9030,9153,9152,7117,446,7117,4079,4796,7548,9600,8933,7155,7107,9750,7917,446,9849,9206,7985,9264,10039,8648,7080,10265,10556,8910,11291,8062,1988,11236,11812,1173,11497,10591,11497,8995,9838,11690,11736,9647,11656,11770,11714,11905,11782,3549,1145,6632,7580,6023,2677,7760,388,4563,7815,6986,2776,7599,272,6642,7605,637,7751,947,6871,6315,3803,7759,7972,7938,7354,4519,4558,7973,7837,1234,7834,7835,5143,7836,5142,5251,8089,3066,8140,5936,8150,8111,5094,7920,4731,6713,8215,6691,8222,8193,5431,5536,8304,6810,7016,5817,1349,7005,2451,5947,4325,8390,7642,7105,3026,8281,840,8358,6732,8547,7246,8514,320,6693,8305,3913,8548,1738,5763,6354,8816,6595,5334,8802,8213,6726,4652,665,8730,8839,6778,8910,4730,8885,7903,8629,8220,8932,4936,9049,3542,4944,1886,36,4945,4941,7126,4940,4943,1521,4942,3775,4460,4939,4938,3449,1176,9300,8478,5841,180,1177,2657,9466,4950,3080,1042,7772,510,7770,7771,511,512,7637,7592,7755,7756,7927,8509,9880,8999,7019,8222,8793,9195,9925,9552,177,178,179,10229,10292,10056,9461,10063,10227,9769,10528,10526,10548,10543,9406,10358,5756,6659,9533,9675,9879,10964,10836,9383,4834,9867,10232,10278,10938,254,9220,8904,11121,10626,9677,7928,8688,9196,8547,9636,11171,10397,10315,11219,6857,11439,11361,11324,11455,10748,9929,11397,10476,10149,10784,11396,7581,6117,9347,6731,9648,4536,2873,11374,6730,4329,6692,3803,6809,548,1741,6845,6223,546,6042,6496,5763,540,3094,7616,1917,7751,2729,3878,5228,5246,5328,4103,6397,3872,2451,6218,543,1764,7987,7903,7972,7973,2677,1145,8117,8140,7833,1126,5143,2776,28,1398,923,1234,4872,5089,5094,1520,8222,7861,5112,1207,956,3392,6901,2915,6902,7047,6902,3048,537,539,8306,7986,6124,4144,7208,4785,5459,5430,28,947,7776,906,466,1370,1741,7029,7047,7047,1318,645,423,1092,8252,532,1600,8888,4855,4855,9017,545,7047,8542,5914,6034,7829,7029,7029,9021,7592,3878,7681,7681,6552,9554,9547,9547,9007,9007,9614,9777,9254,7710,9675,9880,6222,6499,6214,6220,6218,6215,6501,6216,6498,6497,6223,6212,9965,9254,10265,532,9648,10258,10212,10212,57,28,9487,10610,10610,11089,10622,11089,10622,1207,28,7856,7834,4985,2995,3048,3392,3392,4029,5251,958,1461,6315,176,7899,947,2447,1533,956,8251,5732,8063,2677,1198,1126,5877,3872,2776,1398,4432,5143,3564,4645,6659,4690,1145,4788,1917,566,7970,8000,179,8793,4701,361,3131,5094,1741,9195,3014,2451,310,3803,4791,4791,4872,5513,1237,9243,8927,2331,9489,9780,167,5431,4617,9325,7803,341,7784,3418,3447,6853,2653,2671,3417,1568,1647,4126,6171,3437,5692,5743,2334,361,6515,4316,4701,3159,8761,7928,8290,8304,8845,8818,4936,4944,7761,8706,3760,4765,1370,1126,4411,6310,231,243,946,2469,836,7859,1127,7864,7034,944,1228,1297,1416,6942,1522,7712,1577,7031,1869,1893,2446,2087,2451,2454,2456,2571,2995,3014,3059,3201,6659,3778,3843,3303,3803,4092,4029,8894,4219,1313,6838,4690,4785,4791,5756,1533,5251,9676,9557,9325,7981,9526,10080,7909,1823,3856,10061,10081,7807,8737,8175,8206,4770,9503,2032,9968,4230,1487,7150,10270,3511,3564,104,10275,9547,3896,10274,8767,8467,10008,10965,8063,10271,7297,8641,7298,8712,8046,9203,10789,8394,7262,10356,10449,8205,8468,8202,11553,11634,9095,11038,11683,11362,9782,10768,11228,8010,11353,1234,1210,1207,1198,1145,1056,956,947,923,57,28,10823,3014,2995,2776,2725,2736,2677,2451,1741,1533,1425,1398,1370,9675,173,9418,4731,4519,3564,4600,4602,4603,4599,10454,10447,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,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,10823,566,173,28,11228,1370,1210,1207,956,1056,466,3872,2451,1741,923,57,1533,3392,1234,1145,2725,1398,2736,9675,1198,2776,1425,9533,2677,2995,3014,4762,4784,4785,173,5089,4788,4690,8894,5756,5112,5143,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC