Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '3f99e76690047aa70ba6a65bda'

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 ("68210", "2", "0", "53", "1", "97.720000000000", "1"),("225655", "1", "1000", "155", "1", "9.060000000000", "2"),("202929", "1", "1008", "44", "1", "128.570000000000", "3"),("240629", "1", "1008", "44", "1", "111.760000000000", "4"),("202921", "1", "1008", "44", "1", "107.560000000000", "5"),("240631", "1", "1006", "44", "1", "132.770000000000", "6"),("240630", "1", "1006", "44", "1", "115.970000000000", "7"),("75189", "2", "4", "470", "1", "8.320000000000", "8"),("86738", "2", "2", "469", "1", "12.520000000000", "9"),("188373", "2", "1", "655", "1", "362.130000000000", "10"),("125135", "1", "1001", "575", "1", "36.970000000000", "11"),("125105", "1", "1000", "575", "1", "35.290000000000", "12"),("125119", "1", "1000", "575", "1", "35.290000000000", "13"),("125121", "1", "1000", "575", "1", "35.290000000000", "14"),("125131", "1", "1000", "575", "1", "35.290000000000", "15"),("125139", "1", "1000", "575", "1", "36.970000000000", "16"),("125141", "1", "1000", "575", "1", "36.970000000000", "17"),("125145", "1", "1000", "575", "1", "36.970000000000", "18"),("125153", "1", "1000", "575", "1", "36.970000000000", "19"),("125155", "1", "1000", "575", "1", "36.970000000000", "20"),("125157", "1", "1000", "575", "1", "36.970000000000", "21"),("125159", "1", "1000", "575", "1", "36.970000000000", "22"),("125163", "1", "1000", "575", "1", "36.970000000000", "23"),("125169", "1", "1000", "575", "1", "36.970000000000", "24"),("125171", "1", "1000", "575", "1", "36.970000000000", "25"),("125181", "1", "1000", "575", "1", "36.970000000000", "26"),("125187", "1", "1000", "575", "1", "36.970000000000", "27"),("154095", "2", "1000", "575", "1", "387.390000000000", "28"),("125125", "1", "1", "575", "1", "35.290000000000", "29"),("123749", "1", "1000", "575", "1", "27.730000000000", "30"),("123697", "1", "1000", "575", "1", "27.730000000000", "31"),("154087", "1", "1000", "575", "1", "27.730000000000", "32"),("154097", "2", "1000", "575", "1", "387.390000000000", "33"),("126343", "2", "1000", "575", "1", "86.550000000000", "34"),("126345", "2", "1000", "575", "1", "86.550000000000", "35"),("126347", "2", "1000", "575", "1", "86.550000000000", "36"),("123557", "1", "1000", "575", "1", "27.730000000000", "37"),("188851", "2", "1", "655", "1", "507.130000000000", "38"),("99726", "1", "1075", "67", "1", "1.340000000000", "39"),("236690", "2", "1000", "423", "1", "5.800000000000", "40"),("100474", "1", "1000", "62", "1", "23.488000000000", "41"),("75203", "2", "130", "469", "1", "1.600000000000", "42"),("112645", "2", "24", "67", "1", "3.150000000000", "43"),("5345", "2", "17", "102", "1", "16.390000000000", "44"),("86343", "2", "12", "28", "1", "19.968000000000", "45"),("100473", "1", "1", "62", "1", "15.320000000000", "46"),("159835", "1", "1000", "575", "1", "27.730000000000", "47"),("159837", "1", "1000", "575", "1", "27.730000000000", "48"),("159841", "1", "1000", "575", "1", "27.730000000000", "49"),("159867", "1", "1000", "575", "1", "27.730000000000", "50"),("159869", "1", "1000", "575", "1", "27.730000000000", "51"),("159873", "1", "1000", "575", "1", "27.730000000000", "52"),("154255", "1", "1000", "575", "1", "27.730000000000", "53"),("154153", "1", "1000", "575", "1", "21.850000000000", "54"),("154155", "1", "1000", "575", "1", "21.850000000000", "55"),("154159", "1", "1000", "575", "1", "21.850000000000", "56"),("154193", "1", "1000", "575", "1", "21.850000000000", "57"),("154195", "1", "1000", "575", "1", "21.850000000000", "58"),("154199", "1", "1000", "575", "1", "21.850000000000", "59"),("154121", "1", "1003", "575", "1", "24.370000000000", "60"),("123753", "1", "1000", "575", "1", "27.730000000000", "61"),("123757", "1", "1000", "575", "1", "27.730000000000", "62"),("123681", "1", "1000", "575", "1", "27.730000000000", "63"),("123693", "1", "1000", "575", "1", "27.730000000000", "64"),("123707", "1", "1000", "575", "1", "27.730000000000", "65"),("159809", "1", "1000", "575", "1", "27.730000000000", "66"),("159829", "1", "1000", "575", "1", "27.730000000000", "67"),("159839", "1", "1000", "575", "1", "27.730000000000", "68"),("159843", "1", "1000", "575", "1", "27.730000000000", "69"),("159853", "1", "1000", "575", "1", "27.730000000000", "70"),("159855", "1", "1000", "575", "1", "27.730000000000", "71"),("159857", "1", "1000", "575", "1", "27.730000000000", "72"),("159871", "1", "1000", "575", "1", "27.730000000000", "73"),("159875", "1", "1000", "575", "1", "27.730000000000", "74"),("159885", "1", "1000", "575", "1", "27.730000000000", "75"),("159887", "1", "1000", "575", "1", "27.730000000000", "76"),("159889", "1", "1000", "575", "1", "27.730000000000", "77"),("126333", "1", "1000", "575", "1", "91.600000000000", "78"),("126335", "1", "1000", "575", "1", "91.600000000000", "79"),("126337", "1", "1000", "575", "1", "91.600000000000", "80"),("154261", "1", "1000", "575", "1", "27.730000000000", "81"),("154075", "1", "1000", "575", "1", "27.730000000000", "82"),("154079", "1", "1000", "575", "1", "27.730000000000", "83"),("154091", "1", "1000", "575", "1", "27.730000000000", "84"),("154107", "1", "1000", "575", "1", "24.370000000000", "85"),("154117", "1", "1000", "575", "1", "24.370000000000", "86"),("154129", "1", "1000", "575", "1", "24.370000000000", "87"),("154135", "1", "1000", "575", "1", "24.370000000000", "88"),("154141", "1", "1000", "575", "1", "21.850000000000", "89"),("154143", "1", "1000", "575", "1", "21.850000000000", "90"),("154145", "1", "1000", "575", "1", "21.850000000000", "91"),("154151", "1", "1000", "575", "1", "21.850000000000", "92"),("154157", "1", "1000", "575", "1", "21.850000000000", "93"),("154161", "1", "1000", "575", "1", "21.850000000000", "94"),("154163", "1", "1000", "575", "1", "21.850000000000", "95"),("154173", "1", "1000", "575", "1", "21.850000000000", "96"),("154175", "1", "1000", "575", "1", "21.850000000000", "97"),("154177", "1", "1000", "575", "1", "21.850000000000", "98"),("154181", "1", "1000", "575", "1", "21.850000000000", "99"),("154183", "1", "1000", "575", "1", "21.850000000000", "100"),("154185", "1", "1000", "575", "1", "21.850000000000", "101"),("154191", "1", "1000", "575", "1", "21.850000000000", "102"),("154197", "1", "1000", "575", "1", "21.850000000000", "103"),("154201", "1", "1000", "575", "1", "21.850000000000", "104"),("154203", "1", "1000", "575", "1", "21.850000000000", "105"),("154213", "1", "1000", "575", "1", "21.850000000000", "106"),("154215", "1", "1000", "575", "1", "21.850000000000", "107"),("154217", "1", "1000", "575", "1", "21.850000000000", "108"),("154221", "1", "1000", "575", "1", "1215.130000000000", "109"),("38649", "2", "1003", "279", "1", "24.370000000000", "110"),("77414", "2", "1001", "279", "1", "16.720000000000", "111"),("58443", "2", "1000", "222", "1", "33.318400000000", "112"),("38587", "2", "1000", "279", "1", "24.370000000000", "113"),("38658", "2", "1000", "279", "1", "24.370000000000", "114"),("77426", "2", "1000", "279", "1", "15.290000000000", "115"),("200799", "2", "1000", "11", "1", "25.090000000000", "116"),("202075", "2", "1000", "423", "1", "5.880000000000", "117"),("202085", "2", "1000", "423", "1", "6.720000000000", "118"),("197339", "2", "1000", "287", "1", "57.980000000000", "119"),("197337", "2", "1000", "287", "1", "57.980000000000", "120"),("197341", "2", "1000", "287", "1", "57.980000000000", "121"),("86346", "2", "11", "28", "1", "19.968000000000", "122"),("86344", "2", "9", "28", "1", "19.968000000000", "123"),("154239", "1", "1002", "575", "1", "36.970000000000", "124"),("123747", "1", "1001", "575", "1", "27.730000000000", "125"),("123527", "1", "1001", "575", "1", "27.730000000000", "126"),("154251", "1", "1001", "575", "1", "36.970000000000", "127"),("154243", "1", "1001", "575", "1", "36.970000000000", "128"),("123389", "1", "1000", "575", "1", "27.730000000000", "129"),("123759", "1", "1000", "575", "1", "27.730000000000", "130"),("123761", "1", "1000", "575", "1", "27.730000000000", "131"),("123405", "1", "1000", "575", "1", "27.730000000000", "132"),("123537", "1", "1000", "575", "1", "27.730000000000", "133"),("123561", "1", "1000", "575", "1", "27.730000000000", "134"),("123581", "1", "1000", "575", "1", "27.730000000000", "135"),("123699", "1", "1000", "575", "1", "27.730000000000", "136"),("123729", "1", "1000", "575", "1", "27.730000000000", "137"),("159831", "1", "1000", "575", "1", "27.730000000000", "138"),("159833", "1", "1000", "575", "1", "27.730000000000", "139"),("126339", "2", "1000", "575", "1", "86.550000000000", "140"),("154245", "1", "1000", "575", "1", "36.970000000000", "141"),("154247", "1", "1000", "575", "1", "36.970000000000", "142"),("154249", "1", "1000", "575", "1", "36.970000000000", "143"),("154253", "1", "1000", "575", "1", "36.970000000000", "144"),("154259", "1", "1000", "575", "1", "27.730000000000", "145"),("154071", "1", "1000", "575", "1", "27.730000000000", "146"),("154077", "1", "1000", "575", "1", "27.730000000000", "147"),("154081", "1", "1000", "575", "1", "27.730000000000", "148"),("154083", "1", "1000", "575", "1", "27.730000000000", "149"),("154085", "1", "1000", "575", "1", "27.730000000000", "150"),("154109", "1", "1000", "575", "1", "24.370000000000", "151"),("154119", "1", "1000", "575", "1", "24.370000000000", "152"),("154137", "1", "1000", "575", "1", "24.370000000000", "153"),("154147", "1", "1000", "575", "1", "21.850000000000", "154"),("154149", "1", "1000", "575", "1", "21.850000000000", "155"),("154187", "1", "1000", "575", "1", "21.850000000000", "156"),("154189", "1", "1000", "575", "1", "21.850000000000", "157"),("154223", "1", "1000", "575", "1", "35.290000000000", "158"),("154225", "1", "1000", "575", "1", "35.290000000000", "159"),("154227", "1", "1000", "575", "1", "35.290000000000", "160"),("154229", "1", "1000", "575", "1", "35.290000000000", "161"),("154231", "1", "1000", "575", "1", "35.290000000000", "162"),("154233", "1", "1000", "575", "1", "35.290000000000", "163"),("154235", "1", "1000", "575", "1", "35.290000000000", "164"),("154237", "1", "1000", "575", "1", "35.290000000000", "165"),("154241", "1", "1000", "575", "1", "36.970000000000", "166"),("156749", "1", "1000", "575", "1", "24.370000000000", "167"),("126503", "2", "2", "575", "1", "3.360000000000", "168"),("123715", "1", "1", "575", "1", "27.730000000000", "169"),("123539", "1", "1001", "575", "1", "27.730000000000", "170"),("123587", "1", "1001", "575", "1", "27.730000000000", "171"),("123385", "1", "1000", "575", "1", "27.730000000000", "172"),("123391", "1", "1000", "575", "1", "27.730000000000", "173"),("123399", "1", "1000", "575", "1", "27.730000000000", "174"),("123763", "1", "1000", "575", "1", "27.730000000000", "175"),("123765", "1", "1000", "575", "1", "27.730000000000", "176"),("123559", "1", "1000", "575", "1", "27.730000000000", "177"),("123571", "1", "1000", "575", "1", "27.730000000000", "178"),("123573", "1", "1000", "575", "1", "27.730000000000", "179"),("123579", "1", "1000", "575", "1", "27.730000000000", "180"),("123589", "1", "1000", "575", "1", "27.730000000000", "181"),("123601", "1", "1000", "575", "1", "27.730000000000", "182"),("123703", "1", "1000", "575", "1", "27.730000000000", "183"),("123723", "1", "1000", "575", "1", "27.730000000000", "184"),("159815", "1", "1000", "575", "1", "27.730000000000", "185"),("159817", "1", "1000", "575", "1", "27.730000000000", "186"),("159819", "1", "1000", "575", "1", "27.730000000000", "187"),("159821", "1", "1000", "575", "1", "27.730000000000", "188"),("159901", "1", "1000", "575", "1", "33.610000000000", "189"),("154257", "1", "1000", "575", "1", "27.730000000000", "190"),("154065", "1", "1000", "575", "1", "27.730000000000", "191"),("154073", "1", "1000", "575", "1", "27.730000000000", "192"),("154089", "1", "1000", "575", "1", "27.730000000000", "193"),("154105", "1", "1000", "575", "1", "24.370000000000", "194"),("154125", "1", "1000", "575", "1", "24.370000000000", "195"),("126499", "2", "1", "575", "1", "30.250000000000", "196"),("215407", "1", "1002", "729", "1", "79.830000000000", "197"),("215259", "1", "1002", "729", "1", "79.830000000000", "198"),("208407", "1", "1002", "54", "1", "36.970000000000", "199"),("226105", "1", "1000", "459", "1", "56.300000000000", "200"),("100148", "1", "37", "28", "1", "19.968000000000", "201"),("237394", "2", "7", "28", "1", "19.968000000000", "202"),("215493", "1", "2", "729", "1", "70.590000000000", "203"),("215473", "1", "2", "729", "1", "70.590000000000", "204"),("188207", "1", "1", "121", "1", "190.370000000000", "205"),("123395", "1", "1000", "575", "1", "27.730000000000", "206"),("123755", "1", "1000", "575", "1", "27.730000000000", "207"),("123543", "1", "1000", "575", "1", "27.730000000000", "208"),("123575", "1", "1000", "575", "1", "27.730000000000", "209"),("123595", "1", "1000", "575", "1", "27.730000000000", "210"),("123597", "1", "1000", "575", "1", "27.730000000000", "211"),("159813", "1", "1000", "575", "1", "27.730000000000", "212"),("159827", "1", "1000", "575", "1", "27.730000000000", "213"),("159845", "1", "1000", "575", "1", "27.730000000000", "214"),("159847", "1", "1000", "575", "1", "27.730000000000", "215"),("159849", "1", "1000", "575", "1", "27.730000000000", "216"),("159851", "1", "1000", "575", "1", "27.730000000000", "217"),("159859", "1", "1000", "575", "1", "27.730000000000", "218"),("159877", "1", "1000", "575", "1", "27.730000000000", "219"),("159879", "1", "1000", "575", "1", "27.730000000000", "220"),("159883", "1", "1000", "575", "1", "27.730000000000", "221"),("159915", "1", "1000", "575", "1", "33.610000000000", "222"),("126607", "1", "1000", "575", "1", "2726.050000000000", "223"),("154139", "1", "1000", "575", "1", "21.850000000000", "224"),("154165", "1", "1000", "575", "1", "21.850000000000", "225"),("154167", "1", "1000", "575", "1", "21.850000000000", "226"),("154169", "1", "1000", "575", "1", "21.850000000000", "227"),("154171", "1", "1000", "575", "1", "21.850000000000", "228"),("154179", "1", "1000", "575", "1", "21.850000000000", "229"),("154205", "1", "1000", "575", "1", "21.850000000000", "230"),("154207", "1", "1000", "575", "1", "21.850000000000", "231"),("154209", "1", "1000", "575", "1", "21.850000000000", "232"),("154211", "1", "1000", "575", "1", "21.850000000000", "233"),("159811", "1", "1000", "575", "1", "27.730000000000", "234"),("159911", "1", "1000", "575", "1", "33.610000000000", "235"),("159913", "1", "1000", "575", "1", "33.610000000000", "236"),("126595", "1", "1000", "575", "1", "1595.800000000000", "237"),("88292", "2", "1025", "67", "1", "4.120000000000", "238"),("10371", "2", "1011", "135", "1", "74.790000000000", "239"),("34086", "2", "1010", "135", "1", "74.790000000000", "240"),("229767", "2", "1005", "135", "1", "74.790000000000", "241"),("7997", "2", "1005", "135", "1", "74.790000000000", "242"),("7998", "2", "1004", "135", "1", "74.790000000000", "243"),("229769", "2", "1004", "135", "1", "74.790000000000", "244"),("10373", "2", "1004", "135", "1", "74.790000000000", "245"),("229766", "2", "1004", "135", "1", "74.790000000000", "246"),("34087", "2", "1004", "135", "1", "74.790000000000", "247"),("229768", "2", "1002", "135", "1", "74.790000000000", "248"),("54149", "2", "1001", "382", "1", "17.650000000000", "249"),("11862", "2", "1001", "135", "1", "74.790000000000", "250"),("54147", "2", "1000", "382", "1", "17.650000000000", "251"),("54148", "2", "1000", "382", "1", "17.650000000000", "252"),("54165", "2", "1000", "382", "1", "63.870000000000", "253"),("223061", "1", "1000", "459", "1", "63.870000000000", "254"),("34088", "2", "1000", "135", "1", "74.790000000000", "255"),("11863", "2", "1000", "135", "1", "74.790000000000", "256"),("10372", "2", "1000", "135", "1", "74.790000000000", "257"),("118047", "1", "24", "28", "1", "16.435200000000", "258"),("118045", "1", "19", "28", "1", "16.435200000000", "259"),("86365", "2", "19", "28", "1", "19.968000000000", "260"),("118044", "1", "17", "28", "1", "16.435200000000", "261"),("237395", "1", "8", "28", "1", "16.435200000000", "262"),("115953", "2", "4", "228", "1", "10.000000000000", "263"),("211761", "2", "4", "309", "1", "28.490000000000", "264"),("115954", "2", "2", "228", "1", "18.720000000000", "265"),("88289", "2", "1076", "67", "1", "2.350000000000", "266"),("66418", "2", "1003", "279", "1", "24.370000000000", "267"),("215261", "1", "1002", "729", "1", "85.710000000000", "268"),("215291", "1", "1002", "729", "1", "79.830000000000", "269"),("66462", "2", "1000", "279", "1", "24.370000000000", "270"),("119045", "2", "1000", "105", "1", "24.370000000000", "271"),("119053", "2", "1000", "105", "1", "23.530000000000", "272"),("128511", "2", "1000", "150", "1", "18.040000000000", "273"),("137875", "1", "1000", "150", "1", "25.680000000000", "274"),("228764", "1", "1000", "135", "1", "74.790000000000", "275"),("225692", "-100", "1000", "135", "1", "74.790000000000", "276"),("225693", "-100", "1000", "135", "1", "74.790000000000", "277"),("225694", "-100", "1000", "135", "1", "74.790000000000", "278"),("118046", "1", "14", "28", "1", "16.435200000000", "279"),("164562", "1", "5", "593", "1", "17.560000000000", "280"),("131653", "1", "4", "593", "1", "17.560000000000", "281"),("115952", "2", "2", "228", "1", "10.000000000000", "282"),("115950", "2", "1", "228", "1", "11.680000000000", "283"),("115951", "2", "1", "228", "1", "10.000000000000", "284"),("88290", "2", "1", "67", "1", "2.350000000000", "285"),("97868", "2", "1004", "135", "1", "83.190000000000", "286"),("66437", "2", "1002", "279", "1", "20.080000000000", "287"),("167447", "1", "1000", "459", "1", "69.750000000000", "288"),("224831", "1", "1000", "729", "1", "94.120000000000", "289"),("97869", "2", "1000", "135", "1", "83.190000000000", "290"),("144435", "2", "1000", "480", "1", "21.050000000000", "291"),("237397", "1", "6", "28", "1", "16.435200000000", "292"),("87211", "2", "4", "354", "1", "22.860000000000", "293"),("87218", "2", "1", "354", "1", "22.860000000000", "294"),("115806", "2", "1002", "294", "1", "13.140000000000", "295"),("115805", "2", "1000", "294", "1", "23.360000000000", "296"),("115809", "2", "1000", "294", "1", "26.290000000000", "297"),("115811", "2", "1000", "294", "1", "23.360000000000", "298"),("115814", "2", "1000", "294", "1", "13.140000000000", "299"),("166368", "2", "1000", "294", "1", "13.140000000000", "300"),("216861", "2", "1000", "279", "1", "33.610000000000", "301"),("115812", "2", "2", "294", "1", "13.140000000000", "302"),("94440", "2", "1001", "135", "1", "251.260000000000", "303"),("102441", "2", "1000", "294", "1", "25.040000000000", "304"),("194369", "2", "1000", "87", "1", "399.160000000000", "305"),("194387", "2", "1000", "87", "1", "465.550000000000", "306"),("194371", "2", "1000", "87", "1", "399.160000000000", "307"),("194385", "2", "1000", "87", "1", "465.550000000000", "308"),("94438", "2", "1000", "135", "1", "251.260000000000", "309"),("94437", "2", "1", "135", "1", "251.260000000000", "310"),("172591", "2", "1005", "401", "1", "5.460000000000", "311"),("172587", "2", "1002", "401", "1", "7.560000000000", "312"),("146485", "1", "1000", "237", "1", "38.180000000000", "313"),("172594", "2", "1000", "401", "1", "6.860000000000", "314"),("151365", "2", "3", "357", "1", "49.130000000000", "315"),("60124", "2", "1002", "27", "1", "157.140000000000", "316"),("60117", "2", "1001", "27", "1", "174.790000000000", "317"),("179149", "1", "1000", "13", "1", "19.240000000000", "318"),("179152", "1", "1000", "13", "1", "16.720000000000", "319"),("151367", "2", "3", "357", "1", "56.690000000000", "320"),("60099", "2", "2", "27", "1", "242.020000000000", "321"),("156275", "2", "1000", "629", "1", "15.550000000000", "322"),("156277", "2", "1000", "629", "1", "15.550000000000", "323"),("156279", "2", "1000", "629", "1", "15.550000000000", "324"),("156281", "2", "1000", "629", "1", "15.550000000000", "325"),("156283", "2", "5", "629", "1", "15.550000000000", "326"),("60158", "2", "3", "27", "1", "133.610000000000", "327"),("62671", "2", "1004", "27", "1", "591.600000000000", "328"),("119642", "2", "1001", "27", "1", "115.970000000000", "329"),("36250", "2", "1000", "105", "1", "21.850000000000", "330"),("36252", "2", "1000", "105", "1", "21.850000000000", "331"),("36253", "2", "1000", "105", "1", "21.850000000000", "332"),("36254", "2", "1000", "105", "1", "21.850000000000", "333"),("36255", "2", "1000", "105", "1", "21.850000000000", "334"),("36256", "2", "1000", "105", "1", "21.850000000000", "335"),("162489", "1", "1000", "459", "1", "55.460000000000", "336"),("225721", "2", "1000", "459", "1", "63.030000000000", "337"),("225825", "1", "1000", "459", "1", "61.340000000000", "338"),("226108", "1", "1000", "459", "1", "83.190000000000", "339"),("225918", "1", "1000", "459", "1", "55.460000000000", "340"),("225961", "1", "1000", "459", "1", "60.500000000000", "341"),("225750", "2", "1000", "459", "1", "58.820000000000", "342"),("226426", "1", "1000", "459", "1", "60.500000000000", "343"),("222943", "1", "1000", "459", "1", "60.500000000000", "344"),("222452", "1", "1000", "459", "1", "61.340000000000", "345"),("223836", "2", "1000", "459", "1", "64.710000000000", "346"),("223376", "1", "1000", "459", "1", "55.460000000000", "347"),("223946", "2", "1000", "459", "1", "60.500000000000", "348"),("194259", "1", "1000", "87", "1", "284.030000000000", "349"),("194261", "1", "1000", "87", "1", "284.030000000000", "350"),("93931", "2", "3", "105", "1", "17.560000000000", "351"),("179146", "1", "1027", "13", "1", "12.520000000000", "352"),("228157", "1", "1003", "20", "1", "22.090000000000", "353"),("240449", "1", "1003", "20", "1", "22.090000000000", "354"),("179150", "1", "1001", "13", "1", "12.520000000000", "355"),("179151", "1", "1001", "13", "1", "16.720000000000", "356"),("118133", "2", "1000", "105", "1", "22.690000000000", "357"),("118134", "2", "1000", "105", "1", "22.690000000000", "358"),("118135", "2", "1000", "105", "1", "22.690000000000", "359"),("118137", "2", "1000", "105", "1", "22.690000000000", "360"),("118139", "2", "1000", "105", "1", "22.690000000000", "361"),("118140", "2", "1000", "105", "1", "22.690000000000", "362"),("89213", "2", "1000", "459", "1", "60.500000000000", "363"),("225910", "1", "1000", "459", "1", "68.910000000000", "364"),("226483", "1", "1000", "459", "1", "60.500000000000", "365"),("226402", "1", "1000", "459", "1", "55.460000000000", "366"),("226437", "1", "1000", "459", "1", "57.980000000000", "367"),("222845", "1", "1000", "459", "1", "60.500000000000", "368"),("179148", "1", "1000", "13", "1", "12.520000000000", "369"),("228165", "1", "1000", "20", "1", "57.540000000000", "370"),("179147", "1", "1000", "13", "1", "12.520000000000", "371"),("228166", "1", "1000", "20", "1", "57.540000000000", "372"),("95401", "2", "3", "27", "1", "247.060000000000", "373"),("70745", "2", "1004", "27", "1", "373.950000000000", "374"),("228154", "1", "1003", "20", "1", "22.090000000000", "375"),("228155", "1", "1003", "20", "1", "22.090000000000", "376"),("228156", "1", "1003", "20", "1", "22.090000000000", "377"),("240450", "1", "1003", "20", "1", "22.090000000000", "378"),("240453", "1", "1003", "20", "1", "22.090000000000", "379"),("199573", "2", "1001", "58", "1", "231.090000000000", "380"),("228358", "2", "1001", "20", "1", "22.090000000000", "381"),("228359", "2", "1001", "20", "1", "22.090000000000", "382"),("199571", "2", "1001", "58", "1", "201.680000000000", "383"),("240427", "1", "1001", "20", "1", "57.540000000000", "384"),("228163", "1", "1001", "20", "1", "57.540000000000", "385"),("228164", "1", "1001", "20", "1", "57.540000000000", "386"),("103572", "1", "1001", "27", "1", "11.510000000000", "387"),("114496", "2", "1000", "27", "1", "44.540000000000", "388"),("228356", "2", "1000", "20", "1", "22.090000000000", "389"),("228357", "2", "1000", "20", "1", "22.090000000000", "390"),("223914", "2", "1000", "459", "1", "69.750000000000", "391"),("198135", "2", "1000", "18", "1", "315.030000000000", "392"),("24470", "2", "1000", "19", "1", "34.540000000000", "393"),("24481", "2", "1000", "19", "1", "34.540000000000", "394"),("228162", "1", "1000", "20", "1", "57.540000000000", "395"),("228161", "1", "1000", "20", "1", "57.540000000000", "396"),("24482", "2", "2", "19", "1", "34.540000000000", "397"),("179145", "1", "1023", "13", "1", "12.520000000000", "398"),("96698", "2", "1002", "27", "1", "484.030000000000", "399"),("221957", "1", "1000", "459", "1", "55.460000000000", "400"),("49377", "2", "1000", "50", "1", "43.700000000000", "401"),("197215", "2", "1000", "50", "1", "41.180000000000", "402"),("197217", "2", "1000", "50", "1", "41.180000000000", "403"),("197219", "2", "1000", "50", "1", "41.180000000000", "404"),("178202", "1", "1005", "128", "1", "82.350000000000", "405"),("210047", "1", "1005", "128", "1", "114.290000000000", "406"),("210049", "1", "1005", "128", "1", "100.840000000000", "407"),("210051", "1", "1005", "128", "1", "94.120000000000", "408"),("210053", "1", "1005", "128", "1", "82.350000000000", "409"),("210055", "1", "1004", "128", "1", "114.290000000000", "410"),("210059", "1", "1004", "128", "1", "100.840000000000", "411"),("178201", "1", "1002", "128", "1", "94.120000000000", "412"),("178203", "1", "1002", "128", "1", "82.350000000000", "413"),("210061", "1", "1002", "128", "1", "82.350000000000", "414"),("210063", "1", "1002", "128", "1", "82.350000000000", "415"),("178204", "1", "1001", "128", "1", "82.350000000000", "416"),("210065", "1", "1001", "128", "1", "82.350000000000", "417"),("210067", "1", "1001", "128", "1", "82.350000000000", "418"),("197181", "1", "1000", "50", "1", "185.710000000000", "419"),("197183", "1", "1000", "50", "1", "156.300000000000", "420"),("197185", "1", "1000", "50", "1", "136.130000000000", "421"),("197187", "1", "1000", "50", "1", "115.970000000000", "422"),("148835", "1", "15", "625", "1", "31.705600000000", "423"),("148833", "1", "15", "625", "1", "31.705600000000", "424"),("176597", "1", "11", "625", "1", "35.225600000000", "425"),("109866", "1", "1005", "188", "1", "59.660000000000", "426"),("109865", "1", "1005", "188", "1", "53.780000000000", "427"),("109864", "1", "1002", "188", "1", "48.740000000000", "428"),("57165", "2", "1000", "27", "1", "82.350000000000", "429"),("176598", "1", "19", "625", "1", "35.225600000000", "430"),("148829", "1", "14", "625", "1", "35.225600000000", "431"),("148831", "1", "6", "625", "1", "31.705600000000", "432"),("169808", "1", "5", "625", "1", "21.132800000000", "433"),("169811", "1", "4", "625", "1", "21.132800000000", "434"),("169813", "1", "4", "625", "1", "28.185600000000", "435"),("113652", "2", "1004", "27", "1", "59.660000000000", "436"),("113653", "2", "1000", "30", "1", "201.680000000000", "437"),("113654", "2", "1000", "30", "1", "262.180000000000", "438"),("169804", "1", "4", "625", "1", "28.185600000000", "439"),("169807", "1", "1", "625", "1", "21.132800000000", "440"),("96394", "2", "1000", "27", "1", "53.780000000000", "441"),("169810", "1", "10", "625", "1", "21.132800000000", "442"),("169820", "1", "6", "625", "1", "28.185600000000", "443"),("145919", "1", "0", "11", "1", "229.130000000000", "444"),("188371", "2", "0", "655", "1", "221.210000000000", "445"),("15314", "2", "0", "115", "1", "21.500000000000", "446"),("188375", "2", "0", "655", "1", "504.120000000000", "447"),("168776", "2", "0", "655", "1", "491.880000000000", "448"),("188365", "2", "0", "655", "1", "368.850000000000", "449"),("188367", "2", "0", "655", "1", "419.700000000000", "450"),("188369", "2", "0", "655", "1", "467.280000000000", "451"),("188377", "2", "0", "655", "1", "541.100000000000", "452"),("188651", "2", "0", "655", "1", "285.630000000000", "453"),("125209", "1", "0", "575", "1", "26.300000000000", "454"),("37619", "2", "0", "204", "1", "3.000000000000", "455"),("56563", "2", "0", "287", "1", "41.410000000000", "456"),("56564", "2", "0", "287", "1", "41.410000000000", "457"),("112644", "2", "0", "67", "1", "1.950000000000", "458"),("112646", "2", "0", "67", "1", "1.950000000000", "459"),("167137", "2", "0", "469", "1", "0.830000000000", "460"),("166837", "2", "0", "469", "1", "17.650000000000", "461"),("166835", "2", "0", "469", "1", "8.190000000000", "462"),("159899", "1", "0", "575", "1", "26.300000000000", "463"),("224991", "2", "0", "528", "1", "16.390000000000", "464"),("79346", "2", "0", "56", "1", "10.800000000000", "465"),("224987", "2", "0", "528", "1", "11.700000000000", "466"),("224988", "2", "0", "528", "1", "11.700000000000", "467"),("224989", "2", "0", "528", "1", "11.700000000000", "468"),("224990", "2", "0", "528", "1", "11.700000000000", "469"),("108903", "2", "0", "279", "1", "19.500000000000", "470"),("123569", "1", "0", "575", "1", "21.700000000000", "471"),("10406", "2", "0", "135", "1", "24.000000000000", "472"),("233396", "2", "0", "54", "1", "23.750000000000", "473"),("54225", "2", "0", "382", "1", "13.700000000000", "474"),("34084", "2", "0", "135", "1", "24.000000000000", "475"),("34085", "2", "0", "135", "1", "24.000000000000", "476"),("130961", "2", "0", "405", "1", "11.940000000000", "477"),("224950", "2", "0", "729", "1", "51.000000000000", "478"),("224951", "2", "0", "729", "1", "51.000000000000", "479"),("188049", "2", "0", "280", "1", "14.290000000000", "480"),("87215", "2", "0", "354", "1", "19.050000000000", "481"),("87217", "2", "0", "354", "1", "19.050000000000", "482"),("87212", "2", "0", "354", "1", "19.700000000000", "483"),("237125", "2", "0", "19", "1", "1428.570000000000", "484"),("115808", "2", "0", "294", "1", "23.360000000000", "485"),("224850", "1", "0", "729", "1", "63.000000000000", "486"),("94436", "2", "0", "135", "1", "145.800000000000", "487"),("102440", "2", "0", "294", "1", "18.150000000000", "488"),("94439", "2", "0", "135", "1", "145.000000000000", "489"),("102439", "2", "0", "294", "1", "18.150000000000", "490"),("194367", "2", "0", "87", "1", "305.990000000000", "491"),("167726", "1", "0", "469", "1", "41.000000000000", "492"),("224049", "1", "0", "13", "1", "9.600000000000", "493"),("62734", "2", "0", "27", "1", "106.250000000000", "494"),("60112", "2", "0", "27", "1", "89.000000000000", "495"),("93883", "2", "0", "105", "1", "21.000000000000", "496"),("93932", "2", "0", "105", "1", "21.000000000000", "497"),("36257", "2", "0", "105", "1", "17.000000000000", "498"),("222034", "1", "0", "459", "1", "53.000000000000", "499"),("226745", "2", "0", "27", "1", "52.000000000000", "500"),("226451", "1", "0", "459", "1", "42.000000000000", "501"),("226463", "1", "0", "459", "1", "46.000000000000", "502"),("62670", "2", "0", "27", "1", "210.000000000000", "503"),("226390", "1", "0", "459", "1", "42.000000000000", "504"),("232155", "1", "0", "459", "1", "46.000000000000", "505"),("118138", "2", "0", "105", "1", "18.000000000000", "506"),("113070", "4", "0", "27", "1", "167.000000000000", "507"),("36602", "2", "0", "19", "1", "26.560000000000", "508"),("95402", "2", "0", "27", "1", "247.060000000000", "509"),("24483", "2", "0", "19", "1", "25.620000000000", "510"),("24484", "2", "0", "19", "1", "26.560000000000", "511"),("24468", "2", "0", "19", "1", "26.560000000000", "512"),("24469", "2", "0", "19", "1", "26.560000000000", "513"),("63128", "2", "0", "27", "1", "99.000000000000", "514"),("193687", "2", "0", "469", "1", "81.970000000000", "515"),("169821", "1", "0", "625", "1", "20.480000000000", "516")

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 = '2' AND name = 'lichidare_stoc'