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,6774,6733,2029,6547,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7123,7101,7116,7124,7079,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7097,7572,4216,2399,7280,7263,7992,6559,8386,7270,3550,906,7932,3380,8670,6832,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,7097,2932,7296,7089,5148,7271,7906,7268,4860,7572,8385,8395,7258,8086,7104,7151,8287,7276,7675,7115,7068,7094,7084,4796,7124,8282,8361,7107,7304,7943,2992,7714,3860,1537,8230,7646,8365,7118,7246,8450,7083,7671,8058,8055,8473,7151,7295,7897,7647,8463,7675,7967,7107,8526,8109,7288,8903,7118,7663,7246,7291,7666,7124,8365,7104,7096,8083,7277,7089,7155,7246,7083,8739,7152,7115,7116,7272,7932,7096,7245,6726,7125,7241,7897,7106,217,7266,7084,8055,8071,7270,7671,1029,7672,8079,4597,8087,4770,8062,1402,4662,8384,7668,421,7675,8269,7657,3550,8019,8077,8657,8053,8363,8202,8739,8052,8081,7668,8468,7931,8418,8084,7071,8471,8422,8641,8087,9148,8736,9053,7671,8475,2573,2328,2388,8450,3297,8438,8477,130,5915,8385,8041,8288,7656,8045,8042,8068,8407,8782,8065,8057,8060,8069,8067,8282,7660,8058,8051,7095,7097,7666,7669,9160,8359,9054,9055,8367,8419,9573,9574,9575,9578,8476,9577,9561,10022,8467,9539,10074,9793,9580,10077,9999,8235,8642,10009,10023,10051,9158,9565,9998,10075,9572,10186,10027,8082,8078,7076,7081,7108,9443,9445,9510,9581,10024,10026,9562,10076,8364,10185,10022,8767,8410,8085,8507,8528,6879,7628,10272,8411,8412,8398,8397,10275,9793,8396,10186,10690,10659,8286,10629,10624,10689,10030,9225,8439,10630,8408,10675,10770,10773,10691,8644,10811,10807,10774,8405,10625,6896,10835,10843,10889,10891,10852,10853,9187,9204,9206,9218,10881,10906,10692,10862,10863,10834,9206,9219,9263,9262,9261,9264,9875,9876,10270,11066,10271,11062,8567,8473,9292,9313,8201,8207,7290,8569,9314,10965,8206,8537,9367,9368,11045,9316,8468,11027,10586,11187,10450,10405,10401,10890,11336,11224,11333,10572,11368,11370,9294,7275,8229,11331,8474,10694,8383,8929,7289,9399,9400,11376,11500,11501,11502,11507,11506,11503,11513,11542,11614,11538,11540,11528,1521,10062,252,9352,7017,9454,9638,6863,2337,4805,5373,5142,4136,3542,585,8888,10116,107,606,188,2918,10009,7249,1894,8930,8473,1650,219,10120,8055,9768,9769,1176,3715,926,8900,7615,7582,7550,8089,6713,8837,7016,5812,5379,7614,10112,9630,3625,9086,8925,3413,8805,8915,8901,8902,1349,9454,9249,8795,10244,8068,9220,9874,9873,9876,9875,9878,9877,9289,9352,9346,4082,7602,9654,7655,8935,10063,10227,9879,10526,9910,8934,9197,4805,10528,10245,9402,4652,10523,8368,7092,10272,162,4209,7903,5729,8890,6251,8800,9900,9817,10115,10699,9993,10229,10246,10341,9248,8804,9464,10548,10894,6876,9081,7019,10856,10895,9363,1461,7761,8222,3595,10904,6710,8793,10569,7155,10858,9195,1520,10027,9740,8055,8794,8769,8049,8368,9739,9621,8711,8052,8078,8049,8058,7931,8770,9738,8736,8286,8645,8711,9719,10075,10077,8721,8398,8792,9572,9540,10506,9622,8411,10577,8055,10507,8414,10573,9204,7262,8473,10587,9445,9313,10690,8049,8397,7293,7671,8045,7086,8735,8055,3029,8368,7096,8473,9160,7071,9187,3890,7385,7258,7089,7939,10670,8460,8568,9563,7249,8083,8641,8086,10584,8657,10575,9082,10624,7258,10582,9187,8459,9134,9609,10869,10789,10906,7106,8430,8370,8424,10767,11045,8039,11187,10584,7071,11124,8045,11278,11277,7121,10692,8739,8039,9054,7276,7272,11196,8370,8282,9539,9578,11124,7662,7661,11125,11276,7278,11334,11376,9793,8711,8431,10510,11472,11469,11471,7241,11411,8711,11470,7574,11196,11525,11511,7108,9370,10580,10275,10271,10270,11333,7271,11526,8411,179,4767,1506,6559,6663,6876,5088,1520,793,464,5907,6001,308,585,600,6162,6168,358,3892,5647,4969,228,7258,6813,7304,6766,6954,6812,4217,7160,1830,6794,7144,6780,6155,2328,2506,6695,2863,6831,6802,7838,3046,7783,4983,6767,2419,7602,2573,6160,7146,8020,4735,6159,725,3728,6811,8093,6588,7143,6605,6971,4570,6128,8096,8526,6726,8230,7822,8503,8836,6172,7304,8611,8184,8512,7887,8109,6348,8852,8489,7897,8869,6104,8869,8032,7850,6809,8118,6845,8903,6104,9075,9116,4860,8630,9052,3725,7920,2023,8500,7839,585,8948,9366,4220,9354,2925,8933,9369,1490,8955,9541,8806,9069,7022,9543,6135,9453,3549,8543,8305,6117,9647,9648,4765,341,9200,4652,9345,9374,9348,1349,8934,9346,9939,9249,9248,8795,8915,8805,8935,9924,6821,8492,9922,4566,9941,9928,4566,8501,4128,9402,4061,8031,10057,10208,9910,9117,10063,7759,4056,3936,10227,3100,1698,7138,6683,145,6986,6635,6793,6684,9991,4131,10039,6679,9363,7761,9258,10341,6595,7354,10548,7019,10688,8222,8793,8222,9195,9552,9925,10245,9993,5236,9000,9027,9282,10762,9034,3595,10879,10938,10528,10955,768,10893,8829,9352,1127,233,228,11127,9749,9065,3964,4635,4656,5046,5193,7760,11021,9038,8629,11122,308,4023,10246,6314,6779,6169,6674,180,148,6639,180,3493,2261,11324,6686,8808,11324,9379,7147,8923,8781,8257,3059,10572,10535,8539,6792,10573,11213,9467,10906,6713,8769,11489,11377,7077,11220,7156,11361,11439,7077,11361,11439,9629,11018,7077,4537,2294,9055,9204,8048,4046,10915,11124,9639,2019,11353,11599,7661,1895,11287,3288,10719,7662,10623,11125,11521,9638,10623,9220,6713,10042,10623,10042,7125,11126,11724,2923,10895,7084,5368,11678,11760,8709,8368,11237,11692,11501,11693,11803,11867,11868,10630,10272,11867,10689,10623,11502,11777,10624,11647,11210,10625,11349) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC