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,2447,6362,6365,2093,4801,5371,3913,2117,1765,7610,7985,10075,7080,9161,10582,7174,10586,10029,524,7674,527,10587,6129,5681,5995,1038,3428,2160,6103,5321,233,4355,228,6315,5837,4056,5421,2194,1998,6361,1453,6633,358,6100,5885,1591,6709,6769,6312,3921,5914,1402,6718,6588,4088,5081,5371,511,6155,2766,5915,5371,6140,5322,4985,311,6391,864,6255,5386,3997,6261,6382,6385,5331,6652,6559,435,427,6177,5148,6653,6391,6785,665,6364,228,3830,6197,3989,4580,275,4860,1165,4234,3860,5535,726,393,2882,2160,4730,6154,1537,4131,6545,1137,543,397,6138,6040,6559,4023,725,6686,6679,6197,7879,7840,7143,7878,8220,5764,7903,8183,3784,3263,215,8222,6750,7998,7638,5995,3761,2467,419,6981,1506,501,2706,8306,3059,971,1215,4178,1257,7833,3134,3368,8542,8616,8488,7840,7879,7878,4259,8529,8306,5143,466,252,6204,6539,7631,7870,7582,4136,3542,8434,4788,7896,8611,8615,3413,2261,7641,7837,7615,7903,7834,9144,8983,6713,9300,8842,9130,7910,9547,6023,10119,9220,9807,10548,10244,9752,9770,10523,10526,9924,10300,36,10688,5576,5267,2467,2989,4769,834,1537,3913,5435,4437,4438,6602,4086,1270,1153,637,1402,1998,6620,2658,2682,6780,5907,6621,5371,3860,240,409,698,1029,1248,1410,6103,6135,4553,176,5175,5252,6122,176,5719,1230,5362,1215,1215,666,1537,6010,6383,3860,4860,5222,6559,7304,5148,5148,5088,5088,6162,6159,2992,2473,1666,6869,7150,7081,323,7155,3254,4614,7079,7079,7280,6382,6152,6985,7243,7155,7713,8228,8228,1770,1765,1771,7182,1768,1766,9383,6354,3070,3073,3071,6689,8816,5094,9619,8520,8730,8814,8817,7751,7972,7973,9655,9665,6151,215,6152,3263,3277,6719,6763,6764,4614,6656,7100,7072,7122,6612,6751,7091,7109,6744,7075,7294,653,6521,6388,6391,1746,2992,240,7087,7258,8087,7263,7675,7675,8049,7089,6385,7300,7106,7069,7276,7125,7117,7117,7117,1927,7120,6656,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,1917,4614,6588,6177,223,4218,2117,6365,7037,6104,5997,4563,7100,4985,8208,8204,3327,3327,8222,4218,979,1165,6272,2389,3830,4796,5236,455,464,4234,4128,4178,5279,4879,6431,1453,6400,1537,3337,766,6195,4178,5995,6001,754,6587,2158,6008,3644,223,4566,1343,6381,323,3860,397,2594,4656,6766,1826,975,6394,3964,6593,858,6986,990,3989,1591,6842,6947,6140,6941,6010,6985,1402,2261,766,5070,6349,6793,5882,1461,5331,6757,6779,6812,2374,6115,6631,6658,4099,4656,6779,6971,7003,217,6850,1029,2474,5530,2000,6951,1371,6996,958,5371,7019,675,3100,230,6312,7034,7148,6569,1917,6168,924,3595,6103,2915,3059,834,239,7226,4947,6813,3493,1461,4796,1558,1520,6141,836,850,3860,233,1785,1537,6431,6951,1776,6275,7739,182,2932,2000,6445,1084,5339,1521,3625,7156,4995,797,2446,1462,1779,1785,6400,3037,2387,2117,7761,4529,4659,8222,8232,8128,3542,1070,7897,4639,3521,7050,1490,2029,4079,7783,8097,4405,4834,4259,8558,1890,6818,2117,8518,8611,8109,6631,1349,8535,8388,8629,5552,4218,1811,3850,8793,7976,2737,8839,8852,7918,734,3823,3966,6667,1558,8305,6814,8889,7602,7147,8183,7307,7795,1772,186,1774,6715,3302,8684,933,4991,314,6366,8281,9340,5769,2009,6583,6438,8561,3519,3554,5305,8978,9344,9290,9197,6700,7903,6255,6552,9453,8781,7048,6631,3520,6642,344,9776,8089,3557,9776,4849,2390,4087,9248,5046,9922,2122,9900,9910,9661,7759,9776,9928,7825,9308,36,9986,7998,10229,9798,1303,10063,6113,2989,9449,5891,2170,8816,6641,10346,10280,9552,9538,8586,10001,9602,9916,10469,10127,576,10292,10500,10375,9513,4349,2158,7173,10548,10526,10654,8956,10579,10652,10775,10652,10747,6562,10719,10894,10227,10297,10871,1765,1767,1771,1768,1769,1766,9154,9518,10670,6354,7922,3883,8272,779,10354,11041,10314,3073,6689,3071,8316,7557,8627,8088,11021,9037,7170,9945,7174,8241,9665,8333,8946,8244,10742,1537,6843,6362,6362,6843,6642,6159,6104,6809,6845,3162,4049,1453,5992,834,6315,6642,5636,5837,2118,5764,6709,1576,6348,6710,1953,6861,4185,6863,4570,36,6364,6713,4277,6645,2160,3715,5013,6123,1559,4767,4886,739,6981,6842,5997,6994,4131,6740,7238,1127,344,7138,6862,3557,7761,7835,7836,6858,7779,3059,7126,7019,7878,7919,7833,7304,8019,7981,7016,7992,1521,850,7834,7751,8220,3217,8193,3754,7972,7580,2419,6698,6857,7973,6117,6962,8547,4798,8440,4510,252,8355,8353,7541,6984,6127,2023,8356,4617,8807,8827,7970,2183,8306,8305,7860,5739,3823,8955,8997,8543,8910,6968,8681,8933,8355,8698,6174,8948,8353,7974,8356,8817,7032,9258,9222,7928,9223,6412,6967,3595,9009,6175,4806,5602,9223,8222,8793,9195,9925,9290,8290,9888,10039,9926,9835,10212,10229,8169,10127,10355,1453,6350,6162,6588,2576,4218,1181,5091,8143,6122,7995,6941,7840,7787,7879,6726,7548,8032,6971,5362,5362,1313,8093,9078,9047,9092,9074,9085,7795,8903,8526,8836,8230,1181,9321,1057,396,8093,9420,9386,9990,7130,9916,4355,5020,1998,4185,3963,5386,5400,5322,5215,1230,5917,1586,24,3913,5764,4082,5885,6117,6792,3595,2992,6831,6104,6595,236,1381,6315,3860,5371,1371,1766,5331,6559,4061,5576,6154,2294,6011,4316,3368,4185,6560,6863,7019,608,501,5215,1954,6337,1690,1325,1521,1600,1272,6979,6595,5997,5371,6713,217,4985,7903,7761,7896,2594,2419,6862,7019,5142,5093,4659,2389,7751,233,7304,7972,1016,6010,5572,7973,6364,6103,8144,2023,6255,5763,8629,7640,3908,7607,7910,8629,8687,8629,8091,8093,6154,6794,3860,391,387,6151,6159,1126,6562,7238,6140,377,1558,2005,6578,2635,7576,7576,808,6595,6751,341,4291,6104,1297,6644,344,2518,2974,3359,2151,2933,3080,223,5148,2706,2992,3860,4769,6188,1462,1453,6813,6588,7130,358,6001,7304,6856,1402,6812,5909,4801,6140,6122,7246,7099,5915,840,8280,8473,2473,7833,7232,7232,7223,7297,7297,7987,9030,8547,223,4839,4395,4535,4639,6130,3715,466,5331,3625,4337,6713,6713,4337,4082,5142,6167,1537,5371,8220,28,958,7304,6845,4983,8358,5732,4452,5763,324,8691,4061,7840,6845,665,1349,6138,6548,5371,6364,6642,6140,6975,5142,7304,6831,6870,867,6967,5188,6969,1974,1153,6947,5484,7022,906,5576,3698,1973,587,5435,2417,2035,7132,6130,5782,1308,808,6769,6809,6710,1345,6644,6645,550,3184,3131,6381,3561,3580,3554,4140,736,1523,7574,1349,1311,6120,6157,6175,6767,726,7962,8024,7304,4916,4985,6818,4923,8361,8199,8762,4302,5733,8434,9037,8629,8049,9134,9055,7903,6248,1537,675,6600,3860,3511,6249,6250,6252,5995,2491,3069,2658,6272,3384,5295,4795,1656,3385,2491,3401,5717,5175,6118,952,6103,3184,2998,2696,6453,6474,6472,6460,6465,6475,6740,2876,6468,222,156,6800,6390,6873,7104,2946,2453,7639,7938,7595,665,8281,7239,5545,7773,6493,8558,7674,7846,8724,8700,6498,8740,8682,8583,7840,9109,9054,8240,435,8913,9249,9249,3850,7647,9529,9619,5512,4185,5542,5906,2889,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,5992,6130,1645,7304,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,5735,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,8169,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,7587,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9078,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,10183,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,11041,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,2706,1343,5907,3029,4834,6740,6740,6510,6212,6530,6509,6223,6531,6511,6512,6529,6538,6537,6533,6515,6508,6535,5386,6528,6523,6514,6198,6200,6382,6390,6066,377,979,726,810,6513,1165,6223,1461,5995,5691,313,7019,1038,3384,3385,3702,6872,7299,6364,3428,7239,1524,7761,2824,5691,1349,4136,6214,7149,7981,8031,6216,6496,1704,7608,7698,1767,1766,2989,7753,1769,1770,1765,5763,1771,1767,8178,8362,7890,4258,5362,7083,7973,1769,5142,5339,8548,8240,7919,7126,5817,5912,5817,6903,8716,8773,1016,8773,8805,8846,5763,8547,8900,2967,8900,8220,2023,1970,659,6205,5373,8716,6,1327,8902,6953,9086,9372,7804,7790,7584,9552,126,6629,7926,9348,9374,10000,9378,9639,9648,6163,9937,10146,10187,10065,9945,311,1955,2913,9281,10350,10130,10416,10315,10212,10568,10115,9548,10528,10749,10895,7893,10904,8214,10667,10721,11025,10566,8871,7024,7077,10816,10210,10413,6484,2706,6110,7304,3860,3863,6377,6743,6066,6371,6152,6190,6530,6506,801,1537,3860,6869,6531,6989,6527,7239,6528,5770,6529,6844,2635,8306,7846,8629,8695,2605,6261,7019,7019,7019,7019,8593,7024,9149,9149,2520,6359,5297,810,7632,5332,8719,8717,7599,1245,9424,8246,8318,6510,6511,6513,6514,7117,7650,7104,7150,2811,2789,2791,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,4839,1366,8356,8530,3227,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,4050,6646,7467,1351,7159,964,7444,7105,7384,2389,3449,3449,8015,8015,8015,8015,8185,2329,4061,1119,975,6710,501,28,1461,3561,4796,1738,5656,5460,6648,2998,1462,587,6690,6900,6779,6979,2389,6900,7139,6981,7142,7127,7141,1537,7148,7268,7084,7124,5407,2776,4637,455,6267,3608,6437,317,7268,6969,2389,4460,538,8744,8354,4294,8585,9030,9042,3287,8314,7985,665,2522,8206,7286,2117,3863,7256,7068,7261,7304,7661,7662,3327,3327,7655,7655,8081,7655,3896,1973,1973,1308,8951,8951,8951,7985,3895,8273,3892,7655,7655,7655,7655,7655,7304,3860,778,6430,6561,368,1785,1785,3493,3493,3493,3493,3913,1370,6855,6312,1764,4405,7304,3860,6740,7897,56,8047,272,409,417,7032,7493,7118,6188,5995,6315,1586,1537,5763,24,223,6103,6415,6383,435,4659,6412,6348,2294,5596,6414,5576,1351,6752,4230,3247,6947,1207,7023,7089,7068,834,6858,6171,7238,7209,5743,4146,4652,3159,3437,466,1741,1572,3457,7022,3554,3754,4597,6,7032,566,6856,6984,7304,6110,2328,6940,7143,1536,7837,2118,7659,7834,7835,2594,1741,1210,7833,8523,665,1349,1016,7836,7840,7879,7878,8306,1215,8514,6010,5609,8358,8927,2737,8389,8915,5371,8681,8698,9041,8817,4131,8869,8884,8442,4901,4544,7823,1257,2677,4519,8901,3860,7583,659,7304,6134,4860,446,501,4178,7548,5371,7840,7878,7879,7635,4834,7787,3850,2009,5421,1453,850,6563,6568,3913,8526,6726,8903,8816,8814,9030,223,463,9085,8094,8095,8488,9052,223,6740,7238,8220,9379,9321,1738,6809,9422,9198,8241,7374,186,7681,1215,2749,6843,6004,7160,2992,7304,1537,2473,7548,7205,3860,6740,7238,3860,7840,8220,3549,6189,5334,7387,51,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,10385,10443,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,6718,1726,6646,1738,7159,947,4234,7576,6632,6809,1766,1768,2932,1351,3860,6366,6725,7840,6189,7570,7762,3913,6726,8109,2889,7635,8142,5551,4986,8390,7635,7020,8297,7840,8109,3029,7879,1770,1765,8815,8730,8183,9030,215,4128,2632,501,3241,5799,5070,3936,3964,3989,4061,3100,4656,1461,6743,396,3830,4527,4834,1057,3644,2639,2261,6645,4131,6793,6595,6214,3874,6796,323,7022,1699,5362,1152,7286,7268,6212,1718,6216,6221,3761,7641,6218,6117,2687,6104,1181,6443,5142,4860,6607,6385,1770,1771,1765,1768,1769,1766,8258,5817,3625,3884,766,4109,5576,955,6845,3728,1568,6635,4126,3415,1055,1647,1727,2299,4689,961,3850,4424,6588,1826,1532,734,2398,1371,6215,3896,186,665,1461,5742,223,7635,840,947,7114,7389,7241,7111,4362,7147,5887,7068,7095,7110,7258,7123,7100,7082,7116,7112,7088,7276,7072,1828,1726,7092,2342,8048,7675,7152,7675,7086,7117,8033,7096,7071,8082,4860,1371,3941,3860,2976,5764,6315,5020,3561,4566,252,793,1402,836,4234,5321,3100,5088,606,5764,4969,5286,5837,6779,3037,1907,1137,1690,4875,6686,8215,7156,1176,7840,5541,1177,1190,2324,4766,4223,2381,2882,3525,5795,5543,7875,1835,3921,6635,4088,6639,8004,1439,1163,5373,7919,9073,9086,3625,8901,252,5142,1521,1137,5131,7858,9243,2657,3715,8793,3493,7016,8902,8888,4056,1177,7582,8629,228,6866,9376,8901,9464,8900,5541,9402,9376,7883,6707,5379,7017,8999,2294,8900,7875,8548,6713,8819,5339,9638,2957,9197,9654,5817,9637,1347,5545,7126,9766,9552,3754,9798,9335,9807,9879,1253,1461,1699,9925,2933,7017,7839,9764,8978,4258,608,9921,7126,8548,9454,4460,9680,6858,9932,8999,10056,9661,9542,9961,10055,9993,10036,9929,10134,9769,9952,10116,5986,4805,4701,2976,9421,9453,2025,9273,9904,10063,4209,10065,10229,10244,8151,9897,10079,10212,10042,10243,10244,9665,10053,10118,773,10245,10211,10149,4652,9541,9347,10258,10227,9045,4337,9249,10307,10377,9831,8805,10342,10355,9476,10245,10062,10246,10266,8934,8915,10523,10524,10473,9833,10548,10397,10568,10523,10528,10127,10627,10416,10348,4665,8010,6248,10246,10628,7718,10350,10569,10734,10879,10735,10899,10341,10798,3413,10870,10300,7614,8795,10737,10938,10375,10814,7615,10894,10711,10608,11020,11021,11023,11018,10972,11042,10913,11089,10878,10765,10893,10911,11121,9930,11122,11126,11123,8948,11100,11142,3003,10749,10783,10784,11171,9072,3288,11220,11219,6117,10530,11234,11230,11237,11235,2992,7548,7879,7840,7878,176,186,6633,7106,5647,1662,3860,1511,7268,2594,8230,3409,8227,3241,924,6940,7020,5657,7812,7943,8109,8223,6971,7160,7548,6726,8296,8230,8049,8526,8526,8064,2992,8357,8357,2473,7110,8512,8033,6773,7669,8503,8503,7074,7304,8903,7714,8051,7714,7272,9030,8960,9040,7903,8420,8020,9309,7897,7897,9525,8961,8961,8961,2157,4769,1774,1774,8834,5882,6235,7086,6364,3337,6845,6364,8401,3913,3913,3913,3913,7276,6740,6740,8783,8783,8783,8783,8783,8783,8783,5148,4234,4121,4121,6571,5719,2706,735,1257,6152,6151,3359,4305,6596,261,314,3074,6830,3702,7915,3334,7722,7938,1811,1831,567,8250,7992,1783,8316,3883,8411,8732,2520,4296,8892,546,9152,8683,8475,8627,9037,7666,9300,7174,8648,8948,7967,7304,5576,2869,7261,834,7079,4405,5371,7666,8361,7115,7106,7897,8463,7286,8251,7286,8251,7287,7715,7287,7715,6940,8450,8240,7938,8362,7671,5262,7243,1126,8644,7906,7072,2033,8469,8852,8891,7109,3882,8891,7270,3892,8438,7270,3893,7294,8365,8769,7266,8724,8576,215,8569,8530,3890,8285,3989,8359,501,7959,8240,8798,8208,5070,5148,8470,5995,7935,3830,7638,8400,2951,735,8236,7125,7096,8641,8227,8050,8407,8396,8364,8396,8364,7265,4131,8422,7265,8422,4580,7297,8042,547,7115,547,7115,8085,9204,8771,7105,8792,1349,7675,8772,7354,8772,7354,9315,6315,9611,8909,9611,8909,9743,9744,9134,2706,9134,2706,6595,9053,6595,9053,5995,7155,5995,7155,5995,7155,8809,9877,8759,9745,8759,9745,510,1145,7665,9378,10320,9561,9564,9480,8832,9259,7273,7152,7116,7093,7092,5331,7072,6794,5904,6785,2262,6633,186,6139,3860,7304,6845,7991,7210,7223,3860,5371,4563,6740,7981,5763,2761,223,7988,7937,7840,7037,2989,5839,6591,7824,6163,6891,7982,3860,7304,6740,1537,2992,8220,3885,7987,7903,7833,182,8859,9030,7304,1537,3860,7713,7251,6754,3090,6763,4362,6740,6368,7238,5995,7840,8220,6693,3860,1767,1767,1767,1767,1343,7013,7013,7304,665,8366,7890,7576,7884,1537,9284,4079,7783,6740,7147,6177,3760,7146,7812,8143,7548,7602,8519,2573,2573,2473,2473,6633,1371,7863,7787,4834,4834,7831,1029,6001,7878,7878,7878,6589,6589,6589,7604,1200,1245,7666,8034,8034,8439,8439,7304,7304,7304,7304,7304,7304,7304,7304,7304,7304,7304,7878,8094,3165,4834,6845,396,3913,8358,8306,7840,3702,319,3557,916,6700,6103,6131,754,3908,240,7304,3860,5992,7897,6766,1537,793,8281,7928,8223,5770,2029,7175,1343,2658,7391,7160,7833,8296,7205,8503,8818,9085,8464,6122,8512,9681,3885,3889,176,3644,7102,7076,7094,3863,3863,3863,7111,3863,3863,3863,7258,7258,8833,6799,8064,8354,8354,4317,7096,7082,7112,7093,7294,7106,8049,7119,7087,7116,8211,8208,8033,8209,8144,7664,7268,7072,7152,7273,8069,7117,8040,7266,8047,7897,7943,8077,8055,8061,8057,8085,8076,8081,8369,8370,8268,7258,7245,7659,8652,8050,8461,7574,8394,8463,7975,8465,8792,8476,8083,7114,8282,8466,7273,7661,7662,8050,7124,7096,7943,8385,9160,8285,8652,8724,7293,8165,7235,7721,650,7001,6565,6076,6544,6669,377,7230,6122,3879,4714,7855,6998,5735,943,6031,2571,6993,1537,2473,7237,6444,8168,2530,7231,772,6675,743,6678,6575,7051,6827,8230,7232,1829,7034,7224,6571,3843,8512,8541,6421,6882,6422,3778,6425,2469,7779,6424,4219,652,7758,7635,567,986,7228,8142,3429,6191,3351,6937,6726,6933,1967,7856,8290,6023,539,3892,6562,3891,3883,1461,313,533,6736,272,223,8542,3885,41,7019,7986,8434,7985,7813,8324,7024,6354,7568,9300,9936,5421,10032,8003,3877,8585,8883,7870,10214,8682,10099,10158,8618,6034,10238,7588,6386,510,7772,10041,173,1160,1441,10344,3825,10519,5096,10644,10607,10325,10563,9521,9520,10555,9515,10551,10640,10797,10836,10828,10796,10545,10794,10795,10793,10791,9386,10522,10790,10829,8717,9191,10750,4302,4463,3890,8273,10846,8260,9192,11019,7372,6485,3830,6175,7737,6740,8370,675,6517,515,8229,6402,7649,7819,7116,6364,7740,8372,7121,7079,8373,7094,8373,7265,7265,7100,7118,7118,7088,8379,7105,8375,8050,7287,7106,7702,7654,6382,6382,7675,7094,9132,9579,7006,8203,7548,8540,6740,6740,4607,4607,4607,6710,2033,4223,4860,501,2932,1461,766,4798,5070,585,1690,4796,1038,3989,3037,2706,3904,6863,6693,3595,4061,5148,4969,2632,2261,4234,5995,1325,3830,1215,5799,1257,3241,4209,4656,5179,3080,5286,2657,739,36,6779,6679,4886,3964,504,446,228,5543,2976,3493,5331,2294,7143,608,6858,6595,1699,5795,7126,4258,1137,5817,1253,7709,5545,4460,997,5339,4178,3059,3080,4635,2933,4839,1347,6981,5207,5142,3775,7019,6632,4879,5193,3525,6986,1917,4566,748,1347,3100,233,7582,6842,3542,7761,5373,2337,7883,2894,6010,6713,4131,7920,1521,7759,7839,1369,215,2658,969,2025,802,7238,8193,6740,5236,4987,8548,6713,7138,7760,7095,7572,7118,7108,3860,7967,6832,6832,7213,7897,7897,7661,7661,6523,389,5165,2992,8268,1537,7104,8055,7263,7602,8033,7258,8087,8087,6388,7082,7252,7076,7079,7705,6521,6212,6223,7698,9781,9591,9592,6656,7844,9312,9590,6220,6497,6498,6222,6496,6216,6501,6215,6218,6221,6214,6499,1770,1765,1771,1767,1769,7261,7261,7121,7113,7069,1537,1537,9030,8199,4769,7647,7647,3409,7107,2843,6483,314,3874,314,7078,6984,8145,3860,4224,2520,7100,5066,6658,7289,7816,7816,5897,2992,1537,3172,7783,4597,8683,6350,8161,2632,1250,7548,7548,4801,4801,8820,7160,8223,8526,8547,8815,3874,4682,7120,7297,7642,6261,5995,7967,4337,6364,4022,7012,6315,1215,1215,802,7266,7967,7252,231,7075,7246,1257,7666,3860,6714,7473,7096,446,8412,7270,6728,3341,7967,7083,7270,7075,7151,8741,3760,8409,8395,8064,8407,8820,7120,7294,2992,7491,3803,7897,3510,7070,7078,7283,6386,7906,8157,3860,7068,8397,2992,2290,8415,1537,7304,2951,7897,7100,8743,7939,7088,8080,8422,7252,7644,7830,5647,7588,252,2736,1533,1210,1210,466,8454,464,8287,8909,8585,9084,8682,7912,4834,4986,3165,8665,4405,801,8816,2290,8815,7024,4834,5995,7304,446,446,8520,4259,5419,8220,7635,9209,8142,8512,840,924,5402,6103,7878,8088,4395,1398,5770,7505,7505,7301,7301,4639,6239,7374,7374,820,820,6613,8306,8828,8828,8828,8828,8828,8828,8828,8828,7130,5421,8973,8973,8973,8973,8973,9471,1771,1770,10041,1771,1767,1767,1767,1767,1767,8864,4199,6809,9391,1766,4178,5995,1967,2869,5134,446,4701,8436,8142,1185,2261,1537,6986,1768,6519,6523,5864,1766,6532,2720,6498,6507,4300,6222,6497,6515,1767,2795,6200,4301,4936,6503,4305,6371,6529,4301,2720,4293,2780,2785,6504,2783,2778,2781,2779,2782,2784,2786,4290,4298,2787,6530,4300,4282,1766,1769,2818,2824,1764,1767,6263,222,3071,2789,6489,6531,4286,6354,3070,2823,1245,6198,6201,6199,6200,1767,1766,6354,3073,7137,511,7299,7300,7134,1767,2808,2803,3888,3885,2791,2820,2801,2802,2805,2807,2806,2794,6546,1769,2826,2827,2828,6514,1245,5576,1351,2869,834,3884,3882,7160,6515,6456,3891,3893,3896,3892,3890,7567,3897,6493,6271,6507,2720,7300,2677,2995,510,6523,6371,6743,3029,7548,6218,6199,6373,6223,6527,6201,810,2522,6354,6546,3070,7751,6689,3073,3071,1769,6750,7599,6746,7870,6749,2018,7753,6751,3889,3882,6599,374,810,379,391,387,6066,384,378,382,375,394,376,6082,1266,7215,7054,3898,1250,4178,5647,7752,6354,1766,7598,7600,7676,7137,7631,6809,4445,4827,4512,6354,3070,3073,3071,6689,550,7677,7168,7167,7170,7165,7163,7173,7164,7959,7922,7054,6985,7752,1767,1765,1769,1766,6168,7986,2522,1741,6354,8233,8232,6880,3071,3521,2389,3070,8272,2822,2823,2826,7238,8245,2728,2893,8294,7787,8432,344,8316,8220,8313,6509,6508,8307,7238,1767,6197,8520,8514,8315,8318,1769,5909,6520,8233,8246,8334,6521,8331,6513,6514,6507,6515,8358,4639,4535,5576,2869,834,1351,1741,8481,6505,6261,3913,3085,8698,8681,3850,5647,8682,6534,6537,4178,6535,8730,8520,8333,8649,601,2170,2390,3610,8342,6641,8596,8691,8814,8817,8815,8520,8142,567,7634,7635,5551,8617,8719,2520,8591,8717,2522,8681,2522,8681,8780,8944,8817,7881,9041,8683,2253,4535,8826,8682,8945,6168,223,9030,4639,311,8358,8698,4834,2992,8175,6691,8727,2925,8232,8551,8681,3913,3172,9390,1232,3165,4178,5068,9736,10297,9390,9951,10364,10238,6971,9334,3646,10353,6209,9934,8514,3731,10164,9084,223,4639,6250,10527,7554,7592,4218,8555,6712,5567,8290,10505,10656,3646,10547,10531,7910,7756,10339,9669,10364,9670,1257,4178,446,5376,222,9543,10865,10654,10877,6611,10296,10786,8306,7636,8681,6521,8698,8822,8816,8400,5995,8220,7108,7108,7842,8063,7084,376,8354,8765,8765,8387,8387,7975,8093,7714,3860,8143,9010,8983,8371,8071,9056,8982,8878,9049,5386,6223,4386,7178,7188,766,3830,501,4301,7698,2992,2605,7187,6377,2063,2290,3515,7696,7304,4297,8899,4301,8728,2594,8434,8949,3888,8729,391,7548,3890,3885,1492,7160,6749,3889,7987,7986,1462,377,6076,8968,1462,8968,3890,372,6593,387,7576,6593,7576,6593,7576,7985,8271,314,8389,6174,6175,9030,1726,6493,8272,3891,3883,1726,3897,378,8878,8877,7576,392,7599,7576,4473,389,3894,3884,3881,2992,368,2145,376,6076,6361,915,6361,6066,1108,1167,546,8267,8788,8223,390,8223,3892,9537,9547,8789,5956,4979,5956,9536,9536,6843,9266,6843,9266,8858,365,6204,6593,365,6593,6750,8878,9616,6743,6751,8390,8981,8983,6750,9879,6746,8879,6746,8879,8980,7196,8167,9950,9692,8230,9692,8230,9525,7588,6745,6386,6745,6386,6743,9890,10167,6916,7610,6745,10263,9829,7304,4936,8358,8358,8230,8230,6984,6984,2992,1973,6658,2520,6386,6386,8596,6719,8345,8345,3172,6444,7721,6966,6383,8352,6969,7805,1828,7805,6658,5956,1979,8661,8616,8616,7147,7110,8211,7252,2992,2992,1537,5188,1242,6283,7162,7199,5717,8639,3702,8208,1537,8081,8274,8223,3860,6587,9030,8236,9032,8386,2033,7646,3883,7260,7260,6594,8445,8514,8460,5961,8424,6817,7655,7715,7077,8289,8439,4774,8423,7605,8386,8398,8034,6,8400,8395,8423,8384,7100,7100,7650,7650,7666,7644,7104,7879,5995,7548,7878,1461,3754,233,4109,1520,231,1738,1228,1532,186,8222,358,4185,8390,223,2727,4639,8358,6842,6155,2889,8306,6589,8103,6588,8109,6639,8514,6366,567,6726,4131,3754,2706,2029,6178,7992,4796,8222,2989,7995,8816,8910,5362,8230,3604,2253,6971,8547,7674,8770,7288,7081,8424,2992,8641,7273,7107,9030,7273,7250,7117,8395,8384,8282,6813,9386,8770,1998,840,7304,272,8961,8439,9028,7075,1126,1145,2331,4432,8019,5251,3368,947,8220,5956,3875,4178,6768,6388,1704,8547,6218,6223,6521,744,1600,467,423,470,645,9770,9566,5312,8000,4830,4984,5218,4423,3136,4008,1474,1593,8894,9378,1460,1098,4164,4165,89,2760,4395,3370,1234,435,9533,9418,5306,3067,2904,1407,3541,4944,1662,8389,10102,10110,1593,6740,10098,10107,8305,6212,10269,7869,2164,4788,9675,1425,5218,2776,9676,10054,1561,2904,7033,10442,89,661,1092,1318,1407,2904,3094,4165,8241,4301,10913,10983,10999,11008,4160,11009,11006,11021,11020,10142,467,744,1407,3541,4964,5312,5402,6832,6691,8968,2328,5371,1521,6645,5582,3346,850,4362,6831,1371,421,6795,7602,4798,223,6890,5927,9694,6785,7214,7639,9900,9386,6687,5543,5142,8876,9244,9362,9389,9387,7144,3728,10129,9497,10116,9951,10001,3081,10313,6130,10312,6889,1453,8828,10956,10517,10240,9959,7783,6633,3414,4834,4399,10818,10131,5947,9354,2467,3878,9545,104,156,7613,8219,4535,1095,7773,4395,3428,4395,2932,4209,4079,8902,1955,9630,8092,526,546,4796,4769,5995,4860,9761,9746,1439,9785,10002,9808,7920,9750,840,608,7839,9668,3941,9925,9638,9220,10173,10165,10149,6632,10243,10115,10135,10245,10233,10229,10244,9993,10042,107,10148,10188,10243,10246,10284,9406,5647,9453,10266,840,5419,10440,1461,10080,10258,10380,665,10283,10439,10141,1215,10212,10268,3913,10314,10375,3989,4861,5148,9052,5799,1257,10062,10227,3241,2706,8893,6842,5070,9602,8514,9420,4234,2632,766,10787,4861,4901,2894,2594,8517,10879,10894,501,396,10128,10895,10315,6842,10375,10306,9453,8306,435,947,7985,1145,6855,28,8274,4752,7810,9049,3872,8260,4520,7654,8793,8222,8520,7106,7019,8826,1766,1767,3860,7304,2992,1537,9030,7897,223,8514,8910,6551,6556,4769,8933,9215,9533,6600,3892,7175,3893,7304,1537,7238,9367,7986,7985,2992,6354,9907,7972,3070,3073,10036,4302,4305,9906,9879,3071,6689,6688,7752,8088,8627,9037,9970,10254,8946,8727,10056,9665,10053,9473,9474,10298,9475,8698,8681,9670,9669,9671,9131,9673,9672,842,10477,8582,10429,9906,9854,3884,8825,2520,8665,6076,2843,9030,8651,1730,10292,3890,3884,8667,10371,6390,6381,8203,10417,9156,8530,6746,8789,389,8858,384,390,376,5882,391,10813,10502,10292,3247,7659,8418,10404,8220,8401,9295,2029,10689,9322,10547,10615,7674) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC