Căutare

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

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 ("80221", "2", "1000", "42", "1", "8.390000000000", "1"),("80222", "2", "1000", "42", "1", "8.390000000000", "2"),("80223", "2", "1000", "42", "1", "8.390000000000", "3"),("80224", "2", "1000", "42", "1", "11.330000000000", "4"),("80225", "2", "1000", "42", "1", "11.330000000000", "5"),("80226", "2", "1000", "42", "1", "11.330000000000", "6"),("80054", "2", "1005", "42", "1", "5.020000000000", "7"),("80061", "2", "1000", "42", "1", "5.020000000000", "8"),("80062", "2", "1000", "42", "1", "5.020000000000", "9"),("80064", "2", "1000", "42", "1", "5.020000000000", "10"),("80152", "2", "1000", "42", "1", "4.610000000000", "11"),("80155", "2", "1000", "42", "1", "3.770000000000", "12"),("80156", "2", "1000", "42", "1", "4.610000000000", "13"),("80158", "2", "1000", "42", "1", "6.710000000000", "14"),("80160", "2", "1000", "42", "1", "7.130000000000", "15"),("80164", "2", "1000", "42", "1", "4.610000000000", "16"),("80167", "2", "1000", "42", "1", "4.610000000000", "17"),("80171", "2", "1000", "42", "1", "3.770000000000", "18"),("80173", "2", "1000", "42", "1", "3.770000000000", "19"),("80174", "2", "1000", "42", "1", "4.610000000000", "20"),("80178", "2", "1000", "42", "1", "5.870000000000", "21"),("80179", "2", "1000", "42", "1", "6.710000000000", "22"),("80180", "2", "1000", "42", "1", "6.290000000000", "23"),("80181", "2", "1000", "42", "1", "7.130000000000", "24"),("80176", "2", "11", "42", "1", "3.770000000000", "25"),("80175", "2", "6", "42", "1", "5.870000000000", "26"),("80063", "2", "3", "42", "1", "5.020000000000", "27"),("196807", "2", "1000", "42", "1", "5.020000000000", "28"),("50594", "2", "1010", "42", "1", "21.830000000000", "29"),("80227", "2", "1010", "42", "1", "5.870000000000", "30"),("50570", "2", "1001", "42", "1", "13.850000000000", "31"),("50578", "2", "1001", "42", "1", "13.430000000000", "32"),("80072", "2", "1000", "42", "1", "5.280000000000", "33"),("80073", "2", "1000", "42", "1", "5.280000000000", "34"),("80074", "2", "1000", "42", "1", "5.280000000000", "35"),("80075", "2", "1000", "42", "1", "5.450000000000", "36"),("80077", "2", "1000", "42", "1", "5.280000000000", "37"),("80113", "2", "1000", "42", "1", "4.190000000000", "38"),("80114", "2", "1000", "42", "1", "4.190000000000", "39"),("80120", "2", "1000", "42", "1", "5.870000000000", "40"),("80121", "2", "1000", "42", "1", "5.870000000000", "41"),("80211", "2", "1000", "42", "1", "3.770000000000", "42"),("80228", "2", "1000", "42", "1", "5.870000000000", "43"),("80229", "2", "1000", "42", "1", "5.870000000000", "44"),("50572", "2", "1000", "42", "1", "15.120000000000", "45"),("50589", "2", "1000", "42", "1", "58.810000000000", "46"),("50591", "2", "1000", "42", "1", "71.410000000000", "47"),("176685", "2", "1000", "42", "1", "5.450000000000", "48"),("50595", "2", "2", "42", "1", "21.830000000000", "49"),("50587", "2", "1", "42", "1", "42.840000000000", "50"),("80083", "2", "1009", "42", "1", "4.610000000000", "51"),("80082", "2", "1003", "42", "1", "4.610000000000", "52"),("176974", "2", "1002", "42", "1", "29.400000000000", "53"),("228942", "2", "1001", "42", "1", "10.070000000000", "54"),("80069", "2", "1000", "42", "1", "5.450000000000", "55"),("80071", "2", "1000", "42", "1", "5.450000000000", "56"),("80084", "2", "1000", "42", "1", "4.610000000000", "57"),("80085", "2", "1000", "42", "1", "4.610000000000", "58"),("80086", "2", "1000", "42", "1", "4.610000000000", "59"),("80087", "2", "1000", "42", "1", "4.610000000000", "60"),("80088", "2", "1000", "42", "1", "4.610000000000", "61"),("80089", "2", "1000", "42", "1", "4.610000000000", "62"),("80090", "2", "1000", "42", "1", "5.020000000000", "63"),("80091", "2", "1000", "42", "1", "5.020000000000", "64"),("80092", "2", "1000", "42", "1", "5.020000000000", "65"),("80093", "2", "1000", "42", "1", "5.450000000000", "66"),("80094", "2", "1000", "42", "1", "5.020000000000", "67"),("80095", "2", "1000", "42", "1", "5.450000000000", "68"),("80096", "2", "1000", "42", "1", "5.450000000000", "69"),("80097", "2", "1000", "42", "1", "5.450000000000", "70"),("80098", "2", "1000", "42", "1", "5.450000000000", "71"),("80099", "2", "1000", "42", "1", "5.450000000000", "72"),("80100", "2", "1000", "42", "1", "5.450000000000", "73"),("80101", "2", "1000", "42", "1", "5.450000000000", "74"),("168930", "2", "1000", "42", "1", "5.020000000000", "75"),("176683", "2", "1000", "42", "1", "5.020000000000", "76"),("176684", "2", "1000", "42", "1", "5.020000000000", "77"),("176687", "2", "1000", "42", "1", "6.290000000000", "78"),("176972", "2", "1000", "42", "1", "24.360000000000", "79"),("176975", "2", "1000", "42", "1", "33.600000000000", "80"),("228943", "2", "1000", "42", "1", "10.070000000000", "81"),("228944", "2", "1000", "42", "1", "10.910000000000", "82"),("228945", "2", "1000", "42", "1", "10.910000000000", "83"),("228946", "2", "1000", "42", "1", "12.600000000000", "84"),("176686", "2", "1000", "42", "1", "5.450000000000", "85"),("176688", "2", "1000", "42", "1", "6.290000000000", "86"),("176691", "2", "1000", "42", "1", "7.550000000000", "87"),("80111", "2", "1014", "42", "1", "5.450000000000", "88"),("80107", "2", "1009", "42", "1", "5.450000000000", "89"),("80109", "2", "1009", "42", "1", "5.450000000000", "90"),("80104", "2", "1001", "42", "1", "5.450000000000", "91"),("80102", "2", "1000", "42", "1", "5.450000000000", "92"),("80103", "2", "1000", "42", "1", "5.450000000000", "93"),("80105", "2", "1000", "42", "1", "5.450000000000", "94"),("80108", "2", "1000", "42", "1", "5.450000000000", "95"),("80115", "2", "1000", "42", "1", "5.020000000000", "96"),("80117", "2", "1000", "42", "1", "5.020000000000", "97"),("80110", "2", "10", "42", "1", "5.450000000000", "98"),("80134", "2", "10", "42", "1", "5.620000000000", "99"),("80136", "2", "9", "42", "1", "5.870000000000", "100"),("80065", "2", "1000", "42", "1", "5.450000000000", "101"),("18096", "2", "1007", "42", "1", "12.600000000000", "102"),("5850", "2", "1004", "42", "1", "20.160000000000", "103"),("40181", "2", "1001", "42", "1", "10.490000000000", "104"),("40182", "2", "1005", "42", "1", "10.910000000000", "105"),("101034", "1", "1005", "42", "1", "10.490000000000", "106"),("40180", "2", "1004", "42", "1", "10.490000000000", "107"),("101035", "1", "1002", "42", "1", "10.490000000000", "108"),("65560", "2", "1005", "42", "1", "10.070000000000", "109"),("40185", "2", "1000", "42", "1", "10.910000000000", "110"),("40184", "2", "1000", "42", "1", "10.910000000000", "111"),("50549", "2", "1005", "42", "1", "15.120000000000", "112"),("50544", "2", "1003", "42", "1", "20.160000000000", "113"),("50545", "2", "1001", "42", "1", "20.160000000000", "114"),("50548", "2", "1001", "42", "1", "15.120000000000", "115"),("50550", "2", "1001", "42", "1", "15.120000000000", "116"),("50529", "2", "1000", "42", "1", "15.120000000000", "117"),("50530", "2", "1000", "42", "1", "15.120000000000", "118"),("50531", "2", "1000", "42", "1", "15.950000000000", "119"),("50532", "2", "1000", "42", "1", "15.950000000000", "120"),("50533", "2", "1000", "42", "1", "15.950000000000", "121"),("50543", "2", "1000", "42", "1", "20.160000000000", "122"),("50547", "2", "1000", "42", "1", "12.600000000000", "123"),("50541", "2", "1", "42", "1", "19.310000000000", "124"),("50546", "2", "1", "42", "1", "12.600000000000", "125"),("50510", "2", "1002", "42", "1", "19.310000000000", "126"),("50502", "2", "1001", "42", "1", "18.470000000000", "127"),("50506", "2", "1001", "42", "1", "18.470000000000", "128"),("50508", "2", "1001", "42", "1", "19.310000000000", "129"),("50495", "2", "1000", "42", "1", "28.550000000000", "130"),("50496", "2", "1000", "42", "1", "28.550000000000", "131"),("50497", "2", "1000", "42", "1", "28.550000000000", "132"),("50503", "2", "1000", "42", "1", "18.470000000000", "133"),("50509", "2", "1000", "42", "1", "19.310000000000", "134"),("50512", "2", "1000", "42", "1", "12.600000000000", "135"),("50513", "2", "1000", "42", "1", "14.270000000000", "136"),("50514", "2", "1000", "42", "1", "36.120000000000", "137"),("50516", "2", "1000", "42", "1", "36.120000000000", "138"),("50517", "2", "1000", "42", "1", "36.120000000000", "139"),("50518", "2", "1000", "42", "1", "31.080000000000", "140"),("50493", "2", "1", "42", "1", "28.550000000000", "141"),("50507", "2", "1", "42", "1", "18.470000000000", "142"),("237223", "2", "1010", "357", "1", "5.790000000000", "143"),("237222", "2", "1008", "357", "1", "5.790000000000", "144"),("237221", "2", "1005", "357", "1", "5.790000000000", "145"),("149771", "2", "1000", "42", "1", "151.250000000000", "146"),("168152", "1", "1000", "42", "1", "336.120000000000", "147"),("168153", "1", "1000", "42", "1", "336.120000000000", "148"),("168155", "1", "1000", "42", "1", "336.120000000000", "149"),("168156", "1", "1000", "42", "1", "336.120000000000", "150"),("168161", "1", "1000", "42", "1", "336.120000000000", "151"),("168162", "1", "1000", "42", "1", "336.120000000000", "152"),("168163", "1", "1000", "42", "1", "336.120000000000", "153"),("168164", "1", "1000", "42", "1", "336.120000000000", "154"),("229482", "1", "1001", "42", "1", "17.640000000000", "155"),("229480", "1", "1000", "42", "1", "14.270000000000", "156"),("101046", "1", "1003", "42", "1", "6.710000000000", "157"),("32158", "2", "1000", "42", "1", "26.590000000000", "158"),("32151", "2", "1", "42", "1", "26.590000000000", "159"),("32157", "2", "1", "42", "1", "20.990000000000", "160"),("91139", "2", "1001", "42", "1", "27.500000000000", "161"),("91132", "2", "1000", "42", "1", "26.590000000000", "162"),("91133", "2", "1000", "42", "1", "26.590000000000", "163"),("91135", "2", "1000", "42", "1", "27.500000000000", "164"),("91138", "2", "1000", "42", "1", "27.500000000000", "165"),("32160", "2", "1000", "42", "1", "26.590000000000", "166"),("51397", "2", "1000", "42", "1", "26.590000000000", "167"),("51398", "2", "1000", "42", "1", "26.590000000000", "168"),("51400", "2", "1000", "42", "1", "26.590000000000", "169"),("51401", "2", "1000", "42", "1", "26.590000000000", "170"),("51402", "2", "1000", "42", "1", "26.590000000000", "171"),("91144", "2", "1", "42", "1", "27.500000000000", "172"),("16870", "2", "1000", "42", "1", "14.270000000000", "173"),("16872", "2", "1000", "42", "1", "12.170000000000", "174"),("91142", "2", "1000", "42", "1", "27.500000000000", "175"),("91143", "2", "1000", "42", "1", "27.500000000000", "176"),("91145", "2", "1000", "42", "1", "27.500000000000", "177"),("91146", "2", "1000", "42", "1", "27.500000000000", "178"),("91147", "2", "1000", "42", "1", "27.500000000000", "179"),("91151", "2", "1000", "42", "1", "27.500000000000", "180"),("91152", "2", "1000", "42", "1", "27.500000000000", "181"),("40930", "2", "1000", "42", "1", "21.830000000000", "182"),("40929", "2", "1", "42", "1", "21.830000000000", "183"),("40555", "2", "1002", "42", "1", "13.850000000000", "184"),("40556", "2", "1002", "42", "1", "13.850000000000", "185"),("31678", "2", "1000", "42", "1", "5.020000000000", "186"),("31679", "2", "1", "42", "1", "5.020000000000", "187"),("168157", "1", "1000", "42", "1", "336.120000000000", "188"),("168158", "1", "1000", "42", "1", "336.120000000000", "189"),("168159", "1", "1000", "42", "1", "336.120000000000", "190"),("168160", "1", "1000", "42", "1", "336.120000000000", "191"),("168166", "1", "1000", "42", "1", "336.120000000000", "192"),("168167", "1", "1000", "42", "1", "336.120000000000", "193"),("168169", "1", "1000", "42", "1", "336.120000000000", "194"),("168171", "1", "1000", "42", "1", "336.120000000000", "195"),("91185", "2", "1000", "42", "1", "26.880000000000", "196"),("50709", "2", "1000", "42", "1", "18.470000000000", "197"),("16853", "2", "1", "42", "1", "57.970000000000", "198"),("39821", "2", "1000", "42", "1", "11.330000000000", "199"),("40141", "2", "1000", "42", "1", "13.430000000000", "200"),("50710", "2", "1", "42", "1", "20.990000000000", "201"),("17012", "2", "1002", "42", "1", "55.450000000000", "202"),("40773", "2", "1000", "42", "1", "13.180000000000", "203"),("50707", "2", "1000", "42", "1", "14.270000000000", "204"),("40776", "2", "2", "42", "1", "15.950000000000", "205"),("40770", "2", "1", "42", "1", "10.240000000000", "206"),("31604", "2", "1002", "42", "1", "34.440000000000", "207"),("50491", "2", "1000", "42", "1", "18.470000000000", "208"),("50492", "2", "999", "42", "1", "20.160000000000", "209"),("17173", "2", "1005", "42", "1", "18.470000000000", "210"),("50705", "2", "1003", "42", "1", "11.330000000000", "211"),("40314", "2", "1002", "42", "1", "16.790000000000", "212"),("101047", "1", "1000", "42", "1", "5.020000000000", "213"),("104195", "1", "1000", "42", "1", "18.470000000000", "214"),("104196", "1", "1000", "42", "1", "20.990000000000", "215"),("40320", "2", "1000", "42", "1", "19.310000000000", "216"),("50706", "2", "1000", "42", "1", "12.600000000000", "217"),("40321", "2", "1000", "42", "1", "22.680000000000", "218"),("101083", "1", "5", "42", "1", "8.390000000000", "219"),("236916", "2", "1009", "42", "1", "7.550000000000", "220"),("164643", "2", "1008", "42", "1", "12.600000000000", "221"),("91080", "2", "1006", "42", "1", "7.130000000000", "222"),("91090", "2", "1004", "42", "1", "6.710000000000", "223"),("91078", "2", "1003", "42", "1", "7.970000000000", "224"),("101304", "1", "1003", "42", "1", "13.430000000000", "225"),("236915", "2", "1003", "42", "1", "6.710000000000", "226"),("164644", "2", "1003", "42", "1", "17.640000000000", "227"),("39488", "2", "1003", "42", "1", "10.910000000000", "228"),("91082", "2", "1002", "42", "1", "7.130000000000", "229"),("91086", "2", "1002", "42", "1", "6.710000000000", "230"),("91088", "2", "1002", "42", "1", "7.130000000000", "231"),("91089", "2", "1002", "42", "1", "5.870000000000", "232"),("101180", "1", "1002", "42", "1", "13.010000000000", "233"),("40791", "2", "1002", "42", "1", "3.510000000000", "234"),("236901", "2", "1002", "42", "1", "7.130000000000", "235"),("39486", "2", "1002", "42", "1", "10.910000000000", "236"),("39693", "2", "1002", "42", "1", "5.530000000000", "237"),("91085", "2", "1002", "42", "1", "7.970000000000", "238"),("91087", "2", "1001", "42", "1", "7.130000000000", "239"),("40656", "2", "1001", "42", "1", "16.370000000000", "240"),("101138", "1", "1000", "42", "1", "4.860000000000", "241"),("101139", "1", "1000", "42", "1", "5.120000000000", "242"),("101303", "1", "1000", "42", "1", "12.170000000000", "243"),("39703", "2", "1000", "42", "1", "7.880000000000", "244"),("39717", "2", "1000", "42", "1", "35.280000000000", "245"),("39719", "2", "1000", "42", "1", "37.800000000000", "246"),("39720", "2", "1000", "42", "1", "40.320000000000", "247"),("39721", "2", "1000", "42", "1", "44.520000000000", "248"),("41251", "2", "1000", "42", "1", "44.520000000000", "249"),("236903", "2", "1000", "42", "1", "8.390000000000", "250"),("236904", "2", "1000", "42", "1", "8.810000000000", "251"),("236905", "2", "1000", "42", "1", "6.960000000000", "252"),("236906", "2", "1000", "42", "1", "7.970000000000", "253"),("236907", "2", "1000", "42", "1", "9.650000000000", "254"),("236908", "2", "1000", "42", "1", "5.450000000000", "255"),("236909", "2", "1000", "42", "1", "6.710000000000", "256"),("236912", "2", "1000", "42", "1", "6.290000000000", "257"),("236913", "2", "1000", "42", "1", "7.550000000000", "258"),("236914", "2", "1000", "42", "1", "5.870000000000", "259"),("131353", "2", "1000", "42", "1", "31.080000000000", "260"),("91084", "2", "5", "42", "1", "6.630000000000", "261"),("164645", "2", "1", "42", "1", "18.390000000000", "262"),("240068", "2", "1", "42", "1", "4.190000000000", "263"),("101214", "1", "1001", "42", "1", "10.070000000000", "264"),("101598", "1", "1005", "42", "1", "5.020000000000", "265"),("101277", "1", "1001", "42", "1", "6.710000000000", "266"),("5920", "2", "1000", "42", "1", "108.390000000000", "267"),("101278", "1", "1000", "42", "1", "12.170000000000", "268"),("229886", "2", "1000", "42", "1", "15.120000000000", "269"),("229887", "2", "1000", "42", "1", "12.600000000000", "270"),("176099", "1", "1000", "42", "1", "10.070000000000", "271"),("101032", "1", "5", "42", "1", "4.610000000000", "272"),("149585", "2", "1000", "73", "1", "30.080000000000", "273"),("152859", "2", "1000", "73", "1", "30.080000000000", "274"),("31650", "2", "1004", "42", "1", "4.610000000000", "275"),("101169", "1", "1013", "42", "1", "7.130000000000", "276"),("104043", "2", "1005", "42", "1", "6.710000000000", "277"),("39589", "2", "1004", "42", "1", "9.230000000000", "278"),("104053", "2", "1003", "42", "1", "9.230000000000", "279"),("39588", "2", "1003", "42", "1", "13.430000000000", "280"),("39710", "2", "1003", "42", "1", "8.980000000000", "281"),("104042", "2", "1003", "42", "1", "6.710000000000", "282"),("101172", "2", "1002", "42", "1", "11.330000000000", "283"),("104049", "2", "1002", "42", "1", "7.550000000000", "284"),("104052", "2", "1002", "42", "1", "7.130000000000", "285"),("104054", "2", "1002", "42", "1", "10.070000000000", "286"),("104055", "2", "1002", "42", "1", "10.490000000000", "287"),("31610", "2", "1002", "42", "1", "9.230000000000", "288"),("39793", "2", "1002", "42", "1", "10.490000000000", "289"),("39688", "2", "1002", "42", "1", "6.450000000000", "290"),("101287", "1", "1001", "42", "1", "12.600000000000", "291"),("101288", "1", "1001", "42", "1", "13.850000000000", "292"),("104045", "2", "1001", "42", "1", "6.710000000000", "293"),("104050", "2", "1001", "42", "1", "7.550000000000", "294"),("104051", "2", "1001", "42", "1", "8.390000000000", "295"),("104056", "2", "1001", "42", "1", "11.330000000000", "296"),("104044", "2", "1001", "42", "1", "6.710000000000", "297"),("39590", "2", "1000", "42", "1", "11.330000000000", "298"),("39594", "2", "1000", "42", "1", "13.430000000000", "299"),("39691", "2", "1000", "42", "1", "7.880000000000", "300"),("39704", "2", "1000", "42", "1", "5.950000000000", "301"),("39707", "2", "1000", "42", "1", "5.870000000000", "302"),("39792", "2", "1000", "42", "1", "9.230000000000", "303"),("39795", "2", "1000", "42", "1", "12.600000000000", "304"),("40317", "2", "1000", "42", "1", "5.950000000000", "305"),("40322", "2", "1000", "42", "1", "12.170000000000", "306"),("40323", "2", "1000", "42", "1", "13.430000000000", "307"),("40324", "2", "1000", "42", "1", "15.950000000000", "308"),("40325", "2", "1000", "42", "1", "20.160000000000", "309"),("40327", "2", "1000", "42", "1", "12.170000000000", "310"),("40328", "2", "1000", "42", "1", "13.430000000000", "311"),("40330", "2", "1000", "42", "1", "20.160000000000", "312"),("31607", "2", "1000", "42", "1", "8.390000000000", "313"),("31609", "2", "1000", "42", "1", "8.810000000000", "314"),("104048", "2", "1000", "42", "1", "7.130000000000", "315"),("104058", "2", "1000", "42", "1", "13.430000000000", "316"),("40090", "2", "1000", "42", "1", "8.390000000000", "317"),("104046", "2", "1000", "42", "1", "7.130000000000", "318"),("104047", "2", "999", "42", "1", "7.130000000000", "319"),("39500", "2", "10", "42", "1", "11.920000000000", "320"),("39498", "2", "3", "42", "1", "9.560000000000", "321"),("101171", "1", "2", "42", "1", "10.910000000000", "322"),("39689", "2", "2", "42", "1", "7.640000000000", "323"),("40326", "2", "2", "42", "1", "11.330000000000", "324"),("101285", "1", "1", "42", "1", "11.330000000000", "325"),("101291", "1", "1", "42", "1", "22.680000000000", "326"),("39676", "2", "1", "42", "1", "7.880000000000", "327"),("31606", "2", "1", "42", "1", "8.390000000000", "328"),("91160", "2", "1003", "42", "1", "10.490000000000", "329"),("67273", "2", "1002", "42", "1", "5.450000000000", "330"),("229910", "2", "1000", "42", "1", "126.880000000000", "331"),("101098", "1", "3", "42", "1", "5.870000000000", "332"),("250235", "2", "1000", "42", "1", "34.710000000000", "333"),("18003", "2", "1000", "42", "1", "13.430000000000", "334"),("8729", "2", "1000", "42", "1", "336.120000000000", "335"),("8731", "2", "1000", "42", "1", "436.960000000000", "336"),("8732", "2", "1000", "42", "1", "436.960000000000", "337"),("8733", "2", "1000", "42", "1", "436.960000000000", "338"),("8734", "2", "1000", "42", "1", "436.960000000000", "339"),("8735", "2", "1000", "42", "1", "436.960000000000", "340"),("8736", "2", "1000", "42", "1", "436.960000000000", "341"),("8724", "2", "1", "42", "1", "336.120000000000", "342"),("8725", "2", "1", "42", "1", "336.120000000000", "343"),("40153", "2", "1005", "42", "1", "2.500000000000", "344"),("40155", "2", "1005", "42", "1", "2.500000000000", "345"),("40151", "2", "1005", "42", "1", "2.500000000000", "346"),("229888", "2", "1000", "42", "1", "5.020000000000", "347"),("39798", "2", "1008", "42", "1", "10.490000000000", "348"),("39780", "2", "1007", "42", "1", "8.810000000000", "349"),("39797", "2", "1007", "42", "1", "9.230000000000", "350"),("39783", "2", "1005", "42", "1", "7.970000000000", "351"),("40231", "2", "1003", "42", "1", "7.550000000000", "352"),("40221", "2", "1002", "42", "1", "6.710000000000", "353"),("40224", "2", "1002", "42", "1", "6.710000000000", "354"),("39781", "2", "1001", "42", "1", "7.970000000000", "355"),("40222", "2", "1001", "42", "1", "6.710000000000", "356"),("47556", "2", "1001", "42", "1", "29.400000000000", "357"),("39782", "2", "1001", "42", "1", "8.390000000000", "358"),("40219", "2", "1000", "42", "1", "6.710000000000", "359"),("40220", "2", "1000", "42", "1", "6.710000000000", "360"),("40223", "2", "1000", "42", "1", "6.710000000000", "361"),("40229", "2", "1000", "42", "1", "6.710000000000", "362"),("40740", "2", "1000", "42", "1", "7.550000000000", "363"),("40888", "2", "1000", "42", "1", "116.790000000000", "364"),("40889", "2", "1000", "42", "1", "119.310000000000", "365"),("40891", "2", "1000", "42", "1", "105.870000000000", "366"),("40892", "2", "1000", "42", "1", "108.390000000000", "367"),("47557", "2", "1000", "42", "1", "33.600000000000", "368"),("47558", "2", "1000", "42", "1", "42.840000000000", "369"),("47559", "2", "1000", "42", "1", "44.520000000000", "370"),("40567", "2", "6", "42", "1", "8.890000000000", "371"),("47553", "2", "6", "42", "1", "20.910000000000", "372"),("47554", "2", "5", "42", "1", "21.750000000000", "373"),("40313", "2", "3", "42", "1", "6.120000000000", "374"),("40315", "2", "3", "42", "1", "7.300000000000", "375"),("40226", "2", "1", "42", "1", "6.710000000000", "376"),("47552", "2", "1", "42", "1", "20.910000000000", "377"),("39974", "2", "1004", "42", "1", "4.610000000000", "378"),("40094", "2", "1003", "42", "1", "7.550000000000", "379"),("50695", "2", "1002", "42", "1", "8.390000000000", "380"),("40097", "2", "1002", "42", "1", "8.390000000000", "381"),("40096", "2", "1001", "42", "1", "7.970000000000", "382"),("40098", "2", "1001", "42", "1", "8.390000000000", "383"),("40091", "2", "1000", "42", "1", "9.230000000000", "384"),("40252", "2", "1000", "42", "1", "13.430000000000", "385"),("40254", "2", "1000", "42", "1", "9.230000000000", "386"),("40895", "2", "1000", "42", "1", "117.640000000000", "387"),("228938", "2", "1000", "42", "1", "22.680000000000", "388"),("228939", "2", "1000", "42", "1", "28.550000000000", "389"),("228940", "2", "1000", "42", "1", "31.920000000000", "390"),("228941", "2", "1000", "42", "1", "34.440000000000", "391"),("50772", "2", "1000", "42", "1", "9.230000000000", "392"),("104083", "2", "4", "42", "1", "126.540000000000", "393"),("231684", "2", "1000", "294", "1", "32.760000000000", "394"),("101206", "1", "1005", "42", "1", "7.550000000000", "395"),("40234", "2", "1005", "42", "1", "11.330000000000", "396"),("101067", "2", "1001", "42", "1", "12.600000000000", "397"),("40238", "2", "1001", "42", "1", "15.120000000000", "398"),("101068", "2", "1000", "42", "1", "13.850000000000", "399"),("40235", "2", "1000", "42", "1", "12.600000000000", "400"),("40237", "2", "1000", "42", "1", "13.850000000000", "401"),("40287", "2", "2", "42", "1", "7.880000000000", "402"),("101069", "2", "1", "42", "1", "15.120000000000", "403"),("230307", "2", "1000", "42", "1", "49.560000000000", "404"),("230309", "2", "1000", "42", "1", "58.810000000000", "405"),("230313", "2", "1000", "42", "1", "58.810000000000", "406"),("230465", "2", "1000", "42", "1", "55.450000000000", "407"),("91180", "2", "1", "42", "1", "60.490000000000", "408"),("101207", "1", "1009", "42", "1", "8.390000000000", "409"),("50775", "2", "1007", "42", "1", "9.650000000000", "410"),("50774", "2", "1001", "42", "1", "9.650000000000", "411"),("8334", "2", "1000", "42", "1", "131.920000000000", "412"),("50776", "2", "1000", "42", "1", "9.650000000000", "413"),("16075", "2", "1000", "42", "1", "118.470000000000", "414"),("16076", "2", "1000", "42", "1", "120.990000000000", "415"),("16077", "2", "1000", "42", "1", "123.510000000000", "416"),("50741", "2", "1000", "42", "1", "528.550000000000", "417"),("50742", "2", "1000", "42", "1", "715.120000000000", "418"),("230303", "2", "1000", "42", "1", "42.000000000000", "419"),("229850", "2", "1001", "42", "1", "8.140000000000", "420"),("229846", "2", "1000", "42", "1", "35.280000000000", "421"),("229851", "2", "1000", "42", "1", "45.360000000000", "422"),("229852", "2", "1000", "42", "1", "10.070000000000", "423"),("50773", "2", "1002", "42", "1", "9.230000000000", "424"),("229855", "2", "1000", "42", "1", "48.730000000000", "425"),("229928", "1", "1000", "42", "1", "41.170000000000", "426"),("124727", "1", "2", "309", "1", "22.680000000000", "427"),("48077", "-100", "1", "26", "1", "33.060000000000", "428"),("215529", "1", "1002", "729", "1", "80.660000000000", "429"),("224806", "1", "1000", "729", "1", "94.940000000000", "430"),("150871", "1", "9", "357", "1", "48.730000000000", "431"),("150873", "1", "9", "357", "1", "68.860000000000", "432"),("80150", "2", "0", "42", "1", "2.100000000000", "433"),("80159", "2", "0", "42", "1", "2.100000000000", "434"),("80161", "2", "0", "42", "1", "3.000000000000", "435"),("80165", "2", "0", "42", "1", "2.100000000000", "436"),("80169", "2", "0", "42", "1", "3.000000000000", "437"),("80170", "2", "0", "42", "1", "2.100000000000", "438"),("80177", "2", "0", "42", "1", "2.100000000000", "439"),("80119", "2", "0", "42", "1", "3.900000000000", "440"),("80212", "2", "0", "42", "1", "2.100000000000", "441"),("80215", "2", "0", "42", "1", "6.200000000000", "442"),("50576", "2", "0", "42", "1", "10.000000000000", "443"),("50577", "2", "0", "42", "1", "10.000000000000", "444"),("50588", "2", "0", "42", "1", "39.000000000000", "445"),("50592", "2", "0", "42", "1", "12.500000000000", "446"),("50593", "2", "0", "42", "1", "14.600000000000", "447"),("80076", "2", "0", "42", "1", "3.100000000000", "448"),("80122", "2", "0", "42", "1", "3.900000000000", "449"),("80126", "2", "0", "42", "1", "3.900000000000", "450"),("80127", "2", "0", "42", "1", "3.900000000000", "451"),("80128", "2", "0", "42", "1", "3.900000000000", "452"),("80129", "2", "0", "42", "1", "3.900000000000", "453"),("80066", "2", "0", "42", "1", "3.400000000000", "454"),("80068", "2", "0", "42", "1", "3.400000000000", "455"),("80106", "2", "0", "42", "1", "3.400000000000", "456"),("80116", "2", "0", "42", "1", "3.200000000000", "457"),("80130", "2", "0", "42", "1", "3.400000000000", "458"),("80135", "2", "0", "42", "1", "3.800000000000", "459"),("80137", "2", "0", "42", "1", "3.800000000000", "460"),("80139", "2", "0", "42", "1", "3.800000000000", "461"),("80140", "2", "0", "42", "1", "3.800000000000", "462"),("80142", "2", "0", "42", "1", "3.800000000000", "463"),("80145", "2", "0", "42", "1", "3.800000000000", "464"),("80146", "2", "0", "42", "1", "3.800000000000", "465"),("80147", "2", "0", "42", "1", "3.800000000000", "466"),("65585", "2", "0", "42", "1", "5.200000000000", "467"),("50542", "2", "0", "42", "1", "14.000000000000", "468"),("50494", "2", "0", "42", "1", "22.000000000000", "469"),("50511", "2", "0", "42", "1", "14.000000000000", "470"),("50515", "2", "0", "42", "1", "28.000000000000", "471"),("50519", "2", "0", "42", "1", "24.000000000000", "472"),("50520", "2", "0", "42", "1", "24.000000000000", "473"),("237220", "2", "0", "357", "1", "5.790000000000", "474"),("51399", "2", "0", "42", "1", "20.500000000000", "475"),("91137", "2", "0", "42", "1", "21.000000000000", "476"),("20697", "2", "0", "42", "1", "20.000000000000", "477"),("40364", "2", "0", "42", "1", "32.600000000000", "478"),("229912", "2", "0", "42", "1", "26.030000000000", "479"),("229490", "1", "0", "42", "1", "68.000000000000", "480"),("229491", "1", "0", "42", "1", "54.000000000000", "481"),("229492", "1", "0", "42", "1", "42.000000000000", "482"),("39480", "2", "0", "42", "1", "8.300000000000", "483"),("39695", "2", "0", "42", "1", "6.100000000000", "484"),("40654", "2", "0", "42", "1", "8.000000000000", "485"),("40655", "2", "0", "42", "1", "11.000000000000", "486"),("40788", "2", "0", "42", "1", "2.800000000000", "487"),("40790", "2", "0", "42", "1", "2.500000000000", "488"),("40792", "2", "0", "42", "1", "2.600000000000", "489"),("236917", "2", "0", "42", "1", "6.200000000000", "490"),("101599", "1", "0", "42", "1", "5.000000000000", "491"),("101281", "1", "0", "42", "1", "11.300000000000", "492"),("39712", "2", "0", "42", "1", "8.100000000000", "493"),("8727", "2", "0", "42", "1", "269.000000000000", "494"),("8730", "2", "0", "42", "1", "269.000000000000", "495"),("101082", "1", "0", "42", "1", "28.000000000000", "496"),("101167", "1", "0", "42", "1", "7.300000000000", "497"),("101296", "1", "0", "42", "1", "6.000000000000", "498"),("40232", "2", "0", "42", "1", "5.200000000000", "499"),("50771", "2", "0", "42", "1", "6.200000000000", "500"),("228936", "2", "0", "42", "1", "13.000000000000", "501"),("228937", "2", "0", "42", "1", "20.500000000000", "502"),("101066", "2", "0", "42", "1", "8.500000000000", "503"),("8511", "2", "0", "42", "1", "50.000000000000", "504"),("230310", "2", "0", "42", "1", "45.000000000000", "505"),("230445", "2", "0", "42", "1", "42.000000000000", "506"),("230449", "2", "0", "42", "1", "49.000000000000", "507"),("230453", "2", "0", "42", "1", "46.000000000000", "508"),("230461", "2", "0", "42", "1", "50.000000000000", "509"),("1524", "2", "0", "42", "1", "25.000000000000", "510"),("229856", "2", "0", "42", "1", "7.700000000000", "511"),("229923", "1", "0", "42", "1", "18.470000000000", "512"),("229924", "1", "0", "42", "1", "18.470000000000", "513"),("229925", "1", "0", "42", "1", "19.300000000000", "514"),("229926", "1", "0", "42", "1", "23.000000000000", "515"),("229927", "1", "0", "42", "1", "19.000000000000", "516"),("229929", "1", "0", "42", "1", "39.000000000000", "517"),("229930", "1", "0", "42", "1", "16.600000000000", "518")

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'