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,4301,4299,4305,4302,4287,4291,4294,4296,4300,4293,7963,4289,4304,3515,7697,7694,7695,7696,1704,7608,7610,6548,5691,7695,3442,6303,7677,7168,7167,7170,7165,7163,7173,1779,6286,7164,7174,7169,7172,7693,7166,7171,4463,4470,4464,4473,1571,2824,2780,2785,2795,2783,2778,2779,2781,2782,2784,2789,2787,2794,2791,2802,2801,2806,2805,2786,2808,2811,2812,2799,2815,2816,2817,2818,2820,6489,6443,2821,2822,2823,2826,2827,2828,6442,2825,7238,8662,7677,4178,4801,1569,1569,1569,8547,7261,1209,5913,6023,4464,6036,4470,6034,6444,6031,6030,2992,6038,1537,6039,9030,2224,2221,2218,2211,6041,6040,2208,6540,693,10551,10336,7167,7165,10325,10322,10331,7170,10599,9176,4463,9631,9632,7164,9232,10332,8662,8164,10427,7167,4464,10613,8167,10487,10489,1767,7677,1771,1766,1411,6359,1765,726,10602,4426,7600,6762,6759,7676,7055,8166,10198,10647,10638,10643,365,10594,10641,10645,4464,7169,10600,10601,6416,6386,7168,10642,10332,10327,6197,10607,10328,1411,7567,2820,4297,10558,3515,10563,6201,10218,4299,8332,10158,5386,7569,10137,3442,10099,4292,10333,2826,9593,9430,10200,10560,7696,4293,4305,10322,9114,9426,9424,9409,4298,9112,9113,8883,2824,10136,9894,9633,4304,10215,8662,9908,4294,6200,2825,10218,2823,8727,1765,9120,8326,8627,1771,9626,4296,1768,7174,9037,6689,1767,2808,1766,510,1771,9473,8944,9669,9407,7752,7677,8627,9920,8432,9474,10154,10725,10642,8971,10139,9665,9475,10155,9601,10298,10729,9493,10238,10522,9383,10637,9867,8586,10152,5576,10877,7636,10232,4386,848,1368,9687,10828,7580,9031,10641,11048,11008,6800,11046,7870,11088,11019,10329,10864,9854,9911,10645,11007,10565,9912,10463,10647,11047,10866,10923,10646,10154,4464,11014,9046,7019,7165,10155,7166,8780,9215,4470,7761,10157,7677,10156,7551,8222,2818,10519,11051,8793,4855,2816,11109,11183,11184,11022,11192,10706,11193,9168,10053,11191,2780,11241,11231,11242,9690,11149,2791,10544,10331,10333,10158,10326,10324,10555,10335,10336,8591,6359,10725,10729,6510,6508,6509,6507,10519,9493,6532,6533,8899,11055,7189,11015,7185,6654,8897,11013,4386,7187,7184,11016,10278,10823,10924,10920,6200,10925,2605,9909,7845,7844,10922,11037,7764,7843,7568,7570,7569,7764,4804,7567,9632,9633,6511,6515,11138,11139,8662,9232,2789,9536,2799,2816,4473,7165,2806,2824,7173,7174,4470,7166,7168,7169,7167,10213,4463,4464,7163,7164,7170,11030,11031,10251,10254,9907,11032,9906,10043,10253,10256,11033,9592,11032,10255,9907,9970,10251,8246,8247,8241,10606,8245,1765,1770,11203,11204,11205,11207,11208,11209,1765,1771,1767,1769,11206,11208,10463,7870,5635,7604,5657,8883,4463,4464,8662,7165,7169,11255,7168,11251,11252,11176,11186,3070,6354,11177,11175,3071,3073,6689,6688,11109,10232,9383,9867,7676,10931,10930,7600,10157,10155,10154,8432,9670,10156,9669,9670,9672,11178,11231,11229,11414,9665,10877,9720,10956,8717,8719,6730,11374,10827,2605,4390,10545,9137,10827,547,549,550,7592,551,6042,536,537,539,510,8820,9438,9437,10354,542,541,540,548,543,10607,553,532,531,529,528,525,524,8247,533,11242,554,526,11137,11049,527,4473,4470,7168,4464,4463,7677,7167,7163,7166,7165,7164,7174,7173,11254,6538,6533,6534,6505,6536,6537,7567,6506,8650,7027,7568,9791,9591,4804,7762,7570,6768,7764,10567,9791,7845,9631,9455,6212,6215,6216,6499,6222,6496,3846,6220,6223,6214,6498,9483,6497,4296,4304,6501,7963,7698,7844,7695,7610,7608,3442,6218,7696,7868,7843,7694,7693,6512,6520,6521,7569,4293,4294,7697,8323,7844,1704,8655,8692,3070,3071,7888,6689,3073,6354,1771,1765,10828,10546,11142,6697,2779,2803,2791,6443,10963,2787,2802,2817,2799,4473,4470,10687,4464,4463,7166,4316,7168,7167,8520,5484,1782,11354,4338,10868,7651,7167,7654,4520,7077,8580,8015,9543,6197,9873,2520,11331,10941,10686,7166,8585,9874,7250,7165,9875,8584,11354,9719,8212,11149,6354,4464,3070,7662,9876,9877,3073,8577,8199,3071,9878,10045,9601,6689,8577,7168,9367,7169,4791,7164,8662,7654,7297,6774,1730,8580,7173,7298,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,11410,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,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC