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,7155,7147,7110,7110,7110,7110,7082,7783,8470,7656,8444,8444,8072,8227,8268,8721,8466,8723,7670,7670,7101,7241,7123,7123,8537,7672,8269,7664,7081,8740,8740,8424,8568,7292,7292,8040,8200,8203,8203,8228,8228,8459,7280,8445,9205,7105,7272,7107,7121,7288,7282,7282,7120,7967,7272,7275,8363,7155,7032,8240,8474,7298,7298,8395,7671,8384,8736,8386,8386,8771,8034,8083,7112,8792,7574,8033,8253,8047,8082,8040,9259,8048,7288,8034,8036,7112,8033,8082,7574,8430,8742,7671,2023,7291,7659,7115,7097,7671,7291,7291,7281,7118,8771,4199,4659,2627,2932,5936,6146,585,2025,3066,6778,6778,8050,7250,7654,7297,8251,3250,7069,7374,9030,2257,8063,7123,7895,8639,7895,7260,7260,8034,8034,8055,7100,7286,7121,9931,8199,7084,7084,735,7086,7080,7119,3874,7385,2179,1324,7108,7292,7292,7096,8050,7104,8061,7298,7642,8060,7297,1366,7106,1366,7107,7122,6740,7238,8220,7124,8431,7607,7094,8470,7108,7077,7293,7250,7655,7288,8033,7574,8444,9300,8469,8768,8395,7932,4801,7971,7674,7105,7082,8472,8740,8424,8568,8445,10056,7262,7261,7646,8266,8450,7124,8048,7671,7572,7075,7103,7152,8529,7654,8771,7243,8365,7115,7155,7110,8364,7125,7083,7715,7765,7243,8082,9132,9148,8240,7291,7251,7665,8469,7107,7647,6794,9032,9205,7646,9047,9189,8446,8580,9259,9076,4973,7671,8768,8769,7247,7249,9134,8423,8852,9315,8439,8083,7094,8060,7275,7666,8451,8034,7674,8770,8358,2643,7109,7268,9161,7104,8447,9314,7150,9537,7647,9133,9133,9573,9577,9619,9748,9622,9621,9747,9620,9560,9580,9746,9745,9876,9878,8085,9876,9877,9956,9138,7291,9744,9873,7304,6967,6376,7143,7023,3380,539,7904,7270,6349,4079,7249,7247,8400,8201,8198,8199,8201,377,6066,8576,8568,2635,2635,553,544,1462,1462,7680,6763,3449,5718,5718,6381,9189,8082,8253,9312,7090,7090,7278,9300,9864,8995,7266,10056,9573,7585,7585,9304,9560,9560,9577,9577,8542,8542,8542,10265,8168,6925,8986,10026,8782,10572,10272,4080,9148,9561,10836,9076,8451,9949,381,9719,7646,7103,6733,7262,9513,9563,7654,7250,9370,8716,9564,8450,8365,7294,8395,8449,9797,7288,7082,9745,9259,9581,8569,7666,9205,8404,10026,9622,7266,9573,9561,8891,8451,3327,7048,7671,9304,10258,10272,9880,9492,8,9189,9957,10303,10312,7287,7121,8211,7110,8084,8087,7096,8047,8366,8063,7084,7658,7268,7655,8080,7714,8065,8452,8652,7659,8456,8998,8068,8268,8713,8064,8401,9560,7273,8891,8892,8393,8378,7670,9053,9594,8058,8362,8049,8425,8050,8406,8201,8640,7674,8373,7662,8641,8476,8430,8766,9564,9738,8712,9740,8428,8570,8646,9508,9741,9442,8737,9562,10025,8467,7665,7266,7122,8081,7660,2093,7674,7112,8445,7659,8577,10577,10675,10272,10275,10575,10629,10630,10906,9743,9508,9562,8034,10007,7077,9261,9564,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,8961,10404,10449,8057,8368,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8767,8207,9738,11367,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8468,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929,11251,11229,10925,10920,11186,11184,11182,11231,11177,11179,11181,11252,11175,11176,10921,6518,11173,11174,11037,11183,6519,6523,11178,1704,3442,7698,7843,7844,7845,7868,11185,10924,4297,4298,4299,9631,7843,6220,3883,3896,3891,3893,6493,3885,3890,8273,3887,3894,3897,3892,3888,3884,3889,3895,8274,10922,6537,6505,4296,6506,6536,6534,6535,6532,6538,6197,3515,10923,529,541,531,545,542,540,539,538,537,536,532,543,528,527,526,6042,553,550,548,547,554,9665,10053,10544,10975,11221,10948,549,535,524,10947,8240,6533,6532,6042,551,11241,10194,525,8332,9432,9435,10326,11240,11156,9431,9434,11241,9427,9428,11242,11406,11405,10326,8243,10606,547,11153,10560,11160,8327,8311,9416,9412,9409,11046,11151,11154,10556,10201,10139,11161,11054,11055,11139,11152,10559,10562,9593,9908,10136,9891,9894,10096,10101,10103,10102,11154,10100,11407,8245,9414,8325,8319,9415,8332,8318,8307,8249,9410,8248,9424,8247,9425,9426,8246,8308,9182,9414,10326,11153,272,4146,2781,3874,2779,2780,2785,6443,10963,2787,2791,9436,2778,4224,9589,9183,8883,8330,10926,10927,10931,9383,9867,11109,8945,8946,6688,10232,7600,10928,7636,810,8327,9430,9592,10137,10645,10643,10641,10639,6198,6199,11430,11252,11176,11218,11493,8586,8682,9084,7546,9407,9920,10565,11147,10238,7694,8584,8585,10463,179,178,177,11324,11219,10938,10750,7631,11019,8618,7870,9993,11455,7810,9655,9554,8050,11369,9520,9522,4752,10229,958,3493,7761,8793,9925,2261,8222,9195,3595,7019,9661,6710,3059,6876,1461,1520,11644,9418,180,233,10278,10823,566,173,28,11228,1370,1210,1207,956,1056,466,3872,2451,1741,923,57,1533,3392,1234,1145,3189,2725,1398,2736,9675,1198,2776,1425,9533,2677,2995,3014,4762,4784,4785,173,5089,4788,4690,8894,5756,5112,5143,3189,2992,5756,5251,7172,1537,7304,9453,9052,24,3327,3860,10526,4234,8798,8893,501,4701,5996,10375,3048,11812,5179,3989,766,6261,4708,3830,9378,4779,947,4731,4519,4029,8220,6740,2632,9300,10836,11121,5799,10056,11690,9879,9030,1616,9980,10050,10473,10065,11020,11235,8999,9937,10568,5339,5545,11495,7126,7920,8548,5817,7883,4460,608,2933,1699,6858,3080,7839,9372,10243,11784,1347,4258,11747,11748,11872,11493,11899,11722,11836,11644,11869) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC