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,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,6381,6380,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,3549,6189,5334,7387,51,5996,6766,7304,2992,3860,6780,772,7977,7572,4801,8032,5582,9030,5881,8019,10390,10264,10445,6922,6925,8156,10263,10222,10597,10389,673,10428,6754,6382,6938,9088,6928,6929,6938,9089,6932,6931,6930,10593,10594,10596,10598,10595,10599,10600,10601,10603,3277,11052,10147,9633,10045,10419,10424,8784,11592,9882,6743,6066,8882,8880,381,524,3881,8878,374,8787,9879,378,6270,10526,392,3885,11663,1770,6499,1765,9411,1730,9555,7963,8665,7698,6496,1771,1767,2780,9213,1769,1768,1766,6746,6222,4512,8154,10098,4121,3896,3070,7693,6381,3073,9377,2520,6689,6688,8946,2780,8278,4701,2778,4287,9377,9592,2816,2787,2786,2802,2801,2783,2782,2818,6354,2820,8983,2812,4302,9799,7752,6193,8627,8088,9996,7753,8727,10053,8943,8727,8944,7881,9679,9037,9665,9822,9037,7696,7881,7610,9679,4305,4286,7694,4297,9905,7695,3442,4304,9909,9903,4300,4291,4287,4298,4293,4296,7963,4290,4289,8945,6688,9867,2791,2828,9867,2825,2785,6489,2823,2826,2824,6197,9632,10232,9631,9633,6201,8946,6198,6200,7608,1704,6199,6538,2822,2821,6534,6535,6537,6506,6501,10139,6532,6533,6536,8323,6214,6216,8278,9534,9536,8276,8275,10176,8003,7782,2815,735,9781,8589,8007,10044,397,10257,979,6443,9011,8667,3898,7636,9129,8566,10372,848,1368,10072,7580,9300,6740,3841,7238,10220,9300,324,4701,10056,7568,9383,9543,10552,10544,2749,9072,8991,3877,7762,4,4520,10647,10612,10646,8946,10641,10642,8871,10260,6311,7024,1230,10531,3425,9669,9624,9131,9671,9670,9673,9672,7171,7172,7170,7174,7165,7173,7166,7164,8681,8698,6528,4146,8817,9888,10861,8,3874,6259,7677,10836,9300,4224,8888,9304,10914,10954,8432,10963,9338,10856,10857,7772,510,7771,7770,511,512,10818,7637,9473,9475,10298,10924,10067,5995,4178,446,10212,9418,1257,10098,5459,814,9667,7903,11109,7143,11121,5995,173,7636,365,392,11263,10725,9259,10920,10923,10561,7119,9206,10214,10563,6270,9148,10216,8339,7933,9905,10194,10195,10922,10862,10333,10821,11137,11048,10921,11139,8729,10200,9587,5635,11146,10199,10925,10201,10328,11147,8897,11013,10558,10330,10329,4386,11015,10331,10098,11014,11016,10323,11022,11154,11148,7186,7187,10215,10607,7176,7180,2799,11157,7179,11160,7182,7181,7183,7185,9590,11156,7178,8596,10139,6654,10557,10560,7189,10800,9535,7184,11152,11153,6652,11051,7188,11240,11138,11247,8878,6653,8880,10335,11269,10551,8243,11167,11242,11033,10253,11241,10153,9970,10043,11031,9907,10256,8330,11296,11294,10728,10519,10799,9492,1245,10336,10970,5096,8248,11030,9410,10254,8327,10176,10218,11301,10100,8336,11022,6688,10803,6689,8946,3071,3073,6354,3070,6689,8088,7752,8627,9037,8727,10805,11221,6212,6215,4714,11238,11318,11317,11405,11406,10828,9880,10822,8343,11427,11431,374,11426,9903,11421,11422,6271,11419,9905,1250,11420,11418,5383,10804,3359,9679,10840,6689,9473,11464,11463,11252,11430,11466,11493,9806,11241,9534,10822,3897,10980,368,1770,10239,10821,8232,11255,10612,6270,8878,9483,9143,6749,6197,4297,9155,3881,7632,9217,4296,11320,4464,6742,9156,4301,6745,4293,9154,8983,9231,4298,8980,10957,4292,8879,9151,4300,10646,9147,4305,9144,10640,4294,10645,9633,9146,5635,8729,6743,10639,4289,10752,10753,10642,10641,11427,10644,9792,11081,10643,10647,11080,4304,11321,4390,10545,10828,11076,11077,8982,8981,10637,11432,10520,9149,10827,10646,10752,11320,2605,1266,9137,10637,10647,10639,9949,1765,1770,11321,10645,11432,4390,11017,1685,11466,6484,11218,8585,11723) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC