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,9889,10940,10039,10649,11395,11412,10670,11399,9863,11412,10670,11399,9863,8139,10296,7026,7388,7388,7388,10235,6925,6926,6922,4227,3840,9899,653,10339,4419,10169,11284,11299,6935,858,11238,4226,857,8389,9767,3327,8596,9488,11308,8860,6438,11329,3863,3913,9951,10228,10228,10844,10844,6715,10670,10844,10670,10844,5435,7592,5435,7592,3327,9863,3327,9863,3913,659,6774,10179,10179,10179,10179,10234,9248,4399,10836,961,4784,11329,7910,11497,10937,10687,9393,9300,10579,11101,2749,5567,450,11497,10228,3863,9865,10836,10477,9488,173,11306,9359,10669,9849,5769,10339,11710,6646,10687,10687,3744,228,2677,6691,2677,5088,3904,4082,6696,1347,3080,6774,5817,2294,6633,6858,6863,6693,1299,4724,6793,6821,3612,6809,2262,739,608,6845,6104,6006,3115,4432,4566,320,3701,3719,7592,4652,1699,1349,4778,2451,1073,2841,7839,4460,6732,6209,4258,7946,7081,7265,7268,7971,8058,7069,4029,7154,8211,8044,8058,7244,8288,8429,8361,8078,7080,8403,8209,7294,8713,8400,3066,8469,6650,8207,8402,8468,5947,8839,8772,186,8195,8284,8876,5936,8281,7913,931,7884,801,659,3647,5545,971,9249,5961,9141,6069,7718,8468,8408,1163,9560,9743,5956,9458,9480,2329,1906,9028,8460,5460,9875,4710,9874,9648,9876,9877,9878,8445,9648,8446,10275,10270,9132,9133,9619,9620,9621,9622,10575,10078,9748,9793,9746,9747,10292,7671,10947,10948,9609,9611,9608,10687,7262,9610,7241,7672,9878,11062,10965,10943,10906,10881,11187,10506,11045,11096,11059,10941,10891,10026,11262,10879,8573,10888,11018,11370,11275,9205,11277,9794,9756,7077,9675,11332,11337,8397,10676,11369,11469,11539,11542,10678,11266,4227,4226,10703,10449,10854,11553,11614,11675,9877,11627,8740,8568,8424,10332,11252,11695,10325,11319,11696,9624,7172,9232,3559,7165,7170,7163,7171,7169,7164,7174,7173,7168,3115,11255,8228,8577,9554,4463,7166,7167,7677,4473,4470,8662,4464,4486,7070,2823,6443,1741,4645,9892,8712,11527,9509,8946,6688,9867,9383,11836,11516,10427,10963,11674,3359,11889,2780,2786,2781,2778,10789,10930,10931,10232,10926,10927,10928,11067,11068,11878,5134,3287,10543,11697,11981,8945,11576,11574,11694,11723,11355,6768,11877,9625,9626,11575,6506,11354,6533,6532,6535,6505,11355,6538,10940,11399,10687,10987,6561,1145,11216,5175,11328,11298,10731,5484,10872,11324,11497,11101,10788,8686,11461,6715,7976,11497,7976,11497,11602,11519,11497,11101,10940,9865,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,11215,11400,11298,8191,1296,10731,6367,9946,7048,4769,7374,11497,1358,1359,11880,1983,9830,6952,6433,4985,51,8947,11714,6548,5567,9863,6396,1084,1086,1085,1604,5495,714,5495,2729,1609,987,7132,5185,6533,990,4346,7020,7636,6589,7636,6750,2018,7580,4563,7972,7973,6201,3380,6098,8098,8093,7273,8302,7639,2006,6843,6445,3521,7105,8199,8047,7895,8413,8514,9055,9132,3647,9206,8475,3169,9195,4796,8224,9900,9935,9879,9630,9945,2736,10547,10026,1993,10765,7976,10881,8053,7152,9134,9204,11798,11609,10466,11497,9019,1770,8272,10673,9300,8306,8306,5567,4178,223,8436,5435,3913,10526,1993,10940,9865,10228,7849,6715,11885,10579,11519,7917,3913,11752,2261,10169,5995,11813) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC