- Error type:
MySQL Error
- Source, line:
Parser::tws_filters[582]
- Error message:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND s.status_key <> 'kAbsent'
...' at line 29
SELECT iv.id, COUNT(1) num
FROM ms_store_info si105,ms_store_info si103,ms_store_info si3,ms_store_info si51, ms_store s, ms_store_info sif USE INDEX(store_value), ms_info_value iv
WHERE si105.info_id=105 AND si105.value_id IN (403,0) AND s.id=si105.store_id AND si103.info_id=103 AND si103.value_id IN (800,0) AND s.id=si103.store_id AND si3.info_id=3 AND si3.value_id IN (474,0) AND s.id=si3.store_id AND si51.info_id=51 AND si51.value_id IN (392,0) AND s.id=si51.store_id AND s.kind_key='kDefault' AND s.no_visible=0 AND s.id=sif.store_id AND iv.id=sif.value_id
AND sif.info_id IN (4,127,0)
AND s.id IN (20,22,23,28,29,31,32,42,45,47,48,64,143,159,164,165,171,172,174,183,184,388,436,443,445,448,451,453,459,461,462,465,466,467,468,475,477,479,481,482,484,486,501,510,511,512,516,519,520,526,533,537,538,541,544,648,655,656,664,665,666,667,675,678,679,683,685,687,688,695,700,701,712,713,716,719,725,726,737,738,739,741,747,748,749,751,754,756,758,760,761,764,765,768,774,781,784,795,803,811,818,822,824,832,835,839,850,851,872,887,888,890,891,916,918,921,924,926,940,945,974,2167,2180,2200,2220,2250,2260,2263,2265,2275,2320,2325,2333,2337,3074,3089,3100,3101,3108,3118,3120,3129,3141,3143,3144,3145,3146,3156,3211,3238,3244,3246,3265,3276,3277,3286,3308,3309,3310,3312,3365,3366,3371,3378,3384,3389,3390,3397,3400,3407,3409,3419,3422,3423,3449,3452,3483,3491,3492,3583,3606,3614,3630,3637,3645,3664,3710,3718,3773,3775,3872,3873,3878,3879,3886,3890,3892,3895,3896,3901,3902,3903,3904,3907,3943,3946,3955,3978,4002,4028,4039,4041,4043,4096,4160,4170,4189,4191,4249,4250,4271,4353,4355,4359,4361,4390,5827,6162,6406,6429,6459,6473,6550,6556,6697,6707,6708,6709,6745,7417,7431,8191,8192,8198,8202,8205,8208,8213,8214,8226,8231,8232,8235,8236,8241,8242,8243,8244,8245,8246,8247,8248,8249,8250,8253,8254,8258,8259,8261,8262,8263,8264,8266,8272,8273,8283,8284,8285,8286,8287,8293,8295,8299,8301,8302,8303,8304,8305,8308,8309,8313,8318,8322,8323,8325,8328,8336,8337,8345,8346,8349,8350,8351,8352,8355,8356,8360,8362,8375,8382,8383,8384,8385,8386,8390,8391,8392,8393,8394,8397,8398,8399,8401,8406,8407,8408,8409,8410,8415,8416,8420,8421,8422,8423,8425,8428,8429,8431,8432,8433,8434,8435,8437,8439,8441,8442,8443,8445,8446,8447,8449,8453,8459,8460,8465,8467,8468,8471,8472,8473,8474,8476,8479,8481,8483,8484,8485,8486,8491,8495,8502,8503,8505,8507,8508,8510,8512,8513,8514,8515,8516,8517,8519,8520,8521,8522,8523,8524,8525,8526,8527,8528,8529,8530,8531,8532,8533,8534,8535,8536,8537,8538,8539,8540,8541,8542,8544,8546,8548,8549,8550,8551,8553,8554,8555,8556,8557,8625,8640,8661,8665,8669,8683,8729,8732,8757,8773,8778,8779,8791,8795,8811,8812,8816,8817,8829,8923,8924,8952,8954,9010,9014,9033,9047,9062,9074,9121,9190,9229,9263,9310,9512,9559,9609,9610,9682,9684,9703,9906,9911,9917,9920,9981,12006,12008,12012,12037,12041,12065,12066,12068,12070,12071,12634,12635,16059,16077,16078,16079,16085,21626,21627,21628,23058,23612)
AND s.status_key <> 'kAbsent'
GROUP BY iv.id
UNION ALL
SELECT iv.id, COUNT(1) num
FROM ms_store s, ms_store_info sif, ms_info_value iv
WHERE s.kind_key='kDefault' AND s.no_visible=0 AND s.id=sif.store_id AND
iv.id=sif.value_id AND sif.info_id = 105
AND s.id IN (20,22,23,28,29,31,32,42,45,47,48,64,143,159,164,165,171,172,174,183,184,388,436,443,445,448,451,453,459,461,462,465,466,467,468,475,477,479,481,482,484,486,501,510,511,512,516,519,520,526,533,537,538,541,544,648,655,656,664,665,666,667,675,678,679,683,685,687,688,695,700,701,712,713,716,719,725,726,737,738,739,741,747,748,749,751,754,756,758,760,761,764,765,768,774,781,784,795,803,811,818,822,824,832,835,839,850,851,872,887,888,890,891,916,918,921,924,926,940,945,974,2167,2180,2200,2220,2250,2260,2263,2265,2275,2320,2325,2333,2337,3074,3089,3100,3101,3108,3118,3120,3129,3141,3143,3144,3145,3146,3156,3211,3238,3244,3246,3265,3276,3277,3286,3308,3309,3310,3312,3365,3366,3371,3378,3384,3389,3390,3397,3400,3407,3409,3419,3422,3423,3449,3452,3483,3491,3492,3583,3606,3614,3630,3637,3645,3664,3710,3718,3773,3775,3872,3873,3878,3879,3886,3890,3892,3895,3896,3901,3902,3903,3904,3907,3943,3946,3955,3978,4002,4028,4039,4041,4043,4096,4160,4170,4189,4191,4249,4250,4271,4353,4355,4359,4361,4390,5827,6162,6406,6429,6459,6473,6550,6556,6697,6707,6708,6709,6745,7417,7431,8191,8192,8198,8202,8205,8208,8213,8214,8226,8231,8232,8235,8236,8241,8242,8243,8244,8245,8246,8247,8248,8249,8250,8253,8254,8258,8259,8261,8262,8263,8264,8266,8272,8273,8283,8284,8285,8286,8287,8293,8295,8299,8301,8302,8303,8304,8305,8308,8309,8313,8318,8322,8323,8325,8328,8336,8337,8345,8346,8349,8350,8351,8352,8355,8356,8360,8362,8375,8382,8383,8384,8385,8386,8390,8391,8392,8393,8394,8397,8398,8399,8401,8406,8407,8408,8409,8410,8415,8416,8420,8421,8422,8423,8425,8428,8429,8431,8432,8433,8434,8435,8437,8439,8441,8442,8443,8445,8446,8447,8449,8453,8459,8460,8465,8467,8468,8471,8472,8473,8474,8476,8479,8481,8483,8484,8485,8486,8491,8495,8502,8503,8505,8507,8508,8510,8512,8513,8514,8515,8516,8517,8519,8520,8521,8522,8523,8524,8525,8526,8527,8528,8529,8530,8531,8532,8533,8534,8535,8536,8537,8538,8539,8540,8541,8542,8544,8546,8548,8549,8550,8551,8553,8554,8555,8556,8557,8625,8640,8661,8665,8669,8683,8729,8732,8757,8773,8778,8779,8791,8795,8811,8812,8816,8817,8829,8923,8924,8952,8954,9010,9014,9033,9047,9062,9074,9121,9190,9229,9263,9310,9512,9559,9609,9610,9682,9684,9703,9906,9911,9917,9920,9981,12006,12008,12012,12037,12041,12065,12066,12068,12070,12071,12634,12635,16059,16077,16078,16079,16085,21626,21627,21628,23058,23612)
AND s.status_key <> 'kAbsent'
GROUP BY iv.id
UNION ALL
SELECT iv.id, COUNT(1) num
FROM ms_store s, ms_store_info sif, ms_info_value iv
WHERE s.kind_key='kDefault' AND s.no_visible=0 AND s.id=sif.store_id AND
iv.id=sif.value_id AND sif.info_id = 3
AND s.id IN (443)
AND s.status_key <> 'kAbsent'
GROUP BY iv.id
UNION ALL
SELECT iv.id, COUNT(1) num
FROM ms_store s, ms_store_info sif, ms_info_value iv
WHERE s.kind_key='kDefault' AND s.no_visible=0 AND s.id=sif.store_id AND
iv.id=sif.value_id AND sif.info_id = 103
AND s.id IN ()
AND s.status_key <> 'kAbsent'
GROUP BY iv.id
UNION ALL
SELECT iv.id, COUNT(1) num
FROM ms_store s, ms_store_info sif, ms_info_value iv
WHERE s.kind_key='kDefault' AND s.no_visible=0 AND s.id=sif.store_id AND
iv.id=sif.value_id AND sif.info_id = 51
AND s.id IN (20,22,23,28,29,31,32,42,45,47,48,64,143,159,164,165,171,172,174,183,184,388,436,443,445,448,451,453,459,461,462,465,466,467,468,475,477,479,481,482,484,486,501,510,511,512,516,519,520,526,533,537,538,541,544,648,655,656,664,665,666,667,675,678,679,683,685,687,688,695,700,701,712,713,716,719,725,726,737,738,739,741,747,748,749,751,754,756,758,760,761,764,765,768,774,781,784,795,803,811,818,822,824,832,835,839,850,851,872,887,888,890,891,916,918,921,924,926,940,945,974,2167,2180,2200,2220,2250,2260,2263,2265,2275,2320,2325,2333,2337,3074,3089,3100,3101,3108,3118,3120,3129,3141,3143,3144,3145,3146,3156,3211,3238,3244,3246,3265,3276,3277,3286,3308,3309,3310,3312,3365,3366,3371,3378,3384,3389,3390,3397,3400,3407,3409,3419,3422,3423,3449,3452,3483,3491,3492,3583,3606,3614,3630,3637,3645,3664,3710,3718,3773,3775,3872,3873,3878,3879,3886,3890,3892,3895,3896,3901,3902,3903,3904,3907,3943,3946,3955,3978,4002,4028,4039,4041,4043,4096,4160,4170,4189,4191,4249,4250,4271,4353,4355,4359,4361,4390,5827,6162,6406,6429,6459,6473,6550,6556,6697,6707,6708,6709,6745,7417,7431,8191,8192,8198,8202,8205,8208,8213,8214,8226,8231,8232,8235,8236,8241,8242,8243,8244,8245,8246,8247,8248,8249,8250,8253,8254,8258,8259,8261,8262,8263,8264,8266,8272,8273,8283,8284,8285,8286,8287,8293,8295,8299,8301,8302,8303,8304,8305,8308,8309,8313,8318,8322,8323,8325,8328,8336,8337,8345,8346,8349,8350,8351,8352,8355,8356,8360,8362,8375,8382,8383,8384,8385,8386,8390,8391,8392,8393,8394,8397,8398,8399,8401,8406,8407,8408,8409,8410,8415,8416,8420,8421,8422,8423,8425,8428,8429,8431,8432,8433,8434,8435,8437,8439,8441,8442,8443,8445,8446,8447,8449,8453,8459,8460,8465,8467,8468,8471,8472,8473,8474,8476,8479,8481,8483,8484,8485,8486,8491,8495,8502,8503,8505,8507,8508,8510,8512,8513,8514,8515,8516,8517,8519,8520,8521,8522,8523,8524,8525,8526,8527,8528,8529,8530,8531,8532,8533,8534,8535,8536,8537,8538,8539,8540,8541,8542,8544,8546,8548,8549,8550,8551,8553,8554,8555,8556,8557,8625,8640,8661,8665,8669,8683,8729,8732,8757,8773,8778,8779,8791,8795,8811,8812,8816,8817,8829,8923,8924,8952,8954,9010,9014,9033,9047,9062,9074,9121,9190,9229,9263,9310,9512,9559,9609,9610,9682,9684,9703,9906,9911,9917,9920,9981,12006,12008,12012,12037,12041,12065,12066,12068,12070,12071,12634,12635,16059,16077,16078,16079,16085,21626,21627,21628,23058,23612)
AND s.status_key <> 'kAbsent'
GROUP BY iv.id