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,6743,9088,8984,9176,9089,6377,6367,5269,9087,6386,9174,8857,3926,860,9233,8788,8899,863,8987,7194,9137,9172,8982,4178,4340,5763,6703,752,3457,4023,6809,585,3908,5764,6740,6104,3913,4950,3474,504,7238,3715,1016,3368,3933,7937,7903,8220,4337,4901,4901,6821,8306,8306,8306,6151,8228,6750,6521,6521,6521,3612,7614,7614,7705,7199,7195,9165,7162,7198,653,3875,7196,7191,7194,8988,6385,8984,9592,2520,7199,6925,7200,9087,6926,6931,3277,6386,8986,9172,9885,7199,9177,8986,10044,9175,7196,10045,6931,7192,6936,6935,6740,6191,6931,6928,6938,9089,6936,653,6388,8387,9733,7703,6271,9734,6414,8349,9932,9735,6517,9850,6375,9852,6989,9729,9811,6234,6191,6531,8523,6519,2720,6372,726,6396,6966,6995,6376,9408,8244,6518,7196,9165,6371,7200,9909,9903,7845,6968,6604,9520,10194,6383,10201,9905,10218,10264,9734,6937,6934,6423,6359,1616,979,8824,9892,6422,6519,6768,1266,7808,5297,1165,1411,810,2720,6518,5864,9149,10045,9165,9500,10044,6372,9432,1967,4714,9120,9119,6656,10336,10332,3625,10323,6146,1730,8243,10324,8341,9175,6151,7191,7610,10115,3542,1521,7610,7311,6371,5691,7697,7694,9499,10419,10431,6989,7567,6271,7569,10330,10426,7614,9904,9220,10244,7985,10323,3885,3884,3893,3897,6493,3894,7695,10325,9592,10147,7696,10327,6740,24,9593,10333,6519,6372,7868,10645,6518,6371,10642,3442,6517,10103,10647,10328,10330,3515,4282,10563,6234,6375,7238,10637,10728,1704,10726,7608,8881,7693,6989,7079,7111,7294,7124,2706,1398,7270,3891,3892,7295,7291,4178,7082,3884,446,7281,7666,5066,7286,8205,8085,8078,1257,1215,5995,7154,1656,8438,7548,8223,8306,8208,3895,3888,3894,7987,7986,7967,8390,4639,223,223,8412,7985,7160,7967,8358,6740,7238,8220,2117,2117,4701,4801,8409,5602,5602,7251,8204,7089,7076,3884,8547,1371,7243,7971,7249,7702,8164,8166,8167,9735,9176,9165,9300,9745,9873,9874,9030,7897,9875,9744,6382,9876,8654,8989,7198,7195,7199,9877,7162,9878,9879,8451,10056,10056,10056,10056,6763,7194,7194,9172,10026,9302,10264,10272,9581,9132,9133,9619,9620,7196,10185,8208,8656,9748,9622,9621,9746,9747,10887,9177,10390,10421,10419,11059,10881,10833,8267,7245,6388,10947,8469,8470,7671,11187,7268,10051,10575,10575,7665,7703,8585,10891,8468,10888,9378,8413,8383,11713,11587,9738,9259,10623,10630,10384,6919,7680,6926,6754,6759,6925,6762,10045,6926,6988,860,3277,6919,7199,10371,857,9735,10432,9735,10432,1526,6234,9781,10263,6914,10335,10194,9500,10334,10333,10557,7211,10551,6938,6937,6937,6898,272,8820,6388,7311,7610,6600,6416,7922,8944,7881,9679,10232,6416,9383,10427,9867,6386,10232,10431,8566,6377,545,3887,537,7703,14,6200,7166,9902,8885,8693,8732,726,810,10613,10386,9172,10387,10098,9734,10420,9905,9735,10638,10383,9601,10429,9909,9087,10643,8011,10645,8696,8232,10432,10644,10640,365,1411,4614,10421,10637,10334,2701,6332,10389,10433,9733,10520,10443,6381,6380,10431,7192,10213,10222,10162,10725,9892,6385,7715,7014,6382,7040,2287,6933,9591,8665,10238,9903,10565,10044,2605,4178,6519,10561,5995,10043,6759,6762,10649,10417,10487,10488,10813,6754,860,10431,10390,10388,6761,6760,10382,10387,10386,857,6913,7162,6840,6926,6925,9735,10445,6381,6391,6914,6763,6915,9165,8693,8156,8267,7200,7199,7196,7198,7194,10996,10797,7195,6917,6988,6922,8267,10599,10600,10598,9087,10505,11077,10445,11078,11079,6935,11080,10603,11075,6916,6933,6936,11077,3277,6928,6929,6934,7191,7192,6937,6918,6385,673,9178,10597,10593,6421,6423,6920,7042,6424,6425,11103,6426,10486,7055,10389,10426,10428,10381,10957,10222,10264,10421,9176,9177,9190,10167,10384,10420,10423,10425,8987,6491,6417,6517) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC