Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '6b79bea7f5806e0743f6abab8d'

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 ("147227", "10", "1000", "13", "1", "132.170000000000", "1"),("206167", "2", "1000", "476", "1", "147.840000000000", "2"),("231316", "2", "1000", "121", "1", "91.590000000000", "3"),("236884", "2", "1000", "47", "1", "74.780000000000", "4"),("233844", "2", "1000", "353", "1", "91.550000000000", "5"),("59583", "2", "1", "287", "1", "47.040000000000", "6"),("70556", "2", "1024", "47", "1", "22.680000000000", "7"),("210235", "2", "1000", "476", "1", "70.120000000000", "8"),("111635", "2", "1000", "168", "1", "73.400000000000", "9"),("236596", "2", "1000", "168", "1", "9.150000000000", "10"),("205677", "2", "1003", "476", "1", "70.120000000000", "11"),("242649", "2", "1000", "73", "1", "294.520000000000", "12"),("111636", "2", "1005", "168", "1", "137.690000000000", "13"),("117192", "10", "2", "280", "1", "63.770000000000", "14"),("151859", "2", "1000", "290", "1", "472.170000000000", "15"),("62402", "2", "1000", "188", "1", "32.680000000000", "16"),("8911", "4", "1000", "13", "1", "36.450000000000", "17"),("62788", "2", "1016", "24", "1", "9.560000000000", "18"),("237660", "2", "1002", "24", "1", "11.670000000000", "19"),("211917", "1", "1000", "224", "1", "65.450000000000", "20"),("211919", "1", "1000", "224", "1", "98.220000000000", "21"),("223256", "2", "1002", "768", "1", "84.780000000000", "22"),("78198", "2", "1001", "476", "1", "1030.200000000000", "23"),("22429", "2", "1001", "47", "1", "74.780000000000", "24"),("49532", "2", "1000", "290", "1", "270.490000000000", "25"),("151853", "2", "1000", "290", "1", "304.110000000000", "26"),("222248", "2", "1000", "768", "1", "84.780000000000", "27"),("222863", "2", "1000", "768", "1", "135.200000000000", "28"),("179975", "2", "1000", "290", "1", "530.990000000000", "29"),("179976", "2", "1000", "290", "1", "530.990000000000", "30"),("179978", "2", "1000", "290", "1", "252.840000000000", "31"),("166241", "2", "1000", "47", "1", "330.240000000000", "32"),("8912", "10", "1000", "13", "1", "25.120000000000", "33"),("62404", "2", "1000", "24", "1", "38.550000000000", "34"),("97568", "2", "1", "168", "1", "580.120000000000", "35"),("166239", "2", "1001", "47", "1", "504.190000000000", "36"),("228217", "1", "1002", "168", "1", "605.830000000000", "37"),("78146", "2", "1001", "476", "1", "420.950000000000", "38"),("78147", "2", "1001", "476", "1", "420.950000000000", "39"),("78178", "2", "1001", "476", "1", "483.980000000000", "40"),("88972", "2", "1000", "362", "1", "57.970000000000", "41"),("88973", "2", "1000", "362", "1", "47.020000000000", "42"),("37508", "2", "1000", "104", "1", "22.600000000000", "43"),("151869", "2", "1000", "290", "1", "336.880000000000", "44"),("113749", "2", "1000", "24", "1", "98.220000000000", "45"),("113750", "2", "1000", "24", "1", "134.360000000000", "46"),("78142", "2", "1000", "476", "1", "378.930000000000", "47"),("88970", "2", "1000", "362", "1", "33.600000000000", "48"),("94761", "2", "1003", "168", "1", "354.360000000000", "49"),("228272", "1", "1002", "168", "1", "530.960000000000", "50"),("94759", "2", "1002", "168", "1", "270.790000000000", "51"),("230021", "1", "1001", "168", "1", "682.220000000000", "52"),("88971", "2", "1000", "362", "1", "36.120000000000", "53"),("128307", "2", "1000", "47", "1", "79.820000000000", "54"),("179974", "2", "1000", "290", "1", "420.910000000000", "55"),("179977", "2", "1000", "290", "1", "228.470000000000", "56"),("25879", "2", "999", "75", "1", "76.370000000000", "57"),("94760", "2", "2", "168", "1", "306.160000000000", "58"),("166223", "2", "1", "121", "1", "336.920000000000", "59"),("173883", "2", "1003", "47", "1", "291.590000000000", "60"),("166243", "2", "1003", "47", "1", "426.880000000000", "61"),("166767", "1", "1002", "121", "1", "562.170000000000", "62"),("230022", "1", "1001", "168", "1", "832.730000000000", "63"),("231746", "2", "1001", "121", "1", "300.830000000000", "64"),("231769", "2", "1001", "121", "1", "337.800000000000", "65"),("230023", "1", "1000", "168", "1", "909.120000000000", "66"),("239871", "2", "1000", "73", "1", "89.020000000000", "67"),("239873", "2", "1000", "73", "1", "72.210000000000", "68"),("151759", "-100", "51", "26", "1", "48.760000000000", "69"),("151137", "1", "4", "121", "1", "378.930000000000", "70"),("98610", "2", "2", "168", "1", "656.500000000000", "71"),("188447", "1", "2", "121", "1", "420.950000000000", "72"),("188451", "2", "2", "121", "1", "547.000000000000", "73"),("131401", "2", "1", "168", "1", "387.260000000000", "74"),("94758", "2", "1", "168", "1", "701.130000000000", "75"),("104001", "1", "1", "168", "1", "636.830000000000", "76"),("151761", "-100", "1", "26", "1", "17.200000000000", "77"),("243556", "2", "1000", "75", "1", "370.490000000000", "78"),("212129", "2", "1002", "370", "1", "466.930000000000", "79"),("188509", "2", "1002", "121", "1", "599.980000000000", "80"),("231317", "1", "1001", "121", "1", "300.830000000000", "81"),("212133", "2", "1001", "370", "1", "564.480000000000", "82"),("188449", "1", "2", "121", "1", "462.970000000000", "83"),("217911", "2", "1", "370", "1", "662.090000000000", "84"),("243845", "2", "1000", "204", "1", "269.650000000000", "85"),("243853", "2", "1000", "204", "1", "420.910000000000", "86"),("163671", "1", "1006", "13", "1", "60.400000000000", "87"),("163672", "1", "1002", "13", "1", "45.360000000000", "88"),("229434", "2", "1000", "204", "1", "706.630000000000", "89"),("163674", "1", "1000", "13", "1", "66.920000000000", "90"),("57062", "2", "1", "67", "1", "36.540000000000", "91"),("114401", "2", "1", "287", "1", "511.670000000000", "92"),("228685", "2", "1000", "204", "1", "210.830000000000", "93"),("231346", "1", "1000", "663", "1", "3400.830000000000", "94"),("231347", "1", "1000", "663", "1", "3500.830000000000", "95"),("231348", "1", "1000", "663", "1", "3280.660000000000", "96"),("231349", "1", "1000", "663", "1", "3400.830000000000", "97"),("231350", "1", "1000", "663", "1", "3500.830000000000", "98"),("231351", "1", "1000", "663", "1", "3280.660000000000", "99"),("245267", "2", "1001", "747", "1", "22.600000000000", "100"),("172899", "1", "1000", "663", "1", "2361.330000000000", "101"),("172901", "1", "1000", "663", "1", "2481.500000000000", "102"),("172903", "1", "1000", "663", "1", "2681.500000000000", "103"),("172904", "1", "1000", "663", "1", "2120.990000000000", "104"),("172907", "1", "1000", "663", "1", "2241.170000000000", "105"),("245917", "2", "3", "747", "1", "25.360000000000", "106"),("172912", "1", "1000", "663", "1", "2120.990000000000", "107"),("245918", "2", "6", "747", "1", "24.690000000000", "108"),("44953", "2", "5", "168", "1", "43.600000000000", "109"),("44950", "2", "1", "168", "1", "33.510000000000", "110"),("208295", "4", "6", "747", "1", "21.750000000000", "111"),("183335", "1", "1000", "705", "1", "442.690000000000", "112"),("228153", "1", "1000", "705", "1", "212.070000000000", "113"),("84689", "2", "1", "75", "1", "49.480000000000", "114"),("208299", "4", "37", "747", "1", "13.350000000000", "115"),("208301", "4", "25", "747", "1", "17.550000000000", "116"),("34999", "2", "1005", "39", "1", "2.840000000000", "117"),("103583", "1", "1014", "39", "1", "3.690000000000", "118"),("62675", "2", "1001", "39", "1", "12.340000000000", "119"),("62673", "2", "1001", "39", "1", "12.340000000000", "120"),("203747", "10", "1000", "705", "1", "283.980000000000", "121"),("62676", "2", "1000", "39", "1", "12.340000000000", "122"),("62674", "2", "1000", "39", "1", "12.340000000000", "123"),("62669", "2", "1000", "39", "1", "100.740000000000", "124"),("60061", "2", "1003", "39", "1", "125.120000000000", "125"),("203745", "10", "1000", "705", "1", "990.360000000000", "126"),("69872", "2", "2", "39", "1", "6.630000000000", "127"),("203749", "10", "1000", "705", "1", "434.850000000000", "128"),("69763", "2", "1009", "39", "1", "7.880000000000", "129"),("69760", "2", "1006", "39", "1", "7.880000000000", "130"),("69761", "2", "1006", "39", "1", "7.880000000000", "131"),("69762", "2", "1003", "39", "1", "7.880000000000", "132"),("69759", "2", "1002", "39", "1", "7.880000000000", "133"),("70237", "2", "1002", "39", "1", "25.950000000000", "134"),("34906", "2", "1002", "39", "1", "20.160000000000", "135"),("69722", "2", "1000", "39", "1", "6.210000000000", "136"),("69728", "2", "1000", "39", "1", "8.310000000000", "137"),("69729", "2", "1000", "39", "1", "8.310000000000", "138"),("69730", "2", "1000", "39", "1", "9.150000000000", "139"),("69731", "2", "1000", "39", "1", "8.730000000000", "140"),("69732", "2", "1000", "39", "1", "9.560000000000", "141"),("69733", "2", "1000", "39", "1", "8.730000000000", "142"),("69734", "2", "1000", "39", "1", "8.730000000000", "143"),("69735", "2", "1000", "39", "1", "8.730000000000", "144"),("34905", "2", "1000", "39", "1", "17.550000000000", "145"),("34907", "2", "1000", "39", "1", "31.830000000000", "146"),("91897", "2", "1000", "348", "1", "131.830000000000", "147"),("91912", "2", "1000", "348", "1", "131.830000000000", "148"),("238107", "2", "2", "358", "1", "53.510000000000", "149"),("11988", "2", "1020", "39", "1", "5.020000000000", "150"),("11980", "2", "1017", "39", "1", "2.090000000000", "151"),("11982", "4", "1011", "39", "1", "2.500000000000", "152"),("11978", "2", "1008", "39", "1", "2.090000000000", "153"),("11979", "2", "1008", "39", "1", "2.090000000000", "154"),("71662", "2", "1005", "39", "1", "8.310000000000", "155"),("60502", "2", "1005", "39", "1", "9.150000000000", "156"),("11981", "2", "1004", "39", "1", "2.090000000000", "157"),("60496", "2", "1003", "39", "1", "7.460000000000", "158"),("60522", "2", "1003", "39", "1", "9.150000000000", "159"),("72023", "2", "1002", "39", "1", "8.310000000000", "160"),("60501", "2", "1001", "39", "1", "8.310000000000", "161"),("60513", "2", "1001", "39", "1", "8.310000000000", "162"),("60497", "2", "1000", "39", "1", "9.150000000000", "163"),("71659", "2", "1000", "39", "1", "8.310000000000", "164"),("60516", "2", "12", "39", "1", "8.310000000000", "165"),("62100", "2", "9", "39", "1", "2.090000000000", "166"),("71648", "2", "1005", "39", "1", "8.310000000000", "167"),("60836", "2", "1003", "39", "1", "8.310000000000", "168"),("60837", "2", "1003", "39", "1", "8.310000000000", "169"),("60838", "2", "1003", "39", "1", "8.310000000000", "170"),("60839", "2", "1003", "39", "1", "8.310000000000", "171"),("61698", "2", "1003", "39", "1", "8.310000000000", "172"),("60829", "2", "1002", "39", "1", "8.310000000000", "173"),("70050", "2", "1001", "39", "1", "8.310000000000", "174"),("72024", "2", "1001", "39", "1", "8.310000000000", "175"),("60827", "2", "1001", "39", "1", "8.310000000000", "176"),("60830", "2", "1001", "39", "1", "8.310000000000", "177"),("60840", "2", "1001", "39", "1", "8.310000000000", "178"),("70040", "2", "1000", "39", "1", "8.310000000000", "179"),("71646", "2", "1000", "39", "1", "8.310000000000", "180"),("60828", "2", "1000", "39", "1", "8.310000000000", "181"),("62793", "2", "1000", "39", "1", "10.830000000000", "182"),("185391", "2", "1000", "168", "1", "319.200000000000", "183"),("185393", "2", "1000", "168", "1", "364.570000000000", "184"),("71653", "2", "3", "39", "1", "8.310000000000", "185"),("70577", "2", "999", "39", "1", "19.230000000000", "186"),("81487", "2", "1000", "109", "1", "25.950000000000", "187"),("81488", "2", "1000", "109", "1", "30.990000000000", "188"),("38483", "2", "1000", "49", "1", "22.600000000000", "189"),("93268", "2", "1000", "281", "1", "494.190000000000", "190"),("164863", "2", "13", "124", "1", "6.710000000000", "191"),("70526", "2", "10", "124", "1", "6.710000000000", "192"),("39642", "2", "1003", "39", "1", "16.790000000000", "193"),("60825", "2", "1003", "39", "1", "8.310000000000", "194"),("60791", "2", "1002", "39", "1", "8.310000000000", "195"),("60817", "2", "1002", "39", "1", "8.310000000000", "196"),("60821", "2", "1002", "39", "1", "8.310000000000", "197"),("60788", "2", "1001", "39", "1", "8.310000000000", "198"),("60789", "2", "1001", "39", "1", "8.310000000000", "199"),("60790", "2", "1001", "39", "1", "8.310000000000", "200"),("59820", "2", "1001", "39", "1", "48.640000000000", "201"),("60787", "2", "1000", "39", "1", "8.310000000000", "202"),("60822", "2", "1000", "39", "1", "8.310000000000", "203"),("113531", "2", "1000", "39", "1", "57.880000000000", "204"),("180465", "2", "1000", "464", "1", "148.640000000000", "205"),("185395", "2", "1000", "168", "1", "417.510000000000", "206"),("185397", "2", "1000", "168", "1", "455.330000000000", "207"),("70743", "2", "1000", "39", "1", "101.670000000000", "208"),("59819", "2", "1000", "39", "1", "44.520000000000", "209"),("247578", "2", "1000", "294", "1", "270.790000000000", "210"),("55153", "2", "1008", "285", "1", "27.120000000000", "211"),("237821", "1", "1004", "533", "1", "68.620000000000", "212"),("237823", "1", "1004", "533", "1", "77.110000000000", "213"),("145429", "2", "1003", "73", "1", "42.800000000000", "214"),("237822", "1", "1003", "533", "1", "72.900000000000", "215"),("237824", "1", "1002", "533", "1", "85.600000000000", "216"),("216393", "1", "1002", "476", "1", "47.000000000000", "217"),("72586", "2", "1000", "290", "1", "157.040000000000", "218"),("79938", "2", "1000", "42", "1", "122.680000000000", "219"),("79939", "2", "1000", "42", "1", "122.680000000000", "220"),("79940", "2", "1000", "42", "1", "122.680000000000", "221"),("79941", "2", "1000", "42", "1", "122.680000000000", "222"),("79943", "2", "1000", "42", "1", "122.680000000000", "223"),("111886", "1", "1000", "48", "1", "145.790000000000", "224"),("250094", "1", "1000", "42", "1", "33.880000000000", "225"),("250102", "1", "1000", "42", "1", "33.880000000000", "226"),("250108", "1", "1000", "42", "1", "33.880000000000", "227"),("224825", "2", "1000", "281", "1", "94.170000000000", "228"),("55152", "2", "5", "285", "1", "30.890000000000", "229"),("108396", "1", "2", "469", "1", "41.170000000000", "230"),("60794", "2", "1004", "39", "1", "8.310000000000", "231"),("60797", "2", "1003", "39", "1", "8.310000000000", "232"),("60798", "2", "1003", "39", "1", "8.310000000000", "233"),("60802", "2", "1003", "39", "1", "8.310000000000", "234"),("60783", "2", "1002", "39", "1", "8.310000000000", "235"),("60803", "2", "1002", "39", "1", "8.310000000000", "236"),("60804", "2", "1002", "39", "1", "8.310000000000", "237"),("60805", "2", "1002", "39", "1", "8.310000000000", "238"),("60807", "2", "1002", "39", "1", "8.310000000000", "239"),("60820", "2", "1002", "39", "1", "8.310000000000", "240"),("60832", "2", "1002", "39", "1", "8.310000000000", "241"),("60833", "2", "1002", "39", "1", "8.310000000000", "242"),("31728", "2", "1002", "177", "1", "23.430000000000", "243"),("60778", "2", "1001", "39", "1", "8.310000000000", "244"),("60779", "2", "1001", "39", "1", "8.310000000000", "245"),("60781", "2", "1001", "39", "1", "8.310000000000", "246"),("60834", "2", "1001", "39", "1", "8.310000000000", "247"),("60835", "2", "1001", "39", "1", "8.310000000000", "248"),("60793", "2", "1000", "39", "1", "8.310000000000", "249"),("173875", "2", "1000", "47", "1", "187.380000000000", "250"),("153837", "1", "3", "455", "1", "183.060000000000", "251"),("153833", "1", "1", "455", "1", "103.660000000000", "252"),("153835", "1", "1", "455", "1", "160.370000000000", "253"),("103582", "1", "1008", "39", "1", "7.550000000000", "254"),("60831", "2", "1000", "39", "1", "8.310000000000", "255"),("63038", "2", "1000", "39", "1", "8.310000000000", "256"),("175466", "1", "1000", "117", "1", "51.170000000000", "257"),("228422", "2", "1000", "168", "1", "58.270000000000", "258"),("231745", "2", "1000", "121", "1", "226.030000000000", "259"),("216379", "2", "1000", "476", "1", "589.020000000000", "260"),("188513", "2", "5", "121", "1", "262.760000000000", "261"),("61695", "2", "4", "39", "1", "31.080000000000", "262"),("31735", "2", "4", "177", "1", "23.430000000000", "263"),("61692", "2", "1", "39", "1", "31.830000000000", "264"),("51664", "2", "1042", "43", "1", "4.190000000000", "265"),("51665", "2", "1006", "43", "1", "4.190000000000", "266"),("51661", "2", "1005", "43", "1", "4.190000000000", "267"),("51662", "2", "1004", "43", "1", "4.190000000000", "268"),("95300", "2", "1001", "24", "1", "34.360000000000", "269"),("211335", "2", "1000", "476", "1", "273.890000000000", "270"),("205271", "1", "1000", "224", "1", "27.640000000000", "271"),("247974", "1", "1000", "808", "1", "25.200000000000", "272"),("230072", "1", "1000", "285", "1", "19.700000000000", "273"),("250093", "1", "1000", "42", "1", "33.880000000000", "274"),("250107", "1", "1000", "42", "1", "33.880000000000", "275"),("51663", "2", "1000", "43", "1", "4.190000000000", "276"),("238199", "2", "1000", "66", "1", "39.360000000000", "277"),("95299", "2", "1000", "24", "1", "31.830000000000", "278"),("239184", "0", "1", "59", "1", "42.800000000000", "279"),("69764", "2", "1000", "39", "1", "8.730000000000", "280"),("69766", "2", "1000", "39", "1", "8.730000000000", "281"),("69767", "2", "1000", "39", "1", "8.730000000000", "282"),("69768", "2", "1000", "39", "1", "8.730000000000", "283"),("69769", "2", "1000", "39", "1", "8.730000000000", "284"),("216375", "2", "1000", "476", "1", "631.030000000000", "285"),("228423", "2", "1000", "168", "1", "77.180000000000", "286"),("70236", "2", "1000", "39", "1", "23.430000000000", "287"),("70238", "2", "1002", "39", "1", "23.430000000000", "288"),("38537", "2", "1000", "75", "1", "51.170000000000", "289"),("108176", "1", "1000", "104", "1", "194.860000000000", "290"),("116974", "10", "3", "280", "1", "83.100000000000", "291"),("116973", "4", "2", "280", "1", "176.290000000000", "292"),("116975", "10", "2", "280", "1", "106.630000000000", "293"),("211735", "1", "1019", "370", "1", "15.040000000000", "294"),("35672", "2", "1002", "75", "1", "9.560000000000", "295"),("80211", "2", "1000", "42", "1", "3.770000000000", "296"),("232959", "2", "1000", "533", "1", "73.250000000000", "297"),("232960", "2", "1000", "533", "1", "68.940000000000", "298"),("194919", "1", "1000", "533", "1", "56.930000000000", "299"),("194921", "1", "1000", "533", "1", "56.930000000000", "300"),("194923", "1", "1000", "533", "1", "60.400000000000", "301"),("194925", "1", "1000", "533", "1", "77.630000000000", "302"),("169591", "2", "1000", "43", "1", "5.700000000000", "303"),("250096", "1", "1000", "42", "1", "33.880000000000", "304"),("250100", "1", "1000", "42", "1", "33.880000000000", "305"),("169592", "2", "1000", "43", "1", "5.700000000000", "306"),("51669", "2", "995", "43", "1", "5.020000000000", "307"),("169590", "2", "995", "43", "1", "5.700000000000", "308"),("169587", "2", "989", "43", "1", "5.700000000000", "309"),("34560", "2", "3", "75", "1", "6.880000000000", "310"),("164864", "2", "2", "124", "1", "6.870000000000", "311"),("162797", "1", "1", "469", "1", "51.170000000000", "312"),("175023", "2", "1", "124", "1", "6.620000000000", "313"),("26073", "2", "1", "75", "1", "152.000000000000", "314"),("229054", "2", "1000", "204", "1", "286.450000000000", "315"),("198769", "1", "1008", "648", "1", "20.570000000000", "316"),("187767", "1", "1002", "18", "1", "6.720000000000", "317"),("70443", "2", "1001", "124", "1", "25.190000000000", "318"),("193593", "1", "1001", "727", "1", "274.080000000000", "319"),("170959", "2", "1001", "656", "1", "600.300000000000", "320"),("70442", "2", "1000", "124", "1", "24.720000000000", "321"),("106762", "2", "1000", "49", "1", "17.550000000000", "322"),("106766", "2", "1000", "49", "1", "17.550000000000", "323"),("106767", "2", "1000", "49", "1", "17.550000000000", "324"),("178923", "2", "1000", "105", "1", "81.410000000000", "325"),("241036", "2", "1000", "73", "1", "63.640000000000", "326"),("235322", "1", "1000", "47", "1", "79.820000000000", "327"),("235323", "1", "1000", "47", "1", "64.690000000000", "328"),("170961", "2", "1000", "656", "1", "643.020000000000", "329"),("250095", "1", "1000", "42", "1", "33.880000000000", "330"),("111570", "1", "1000", "445", "1", "675.500000000000", "331"),("9984", "2", "13", "73", "1", "19.860000000000", "332"),("70770", "2", "2", "285", "1", "2.090000000000", "333"),("66923", "2", "1", "368", "1", "377.210000000000", "334"),("188761", "1", "1", "191", "1", "70.490000000000", "335"),("9191", "2", "1000", "104", "1", "54.440000000000", "336"),("195145", "2", "1000", "533", "1", "60.640000000000", "337"),("195147", "2", "1000", "533", "1", "71.180000000000", "338"),("195149", "2", "1000", "533", "1", "93.170000000000", "339"),("145155", "1", "1013", "18", "1", "6.720000000000", "340"),("80083", "2", "1008", "42", "1", "4.610000000000", "341"),("168933", "1", "1006", "54", "1", "51.250000000000", "342"),("164813", "1", "1004", "18", "1", "6.720000000000", "343"),("80082", "2", "1003", "42", "1", "4.610000000000", "344"),("89347", "2", "1003", "362", "1", "36.960000000000", "345"),("89346", "2", "1001", "362", "1", "33.180000000000", "346"),("26107", "2", "1001", "75", "1", "6.630000000000", "347"),("229982", "2", "1001", "368", "1", "492.390000000000", "348"),("15488", "2", "1000", "115", "1", "30.160000000000", "349"),("15489", "2", "1000", "115", "1", "30.160000000000", "350"),("15492", "2", "1000", "115", "1", "30.160000000000", "351"),("15494", "2", "1000", "115", "1", "30.160000000000", "352"),("80084", "2", "1000", "42", "1", "4.610000000000", "353"),("80085", "2", "1000", "42", "1", "4.610000000000", "354"),("80086", "2", "1000", "42", "1", "4.610000000000", "355"),("80087", "2", "1000", "42", "1", "4.610000000000", "356"),("80088", "2", "1000", "42", "1", "4.610000000000", "357"),("80089", "2", "1000", "42", "1", "4.610000000000", "358"),("80090", "2", "1000", "42", "1", "5.020000000000", "359"),("80091", "2", "1000", "42", "1", "5.020000000000", "360"),("80092", "2", "1000", "42", "1", "5.020000000000", "361"),("80093", "2", "1000", "42", "1", "5.450000000000", "362"),("80094", "2", "1000", "42", "1", "5.020000000000", "363"),("80095", "2", "1000", "42", "1", "5.450000000000", "364"),("80096", "2", "1000", "42", "1", "5.450000000000", "365"),("80097", "2", "1000", "42", "1", "5.450000000000", "366"),("80099", "2", "1000", "42", "1", "5.450000000000", "367"),("80100", "2", "1000", "42", "1", "5.450000000000", "368"),("80101", "2", "1000", "42", "1", "5.450000000000", "369"),("89348", "2", "1000", "362", "1", "30.240000000000", "370"),("168930", "2", "1000", "42", "1", "5.020000000000", "371"),("132107", "1", "1000", "49", "1", "163.770000000000", "372"),("132111", "1", "1000", "49", "1", "137.720000000000", "373"),("116994", "1", "1000", "162", "1", "47.860000000000", "374"),("227967", "2", "1000", "168", "1", "364.570000000000", "375"),("209333", "2", "1000", "670", "1", "25.120000000000", "376"),("192841", "2", "1000", "121", "1", "206.710000000000", "377"),("240137", "1", "1000", "798", "1", "73.490000000000", "378"),("240138", "1", "1000", "798", "1", "82.060000000000", "379"),("170935", "2", "1000", "656", "1", "515.010000000000", "380"),("227968", "2", "1000", "168", "1", "319.200000000000", "381"),("110857", "10", "1000", "82", "1", "512.270000000000", "382"),("233082", "2", "1000", "727", "1", "427.750000000000", "383"),("80098", "2", "1000", "42", "1", "5.450000000000", "384"),("89345", "2", "7", "362", "1", "23.430000000000", "385"),("89350", "2", "3", "362", "1", "36.960000000000", "386"),("131621", "1", "3", "593", "1", "18.390000000000", "387"),("188183", "1", "3", "54", "1", "49.210000000000", "388"),("179795", "2", "2", "681", "1", "85.620000000000", "389"),("12941", "2", "1", "95", "1", "23.030000000000", "390"),("96709", "2", "1", "98", "1", "210.070000000000", "391"),("89351", "2", "1", "362", "1", "43.690000000000", "392"),("229126", "1", "1", "59", "1", "83.170000000000", "393"),("145493", "2", "1", "492", "1", "352.130000000000", "394"),("89349", "2", "1", "362", "1", "55.870000000000", "395"),("180488", "2", "1000", "685", "1", "304.110000000000", "396"),("116971", "4", "1", "280", "1", "89.820000000000", "397"),("180499", "2", "1000", "685", "1", "606.630000000000", "398"),("80111", "2", "1014", "42", "1", "5.450000000000", "399"),("243070", "1", "1011", "162", "1", "47.000000000000", "400"),("237224", "2", "1010", "357", "1", "7.130000000000", "401"),("237226", "2", "1010", "357", "1", "7.130000000000", "402"),("80107", "2", "1009", "42", "1", "5.450000000000", "403"),("80109", "2", "1009", "42", "1", "5.450000000000", "404"),("216387", "1", "1005", "59", "1", "399.940000000000", "405"),("47827", "2", "1004", "75", "1", "54.610000000000", "406"),("188083", "1", "1003", "500", "1", "5.320000000000", "407"),("188087", "1", "1003", "500", "1", "5.320000000000", "408"),("140663", "1", "1002", "360", "1", "435.670000000000", "409"),("188081", "1", "1002", "500", "1", "5.000000000000", "410"),("188085", "1", "1002", "500", "1", "5.320000000000", "411"),("215175", "1", "1002", "729", "1", "58.810000000000", "412"),("215217", "1", "1002", "729", "1", "58.810000000000", "413"),("116996", "1", "1002", "162", "1", "47.000000000000", "414"),("80104", "2", "1001", "42", "1", "5.450000000000", "415"),("215151", "1", "1001", "729", "1", "58.810000000000", "416"),("151597", "2", "1001", "11", "1", "645.740000000000", "417"),("15496", "2", "1000", "115", "1", "30.160000000000", "418"),("15497", "2", "1000", "115", "1", "30.160000000000", "419"),("68487", "2", "1000", "162", "1", "64.060000000000", "420"),("80102", "2", "1000", "42", "1", "5.450000000000", "421"),("80103", "2", "1000", "42", "1", "5.450000000000", "422"),("80105", "2", "1000", "42", "1", "5.450000000000", "423"),("80108", "2", "1000", "42", "1", "5.450000000000", "424"),("45535", "2", "1000", "168", "1", "73.060000000000", "425"),("174864", "2", "1000", "191", "1", "89.900000000000", "426"),("226366", "2", "1000", "459", "1", "57.040000000000", "427"),("226376", "2", "1000", "459", "1", "57.040000000000", "428"),("178750", "2", "1000", "27", "1", "130.990000000000", "429"),("178751", "2", "1000", "27", "1", "162.930000000000", "430"),("188089", "1", "1000", "500", "1", "5.750000000000", "431"),("188091", "1", "1000", "500", "1", "5.750000000000", "432"),("188093", "1", "1000", "500", "1", "8.120000000000", "433"),("198097", "1", "1000", "120", "1", "57.210000000000", "434"),("200941", "1", "1000", "656", "1", "34.990000000000", "435"),("216227", "1", "1000", "476", "1", "17.600000000000", "436"),("237908", "2", "1000", "357", "1", "10.880000000000", "437"),("195193", "1", "1000", "533", "1", "735.450000000000", "438"),("80110", "2", "10", "42", "1", "5.450000000000", "439"),("237227", "2", "10", "357", "1", "7.130000000000", "440"),("168931", "1", "3", "54", "1", "39.400000000000", "441"),("178327", "2", "2", "11", "1", "482.260000000000", "442"),("215193", "1", "2", "729", "1", "58.810000000000", "443"),("83545", "2", "1", "59", "1", "244.510000000000", "444"),("88304", "4", "1", "16", "1", "159.650000000000", "445"),("168929", "1", "1", "54", "1", "49.210000000000", "446"),("131725", "1", "1", "59", "1", "395.780000000000", "447"),("229127", "1", "1", "59", "1", "83.170000000000", "448"),("232241", "1", "1", "59", "1", "286.530000000000", "449"),("232242", "1", "1", "59", "1", "286.530000000000", "450"),("232243", "1", "1", "59", "1", "286.530000000000", "451"),("237860", "1", "1", "476", "1", "105.830000000000", "452"),("56703", "2", "1005", "294", "1", "23.330000000000", "453"),("21898", "2", "1004", "73", "1", "87.020000000000", "454"),("238628", "1", "1004", "54", "1", "51.250000000000", "455"),("114153", "2", "1002", "185", "1", "40.240000000000", "456"),("93484", "2", "1001", "68", "1", "35.700000000000", "457"),("93485", "2", "1001", "68", "1", "41.590000000000", "458"),("114150", "2", "1001", "185", "1", "40.240000000000", "459"),("220219", "1", "1001", "224", "1", "226.790000000000", "460"),("9062", "2", "1000", "58", "1", "16.710000000000", "461"),("82910", "2", "1000", "168", "1", "77.130000000000", "462"),("56704", "2", "1000", "294", "1", "27.120000000000", "463"),("56705", "2", "1000", "294", "1", "30.890000000000", "464"),("26431", "2", "1000", "162", "1", "69.940000000000", "465"),("170590", "2", "1000", "58", "1", "33.510000000000", "466"),("170591", "2", "1000", "58", "1", "38.550000000000", "467"),("170592", "2", "1000", "58", "1", "42.760000000000", "468"),("171849", "2", "1000", "332", "1", "673.100000000000", "469"),("171851", "2", "1000", "332", "1", "673.100000000000", "470"),("171852", "2", "1000", "332", "1", "673.100000000000", "471"),("171853", "2", "1000", "332", "1", "673.100000000000", "472"),("171854", "2", "1000", "332", "1", "673.100000000000", "473"),("156677", "2", "1000", "49", "1", "21.670000000000", "474"),("156679", "2", "1000", "49", "1", "29.060000000000", "475"),("156681", "2", "1000", "49", "1", "26.710000000000", "476"),("156683", "2", "1000", "49", "1", "26.710000000000", "477"),("114152", "2", "1000", "185", "1", "40.240000000000", "478"),("114154", "2", "1000", "185", "1", "40.240000000000", "479"),("114155", "2", "1000", "185", "1", "40.240000000000", "480"),("118329", "2", "1000", "105", "1", "21.750000000000", "481"),("223565", "-100", "1000", "290", "1", "673.010000000000", "482"),("180867", "2", "1000", "162", "1", "44.150000000000", "483"),("232968", "1", "1000", "533", "1", "150.180000000000", "484"),("209331", "2", "1000", "75", "1", "26.790000000000", "485"),("199323", "1", "1000", "656", "1", "682.790000000000", "486"),("200937", "1", "1000", "656", "1", "34.990000000000", "487"),("200939", "1", "1000", "656", "1", "34.990000000000", "488"),("200951", "1", "1000", "656", "1", "34.990000000000", "489"),("242819", "1", "1000", "353", "1", "227.680000000000", "490"),("243057", "2", "1000", "162", "1", "68.010000000000", "491"),("243059", "2", "1000", "162", "1", "68.010000000000", "492"),("213263", "1", "1000", "238", "1", "860.120000000000", "493"),("184065", "2", "1000", "360", "1", "159.620000000000", "494"),("165744", "1", "9", "467", "1", "4.520000000000", "495"),("177520", "1", "6", "12", "1", "142.760000000000", "496"),("177518", "1", "6", "12", "1", "198.300000000000", "497"),("131619", "1", "5", "593", "1", "28.020000000000", "498"),("131613", "1", "4", "593", "1", "28.020000000000", "499"),("34090", "2", "4", "287", "1", "27.720000000000", "500"),("87446", "2", "3", "358", "1", "19.900000000000", "501"),("131617", "1", "2", "593", "1", "28.020000000000", "502"),("93483", "2", "1", "68", "1", "21.750000000000", "503"),("184969", "2", "1", "54", "1", "49.560000000000", "504"),("225884", "2", "1017", "370", "1", "17.360000000000", "505"),("225883", "2", "1011", "370", "1", "17.360000000000", "506"),("193573", "1", "1004", "727", "1", "337.240000000000", "507"),("231775", "1", "1002", "795", "1", "231.920000000000", "508"),("219987", "2", "1002", "185", "1", "46.930000000000", "509"),("219988", "2", "1002", "185", "1", "46.930000000000", "510"),("168974", "1", "1001", "54", "1", "320.160000000000", "511"),("233061", "1", "1001", "533", "1", "513.170000000000", "512"),("210377", "1", "1001", "476", "1", "76.370000000000", "513"),("194929", "2", "1001", "533", "1", "13.310000000000", "514"),("242459", "1", "1001", "353", "1", "273.060000000000", "515"),("91913", "2", "1000", "348", "1", "131.830000000000", "516"),("95160", "2", "1000", "360", "1", "454.570000000000", "517"),("179447", "1", "1000", "603", "1", "69.740000000000", "518"),("228560", "1", "1000", "362", "1", "28.140000000000", "519"),("231777", "1", "1000", "795", "1", "213.430000000000", "520"),("231781", "1", "1000", "795", "1", "231.920000000000", "521"),("233710", "1", "1000", "353", "1", "208.770000000000", "522"),("212615", "1", "1000", "370", "1", "335.540000000000", "523"),("212629", "1", "1000", "370", "1", "653.640000000000", "524"),("215025", "2", "1000", "204", "1", "395.700000000000", "525"),("189305", "1", "1000", "354", "1", "14.190000000000", "526"),("194927", "2", "1000", "533", "1", "13.310000000000", "527"),("194931", "2", "1000", "533", "1", "13.310000000000", "528"),("200953", "1", "1000", "656", "1", "34.990000000000", "529"),("200995", "1", "1000", "224", "1", "15.020000000000", "530"),("219097", "1", "1000", "292", "1", "25.580000000000", "531"),("219098", "1", "1000", "292", "1", "25.580000000000", "532"),("219099", "1", "1000", "292", "1", "25.580000000000", "533"),("219100", "1", "1000", "292", "1", "25.580000000000", "534"),("236108", "1", "1000", "795", "1", "231.920000000000", "535"),("236109", "1", "1000", "795", "1", "213.430000000000", "536"),("236110", "1", "1000", "795", "1", "213.430000000000", "537"),("236111", "1", "1000", "795", "1", "213.430000000000", "538"),("242481", "2", "1000", "185", "1", "46.930000000000", "539"),("242483", "2", "1000", "185", "1", "46.930000000000", "540"),("215027", "2", "1000", "204", "1", "378.890000000000", "541"),("142443", "2", "1000", "94", "1", "26.770000000000", "542"),("142445", "2", "1000", "94", "1", "26.770000000000", "543"),("152900", "2", "1000", "73", "1", "30.960000000000", "544"),("213255", "1", "1000", "238", "1", "860.120000000000", "545"),("213257", "1", "1000", "238", "1", "860.120000000000", "546"),("213259", "1", "1000", "238", "1", "860.120000000000", "547"),("213261", "1", "1000", "238", "1", "860.120000000000", "548"),("236182", "1", "1000", "54", "1", "337.800000000000", "549"),("150733", "1", "1000", "54", "1", "59.560000000000", "550"),("131495", "1", "11", "47", "1", "42.760000000000", "551"),("34857", "2", "6", "204", "1", "19.310000000000", "552"),("146629", "2", "5", "85", "1", "157.130000000000", "553"),("209417", "1", "1", "500", "1", "115.140000000000", "554"),("114151", "2", "1", "185", "1", "40.240000000000", "555"),("190635", "1", "1", "721", "1", "111.750000000000", "556"),("190637", "1", "1", "721", "1", "111.750000000000", "557"),("190641", "1", "1", "721", "1", "111.750000000000", "558"),("190643", "1", "1", "721", "1", "111.750000000000", "559"),("225885", "2", "1052", "370", "1", "4.500000000000", "560"),("225886", "2", "1015", "370", "1", "4.500000000000", "561"),("181189", "2", "1013", "13", "1", "7.130000000000", "562"),("181191", "2", "1009", "13", "1", "7.130000000000", "563"),("223157", "1", "1007", "30", "1", "23.840000000000", "564"),("181185", "2", "1006", "13", "1", "7.130000000000", "565"),("181187", "2", "1003", "13", "1", "7.130000000000", "566"),("231779", "1", "1002", "795", "1", "249.560000000000", "567"),("215809", "1", "1002", "459", "1", "58.810000000000", "568"),("144533", "2", "1002", "353", "1", "38.550000000000", "569"),("118713", "2", "1001", "105", "1", "16.710000000000", "570"),("68273", "2", "1000", "141", "1", "46.680000000000", "571"),("168986", "1", "1000", "54", "1", "373.100000000000", "572"),("149585", "2", "1000", "73", "1", "30.080000000000", "573"),("152859", "2", "1000", "73", "1", "30.080000000000", "574"),("118712", "2", "1000", "105", "1", "14.190000000000", "575"),("118714", "2", "1000", "105", "1", "17.550000000000", "576"),("118715", "2", "1000", "105", "1", "17.550000000000", "577"),("226412", "1", "1000", "459", "1", "57.040000000000", "578"),("187103", "1", "1000", "122", "1", "51.250000000000", "579"),("187105", "1", "1000", "122", "1", "51.250000000000", "580"),("187107", "1", "1000", "122", "1", "51.250000000000", "581"),("191993", "2", "1000", "332", "1", "135.280000000000", "582"),("192001", "2", "1000", "332", "1", "135.280000000000", "583"),("219778", "1", "1000", "455", "1", "341.880000000000", "584"),("219779", "1", "1000", "455", "1", "341.880000000000", "585"),("239354", "2", "1000", "648", "1", "3.600000000000", "586"),("240980", "1", "1000", "17", "1", "370.490000000000", "587"),("240983", "1", "1000", "17", "1", "362.090000000000", "588"),("240986", "1", "1000", "17", "1", "353.690000000000", "589"),("240987", "1", "1000", "17", "1", "353.690000000000", "590"),("240990", "1", "1000", "17", "1", "345.280000000000", "591"),("192839", "2", "1000", "121", "1", "206.710000000000", "592"),("117675", "2", "1000", "12", "1", "127.530000000000", "593"),("115407", "2", "1000", "11", "1", "47.490000000000", "594"),("142447", "2", "1000", "94", "1", "26.770000000000", "595"),("143301", "2", "1000", "47", "1", "31.310000000000", "596"),("196807", "2", "1000", "42", "1", "5.020000000000", "597"),("239353", "2", "1000", "648", "1", "2.840000000000", "598"),("35089", "2", "20", "69", "1", "17.410000000000", "599"),("131615", "1", "4", "593", "1", "18.390000000000", "600"),("97494", "2", "2", "309", "1", "29.310000000000", "601"),("181197", "2", "1009", "13", "1", "7.970000000000", "602"),("119318", "2", "1002", "105", "1", "106.630000000000", "603"),("127957", "2", "1001", "15", "1", "23.170000000000", "604"),("142441", "2", "1001", "94", "1", "26.770000000000", "605"),("80428", "2", "1000", "115", "1", "89.060000000000", "606"),("80429", "2", "1000", "115", "1", "118.470000000000", "607"),("170238", "1", "1000", "514", "1", "539.400000000000", "608"),("170239", "1", "1000", "514", "1", "585.620000000000", "609"),("126443", "2", "1000", "193", "1", "14.270000000000", "610"),("126445", "2", "1000", "193", "1", "14.270000000000", "611"),("126447", "2", "1000", "193", "1", "15.950000000000", "612"),("126449", "2", "1000", "193", "1", "16.790000000000", "613"),("127953", "2", "1000", "15", "1", "21.230000000000", "614"),("127955", "2", "1000", "15", "1", "21.230000000000", "615"),("181193", "2", "1000", "13", "1", "7.970000000000", "616"),("221442", "2", "1000", "360", "1", "11.230000000000", "617"),("221443", "2", "1000", "360", "1", "11.230000000000", "618"),("221444", "2", "1000", "360", "1", "11.230000000000", "619"),("221457", "2", "1000", "360", "1", "11.230000000000", "620"),("221458", "2", "1000", "360", "1", "11.230000000000", "621"),("235658", "4", "1000", "370", "1", "7.310000000000", "622"),("240971", "1", "1000", "17", "1", "395.700000000000", "623"),("240972", "1", "1000", "17", "1", "378.890000000000", "624"),("240973", "1", "1000", "17", "1", "378.890000000000", "625"),("240974", "1", "1000", "17", "1", "378.890000000000", "626"),("240978", "1", "1000", "17", "1", "370.490000000000", "627"),("240985", "1", "1000", "17", "1", "362.090000000000", "628"),("148451", "2", "1000", "85", "1", "11.590000000000", "629"),("230668", "10", "1000", "376", "1", "464.040000000000", "630"),("170729", "1", "7", "287", "1", "69.740000000000", "631"),("68464", "2", "1008", "24", "1", "8.310000000000", "632"),("68466", "2", "1000", "24", "1", "8.310000000000", "633"),("196627", "2", "1000", "88", "1", "835.280000000000", "634"),("126451", "2", "1000", "193", "1", "11.750000000000", "635"),("126453", "2", "1000", "193", "1", "12.170000000000", "636"),("126455", "2", "1000", "193", "1", "13.010000000000", "637"),("126457", "2", "1000", "193", "1", "15.950000000000", "638"),("126459", "2", "1000", "193", "1", "14.270000000000", "639"),("126461", "2", "1000", "193", "1", "15.530000000000", "640"),("126463", "2", "1000", "193", "1", "15.920000000000", "641"),("126465", "2", "1000", "193", "1", "13.850000000000", "642"),("126467", "2", "1000", "193", "1", "12.170000000000", "643"),("225502", "1", "1000", "122", "1", "54.610000000000", "644"),("225503", "1", "1000", "122", "1", "54.610000000000", "645"),("183377", "1", "1000", "501", "1", "42.760000000000", "646"),("183379", "1", "1000", "501", "1", "42.760000000000", "647"),("183381", "1", "1000", "501", "1", "42.760000000000", "648"),("219766", "1", "1000", "455", "1", "379.700000000000", "649"),("219772", "1", "1000", "455", "1", "379.700000000000", "650"),("219773", "1", "1000", "455", "1", "379.700000000000", "651"),("219774", "1", "1000", "455", "1", "379.700000000000", "652"),("219775", "1", "1000", "455", "1", "379.700000000000", "653"),("219776", "1", "1000", "455", "1", "379.700000000000", "654"),("243689", "2", "1000", "170", "1", "18.330000000000", "655"),("243690", "2", "1000", "170", "1", "18.330000000000", "656"),("243691", "2", "1000", "170", "1", "18.330000000000", "657"),("243692", "2", "1000", "170", "1", "18.330000000000", "658"),("243694", "2", "1000", "170", "1", "18.330000000000", "659"),("243695", "2", "1000", "170", "1", "18.330000000000", "660"),("243698", "2", "1000", "170", "1", "18.330000000000", "661"),("243704", "2", "1000", "170", "1", "18.330000000000", "662"),("243709", "2", "1000", "170", "1", "26.540000000000", "663"),("243710", "2", "1000", "170", "1", "26.540000000000", "664"),("248572", "2", "1000", "54", "1", "51.250000000000", "665"),("243701", "2", "1000", "170", "1", "18.330000000000", "666"),("243702", "2", "1000", "170", "1", "18.330000000000", "667"),("243703", "2", "1000", "170", "1", "18.330000000000", "668"),("243705", "2", "1000", "170", "1", "18.330000000000", "669"),("243707", "2", "1000", "170", "1", "26.540000000000", "670"),("250129", "2", "1000", "30", "1", "9.830000000000", "671"),("168253", "1", "1", "58", "1", "354.520000000000", "672"),("178294", "2", "1000", "88", "1", "726.030000000000", "673"),("178991", "2", "1000", "88", "1", "871.410000000000", "674"),("178997", "2", "1000", "88", "1", "943.690000000000", "675"),("107869", "1", "1010", "58", "1", "9.150000000000", "676"),("107868", "1", "1010", "58", "1", "9.150000000000", "677"),("181199", "2", "1007", "13", "1", "7.970000000000", "678"),("107866", "1", "1006", "58", "1", "9.150000000000", "679"),("181201", "2", "1005", "13", "1", "7.130000000000", "680"),("181203", "2", "1004", "13", "1", "7.130000000000", "681"),("247704", "2", "1002", "168", "1", "255.360000000000", "682"),("248687", "1", "1001", "173", "1", "283.810000000000", "683"),("95934", "2", "1000", "105", "1", "81.410000000000", "684"),("106345", "1", "1000", "75", "1", "81.540000000000", "685"),("231684", "2", "1000", "294", "1", "32.760000000000", "686"),("240982", "1", "1000", "17", "1", "362.090000000000", "687"),("240989", "1", "1000", "17", "1", "353.690000000000", "688"),("240991", "1", "1000", "17", "1", "345.280000000000", "689"),("248569", "2", "1000", "54", "1", "51.250000000000", "690"),("248574", "2", "1000", "54", "1", "51.250000000000", "691"),("245706", "2", "1000", "798", "1", "22.600000000000", "692"),("217987", "2", "1000", "150", "1", "236.390000000000", "693"),("107867", "1", "1000", "58", "1", "9.150000000000", "694"),("65291", "2", "2", "103", "1", "12.840000000000", "695"),("65292", "2", "2", "103", "1", "14.360000000000", "696"),("121160", "2", "2", "287", "1", "67.210000000000", "697"),("65290", "2", "1", "103", "1", "13.600000000000", "698"),("239240", "1", "1", "648", "1", "185.700000000000", "699"),("239241", "1", "1", "648", "1", "210.910000000000", "700"),("247711", "2", "1002", "168", "1", "301.640000000000", "701"),("243711", "2", "1000", "170", "1", "43.690000000000", "702"),("243712", "2", "1000", "170", "1", "43.690000000000", "703"),("243713", "2", "1000", "170", "1", "43.690000000000", "704"),("155831", "1", "1000", "85", "1", "24.710000000000", "705"),("231613", "1", "1000", "658", "1", "39.670000000000", "706"),("231614", "1", "1000", "658", "1", "39.670000000000", "707"),("231615", "1", "1000", "658", "1", "39.670000000000", "708"),("231616", "1", "1000", "658", "1", "39.670000000000", "709"),("231617", "1", "1000", "658", "1", "38.820000000000", "710"),("231618", "1", "1000", "658", "1", "38.820000000000", "711"),("231619", "1", "1000", "658", "1", "38.820000000000", "712"),("231620", "1", "1000", "658", "1", "39.530000000000", "713"),("231621", "1", "1000", "658", "1", "39.530000000000", "714"),("231622", "1", "1000", "658", "1", "39.530000000000", "715"),("231623", "1", "1000", "658", "1", "39.530000000000", "716"),("170918", "2", "1", "656", "1", "600.310000000000", "717"),("38585", "2", "1002", "279", "1", "25.200000000000", "718"),("38647", "2", "1000", "279", "1", "25.950000000000", "719"),("111171", "2", "1000", "49", "1", "9.150000000000", "720"),("111172", "2", "1000", "49", "1", "9.150000000000", "721"),("224785", "2", "1000", "729", "1", "42.000000000000", "722"),("224800", "2", "1000", "729", "1", "42.000000000000", "723"),("178293", "2", "1000", "88", "1", "653.770000000000", "724"),("38656", "2", "2", "279", "1", "17.550000000000", "725"),("181195", "2", "1001", "13", "1", "7.970000000000", "726"),("243666", "2", "1000", "204", "1", "420.910000000000", "727"),("155833", "1", "1000", "85", "1", "24.710000000000", "728"),("11531", "2", "1003", "75", "1", "10.070000000000", "729"),("11530", "2", "1002", "75", "1", "10.830000000000", "730"),("107958", "2", "1000", "124", "1", "493.660000000000", "731"),("108900", "2", "1000", "279", "1", "25.950000000000", "732"),("179026", "2", "1000", "88", "1", "979.820000000000", "733"),("146473", "2", "1000", "85", "1", "472.260000000000", "734"),("22289", "2", "1000", "20", "1", "6.730000000000", "735"),("22291", "2", "1000", "20", "1", "6.730000000000", "736"),("1148", "2", "1000", "13", "1", "27.640000000000", "737"),("22290", "2", "1", "20", "1", "7.790000000000", "738"),("178189", "1", "1", "279", "1", "21.750000000000", "739"),("219986", "2", "1045", "13", "1", "152.000000000000", "740"),("220374", "2", "1037", "13", "1", "126.790000000000", "741"),("219962", "2", "1036", "13", "1", "135.200000000000", "742"),("219978", "2", "1013", "13", "1", "143.600000000000", "743"),("184967", "1", "1002", "54", "1", "215.120000000000", "744"),("125251", "1", "1001", "360", "1", "208.780000000000", "745"),("241767", "2", "1001", "224", "1", "367.970000000000", "746"),("152517", "4", "1000", "13", "1", "190.740000000000", "747"),("152519", "4", "1000", "13", "1", "208.890000000000", "748"),("156757", "1", "1000", "629", "1", "23.430000000000", "749"),("189123", "1", "1000", "88", "1", "399.980000000000", "750"),("189371", "1", "1000", "88", "1", "436.120000000000", "751"),("152515", "4", "1000", "13", "1", "178.140000000000", "752"),("68529", "2", "5", "24", "1", "30.160000000000", "753"),("247220", "2", "1000", "353", "1", "14.680000000000", "754"),("66461", "2", "1001", "279", "1", "25.200000000000", "755"),("196611", "2", "1000", "88", "1", "798.310000000000", "756"),("196613", "2", "1000", "88", "1", "762.170000000000", "757"),("196617", "2", "1000", "88", "1", "798.310000000000", "758"),("66417", "2", "1", "279", "1", "17.550000000000", "759"),("66436", "2", "1000", "279", "1", "25.950000000000", "760"),("108450", "2", "1000", "329", "1", "28.530000000000", "761"),("176185", "2", "1000", "124", "1", "127.720000000000", "762"),("176186", "2", "1000", "124", "1", "162.170000000000", "763"),("116262", "2", "1", "124", "1", "103.980000000000", "764"),("133065", "1", "1002", "360", "1", "246.600000000000", "765"),("133063", "1", "1000", "360", "1", "227.690000000000", "766"),("134833", "1", "1000", "117", "1", "53.690000000000", "767"),("216871", "2", "1000", "279", "1", "35.200000000000", "768"),("176184", "2", "1000", "124", "1", "94.710000000000", "769"),("176187", "2", "1000", "124", "1", "199.190000000000", "770"),("246574", "2", "1000", "73", "1", "46.830000000000", "771"),("245682", "2", "20", "59", "1", "22.680000000000", "772"),("46902", "2", "3", "193", "1", "17.640000000000", "773"),("247310", "1", "1000", "360", "1", "656.500000000000", "774"),("46928", "2", "3", "193", "1", "13.850000000000", "775"),("46834", "2", "1000", "193", "1", "13.850000000000", "776"),("46943", "2", "1000", "193", "1", "16.790000000000", "777"),("49537", "2", "1000", "290", "1", "115.020000000000", "778"),("73196", "2", "1", "464", "1", "73.100000000000", "779"),("65600", "2", "1000", "160", "1", "37.770000000000", "780"),("60400", "2", "1002", "24", "1", "16.790000000000", "781"),("60403", "2", "1000", "24", "1", "15.120000000000", "782"),("60406", "2", "1000", "24", "1", "15.120000000000", "783"),("37495", "2", "3", "204", "1", "24.360000000000", "784"),("68462", "2", "1000", "24", "1", "16.790000000000", "785"),("66406", "2", "14", "100", "1", "33.800000000000", "786"),("66394", "2", "13", "100", "1", "28.840000000000", "787"),("66396", "2", "8", "100", "1", "28.840000000000", "788"),("66393", "2", "6", "100", "1", "28.840000000000", "789"),("66405", "2", "6", "100", "1", "32.150000000000", "790"),("12356", "2", "1005", "204", "1", "58.810000000000", "791"),("73242", "2", "1001", "464", "1", "27.640000000000", "792"),("17316", "2", "1000", "42", "1", "21.830000000000", "793"),("33527", "2", "1000", "204", "1", "39.400000000000", "794"),("33530", "2", "1000", "204", "1", "41.080000000000", "795"),("217559", "2", "1000", "476", "1", "1828.510000000000", "796"),("12386", "2", "4", "204", "1", "53.770000000000", "797"),("33529", "2", "1", "204", "1", "30.160000000000", "798"),("17312", "2", "1007", "42", "1", "26.030000000000", "799"),("17317", "2", "1000", "42", "1", "21.830000000000", "800"),("18619", "2", "1000", "204", "1", "54.520000000000", "801"),("21907", "2", "1000", "73", "1", "19.030000000000", "802"),("183327", "10", "1000", "703", "1", "415.260000000000", "803"),("35269", "2", "3", "46", "1", "10.830000000000", "804"),("34968", "2", "2", "59", "1", "38.640000000000", "805"),("17320", "2", "1002", "42", "1", "21.830000000000", "806"),("17321", "2", "1002", "42", "1", "12.600000000000", "807"),("33525", "2", "1002", "204", "1", "69.650000000000", "808"),("17318", "2", "1000", "42", "1", "21.830000000000", "809"),("128301", "2", "1000", "47", "1", "132.760000000000", "810"),("1605", "2", "8", "46", "1", "16.790000000000", "811"),("42314", "2", "6", "46", "1", "10.830000000000", "812"),("35261", "2", "3", "46", "1", "10.830000000000", "813"),("11044", "2", "3", "46", "1", "13.350000000000", "814"),("42313", "2", "2", "46", "1", "14.690000000000", "815"),("11045", "2", "1", "46", "1", "13.350000000000", "816"),("17313", "2", "1003", "42", "1", "26.030000000000", "817"),("17314", "2", "1002", "42", "1", "24.360000000000", "818"),("176967", "2", "1002", "42", "1", "20.160000000000", "819"),("128393", "2", "1001", "47", "1", "968.050000000000", "820"),("17315", "2", "1000", "42", "1", "26.880000000000", "821"),("26110", "2", "1000", "75", "1", "41.920000000000", "822"),("26113", "2", "1000", "75", "1", "38.550000000000", "823"),("145487", "2", "1000", "47", "1", "929.400000000000", "824"),("1609", "2", "5", "46", "1", "16.790000000000", "825"),("119336", "2", "3", "173", "1", "190.070000000000", "826"),("167003", "2", "2", "59", "1", "1647.880000000000", "827"),("86850", "2", "2", "173", "1", "223.960000000000", "828"),("167002", "2", "1", "59", "1", "1899.980000000000", "829"),("230548", "2", "1", "59", "1", "2857.960000000000", "830"),("180771", "1", "1000", "685", "1", "101.590000000000", "831"),("203753", "10", "1000", "703", "1", "412.700000000000", "832"),("113656", "2", "1022", "24", "1", "13.350000000000", "833"),("96410", "2", "1001", "24", "1", "14.190000000000", "834"),("22675", "4", "1001", "246", "1", "216.570000000000", "835"),("96402", "2", "1000", "24", "1", "10.830000000000", "836"),("96403", "2", "1000", "24", "1", "11.670000000000", "837"),("110788", "4", "1000", "246", "1", "257.200000000000", "838"),("38957", "2", "12", "287", "1", "30.240000000000", "839"),("22676", "4", "1", "246", "1", "173.850000000000", "840"),("113655", "2", "1007", "24", "1", "15.020000000000", "841"),("89094", "2", "1000", "423", "1", "17.640000000000", "842"),("102279", "2", "1000", "204", "1", "22.600000000000", "843"),("102280", "2", "1000", "204", "1", "16.290000000000", "844"),("59478", "2", "2", "100", "1", "41.240000000000", "845"),("62368", "2", "1003", "24", "1", "18.390000000000", "846"),("243555", "2", "1000", "75", "1", "70.490000000000", "847"),("234283", "2", "0", "59", "1", "98.300000000000", "848"),("234282", "2", "0", "59", "1", "118.460000000000", "849"),("65850", "2", "0", "121", "1", "59.450000000000", "850"),("187985", "10", "0", "280", "1", "30.030000000000", "851"),("117193", "10", "0", "280", "1", "33.280000000000", "852"),("100644", "1", "0", "59", "1", "286.530000000000", "853"),("4402", "2", "0", "98", "1", "333.130000000000", "854"),("96625", "2", "0", "98", "1", "33.010000000000", "855"),("4401", "2", "0", "98", "1", "229.890000000000", "856"),("4403", "2", "0", "98", "1", "33.010000000000", "857"),("59500", "2", "0", "98", "1", "564.230000000000", "858"),("62411", "10", "0", "27", "1", "22.000000000000", "859"),("117760", "2", "0", "109", "1", "25.600000000000", "860"),("223563", "2", "0", "768", "1", "143.600000000000", "861"),("234419", "4", "0", "59", "1", "54.600000000000", "862"),("62412", "2", "0", "27", "1", "32.000000000000", "863"),("215015", "2", "0", "204", "1", "55.360000000000", "864"),("22428", "2", "0", "47", "1", "28.230000000000", "865"),("166238", "2", "0", "47", "1", "322.990000000000", "866"),("244205", "1", "0", "13", "1", "38.550000000000", "867"),("83645", "2", "0", "59", "1", "496.620000000000", "868"),("56257", "2", "0", "98", "1", "743.700000000000", "869"),("239480", "2", "0", "59", "1", "62.550000000000", "870"),("215163", "2", "0", "204", "1", "105.790000000000", "871"),("96570", "2", "0", "168", "1", "606.600000000000", "872"),("96571", "2", "0", "168", "1", "368.290000000000", "873"),("25878", "2", "0", "75", "1", "39.000000000000", "874"),("131399", "2", "0", "168", "1", "292.330000000000", "875"),("113676", "10", "0", "27", "1", "42.000000000000", "876"),("62466", "2", "0", "27", "1", "12.000000000000", "877"),("88307", "4", "0", "16", "1", "74.100000000000", "878"),("228599", "2", "0", "168", "1", "44.440000000000", "879"),("198303", "1", "0", "168", "1", "547.460000000000", "880"),("147965", "2", "0", "121", "1", "252.280000000000", "881"),("142331", "2", "0", "332", "1", "240.340000000000", "882"),("233055", "1", "0", "533", "1", "812.890000000000", "883"),("233057", "1", "0", "533", "1", "641.890000000000", "884"),("142329", "2", "0", "332", "1", "240.340000000000", "885"),("97579", "2", "0", "168", "1", "708.690000000000", "886"),("233054", "1", "0", "533", "1", "855.640000000000", "887"),("233056", "1", "0", "533", "1", "727.360000000000", "888"),("212131", "2", "0", "370", "1", "299.470000000000", "889"),("38355", "2", "0", "75", "1", "323.000000000000", "890"),("97580", "2", "0", "168", "1", "772.980000000000", "891"),("221510", "1", "0", "353", "1", "235.000000000000", "892"),("221511", "1", "0", "353", "1", "193.490000000000", "893"),("172890", "1", "0", "663", "1", "2087.020000000000", "894"),("233525", "1", "0", "705", "1", "205.920000000000", "895"),("183329", "1", "0", "705", "1", "158.530000000000", "896"),("208297", "4", "0", "747", "1", "17.290000000000", "897"),("68938", "2", "0", "39", "1", "33.600000000000", "898"),("60055", "2", "0", "39", "1", "88.220000000000", "899"),("208691", "4", "0", "747", "1", "36.600000000000", "900"),("60518", "2", "0", "39", "1", "3.520000000000", "901"),("111898", "1", "0", "48", "1", "1092.440000000000", "902"),("64269", "2", "0", "358", "1", "74.880000000000", "903"),("235882", "2", "0", "59", "1", "580.650000000000", "904"),("235883", "2", "0", "59", "1", "614.260000000000", "905"),("87165", "2", "0", "469", "1", "27.600000000000", "906"),("107500", "1", "0", "469", "1", "25.950000000000", "907"),("108395", "1", "0", "469", "1", "23.600000000000", "908"),("83071", "2", "0", "168", "1", "305.790000000000", "909"),("83082", "2", "0", "168", "1", "305.530000000000", "910"),("83196", "2", "0", "168", "1", "239.400000000000", "911"),("167001", "2", "0", "39", "1", "35.000000000000", "912"),("188511", "2", "0", "121", "1", "126.020000000000", "913"),("116966", "2", "0", "280", "1", "14.790000000000", "914"),("61696", "2", "0", "39", "1", "22.950000000000", "915"),("51668", "2", "0", "43", "1", "2.100000000000", "916"),("235689", "1", "0", "191", "1", "27.180000000000", "917"),("235690", "1", "0", "191", "1", "29.890000000000", "918"),("193869", "1", "0", "87", "1", "89.200000000000", "919"),("193871", "1", "0", "87", "1", "208.200000000000", "920"),("231700", "2", "0", "294", "1", "108.220000000000", "921"),("232946", "2", "0", "533", "1", "301.450000000000", "922"),("198935", "2", "0", "59", "1", "580.650000000000", "923"),("198937", "2", "0", "59", "1", "614.260000000000", "924"),("38536", "2", "0", "75", "1", "32.500000000000", "925"),("141389", "2", "0", "353", "1", "277.750000000000", "926"),("116976", "10", "0", "280", "1", "91.000000000000", "927"),("80212", "2", "0", "42", "1", "2.100000000000", "928"),("51672", "2", "0", "43", "1", "3.300000000000", "929"),("157551", "1", "0", "469", "1", "108.950000000000", "930"),("157555", "1", "0", "469", "1", "145.360000000000", "931"),("157557", "1", "0", "469", "1", "233.350000000000", "932"),("162785", "2", "0", "469", "1", "90.210000000000", "933"),("174992", "-100", "0", "570", "1", "27.980000000000", "934"),("175025", "2", "0", "124", "1", "4.410000000000", "935"),("132935", "-100", "0", "570", "1", "27.980000000000", "936"),("116965", "2", "0", "280", "1", "17.424000000000", "937"),("228598", "2", "0", "168", "1", "46.940000000000", "938"),("70444", "2", "0", "124", "1", "17.560000000000", "939"),("162784", "1", "0", "469", "1", "80.490000000000", "940"),("162803", "1", "0", "469", "1", "107.780000000000", "941"),("125013", "2", "0", "469", "1", "260.040000000000", "942"),("106765", "2", "0", "49", "1", "12.500000000000", "943"),("106768", "2", "0", "49", "1", "12.500000000000", "944"),("132937", "-100", "0", "570", "1", "29.400000000000", "945"),("230324", "2", "0", "59", "1", "41.320000000000", "946"),("236923", "2", "0", "476", "1", "57.100000000000", "947"),("162782", "1", "0", "469", "1", "50.330000000000", "948"),("116972", "4", "0", "280", "1", "97.240000000000", "949"),("179888", "4", "0", "280", "1", "97.240000000000", "950"),("4773", "2", "0", "95", "1", "33.010000000000", "951"),("170936", "2", "0", "656", "1", "411.790000000000", "952"),("132109", "1", "0", "49", "1", "112.000000000000", "953"),("180665", "1", "0", "469", "1", "42.760000000000", "954"),("182209", "2", "0", "656", "1", "443.230000000000", "955"),("230323", "2", "0", "59", "1", "41.320000000000", "956"),("230325", "2", "0", "59", "1", "41.320000000000", "957"),("235175", "1", "0", "59", "1", "54.800000000000", "958"),("207531", "1", "0", "528", "1", "21.830000000000", "959"),("207533", "1", "0", "528", "1", "24.350000000000", "960"),("95301", "2", "0", "24", "1", "24.000000000000", "961"),("180490", "2", "0", "685", "1", "180.000000000000", "962"),("180501", "2", "0", "685", "1", "360.000000000000", "963"),("180503", "2", "0", "685", "1", "360.000000000000", "964"),("80106", "2", "0", "42", "1", "3.400000000000", "965"),("59543", "2", "0", "287", "1", "25.210000000000", "966"),("159999", "1", "0", "469", "1", "50.180000000000", "967"),("165760", "1", "0", "71", "1", "68.610000000000", "968"),("151595", "2", "0", "11", "1", "537.120000000000", "969"),("231044", "1", "0", "654", "1", "10.700000000000", "970"),("232240", "1", "0", "59", "1", "286.530000000000", "971"),("232244", "1", "0", "59", "1", "286.530000000000", "972"),("232245", "1", "0", "59", "1", "286.530000000000", "973"),("233062", "1", "0", "533", "1", "684.000000000000", "974"),("233086", "2", "0", "727", "1", "385.010000000000", "975"),("235159", "1", "0", "59", "1", "54.800000000000", "976"),("220468", "1", "0", "749", "1", "23.430000000000", "977"),("10536", "2", "0", "178", "1", "36.000000000000", "978"),("198095", "1", "0", "120", "1", "30.580000000000", "979"),("96216", "2", "0", "168", "1", "194.420000000000", "980"),("96217", "2", "0", "168", "1", "149.400000000000", "981"),("171846", "2", "0", "332", "1", "400.000000000000", "982"),("171870", "2", "0", "332", "1", "335.000000000000", "983"),("165743", "1", "0", "467", "1", "2.640000000000", "984"),("166209", "1", "0", "54", "1", "258.370000000000", "985"),("177516", "1", "0", "12", "1", "149.030000000000", "986"),("232676", "1", "0", "727", "1", "68.940000000000", "987"),("232677", "1", "0", "727", "1", "68.940000000000", "988"),("232690", "1", "0", "727", "1", "68.940000000000", "989"),("233063", "2", "0", "533", "1", "120.220000000000", "990"),("234509", "1", "0", "59", "1", "63.000000000000", "991"),("64684", "2", "0", "168", "1", "44.980000000000", "992"),("21897", "2", "0", "73", "1", "57.000000000000", "993"),("235691", "1", "0", "47", "1", "28.510000000000", "994"),("235692", "1", "0", "47", "1", "25.800000000000", "995"),("157549", "1", "0", "469", "1", "16.590000000000", "996"),("109206", "2", "0", "12", "1", "82.460000000000", "997"),("223816", "2", "0", "459", "1", "46.000000000000", "998"),("224938", "2", "0", "729", "1", "49.000000000000", "999"),("182331", "1", "0", "469", "1", "41.000000000000", "1000")

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'