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,7112,2085,4752,4769,7241,7674,7125,7110,7117,7574,389,4801,7073,1250,8053,7671,8240,7152,8033,7895,7895,8047,7656,1084,8514,7250,382,8739,7483,7106,8794,8638,7243,8282,8863,8863,4068,376,9054,8240,7671,9055,9132,9134,9134,9134,8412,9259,9733,7654,7151,8475,7657,7272,8046,8062,9049,7671,7671,7671,8450,9315,8111,9623,9623,9623,7287,7090,7068,7108,7971,7072,7247,7946,7946,7107,7294,3036,8044,8049,7906,7282,7282,8086,7279,8081,7662,7269,7939,7074,4983,8220,7940,8371,8371,8086,7077,8206,8206,7931,7241,8076,8547,7087,8055,7116,8077,7656,7280,8066,8770,8358,8832,8386,8053,7675,9161,7267,8358,8087,9031,7087,8398,553,8770,7125,6130,7086,7124,9293,9793,10075,7111,7122,7931,7107,7094,7124,7124,6740,8739,7087,7087,9660,9574,8739,7656,9083,7657,10409,10475,10475,10074,10591,10588,10592,10774,10691,10609,10692,10889,10694,7100,8439,7068,6613,8568,8459,8740,8406,8080,8060,8061,8400,8060,7116,7666,9084,7979,6689,8283,9082,8283,9142,8055,7286,7123,8431,7106,8041,3073,3071,6689,7753,8088,7079,3885,3890,7109,7279,7261,7261,7261,7261,9594,8425,9057,9508,8462,8928,8081,9286,9995,9441,9560,10449,9082,8444,7113,8459,9998,8794,8438,8207,9370,10030,8740,8424,9530,8468,8427,10007,8086,7080,8063,8426,8720,7574,8205,10888,10041,10031,9963,10021,10060,9963,4405,9968,308,10072,9988,9978,10061,9941,10056,10125,10121,10125,10183,10182,10163,9652,6348,9917,9917,10220,9967,9918,8214,10228,10261,10111,9307,10269,9967,10129,10267,10412,10113,10362,9701,10114,10312,10512,10313,6889,9835,10550,10538,10527,10547,8290,10553,10240,10003,10541,10182,10674,10667,10649,10650,10566,10723,9448,10656,10741,10668,9979,10814,7774,10820,10480,10785,8515,9790,10935,10910,10786,10934,10938,10679,10905,6809,10976,10679,10905,10976,10679,11026,11027,9465,10303,11026,10673,9872,11090,7602,8268,11094,11089,5688,11103,9093,10000,6769,11129,11127,10518,11121,11090,7970,10048,9336,11120,10229,11136,11200,11199,11222,11217,2913,10979,4254,10314,10778,11271,11169,11266,11280,11282,10184,11315,3647,11201,11338,11352,11324,11382,6646,11351,8517,3574,11436,11435,11447,11424,11417,7828,11447,11480,11496,7009,11494,11359,11477,11494,11488,8884,10873,8281,2063,9950,11112,11554,9950,11603,5688,11112,11554,11603,5688,11195,11608,11680,11679,11682,11717,9989,10294,10338,11736,11446,10875,11719,11800,11850,11851,11825,11855,11478,3913,11895,11879,11344,2615,11900,11904,11923,11902,11290,11905,236,10910,11010,8280,8299,7988,11829,11664,11978,12001,11860,12002,11980,11603,12016,12014,11371,12025,7084,8393,7271,8394,8876,7913,9562,7103,8474,9261,8415,8417,8394,8208,9161,10185,7250,7660,9594,10356,7115,8282,9370,9956,9821,10507,7298,8892,8891,10025,10570,10577,10508,10576,10629,10272,10574,9999,10623,10625,9744,9873,10767,9875,10399,9877,10077,10882,10881,7971,8411,9509,10965,10302,8468,10630,9148,9316,10833,9609,8071,7933,7241,7108,10076,9259,8567,9264,9563,8474,7295,10811,11108,9053,9225,11124,8282,10625,11125,7271,8736,8794,9662,7270,7715,9650,10451,8285,9574,11262,7243,9577,10906,9293,7261,10773,10835,7092,10011,11331,9756,9755,8370,9053,10451,7656,7657,9659,11376,11274,11273,10475,9660,7298,8411,9876,9797,10855,10854,9367,11275,10022,11472,11515,11516,9141,10271,11532,11534,11508,9302,11693,11692,11711,11573,11711,9398,11535,11536,8743,8415,11540,11539,7250,11108,8087,11671,9058,9059,11700,11777,8052,7271,8238,11472,11534,11279,9610,9609,11262,8892,8891,7281,11628,8460,11629,8711,8580,7088,8735,7086,9572,7289,8052,11881,9187,8087,11892,11889,11890,11513,11882,11887,11912,11913,11893,11863,11884,7646,11915,11916,11626,11955,11914,8737,10834,8722,9321,9719,10789,10583,10584,10272,10403,10591,9158,10692,10915,9370,8720,10007,8424,7261,8427,8721,10582,9742,7574,7895,7935,8450,10588,10690,10586,10623,10767,11034,11150,10770,10789,10807,10833,10858,11187,11273,11275,10835,10882,7069,11335,9148,11063,8461,10863,11369,11334,11411,11333,11064,11196,10843,10888,9148,9390,1912,6138,11239,7088,8517,8080,9573,7674,7122,7287,7971,7125,9055,8449,8770,8449,7655,7715,10401,7286,7280,7714,10475,7662,10272,7265,7660,8451,7281,9148,8288,11692,7077,7287,7286,11526,7147,8377,7249,7088,9739,10007,7081,8638,8371,8641,6768,2658,7897,947,6658,2005,8866,8866,7420,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,6631,8196,7256,10731,5858,3043,5068,9442,1993,378,11328,10348,11400,1153,9817,9819,9820,9818,10095,8229,8371,8712,7261,461,8721,7287,7861,7088,7086,8040,6702,9095,6701) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC