Căutare

SELECT data
FROM `oc_session`
WHERE session_id = 'd56115c9f8fd35fb1d84940cd7'

SELECT `trigger`, `action`
FROM oc_event

CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("144099", "1", "1000", "150", "1", "59.390000000000", "1"),("144103", "1", "1001", "150", "1", "59.390000000000", "2"),("78283", "2", "12", "469", "1", "6.640000000000", "3"),("118914", "2", "1000", "554", "1", "103.920000000000", "4"),("87843", "2", "1", "423", "1", "92.440000000000", "5"),("177632", "2", "1000", "11", "1", "62.700000000000", "6"),("177634", "2", "1000", "11", "1", "62.700000000000", "7"),("144095", "1", "1000", "150", "1", "59.390000000000", "8"),("144109", "1", "1000", "150", "1", "59.390000000000", "9"),("177635", "2", "1000", "11", "1", "62.700000000000", "10"),("224732", "1", "1000", "725", "1", "12.750000000000", "11"),("72826", "2", "1000", "464", "1", "22.610000000000", "12"),("231578", "1", "1000", "658", "1", "46.020000000000", "13"),("231579", "1", "1000", "658", "1", "46.020000000000", "14"),("231580", "1", "1000", "658", "1", "46.020000000000", "15"),("231581", "1", "1000", "658", "1", "46.020000000000", "16"),("231582", "1", "1000", "658", "1", "46.020000000000", "17"),("103055", "4", "1000", "124", "1", "637.650000000000", "18"),("105716", "1", "1000", "58", "1", "24.290000000000", "19"),("231620", "1", "1000", "658", "1", "40.110000000000", "20"),("231621", "1", "1000", "658", "1", "40.110000000000", "21"),("231622", "1", "1000", "658", "1", "40.110000000000", "22"),("231623", "1", "1000", "658", "1", "40.110000000000", "23"),("82826", "2", "1003", "168", "1", "504.870000000000", "24"),("115475", "10", "1000", "255", "1", "649.540000000000", "25"),("149715", "2", "1000", "20", "1", "57.190000000000", "26"),("171655", "10", "1000", "255", "1", "1325.820000000000", "27"),("126999", "1", "1000", "585", "1", "1634.450000000000", "28"),("149703", "2", "1001", "20", "1", "40.770000000000", "29"),("13945", "2", "1000", "115", "1", "13.030000000000", "30"),("92121", "10", "1000", "222", "1", "118.040000000000", "31"),("49922", "10", "1000", "256", "1", "7052.140000000000", "32"),("49924", "10", "1000", "256", "1", "6628.020000000000", "33"),("60279", "2", "10", "406", "1", "6.720000000000", "34"),("100561", "10", "1", "271", "1", "58.140000000000", "35"),("242655", "2", "1000", "475", "1", "925.130000000000", "36"),("242656", "2", "1000", "475", "1", "925.130000000000", "37"),("91090", "2", "1004", "42", "1", "5.880000000000", "38"),("121359", "2", "1001", "85", "1", "41.612800000000", "39"),("172436", "2", "1000", "123", "1", "26.660000000000", "40"),("172444", "2", "1000", "123", "1", "26.660000000000", "41"),("172447", "2", "1000", "123", "1", "26.660000000000", "42"),("172452", "2", "1000", "123", "1", "26.660000000000", "43"),("218229", "1", "1000", "224", "1", "33.300000000000", "44"),("191237", "1", "1000", "723", "1", "2801.680000000000", "45"),("191259", "1", "1000", "723", "1", "2902.520000000000", "46"),("24638", "10", "1000", "271", "1", "35.410000000000", "47"),("229510", "10", "1000", "20", "1", "71.490000000000", "48"),("202501", "1", "1000", "224", "1", "38.570000000000", "49"),("238985", "1", "1005", "782", "1", "15.880000000000", "50"),("88187", "2", "1005", "368", "1", "17.740000000000", "51"),("121363", "2", "1001", "85", "1", "41.612800000000", "52"),("108919", "2", "1001", "279", "1", "16.050000000000", "53"),("233858", "1", "1001", "353", "1", "491.560000000000", "54"),("172445", "2", "1000", "123", "1", "26.660000000000", "55"),("172448", "2", "1000", "123", "1", "26.660000000000", "56"),("172450", "2", "1000", "123", "1", "26.660000000000", "57"),("172453", "2", "1000", "123", "1", "26.660000000000", "58"),("172456", "2", "1000", "123", "1", "26.660000000000", "59"),("224866", "2", "1000", "729", "1", "41.180000000000", "60"),("242429", "2", "1000", "115", "1", "22.690000000000", "61"),("242449", "2", "1000", "115", "1", "19.330000000000", "62"),("192325", "1", "1000", "723", "1", "2902.520000000000", "63"),("168816", "1", "1000", "54", "1", "106.720000000000", "64"),("154011", "1", "1000", "206", "1", "16.810000000000", "65"),("21730", "2", "1000", "94", "1", "29.580000000000", "66"),("21731", "2", "1000", "94", "1", "29.580000000000", "67"),("94906", "10", "1000", "271", "1", "97.050000000000", "68"),("108918", "2", "1000", "279", "1", "16.050000000000", "69"),("110344", "10", "1000", "255", "1", "1076.030000000000", "70"),("121361", "2", "1000", "85", "1", "42.675200000000", "71"),("229499", "1", "1000", "20", "1", "50.200000000000", "72"),("44647", "4", "1000", "13", "1", "15.210000000000", "73"),("44648", "4", "1000", "13", "1", "15.210000000000", "74"),("179319", "2", "1000", "185", "1", "57.450000000000", "75"),("169297", "1", "4", "54", "1", "41.090000000000", "76"),("44646", "4", "1", "13", "1", "11.680000000000", "77"),("124711", "1", "1", "309", "1", "17.500000000000", "78"),("89238", "2", "1", "459", "1", "49.160000000000", "79"),("123473", "2", "1004", "362", "1", "14.710000000000", "80"),("217915", "1", "1003", "476", "1", "38.340000000000", "81"),("238983", "1", "1003", "782", "1", "15.880000000000", "82"),("66627", "2", "1003", "104", "1", "310.000000000000", "83"),("188185", "2", "1002", "121", "1", "37.730000000000", "84"),("109796", "2", "1002", "94", "1", "29.580000000000", "85"),("179317", "2", "1002", "185", "1", "57.450000000000", "86"),("21726", "2", "1001", "94", "1", "29.580000000000", "87"),("224860", "2", "1000", "729", "1", "41.180000000000", "88"),("224862", "2", "1000", "729", "1", "41.180000000000", "89"),("224863", "2", "1000", "729", "1", "41.180000000000", "90"),("224864", "2", "1000", "729", "1", "41.180000000000", "91"),("224865", "2", "1000", "729", "1", "41.180000000000", "92"),("224880", "2", "1000", "729", "1", "41.180000000000", "93"),("224861", "2", "1000", "729", "1", "41.180000000000", "94"),("21727", "2", "1000", "94", "1", "29.580000000000", "95"),("21728", "2", "1000", "94", "1", "29.580000000000", "96"),("21729", "2", "1000", "94", "1", "29.580000000000", "97"),("108922", "2", "1000", "279", "1", "16.050000000000", "98"),("129991", "1", "1000", "597", "1", "5461.340000000000", "99"),("226841", "1", "1000", "459", "1", "88.990000000000", "100"),("219571", "1", "1000", "401", "1", "156.220000000000", "101"),("105272", "1", "1000", "104", "1", "294.870000000000", "102"),("179318", "2", "1000", "185", "1", "57.450000000000", "103"),("169296", "1", "2", "54", "1", "41.090000000000", "104"),("108917", "2", "1", "279", "1", "17.480000000000", "105"),("157833", "2", "1", "631", "1", "116.720000000000", "106"),("238984", "1", "1004", "782", "1", "15.880000000000", "107"),("166317", "1", "1002", "85", "1", "28.570000000000", "108"),("238001", "1", "1001", "54", "1", "53.780000000000", "109"),("189379", "2", "1001", "24", "1", "10.000000000000", "110"),("177194", "2", "1000", "117", "1", "49.580000000000", "111"),("177195", "2", "1000", "117", "1", "49.580000000000", "112"),("177196", "2", "1000", "117", "1", "49.580000000000", "113"),("177197", "2", "1000", "117", "1", "49.580000000000", "114"),("177204", "2", "1000", "117", "1", "52.100000000000", "115"),("177205", "2", "1000", "117", "1", "52.100000000000", "116"),("177206", "2", "1000", "117", "1", "52.100000000000", "117"),("177207", "2", "1000", "117", "1", "54.620000000000", "118"),("177208", "2", "1000", "117", "1", "54.620000000000", "119"),("108920", "2", "1000", "279", "1", "16.050000000000", "120"),("109795", "2", "1000", "94", "1", "29.580000000000", "121"),("223858", "2", "1000", "459", "1", "70.500000000000", "122"),("223912", "2", "1000", "459", "1", "70.500000000000", "123"),("223918", "2", "1000", "459", "1", "70.500000000000", "124"),("223919", "2", "1000", "459", "1", "70.500000000000", "125"),("223920", "2", "1000", "459", "1", "70.500000000000", "126"),("223921", "2", "1000", "459", "1", "70.500000000000", "127"),("223922", "2", "1000", "459", "1", "70.500000000000", "128"),("223923", "2", "1000", "459", "1", "70.500000000000", "129"),("223924", "2", "1000", "459", "1", "70.500000000000", "130"),("223927", "2", "1000", "459", "1", "70.500000000000", "131"),("223928", "2", "1000", "459", "1", "70.500000000000", "132"),("223929", "2", "1000", "459", "1", "70.500000000000", "133"),("223936", "2", "1000", "459", "1", "70.500000000000", "134"),("223938", "2", "1000", "459", "1", "70.500000000000", "135"),("226843", "1", "1000", "459", "1", "88.990000000000", "136"),("218179", "1", "1000", "749", "1", "259.580000000000", "137"),("218183", "1", "1000", "749", "1", "215.040000000000", "138"),("179519", "1", "1116", "17", "1", "671.430000000000", "139"),("238986", "1", "1005", "782", "1", "15.880000000000", "140"),("44420", "4", "1003", "13", "1", "21.180000000000", "141"),("101067", "2", "1001", "42", "1", "11.760000000000", "142"),("119367", "2", "1001", "105", "1", "35.290000000000", "143"),("233769", "1", "1001", "353", "1", "90.720000000000", "144"),("148813", "1", "1001", "54", "1", "134.450000000000", "145"),("115845", "1", "1000", "285", "1", "22.500000000000", "146"),("233770", "1", "1000", "353", "1", "90.720000000000", "147"),("229461", "1", "1000", "540", "1", "27.310000000000", "148"),("175927", "1", "1000", "117", "1", "49.580000000000", "149"),("175931", "1", "1000", "117", "1", "49.580000000000", "150"),("175933", "1", "1000", "117", "1", "49.580000000000", "151"),("175935", "1", "1000", "117", "1", "49.580000000000", "152"),("175936", "1", "1000", "117", "1", "49.580000000000", "153"),("175937", "1", "1000", "117", "1", "49.580000000000", "154"),("175938", "1", "1000", "117", "1", "49.580000000000", "155"),("175940", "1", "1000", "117", "1", "49.580000000000", "156"),("175941", "1", "1000", "117", "1", "49.580000000000", "157"),("175945", "1", "1000", "117", "1", "49.580000000000", "158"),("175946", "1", "1000", "117", "1", "49.580000000000", "159"),("175947", "1", "1000", "117", "1", "49.580000000000", "160"),("46037", "2", "1000", "11", "1", "29.270000000000", "161"),("154019", "2", "1000", "553", "1", "2100.760000000000", "162"),("176087", "2", "1000", "94", "1", "31.710000000000", "163"),("176088", "2", "1000", "94", "1", "31.710000000000", "164"),("176089", "2", "1000", "94", "1", "31.710000000000", "165"),("176090", "2", "1000", "94", "1", "31.710000000000", "166"),("176091", "2", "1000", "94", "1", "31.710000000000", "167"),("166309", "1", "1000", "85", "1", "19.620000000000", "168"),("166310", "1", "1000", "85", "1", "19.620000000000", "169"),("166312", "1", "1000", "85", "1", "19.620000000000", "170"),("223913", "2", "1000", "459", "1", "70.500000000000", "171"),("223930", "2", "1000", "459", "1", "70.500000000000", "172"),("223934", "2", "1000", "459", "1", "70.500000000000", "173"),("223935", "2", "1000", "459", "1", "70.500000000000", "174"),("229468", "1", "1000", "362", "1", "27.310000000000", "175"),("165750", "1", "1000", "324", "1", "10.340000000000", "176"),("118336", "2", "1000", "105", "1", "20.080000000000", "177"),("82700", "2", "1000", "168", "1", "630.920000000000", "178"),("115842", "1", "1000", "285", "1", "22.500000000000", "179"),("205803", "2", "1000", "476", "1", "134.410000000000", "180"),("229527", "1", "1000", "540", "1", "29.500000000000", "181"),("236629", "1", "1000", "85", "1", "28.570000000000", "182"),("236630", "1", "1000", "85", "1", "28.570000000000", "183"),("178278", "1", "1000", "122", "1", "188.240000000000", "184"),("236631", "1", "1000", "85", "1", "28.570000000000", "185"),("175969", "2", "1000", "94", "1", "31.710000000000", "186"),("166313", "1", "1000", "85", "1", "19.620000000000", "187"),("166315", "1", "1000", "85", "1", "19.620000000000", "188"),("221949", "1", "1000", "459", "1", "56.220000000000", "189"),("221950", "1", "1000", "459", "1", "56.220000000000", "190"),("221951", "1", "1000", "459", "1", "56.220000000000", "191"),("223914", "2", "1000", "459", "1", "70.500000000000", "192"),("226477", "1", "1000", "459", "1", "61.260000000000", "193"),("226478", "1", "1000", "459", "1", "61.260000000000", "194"),("226479", "1", "1000", "459", "1", "61.260000000000", "195"),("226480", "1", "1000", "459", "1", "61.260000000000", "196"),("226481", "1", "1000", "459", "1", "61.260000000000", "197"),("226482", "1", "1000", "459", "1", "61.260000000000", "198"),("226823", "2", "1000", "459", "1", "67.140000000000", "199"),("226824", "2", "1000", "459", "1", "67.140000000000", "200"),("226825", "2", "1000", "459", "1", "67.140000000000", "201"),("226826", "2", "1000", "459", "1", "67.140000000000", "202"),("226827", "2", "1000", "459", "1", "67.140000000000", "203"),("226828", "2", "1000", "459", "1", "67.140000000000", "204"),("235038", "1", "1000", "11", "1", "44.480000000000", "205"),("131835", "2", "4", "593", "1", "20.080000000000", "206"),("116704", "2", "1001", "459", "1", "67.140000000000", "207"),("117852", "2", "1001", "58", "1", "23.450000000000", "208"),("134783", "2", "1000", "193", "1", "24.370000000000", "209"),("134785", "2", "1000", "193", "1", "24.370000000000", "210"),("134789", "2", "1000", "193", "1", "24.370000000000", "211"),("134791", "2", "1000", "193", "1", "24.370000000000", "212"),("134797", "2", "1000", "193", "1", "24.370000000000", "213"),("221952", "1", "1000", "459", "1", "56.220000000000", "214"),("221953", "1", "1000", "459", "1", "56.220000000000", "215"),("235039", "1", "1000", "11", "1", "44.480000000000", "216"),("235040", "1", "1000", "11", "1", "44.480000000000", "217"),("44634", "4", "1000", "13", "1", "5.630000000000", "218"),("164829", "2", "2", "593", "1", "20.080000000000", "219"),("164550", "2", "2", "593", "1", "20.080000000000", "220"),("134793", "2", "1", "193", "1", "24.370000000000", "221"),("131827", "2", "1", "593", "1", "20.080000000000", "222"),("227270", "1", "1000", "96", "1", "65.250000000000", "223"),("236586", "1", "1000", "85", "1", "63.870000000000", "224"),("44655", "10", "1000", "13", "1", "11.760000000000", "225"),("221954", "1", "1000", "459", "1", "56.220000000000", "226"),("235037", "1", "1000", "11", "1", "44.480000000000", "227"),("117850", "2", "1000", "105", "1", "25.130000000000", "228"),("18505", "2", "1000", "105", "1", "38.570000000000", "229"),("242653", "2", "1000", "475", "1", "756.220000000000", "230"),("63655", "-100", "15", "26", "1", "15.040000000000", "231"),("191003", "2", "2", "95", "1", "125.210000000000", "232"),("96392", "2", "2", "188", "1", "33.190000000000", "233"),("106072", "1", "1004", "58", "1", "13.450000000000", "234"),("62360", "2", "1004", "24", "1", "49.500000000000", "235"),("105315", "1", "1003", "58", "1", "60.500000000000", "236"),("105321", "1", "1002", "58", "1", "101.600000000000", "237"),("105857", "1", "1002", "58", "1", "31.010000000000", "238"),("106071", "1", "1002", "58", "1", "14.200000000000", "239"),("106083", "1", "1002", "58", "1", "13.360000000000", "240"),("105292", "1", "1001", "58", "1", "41.930000000000", "241"),("95029", "2", "1001", "105", "1", "576.390000000000", "242"),("183215", "1", "1000", "701", "1", "36.050000000000", "243"),("62357", "2", "1000", "24", "1", "49.500000000000", "244"),("150433", "2", "1000", "58", "1", "72.180000000000", "245"),("242657", "2", "1000", "475", "1", "925.130000000000", "246"),("223662", "1", "1000", "124", "1", "466.390000000000", "247"),("105728", "1", "1000", "58", "1", "88.990000000000", "248"),("104264", "1", "1002", "104", "1", "24.290000000000", "249"),("99464", "1", "1000", "135", "1", "251.260000000000", "250"),("101932", "2", "1000", "204", "1", "37.820000000000", "251"),("183217", "1", "1000", "701", "1", "36.050000000000", "252"),("165988", "1", "1000", "224", "1", "226.810000000000", "253"),("242654", "2", "1000", "475", "1", "925.130000000000", "254"),("170933", "2", "1001", "656", "1", "529.970000000000", "255"),("183221", "1", "1000", "701", "1", "36.050000000000", "256"),("183219", "1", "1000", "701", "1", "36.050000000000", "257"),("191751", "1", "1003", "122", "1", "43.700000000000", "258"),("244189", "1", "1000", "122", "1", "43.700000000000", "259"),("244188", "1", "1000", "122", "1", "43.700000000000", "260"),("244192", "1", "1000", "122", "1", "43.700000000000", "261"),("244194", "1", "1000", "122", "1", "43.700000000000", "262"),("244216", "1", "1000", "122", "1", "43.700000000000", "263"),("244219", "1", "1000", "122", "1", "43.700000000000", "264"),("243291", "1", "1000", "122", "1", "43.700000000000", "265"),("244700", "1", "1000", "122", "1", "43.700000000000", "266"),("13946", "2", "0", "115", "1", "10.000000000000", "267"),("177633", "2", "0", "11", "1", "45.880000000000", "268"),("87842", "2", "0", "423", "1", "44.000000000000", "269"),("115476", "10", "0", "255", "1", "353.410000000000", "270"),("105284", "1", "0", "58", "1", "16.500000000000", "271"),("172455", "2", "0", "123", "1", "19.200000000000", "272"),("172443", "2", "0", "123", "1", "19.200000000000", "273"),("43420", "2", "0", "297", "1", "10.920000000000", "274"),("172449", "2", "0", "123", "1", "19.200000000000", "275"),("172451", "2", "0", "123", "1", "19.200000000000", "276"),("124713", "1", "0", "309", "1", "20.000000000000", "277"),("102413", "2", "0", "285", "1", "132.090000000000", "278"),("191269", "1", "0", "723", "1", "921.960000000000", "279"),("108921", "2", "0", "279", "1", "16.050000000000", "280"),("226834", "1", "0", "459", "1", "67.000000000000", "281"),("226835", "1", "0", "459", "1", "67.000000000000", "282"),("226837", "1", "0", "459", "1", "67.000000000000", "283"),("226838", "1", "0", "459", "1", "67.000000000000", "284"),("226839", "1", "0", "459", "1", "67.000000000000", "285"),("113966", "2", "0", "185", "1", "37.000000000000", "286"),("177210", "2", "0", "117", "1", "35.000000000000", "287"),("223915", "2", "0", "459", "1", "54.000000000000", "288"),("223916", "2", "0", "459", "1", "54.000000000000", "289"),("223917", "2", "0", "459", "1", "54.000000000000", "290"),("223931", "2", "0", "459", "1", "54.000000000000", "291"),("223933", "2", "0", "459", "1", "54.000000000000", "292"),("223937", "2", "0", "459", "1", "54.000000000000", "293"),("226836", "1", "0", "459", "1", "67.000000000000", "294"),("226840", "1", "0", "459", "1", "67.000000000000", "295"),("226842", "1", "0", "459", "1", "67.000000000000", "296"),("120278", "2", "0", "475", "1", "1000.000000000000", "297"),("177209", "2", "0", "117", "1", "35.000000000000", "298"),("228616", "1", "0", "294", "1", "363.020000000000", "299"),("228771", "1", "0", "17", "1", "150.420000000000", "300"),("84504", "2", "0", "163", "1", "20.830000000000", "301"),("171370", "1", "0", "648", "1", "8.000000000000", "302"),("231054", "1", "0", "723", "1", "802.960000000000", "303"),("194033", "1", "0", "87", "1", "122.380000000000", "304"),("81563", "2", "0", "287", "1", "22.810000000000", "305"),("231075", "1", "0", "723", "1", "743.460000000000", "306"),("173398", "1", "0", "55", "1", "56.600000000000", "307"),("173434", "1", "0", "55", "1", "56.600000000000", "308"),("144499", "1", "0", "353", "1", "29.480000000000", "309"),("173445", "1", "0", "55", "1", "102.910000000000", "310"),("170993", "1", "0", "55", "1", "61.740000000000", "311"),("116937", "1", "0", "455", "1", "27.480000000000", "312"),("177553", "1", "0", "11", "1", "115.560000000000", "313"),("134787", "2", "0", "193", "1", "16.220000000000", "314"),("173192", "1", "0", "55", "1", "773.450000000000", "315"),("173380", "1", "0", "55", "1", "61.740000000000", "316"),("173188", "1", "0", "55", "1", "803.200000000000", "317"),("225161", "1", "0", "528", "1", "46.220000000000", "318"),("135051", "2", "0", "193", "1", "3.190000000000", "319"),("219587", "1", "0", "749", "1", "94.870000000000", "320"),("173193", "1", "0", "55", "1", "773.450000000000", "321"),("164812", "2", "0", "593", "1", "19.980000000000", "322"),("131831", "2", "0", "593", "1", "19.980000000000", "323"),("131881", "2", "0", "593", "1", "19.980000000000", "324"),("168764", "10", "0", "55", "1", "56.600000000000", "325"),("242652", "2", "0", "475", "1", "520.000000000000", "326"),("212447", "2", "0", "753", "1", "312.000000000000", "327"),("94439", "2", "0", "135", "1", "145.000000000000", "328"),("176599", "1", "0", "88", "1", "2855.669900000000", "329")

SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t

SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20

SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name

SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1

SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'