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,863,5719,397,714,6798,6390,713,6381,377,3036,6082,386,392,6381,3841,382,323,4906,388,372,374,2701,2474,7238,3860,378,4199,6740,3933,6809,7833,8215,7903,1984,5995,4878,101,222,5419,6011,1537,6362,550,6158,6774,6154,6559,5882,6691,5995,2709,6746,6743,7159,6177,6983,801,5175,969,7938,6381,7756,7659,4390,8231,6926,1886,7546,8584,6008,8681,8698,6933,8817,8910,8156,8514,573,551,3893,3889,1766,6444,512,3896,6381,6509,6377,6539,6544,6371,6545,6540,6388,6546,6538,6382,6372,6743,6534,6375,6535,6517,6533,6537,6515,6523,6510,6386,6527,6198,6520,6521,6212,6218,6220,6201,6200,6511,6508,6223,6221,240,6512,6199,7297,3874,7151,7151,3891,3891,1537,3892,547,547,3889,8272,3897,8272,3890,3884,3883,3883,6390,7094,7766,3891,1886,6382,3896,3885,3897,3890,3889,3895,3888,8971,3894,3882,3881,3883,8306,4535,2467,4834,8780,3131,8169,4131,8514,7903,182,2989,182,2522,5484,6117,7146,7615,7121,8910,9245,1402,9406,9116,7920,9431,9734,6744,9178,9408,8246,8244,8087,8067,9225,7704,6416,6612,9734,9178,9501,9806,4286,4289,4304,4298,4299,4287,4292,4302,4296,4305,7311,7610,4297,7083,7697,7695,7696,7868,7694,2951,3442,11184,11149,11183,11181,11252,11174,5297,11182,10920,1704,11037,11179,11178,11231,11173,11175,11251,11185,11229,11177,11176,11186,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,10431,7192,7190,10213,10222,10162,10725,9892,6385,7715,7014,6382,7040,2287,6933,9591,8665,10238,9903,10565,10044,2605,4178,6519,10561,5995,10043,526,531,542,524,1557,6385,8820,8007,549,11301,11269,11247,11254,11022,735,11568,11650,11317,11318,10922,7083,550,547,11665,11791,11427,6527,10176,11051,11194,11244,11601,5383,3070,6354,10925,10923,810,10827,540,532,8788,394,8786,8858,6270,375,390,6076,548,6066,537,541,8880,8878,7693,11467,11611,8784,8787,391,6836,11081,11079,11080,11878,11877,11602,4282,11296,11075,11876,11077,392,538,11903,11078,6076,10921,11173,11174,9523,11183,11667,10643,11936,11935,11939,9483,4299,4305,11980,9610,11825,7610,5691,7311,7697,7695,7694,7868,3442,7696,11695,1704,11694,3515,11696,11697,11576,11574,7608,5297,10522,7844,11176,7845,11252) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC