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,9049,7217,7217,11168,11168,10810,10810,8292,10940,11121,6740,10844,7592,11025,2253,10940,10305,4424,9765,10212,11216,8257,4512,6953,9900,6971,9879,9879,8781,9949,8877,8878,9755,8200,8880,8880,7898,9537,9885,7304,9853,9890,1770,1770,10526,10526,8880,6845,6845,3029,6845,7297,6845,7297,7897,8498,7897,8498,10615,10614,10615,10614,8882,8371,8882,8371,10898,10579,9797,10858,10346,10346,8628,10907,8628,10907,10956,8115,3949,11216,10840,8191,3890,7987,7808,11209,5297,8682,3896,8255,11307,10646,9129,3358,8244,6688,11322,8897,10520,11049,7176,8874,11013,8618,11015,7632,11432,11414,11463,9865,10932,10984,11204,11147,10326,11205,5635,11418,9524,9863,8963,10758,3327,3327,6368,11099,10687,10631,8622,2567,10063,892,6801,10060,10060,10060,10060,130,10240,10227,10649,10940,4079,4079,3957,6586,11323,1380,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,10823,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,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,7159,5098,1974,1726,4923,9856,1307,9488,10301,8650,8130,10316,8130,10316,226,4923,11101,11101,11497,10579,5435,10731,5435,10731,10874,11292,10372,10687,7708,11400,11444,10984,11489,9951,6822,10966,5435,9418,10892,10984,11485,10932,6242,11285,11342,7976,11455,10141,11477,9950,11328,11101,10731,10343,10278,947,1207,7641,9655,10505,9533,11289,10566,8169,11272,10687,4779,11226,6004,4574,8109,2342,11303,9389,10909,10339,11900,11363,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,3830,6197,3989,4580,275,4860,1165,4234,3860,5535,726,393,2882,2160,4730,6154,1537,4131,5996,6545,1137,543,397,6138,6040,6559,4023,725,6686,6679,6197,7879,7840,7143,7878,8220,5764,7903,8183,3784,3263,215,8222,6750,7998,7638,5995,3761,2467,419,6981,1506,501,2706,8306,3059,971,1215,4178,1257,7833,3134,3368,8542,8616,8488,7840,7879,7878,4259,8529,8306,5143,466,252,6204,6539,7631,7870,7582,4136,3542,8434,4788,7896,8611,8615,3413,2261,7641,7837,7615,7903,7834,9144,8983,6713,9300,8842,9130,7910,9547,6023,10119,9220,9807,10548,10244,9752,9770,10523,10526,9924,10300,36,10688,11733,11346,10569,10892,10734,9811,10674,11325,9831,11380,11101,10687,11749,11311,11707,11497,11283,11346,11709,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,1645,6152,6151,1520,6654,4355,800,5321,1770,5995,1768,1524,1766,5542,1769,1771,1970,6691,6718,6985,1662,737,5148,6175,7262,1767,6721,508,1771,1769,2706,7270,1133,1770,1257,5454,6204,6104,7209,272,4230,7107,7083,2023,6593,1685,1327,6689,7881,186,1073,1215,3071,6315,7671,1173,6586,5927,8088,7753,7881,6546,501,322,6858,810,979,3989,4796,5732,1173,6743,3719,3559,6315,8193,507,1351,3115,7771,3385,7213,1173,8688,4227,3881,7104,8111,7585,8436,8627,7238,8548,8220,8175,7637,8168,8687,8885,446,8440,8765,8834,512,8831,8900,8963,7837,9037,8951,1768,9136,800,8828,9136,8946,1257,8306,1215,3989,8578,9096,5995,9052,7301,7736,4130,9245,8250,9300,2122,9365,9278,9308,9382,8704,9455,8175,9439,2701,6778,7636,9308,9474,9615,1245,1532,9636,9602,8904,9623,9323,9196,8899,8946,9679,9648,8543,9347,9634,6857,9961,7581,6117,9930,9627,9195,9543,6646,10118,1108,10212,9554,6874,10149,10172,107,9867,8897,9760,10232,9665,9342,9049,9383,8728,10000,10272,10554,10342,8615,10523,9221,4337,8173,24,585,10053,9453,10476,10878,10375,10664,10893,10940,10870,11024,254,11028,10836,10292,4558,2811,30,11142,10671,8893,8132,11122,6595,11220,10672,3933,11105,6646,11021,8171,10784,6616,11302,11253,11402,11423,4437,10291,1080,4136,9929,5922,11361,7975,11142,9949,11263,3493,9865,10258,11473,9455,10464,11548,10248,10730,314,11491,8762,11423,11550,10650,5923,9866,11399,11042,11283,11690,11404,11097,26,7159,11645,11739,11678,11328,11764,11701,11118,11721,5534,11644,9603,10798,10784,783,11724,9513,11074,11816,10010,11123,10554,11824,7215,9541,11869,314,11267,11725,7854,10370,9649,9648,11751,9524,11870,2009,7273,7291,10185,10510,7289,9138,8794,7543,7400,7419,7472,7541,8868,7491,7563,7390,7449,9853,9025,7290,11201,11477,11479,11480,11476,1624,820,6801,10677,10817,6803,10985,2538,11053,10707,11380,3105,3108,7383,7409,7408,7406) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC