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,7677,7169,11349,8943,8944,11235,10895,7881,7752,10568,8627,11237,9922,8945,11361,8585,10975,11314,10354,9249,10747,11457,11423,11272,11458,11396,11488,11287,11456,11495,11493,11492,11372,11377,6442,11476,11599,11549,11521,3549,11123,11435,11443,11489,11412,11595,11414,11498,11661,11604,11027,8088,11552,11288,11678,10532,11690,11655,11724,11646,11598,1917,3698,3241,4099,1298,6832,2458,3595,1559,6779,5088,1498,2261,6248,3550,1257,1215,6560,3702,6588,3037,6732,252,3625,2337,6635,1521,5142,3327,2954,6793,5373,3542,4136,6104,5379,1349,6713,7016,4023,6684,5817,435,766,5339,3159,3437,971,6069,4460,4005,4258,4050,7019,7156,7138,6365,4878,1762,3080,1080,4125,249,752,322,1121,7230,7304,5460,7005,4178,4455,5020,1536,7126,7050,7238,4886,7761,1253,608,1698,4460,5545,7038,7840,6693,7354,7879,5236,2915,3725,7829,1038,7839,2705,7878,7760,7783,1371,6842,4652,7858,7640,361,2635,6663,7920,8031,8089,8094,7992,5349,4199,2387,5070,8095,3701,2294,3162,4218,2590,358,5247,8222,5885,5088,6478,4710,228,5764,2882,4766,5915,8611,1830,4217,2863,6001,7787,6941,6366,8442,4144,8829,6314,6686,2657,8548,4209,5362,6971,8555,6712,8809,2381,8938,9027,4082,9038,8837,7614,1318,8918,8687,36,1127,8910,9030,8947,6117,8901,9079,9195,8999,8902,9186,9052,8543,6981,7550,9220,7615,9086,7883,6642,9200,9248,8500,9346,9348,8805,8935,8800,9363,9321,9353,9453,7582,9372,9386,7758,9213,9402,8919,3165,9468,9335,7221,9558,2698,9471,9606,9541,9602,9377,1277,9552,9607,9638,9615,7856,9634,9554,9654,6858,9406,1699,9769,9668,8514,9825,9600,9800,9455,5484,7910,9454,7017,9374,9922,9116,9308,9221,9835,9945,9952,9964,5222,3302,5210,9986,7830,6824,9834,9814,9212,9937,10021,10018,10019,6113,10002,9910,9884,10001,9928,9896,9900,8933,61,3117,3134,9883,10039,9831,10062,9799,8006,10131,10116,10188,10129,9935,9639,8777,8776,10063,9258,239,9347,9352,8923,10173,10115,10057,10048,6010,10148,10245,9730,9951,10047,9942,9387,773,5692,5743,10243,10046,9879,10288,10283,10227,10130,10505,10284,10374,10528,10548,10373,10526,10376,10368,10375,10469,10674,10556,10394,10725,9593,10201,9591,10139,10562,9983,10199,11020,10938,9589,9587,10559,11028,9833,10892,10518,9407,10871,9588,10268,9430,11135,10894,10727,10472,11156,11021,11122,9832,11104,10750,11136,11154,11139,11220,11218,11154,1699,10225,10649,7599,10211,10738,9389,10956,11010,6845,11314,11324,10830,10266,11018,10289,11287,11288,11126,8586,11233,11406,11360,11379,11299,8390,10719,9814,11340,10463,11361,10565,11353,1537,11442,10526,10904,2992,11437,11378,10895,9193,11396,11382,10879,2506,11304,173,10823,11351,11455,11493,3521,11409,10893,177,178,179,10314,11443,11495,11489,11522,11552,11598,9950,11599,11093,11377,11606,11480,11608,11342,11523,11600,11655,11658,11646,11285,11661,11620,11656,11453,10892,11678,11691,11479,11289,9244,11681,11670,11201,9339,9381,11383,11491,10188,11621,11724,11488,11786,11785,11373,11107,11455,11764,11770,6704,93,10731,10721,11602,1969,11775,11202,11441,11851,9601,11848,11408,11784,11854,11828,11850,10798,7807,11363,9538,11872,9544,11964,11900,11899,11860,11965,11905,5334,3549,11272,9558,10558,10559,8243,8241,10556,8246,10333,10555,10546,7599,10563,10521,1685,1411,10327,10522,8249,8308,8312,8313,8315,8316,8320,8326,1266,810,10502,10565,9920,9407,6425,6424,10325,8618,8584,7870,8586,7546,10238,8682,9084,10488,9867,7631,8333,8329,8331,10336,10561,7638,5332,10519,1556,10328,10489,2605,9383,10545,10821,3875,1770,1768,1771,1765,1766,1767,8007,8159,2932,8825,10427,10612,10866,10931,7676,7600,10930,1768,10929,10799,10800,10963,10928,10840,7676,10927,10926,10828,3889,3890,3891,3892,3893,3894,3895,3896,3897,10725,10216,10159,1769,10849,1766,8585,10637,9679,11069,11019,11049,11047,10526,11008,8002,11071,11137,8154,11048,10526,11055,7810,8971,9165,735,1730,11139,11046,11138,11057,11203,11192,11191,11186,11185,11183,11181,11182,11175,11184,11177,8311,11221,11229,11243,9665,11244,10544,10053,8162,2488,11221,10975,11245,7734,11246,11241,11218,4752,8703,11190,11193,9278,11406,11407,11161,11242,10326,11046,11151,11153,11154,10560,9424,9425,9426,9428,9431,9434,9432,9435,8324,10562,10201,10139,8162,8161,11156,11405,11160,11240,10329,10330,10331,10324,11695,11696,11697,11617,11050,11677,11320,11321,11357,11356,11355,11694,11356,11467,11318,11319,11723,7610,7608,7868,5691,7693,11317,7311,848,7580,3442,3515,1704,7697,7696,7695,7694,11611,11354,11618,11836,6800,8002,11068,11067,8154,11071,11799,11069,10640,10641,10642,10643,10644,10639,10645,10646,10752,11252,11251,11461,11493,11228,2677,10647,11922,3874,11432,7697,8154,7694,8002,4298,4289,6354,10327,8584,3070,8649,7546,10519,8618,7843,8682,9084,1704,7870,9407,7844,10238,7631,4121,7845,9920,9632,7695,9920,9633,6197,6199,6200,6493,7986,9631,6198,7985,6201,7987,8272,6260,3884,3883,3892,3897,8154,9905,3881,9909,9119,6526,8260,6520,6521,6373,6503,6523,10924,6504,10920,9903,8321,8241,10324,10563,10331,10329,9522,10333,10331,10329,8244,10323,10921,10922,4293,4282,4294,7963,4287,5792,3442,7696,6855,10565,10827,10750,7698,1766,6214,6499,6218,6221,9920,10238,6212,1766,9517,6496,6501,9515,8154,6216,6223,6497,6215,11069,6222,8586,11067,9084,9522,11252,11190,5383,11192,11194,11243,10797,11245,7610,11246,9407,8584,11181,11191,11251,6538,6503,8703,7172,11177,7567,11176,7170,6537,11175,7174,6536,7173,6535,11186,6596,6534,7165,11354,6506,7164,510,10639,10752,9518,9521,10753,7168,8917,3719,10637,7167,11320,11321,11461,11493,8585,11218,11466,10849,9520,10923,3894,11019,11422,11431,11459,11407,11240,8247,8242,10606,8703,11191,11193,3070,11375,11432,3073,6354,3071,6689,8088,7752,7753,2780,2789,2812,2791,11464,1589,11493,5792,2779,6896,2787,6688,4512,9129,7751,7972,7973,8946,7184,11148,11147,510,11146,7770,7772,11656,11405,11615,11419,11618,11465,10278,8436,11723,4282,3997,11792,11421,10332,11677,11792,3327,11799,11696,11697,10522,7938,510,4294,10325,11617,11186,11419,11176,11251,11252,11429,11575,11194,9232,11245,11244,11243,11574,4305,11190,11246,7972,3874,4146,11068,11878,11899,11081,11425,11031,11032,11037,7770,7772,510,7771,3282,3719,4580,11051,11033,11080,510,3719,6879,3115,11458,11922,979,11935,8174,11876,11355,7808,9149,11877,11759,3897,10647,3885,11427,7721,10520,8436,11677,10828,527,7986,7956,11319,11723,9905,549,8247,11299,11185,11050,10326,10330,10327,9909,10433,10238,3066,11182,11587,11209,11205,11203,9518,3891,8339,11204,8274,4464,11407,7677,3888,10562,11425,11184,4714,3894,7546,6520,8326,10336,8244,8585,11181,7568,3898,11175,11183,11176,7764,8271,3896,6197,8245,11430,1769,3887,6040,3882,8272,1768,6040,6036,7167,7165,1767,6493,10923,6505,11497,11931,1766,11221,7696,10925,11178,11179,11183,7693,11037,11146,7870,4294,7189,11015,5635,11148,4386,9909,11331,10889,10920,10475,7697,4,11255,10863,10835,10921,10923,10486,7694,2605,10828,979,9149,10545,10840,11177,11375,10075,10520,1685,10521,1266,4390,4282,1411,8696,8695,8654,8656,11175,5297,6359,10827,11249,7808,9137,5332,6995,8694,1769,1768,10522,10922,11154,8655,10027,3442,6520,810,11251,10029,11317,1685,10546,11185,11182,11181,11186,11318,11184,10924,10639,10641,10645,10646,10643,10642,9880,10644,10647,10753,8693,11458,10644,10822,9933,8694,3895,8692,8655,10645,10637,11252,11321,11176,11590,11432,6354,1766,8946,6688,10331,9794,7881,7753,7752,10053,3070,9665,8627,11584,9679,9867,10544,10975,6689,7266,10927,3073,10926,7676,10930,10931,7600,11109,8727,8088,10232,3071,11582,11578,7188,7176,7186,7178,7187,7184,8897,7181,11419,7180,6652,272,11422,11013,9037,6654,11148,10928,11016,11221,9250,8944,7183,9223,8945,8943,8011,8247,11431,7182,8585,11418,510,11149,11601,9383,6653,11723,11579,7179,7185,6426,11019,11218,11493,6271,10329,10333,8241,10332,8337,11420,11465,1303,11176,11650,10327,11427,11429,11463,10931,8727,9920,11421,7870,10323,8883,8310,10565,11147,4386,11464,10238,8333,10555,10640,9407,10216,8308,8314,11146,8244,7151,7024,8318,8248,8585,9120,11466,7663,7103,3874,10519,10641,4146,10639,8880,394,10643,10752,1266,11799,9037,8787,10637,10647,10640,11723,10646,11321,11836,10931,10463,7753,7752,8325,11624,7604,8088,7600,9665,10975,10053,8627,10544,3071,10644,8944,8943,10642,8727,9383,9587,9867,10232,9589,8945,11221,2605,8946,6354,10926,8897,10927,10928,10930,8323,8321,7600,7676,11899,11836,4146,10948,6270,7184,11981,7185,11014,10641,11015,6654,7179,7183,7181,11109,7188,10928,7600,367,391,365,368,10161,6270,8878,8880,9483,8882,380,10846,11241,10323,11019,10750,11493,11218,7631,10726,9407,7631,9084,8682,8618,9920,10238,11899,7870,11611,9386,9231,380,9892,7953,7546,8586,11750,9920,11568,10565,11493,11269,6652,10463,9892,11602,11775,9907,3070,3073,6689,9665,8627,11019,10750,9518,9520,9521,8340,11220,11205,10687,8241,8139,8249,11206,10606,11203,11050,10139,8318,8247,11007,8248,8310,11055,11009,9416,2780,9415,5297,4390,51,10325,8824,10522,8332,8262,11021,11402,10227,10323,10828,10227,10323,10828,11207,11209,11204,11149,10606,8327,9182,8699,11646,3073,9402,11148,9625,9626,8314,8586,11218,10565,11493,9424,10327,11419,11462,9624,9625,10797,11013,7188,7178,11464,11463,7189,11421,7185,11014,11493,11218,10238,11429,6521,11574,11576,7631,9407,9084,11650,8682,6520,3890,3895,11677,10565,10269,11493,11218,10327,2779,10963,10463,10328,10326,10325,529,11559,3888,3884,10332,3891,11181,11184,10323,11318,11242,11430,3384,7299,8339,3893,2785,3885,10238,2780,2781,6354,11019,3385,9232,5810,3896,8618,6394,6800,7973,2818,3881,3887,10331,2786,2805,2822,11792,8585,10333,11033,2778,2787,9024,9024,9024,8582,9840,9865,10480,9633,8310,8897,7698,3254,842,8274,6520,3897,8272,3883,3884,3895,3892,3891,3888,3882,3896,3890,3887,11458,11459,10238,8585,9407,9920,7870,8586,8618,8682,7631,11218,9084,7546,10565,2807,2806,10828,7631,1685,9137,7870,8586,9147,9920,8682,9407,10565,3874,7986,9154,11019,4146,11493,11339,10893,11611,4714,11255,8662,11218,4464,5066,4512,4470,7167,4463,7165,6354,3073,3071,6689,7753,10489,7752,7167,8088,8627,9037,10053,10544,10975,11221,9383,9867,10232,8946,6538,6537,6536,6535,8943,6534,7881,8944,7179,7178,6506,10733,4785,11836,7569,151,11252,11231,11179,4599,4598,11899,10155,8432,4598,10610,10448,11016,9981,6929,6377,11358,10622,10599,5635,8965,7697,7694,7695,11694,7868,10332,11624,7695,11694,3073,10326,10325,6354,8332,3895,3896,3888,3887,8274,3889,3893,3885,8273,6493,3897,3891,8272,3883,3894,3884,8946,10327,10328,10329,10330,10331,10323,8248,10333,10606,9119,8585,9908,10194,8882,8290,8339,9588,9587,8330,9430,9429,8682,11242,11677,8586,8618,9407,9920,9589,10200,10199,10801,11160,10557,11617,11615,11759,11618,10214,10215,10158,10096,10137,10138,10099,11156,11625,8314,11139,11151,11934,11154,9409,10562,10103,10100,10556,10559,11932,11933,11153,10101,9593,10102,10139,11406,8324,9425,9427,9428,9891,10153,10195,10197,510,7772,7770,7771,511,512,512,7637,10558,9894,9410,8241,10332,10325,10326,10327,10725,10329,10328,10330,10331,10333,8329,11241,11407,9592,11046,9593,7631,7870,8586,11019,7546,8699,8329,8339,11931,9407,10565,11624,11625,1604,4769,8315,8310,11617,8584,11759,11009,10556,10139,10325,11618,10238,10562,11933,9407,8271,7870,10333,11407,8586,3893,11615,9084,3897,3894,10324,11899,394,11156,3883,3890,10327,6270,10565,11161,3891,10323,11019,3889,367,10331,3888,6505,6076,11242,11318,8273,6533,11493,3881,11241,11249,7546,8274,3885,11139,11046,3892,11154,11159,8682,11405,3895,3884,11153,11218,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,8443,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,11836,11644,11869,11816,6117,9648,10930,9657,11838,10734,11593,10744,8885,7807,6821,11354,9555,11871,8436,5995,11355,254,11981,2294,10569,10543,7919,11965,11356,11873,3066,11984,11357,7238,11645,8220,3244,3003,11423,10342,7592,3376,7636,10332,6354,11218,11899,10827,11466,4305,8824,4305,10520,1266,4297,10522,4299,4292,4287,9407,7631,8586,9084,8585,7870,9920,10829,11899,8945,10975,11627,11877,8583,7870,7600,10565,10942,9920,10238,10943,9624,9625,9626,8087,11246,11109,11019,10941,7150,8944,8943,11046,11934,10725,8585,7546,8586,8618,8682,9920,10565) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC