System error in Melbis Shop 6.1.1



Error occured in script work

Error occured, script stoped


Error type: MySQL Error

Source, line: Parser::tws_filters[285]

Error: 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 ') GROUP BY iv.id ' at line 54

Error information:

 SELECT iv.id, COUNT(1) num
                    FROM MS_store_info si111,MS_store_info si845, MS_store s, MS_store_info sif, MS_info_value iv
                    WHERE  si111.info_id=111 AND si111.value_id IN (75064,36694,0) AND s.id=si111.store_id AND si845.info_id=845 AND si845.value_id IN (75074,75076,0) AND s.id=si845.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 (13,847,773,873,875,12,844,0)
                        AND s.id IN (231629,120111,336619,347550,194885,326203,334998,334999,467065,467066,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,471702,471703,335009,318775,318774,501320,101405,367063)
                    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 IN (price)
                                        AND s.id IN (282624,299557,299561,337002,410397,410399,410402,410403,410404,410406,410407,410409,410410,347186,414236,414196,405072,405075,405073,325711,476710,484634,405071,410386,476573,476572,431430,493725,493726,493724,493727,493728,476382,476381,476385,476348,476383,476384,500053,500054,501289,501291,490406,498087,493729,502157,502483,501290,231629,235191,268730,325716,120111,334996,77597,336619,347551,347550,194885,114099,291208,320511,326203,299476,299477,300309,300310,347590,334998,334999,412546,412547,431447,431448,268746,268748,431450,467065,467066,414239,470522,470523,470526,470527,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,467724,471692,471696,471701,471702,471703,471704,471705,471708,471709,476529,470525,449045,484641,476347,335009,347661,122105,194881,471700,477125,490414,467726,467727,467725,471694,367073,471706,318775,318774,501320,101405,502147,502149,470524,502148,367063,477103,477100,477092,477101,477106,477111,467037,477105,477089)
                                    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 IN (price)
                                        AND s.id IN (282624,299557,299561,337002,410397,410399,410402,410403,410404,410406,410407,410409,410410,347186,414236,414196,405072,405075,405073,325711,476710,484634,405071,410386,476573,476572,431430,493725,493726,493724,493727,493728,476382,476381,476385,476348,476383,476384,500053,500054,501289,501291,490406,498087,493729,502157,502483,501290,231629,235191,268730,325716,120111,334996,77597,336619,347551,347550,194885,114099,291208,320511,326203,299476,299477,300309,300310,347590,334998,334999,412546,412547,431447,431448,268746,268748,431450,467065,467066,414239,470522,470523,470526,470527,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,467724,471692,471696,471701,471702,471703,471704,471705,471708,471709,476529,470525,449045,484641,476347,335009,347661,122105,194881,471700,477125,490414,467726,467727,467725,471694,367073,471706,318775,318774,501320,101405,502147,502149,470524,502148,367063,477103,477100,477092,477101,477106,477111,467037,477105,477089)
                                    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 IN (price)
                                        AND s.id IN (282624,299557,299561,337002,410397,410399,410402,410403,410404,410406,410407,410409,410410,347186,414236,414196,405072,405075,405073,325711,476710,484634,405071,410386,476573,476572,431430,493725,493726,493724,493727,493728,476382,476381,476385,476348,476383,476384,500053,500054,501289,501291,490406,498087,493729,502157,502483,501290,231629,235191,268730,325716,120111,334996,77597,336619,347551,347550,194885,114099,291208,320511,326203,299476,299477,300309,300310,347590,334998,334999,412546,412547,431447,431448,268746,268748,431450,467065,467066,414239,470522,470523,470526,470527,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,467724,471692,471696,471701,471702,471703,471704,471705,471708,471709,476529,470525,449045,484641,476347,335009,347661,122105,194881,471700,477125,490414,467726,467727,467725,471694,367073,471706,318775,318774,501320,101405,502147,502149,470524,502148,367063,477103,477100,477092,477101,477106,477111,467037,477105,477089)
                                    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 IN (price)
                                        AND s.id IN (282624,299557,299561,337002,410397,410399,410402,410403,410404,410406,410407,410409,410410,347186,414236,414196,405072,405075,405073,325711,476710,484634,405071,410386,476573,476572,431430,493725,493726,493724,493727,493728,476382,476381,476385,476348,476383,476384,500053,500054,501289,501291,490406,498087,493729,502157,502483,501290,231629,235191,268730,325716,120111,334996,77597,336619,347551,347550,194885,114099,291208,320511,326203,299476,299477,300309,300310,347590,334998,334999,412546,412547,431447,431448,268746,268748,431450,467065,467066,414239,470522,470523,470526,470527,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,467724,471692,471696,471701,471702,471703,471704,471705,471708,471709,476529,470525,449045,484641,476347,335009,347661,122105,194881,471700,477125,490414,467726,467727,467725,471694,367073,471706,318775,318774,501320,101405,502147,502149,470524,502148,367063,477103,477100,477092,477101,477106,477111,467037,477105,477089)
                                    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 IN (price)
                                        AND s.id IN (282624,299557,299561,337002,410397,410399,410402,410403,410404,410406,410407,410409,410410,347186,414236,414196,405072,405075,405073,325711,476710,484634,405071,410386,476573,476572,431430,493725,493726,493724,493727,493728,476382,476381,476385,476348,476383,476384,500053,500054,501289,501291,490406,498087,493729,502157,502483,501290,231629,235191,268730,325716,120111,334996,77597,336619,347551,347550,194885,114099,291208,320511,326203,299476,299477,300309,300310,347590,334998,334999,412546,412547,431447,431448,268746,268748,431450,467065,467066,414239,470522,470523,470526,470527,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,467724,471692,471696,471701,471702,471703,471704,471705,471708,471709,476529,470525,449045,484641,476347,335009,347661,122105,194881,471700,477125,490414,467726,467727,467725,471694,367073,471706,318775,318774,501320,101405,502147,502149,470524,502148,367063,477103,477100,477092,477101,477106,477111,467037,477105,477089)
                                    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 IN (price)
                                        AND s.id IN (282624,299557,299561,337002,410397,410399,410402,410403,410404,410406,410407,410409,410410,347186,414236,414196,405072,405075,405073,325711,476710,484634,405071,410386,476573,476572,431430,493725,493726,493724,493727,493728,476382,476381,476385,476348,476383,476384,500053,500054,501289,501291,490406,498087,493729,502157,502483,501290,231629,235191,268730,325716,120111,334996,77597,336619,347551,347550,194885,114099,291208,320511,326203,299476,299477,300309,300310,347590,334998,334999,412546,412547,431447,431448,268746,268748,431450,467065,467066,414239,470522,470523,470526,470527,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,467724,471692,471696,471701,471702,471703,471704,471705,471708,471709,476529,470525,449045,484641,476347,335009,347661,122105,194881,471700,477125,490414,467726,467727,467725,471694,367073,471706,318775,318774,501320,101405,502147,502149,470524,502148,367063,477103,477100,477092,477101,477106,477111,467037,477105,477089)
                                    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 IN (111)
                                        AND s.id IN ()
                                    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 IN (111)
                                        AND s.id IN (231629,120111,336619,347550,194885,326203,334998,334999,467065,467066,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,471702,471703,335009,318775,318774,501320,101405,367063)
                                    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 IN (111)
                                        AND s.id IN (231516,231629,120145,336627,336619,367065,268758,326203,367066,367068,347648,405200,336637,405172,467065,467066,318765,318766,318767,318768,318769,318770,318772,471702,471703,484626,347640,405076,490405,490407,476473,476474,476475,476460,476461,476463,501320,476462,476466,268670,74964,118944,268626,268671,77690,120111,335025,335027,337003,118945,335005,335006,347550,123893,194885,101406,226097,228847,326198,335023,334998,334999,335004,369969,369970,318773,318777,318779,318780,318781,466537,335009,320505,408059,120128,299602,335029,335033,335035,336634,405583,470490,490402,335906,335907,490690,318775,318774,101405,408060,120120,120121,120122,367063,467063,467064)
                                    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 IN (111)
                                        AND s.id IN (231516,231629,120145,336627,336619,367065,268758,326203,367066,367068,347648,405200,336637,405172,467065,467066,318765,318766,318767,318768,318769,318770,318772,471702,471703,484626,347640,405076,490405,490407,476473,476474,476475,476460,476461,476463,501320,476462,476466,268670,74964,118944,268626,268671,77690,120111,335025,335027,337003,118945,335005,335006,347550,123893,194885,101406,226097,228847,326198,335023,334998,334999,335004,369969,369970,318773,318777,318779,318780,318781,466537,335009,320505,408059,120128,299602,335029,335033,335035,336634,405583,470490,490402,335906,335907,490690,318775,318774,101405,408060,120120,120121,120122,367063,467063,467064)
                                    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 IN (111)
                                        AND s.id IN (231516,231629,120145,336627,336619,367065,268758,326203,367066,367068,347648,405200,336637,405172,467065,467066,318765,318766,318767,318768,318769,318770,318772,471702,471703,484626,347640,405076,490405,490407,476473,476474,476475,476460,476461,476463,501320,476462,476466,268670,74964,118944,268626,268671,77690,120111,335025,335027,337003,118945,335005,335006,347550,123893,194885,101406,226097,228847,326198,335023,334998,334999,335004,369969,369970,318773,318777,318779,318780,318781,466537,335009,320505,408059,120128,299602,335029,335033,335035,336634,405583,470490,490402,335906,335907,490690,318775,318774,101405,408060,120120,120121,120122,367063,467063,467064)
                                    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 IN (111)
                                        AND s.id IN (231516,231629,120145,336627,336619,367065,268758,326203,367066,367068,347648,405200,336637,405172,467065,467066,318765,318766,318767,318768,318769,318770,318772,471702,471703,484626,347640,405076,490405,490407,476473,476474,476475,476460,476461,476463,501320,476462,476466,268670,74964,118944,268626,268671,77690,120111,335025,335027,337003,118945,335005,335006,347550,123893,194885,101406,226097,228847,326198,335023,334998,334999,335004,369969,369970,318773,318777,318779,318780,318781,466537,335009,320505,408059,120128,299602,335029,335033,335035,336634,405583,470490,490402,335906,335907,490690,318775,318774,101405,408060,120120,120121,120122,367063,467063,467064)
                                    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 IN (845)
                                        AND s.id IN (120111,347550,194885,334998,334999,318773,318777,318779,318780,318781,335009,318775,318774,101405,367063)
                                    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 IN (845)
                                        AND s.id IN (231629,336619,326203,467065,467066,318765,318766,318767,318768,318769,318770,471702,471703,501320)
                                    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 IN (845)
                                        AND s.id IN (231629,120111,336619,347550,194885,326203,334998,334999,467065,467066,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,471691,471702,471703,413949,476478,476479,335009,476713,318775,318774,501320,472187,101405,367063,498691,498692,498694,498693,498695,498696)
                                    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 IN (845)
                                        AND s.id IN (231629,120111,336619,347550,194885,326203,334998,334999,467065,467066,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,471691,471702,471703,413949,476478,476479,335009,476713,318775,318774,501320,472187,101405,367063,498691,498692,498694,498693,498695,498696)
                                    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 IN (845)
                                        AND s.id IN (231629,120111,336619,347550,194885,326203,334998,334999,467065,467066,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,471691,471702,471703,413949,476478,476479,335009,476713,318775,318774,501320,472187,101405,367063,498691,498692,498694,498693,498695,498696)
                                    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 IN (845)
                                        AND s.id IN (231629,120111,336619,347550,194885,326203,334998,334999,467065,467066,318765,318766,318767,318768,318769,318770,318773,318777,318779,318780,318781,471691,471702,471703,413949,476478,476479,335009,476713,318775,318774,501320,472187,101405,367063,498691,498692,498694,498693,498695,498696)
                                    GROUP BY iv.id
                                     



Melbis Shop © 2002-2012, http://www.melbis.com