Căutare

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

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 ("171115", "2", "1001", "337", "1", "58.810000000000", "1"),("171113", "2", "1000", "337", "1", "68.050000000000", "2"),("171116", "2", "1000", "337", "1", "68.050000000000", "3"),("171117", "2", "1000", "337", "1", "68.050000000000", "4"),("100964", "2", "1001", "177", "1", "42.760000000000", "5"),("100962", "2", "1000", "177", "1", "42.760000000000", "6"),("37197", "2", "1000", "177", "1", "42.760000000000", "7"),("37199", "2", "1000", "177", "1", "42.760000000000", "8"),("223445", "1", "1000", "459", "1", "75.530000000000", "9"),("223446", "1", "1000", "459", "1", "75.530000000000", "10"),("91774", "2", "1000", "85", "1", "37.800000000000", "11"),("37196", "2", "1", "177", "1", "42.760000000000", "12"),("70712", "2", "1001", "222", "1", "8.860000000000", "13"),("236984", "2", "1002", "85", "1", "37.800000000000", "14"),("223444", "1", "1000", "459", "1", "75.530000000000", "15"),("223448", "1", "1000", "459", "1", "75.530000000000", "16"),("223449", "1", "1000", "459", "1", "75.530000000000", "17"),("91775", "2", "1000", "85", "1", "24.160000000000", "18"),("236127", "2", "5", "85", "1", "37.800000000000", "19"),("120164", "2", "7", "280", "1", "7.460000000000", "20"),("238232", "1", "1000", "656", "1", "43.240000000000", "21"),("238228", "1", "1000", "656", "1", "43.240000000000", "22"),("229851", "2", "1000", "42", "1", "45.360000000000", "23"),("229852", "2", "1000", "42", "1", "10.070000000000", "24"),("91781", "2", "1000", "85", "1", "24.160000000000", "25"),("238229", "1", "1000", "656", "1", "43.240000000000", "26"),("238230", "1", "1000", "656", "1", "43.240000000000", "27"),("238231", "1", "1000", "656", "1", "43.240000000000", "28"),("238233", "1", "999", "656", "1", "43.240000000000", "29"),("120165", "2", "3", "280", "1", "7.460000000000", "30"),("120174", "2", "2", "280", "1", "6.630000000000", "31"),("191735", "1", "1002", "54", "1", "29.400000000000", "32"),("191737", "1", "1002", "54", "1", "29.400000000000", "33"),("191747", "1", "1002", "54", "1", "29.400000000000", "34"),("191749", "1", "1002", "54", "1", "29.400000000000", "35"),("191741", "1", "1002", "54", "1", "29.400000000000", "36"),("73729", "2", "1000", "185", "1", "50.320000000000", "37"),("73731", "2", "1000", "185", "1", "50.320000000000", "38"),("73735", "2", "1000", "185", "1", "50.320000000000", "39"),("126415", "2", "1000", "581", "1", "35.280000000000", "40"),("137935", "2", "1000", "581", "1", "35.280000000000", "41"),("191743", "1", "1000", "54", "1", "29.400000000000", "42"),("137927", "2", "1000", "581", "1", "35.280000000000", "43"),("120140", "2", "5", "280", "1", "6.630000000000", "44"),("132963", "1", "1018", "360", "1", "16.900000000000", "45"),("164998", "2", "1004", "185", "1", "42.340000000000", "46"),("127635", "1", "1003", "185", "1", "63.190000000000", "47"),("205453", "2", "1003", "185", "1", "62.050000000000", "48"),("191745", "1", "1002", "54", "1", "29.400000000000", "49"),("207793", "1", "1001", "117", "1", "53.690000000000", "50"),("73733", "2", "1000", "185", "1", "52.840000000000", "51"),("133843", "2", "1000", "341", "1", "29.400000000000", "52"),("114121", "2", "1000", "185", "1", "62.050000000000", "53"),("185891", "2", "1000", "185", "1", "62.050000000000", "54"),("207789", "1", "1000", "117", "1", "53.690000000000", "55"),("58822", "2", "3", "285", "1", "15.770000000000", "56"),("133845", "2", "1", "341", "1", "29.400000000000", "57"),("230055", "2", "1001", "285", "1", "17.050000000000", "58"),("227535", "2", "1003", "185", "1", "61.300000000000", "59"),("114115", "2", "1003", "185", "1", "55.360000000000", "60"),("98900", "2", "1002", "117", "1", "42.760000000000", "61"),("42850", "2", "1002", "185", "1", "62.050000000000", "62"),("98891", "2", "1002", "117", "1", "42.760000000000", "63"),("227532", "2", "1002", "185", "1", "61.300000000000", "64"),("98801", "2", "1000", "117", "1", "42.760000000000", "65"),("98887", "2", "1000", "117", "1", "42.760000000000", "66"),("98897", "2", "1000", "117", "1", "42.760000000000", "67"),("98904", "2", "1000", "117", "1", "42.760000000000", "68"),("177711", "1", "1000", "105", "1", "31.830000000000", "69"),("177712", "1", "1000", "105", "1", "31.830000000000", "70"),("177713", "1", "1000", "105", "1", "31.830000000000", "71"),("177714", "1", "1000", "105", "1", "31.830000000000", "72"),("177715", "1", "1000", "105", "1", "31.830000000000", "73"),("177716", "1", "1000", "105", "1", "31.830000000000", "74"),("177717", "1", "1000", "105", "1", "31.830000000000", "75"),("177718", "1", "1000", "105", "1", "31.830000000000", "76"),("177719", "1", "1000", "105", "1", "31.830000000000", "77"),("133835", "2", "1000", "341", "1", "29.400000000000", "78"),("133837", "2", "1000", "341", "1", "29.400000000000", "79"),("133847", "2", "1000", "341", "1", "29.400000000000", "80"),("98431", "2", "1000", "117", "1", "51.170000000000", "81"),("98895", "2", "1000", "117", "1", "42.760000000000", "82"),("98903", "2", "1000", "117", "1", "42.760000000000", "83"),("99833", "2", "1000", "117", "1", "61.250000000000", "84"),("99835", "2", "1000", "117", "1", "61.250000000000", "85"),("99838", "2", "1000", "117", "1", "61.250000000000", "86"),("99840", "2", "1000", "117", "1", "61.250000000000", "87"),("42847", "2", "1005", "185", "1", "61.300000000000", "88"),("67028", "2", "1004", "185", "1", "61.300000000000", "89"),("227533", "2", "1004", "185", "1", "61.300000000000", "90"),("227531", "2", "1004", "185", "1", "61.300000000000", "91"),("227534", "2", "1002", "185", "1", "61.300000000000", "92"),("99742", "2", "1001", "117", "1", "47.800000000000", "93"),("98399", "2", "1000", "117", "1", "59.560000000000", "94"),("98799", "2", "1000", "117", "1", "42.760000000000", "95"),("99738", "2", "1000", "117", "1", "47.800000000000", "96"),("99741", "2", "1000", "117", "1", "47.800000000000", "97"),("99743", "2", "1000", "117", "1", "47.800000000000", "98"),("99744", "2", "1000", "117", "1", "47.800000000000", "99"),("133833", "2", "1000", "341", "1", "29.400000000000", "100"),("114118", "2", "1000", "185", "1", "52.840000000000", "101"),("227530", "2", "1000", "185", "1", "62.050000000000", "102"),("99739", "2", "1000", "117", "1", "47.800000000000", "103"),("99737", "2", "1", "117", "1", "47.800000000000", "104"),("240750", "1", "3", "100", "1", "27.840000000000", "105"),("240953", "1", "1000", "146", "1", "23.430000000000", "106"),("248258", "2", "1000", "122", "1", "34.440000000000", "107"),("248259", "2", "1000", "122", "1", "34.440000000000", "108"),("248262", "2", "1000", "122", "1", "34.440000000000", "109"),("248263", "2", "1000", "122", "1", "34.440000000000", "110"),("98800", "2", "1000", "117", "1", "42.760000000000", "111"),("197575", "2", "2", "229", "1", "11.750000000000", "112"),("240959", "1", "1000", "146", "1", "55.360000000000", "113"),("248260", "2", "1000", "122", "1", "34.440000000000", "114"),("248261", "2", "1000", "122", "1", "34.440000000000", "115"),("248264", "2", "1000", "122", "1", "34.440000000000", "116"),("248265", "2", "1000", "122", "1", "34.440000000000", "117"),("248267", "2", "1000", "122", "1", "34.440000000000", "118"),("244941", "2", "1000", "122", "1", "34.440000000000", "119"),("244942", "2", "1000", "122", "1", "34.440000000000", "120"),("244943", "2", "1000", "122", "1", "34.440000000000", "121"),("229904", "2", "1000", "42", "1", "12.600000000000", "122"),("229905", "2", "1000", "42", "1", "12.600000000000", "123"),("249850", "1", "1000", "54", "1", "64.690000000000", "124"),("249852", "1", "1000", "54", "1", "64.690000000000", "125"),("249856", "1", "1000", "54", "1", "64.690000000000", "126"),("240962", "1", "1000", "146", "1", "55.360000000000", "127"),("242650", "1", "1000", "146", "1", "55.360000000000", "128"),("248266", "2", "1000", "122", "1", "34.440000000000", "129"),("240170", "1", "16", "100", "1", "27.840000000000", "130"),("240171", "1", "13", "100", "1", "27.840000000000", "131"),("249823", "1", "11", "100", "1", "27.840000000000", "132"),("235540", "1", "1002", "54", "1", "37.800000000000", "133"),("235544", "1", "1002", "54", "1", "37.800000000000", "134"),("161349", "1", "1000", "637", "1", "30.240000000000", "135"),("161351", "1", "1000", "637", "1", "30.240000000000", "136"),("161353", "1", "1000", "637", "1", "30.240000000000", "137"),("161355", "1", "1000", "637", "1", "30.240000000000", "138"),("161357", "1", "1000", "637", "1", "24.360000000000", "139"),("161363", "1", "1000", "637", "1", "30.240000000000", "140"),("235539", "1", "1000", "54", "1", "37.800000000000", "141"),("235543", "1", "1000", "54", "1", "37.800000000000", "142"),("197577", "2", "9", "229", "1", "11.750000000000", "143"),("115815", "2", "1", "492", "1", "6.900000000000", "144"),("197581", "2", "1", "229", "1", "11.750000000000", "145"),("230715", "1", "1000", "693", "1", "96.630000000000", "146"),("230716", "1", "1000", "693", "1", "96.630000000000", "147"),("230717", "1", "1000", "693", "1", "96.630000000000", "148"),("171895", "1", "1002", "658", "1", "20.640000000000", "149"),("171896", "1", "1002", "658", "1", "20.640000000000", "150"),("171897", "1", "1002", "658", "1", "20.640000000000", "151"),("171899", "1", "1002", "658", "1", "20.640000000000", "152"),("171900", "1", "1002", "658", "1", "20.640000000000", "153"),("171901", "1", "1002", "658", "1", "20.640000000000", "154"),("171902", "1", "1002", "658", "1", "20.640000000000", "155"),("240393", "1", "1002", "658", "1", "20.640000000000", "156"),("240394", "1", "1002", "658", "1", "20.640000000000", "157"),("171795", "1", "1001", "658", "1", "36.260000000000", "158"),("171804", "1", "1001", "658", "1", "36.260000000000", "159"),("135121", "1", "1001", "117", "1", "53.690000000000", "160"),("244939", "2", "1000", "122", "1", "34.440000000000", "161"),("244948", "2", "1000", "122", "1", "34.440000000000", "162"),("249849", "1", "1000", "54", "1", "64.690000000000", "163"),("249853", "1", "1000", "54", "1", "64.690000000000", "164"),("249855", "1", "1000", "54", "1", "64.690000000000", "165"),("171796", "1", "1000", "658", "1", "36.260000000000", "166"),("171797", "1", "1000", "658", "1", "36.260000000000", "167"),("171798", "1", "1000", "658", "1", "26.040000000000", "168"),("171799", "1", "1000", "658", "1", "36.260000000000", "169"),("171800", "1", "1000", "658", "1", "36.260000000000", "170"),("171801", "1", "1000", "658", "1", "36.260000000000", "171"),("171802", "1", "1000", "658", "1", "36.260000000000", "172"),("171803", "1", "1000", "658", "1", "36.260000000000", "173"),("147719", "1", "1000", "117", "1", "53.690000000000", "174"),("135127", "1", "1000", "117", "1", "53.690000000000", "175"),("48009", "2", "1001", "113", "1", "774.690000000000", "176"),("165648", "1", "1000", "224", "1", "299.060000000000", "177"),("230714", "1", "1000", "693", "1", "96.630000000000", "178"),("230718", "1", "1000", "693", "1", "96.630000000000", "179"),("230719", "1", "1000", "693", "1", "96.630000000000", "180"),("230720", "1", "1000", "693", "1", "96.630000000000", "181"),("205119", "1", "1000", "360", "1", "14.790000000000", "182"),("240180", "1", "18", "100", "1", "27.840000000000", "183"),("240179", "1", "18", "100", "1", "27.840000000000", "184"),("240172", "1", "16", "100", "1", "27.840000000000", "185"),("249916", "1", "12", "100", "1", "27.840000000000", "186"),("249918", "1", "12", "100", "1", "27.840000000000", "187"),("249824", "1", "11", "100", "1", "27.840000000000", "188"),("240751", "1", "5", "100", "1", "27.840000000000", "189"),("135123", "1", "1001", "117", "1", "53.690000000000", "190"),("135125", "1", "1001", "117", "1", "53.690000000000", "191"),("135129", "1", "1000", "117", "1", "53.690000000000", "192"),("235541", "1", "1000", "54", "1", "37.800000000000", "193"),("197579", "2", "8", "229", "1", "11.750000000000", "194"),("230712", "1", "1000", "693", "1", "96.630000000000", "195"),("249920", "1", "12", "100", "1", "27.840000000000", "196"),("249825", "1", "11", "100", "1", "27.840000000000", "197"),("249915", "1", "10", "100", "1", "27.840000000000", "198"),("137921", "2", "1006", "581", "1", "35.280000000000", "199"),("64864", "2", "1004", "185", "1", "46.930000000000", "200"),("70376", "2", "1000", "185", "1", "40.240000000000", "201"),("70408", "2", "1000", "185", "1", "39.400000000000", "202"),("70409", "2", "1000", "185", "1", "39.400000000000", "203"),("70410", "2", "1000", "185", "1", "39.400000000000", "204"),("97153", "2", "1000", "185", "1", "39.400000000000", "205"),("137925", "2", "1000", "581", "1", "35.280000000000", "206"),("238163", "1", "1000", "656", "1", "60.970000000000", "207"),("238160", "1", "1000", "656", "1", "60.970000000000", "208"),("238159", "1", "1000", "656", "1", "60.970000000000", "209"),("100758", "2", "1", "177", "1", "29.310000000000", "210"),("167645", "2", "1", "54", "1", "27.260000000000", "211"),("230713", "1", "1000", "693", "1", "96.630000000000", "212"),("205123", "1", "1000", "360", "1", "14.790000000000", "213"),("249914", "1", "12", "100", "1", "27.840000000000", "214"),("248279", "1", "1001", "122", "1", "61.500000000000", "215"),("60651", "2", "1000", "189", "1", "10.830000000000", "216"),("135131", "1", "1000", "117", "1", "53.690000000000", "217"),("248275", "1", "1", "122", "1", "61.500000000000", "218"),("248276", "1", "1", "122", "1", "61.500000000000", "219"),("174678", "2", "1", "423", "1", "5.100800000000", "220"),("219885", "1", "1009", "185", "1", "39.360000000000", "221"),("219882", "1", "1005", "185", "1", "54.490000000000", "222"),("112342", "1", "1004", "85", "1", "31.080000000000", "223"),("104316", "2", "1003", "42", "1", "13.430000000000", "224"),("104320", "2", "1003", "42", "1", "13.430000000000", "225"),("104317", "2", "1003", "42", "1", "13.430000000000", "226"),("104318", "2", "1003", "42", "1", "13.430000000000", "227"),("104322", "2", "1003", "42", "1", "13.430000000000", "228"),("104314", "2", "1002", "42", "1", "13.430000000000", "229"),("231232", "2", "1002", "42", "1", "13.430000000000", "230"),("219886", "1", "1002", "185", "1", "39.360000000000", "231"),("104319", "2", "1002", "42", "1", "13.430000000000", "232"),("104315", "2", "1002", "42", "1", "13.430000000000", "233"),("231231", "2", "1002", "42", "1", "13.430000000000", "234"),("89403", "2", "1002", "423", "1", "21.830000000000", "235"),("98791", "2", "1001", "117", "1", "36.880000000000", "236"),("163265", "2", "1001", "185", "1", "46.930000000000", "237"),("219879", "1", "1001", "185", "1", "54.490000000000", "238"),("98794", "2", "1000", "117", "1", "36.880000000000", "239"),("104377", "2", "1000", "42", "1", "12.600000000000", "240"),("168686", "2", "1000", "603", "1", "30.240000000000", "241"),("168687", "2", "1000", "603", "1", "30.240000000000", "242"),("168688", "2", "1000", "603", "1", "30.240000000000", "243"),("168689", "2", "1000", "603", "1", "30.240000000000", "244"),("168690", "2", "1000", "603", "1", "30.240000000000", "245"),("163271", "2", "1000", "185", "1", "46.930000000000", "246"),("133859", "2", "1000", "341", "1", "20.990000000000", "247"),("133867", "2", "1000", "341", "1", "20.990000000000", "248"),("227438", "1", "1000", "54", "1", "44.520000000000", "249"),("218105", "2", "1000", "54", "1", "54.610000000000", "250"),("218107", "2", "1000", "54", "1", "54.610000000000", "251"),("218109", "2", "1000", "54", "1", "54.610000000000", "252"),("218111", "2", "1000", "54", "1", "54.610000000000", "253"),("219869", "1", "1000", "185", "1", "54.490000000000", "254"),("219872", "1", "1000", "185", "1", "54.490000000000", "255"),("238162", "1", "1000", "656", "1", "60.970000000000", "256"),("104374", "2", "1000", "42", "1", "12.600000000000", "257"),("104375", "2", "1000", "42", "1", "12.600000000000", "258"),("104376", "2", "1000", "42", "1", "12.600000000000", "259"),("104378", "2", "1000", "42", "1", "12.600000000000", "260"),("104381", "2", "1000", "42", "1", "12.600000000000", "261"),("104382", "2", "1000", "42", "1", "12.600000000000", "262"),("231178", "2", "1000", "42", "1", "12.600000000000", "263"),("231179", "2", "1000", "42", "1", "12.600000000000", "264"),("48778", "2", "1000", "155", "1", "32.460000000000", "265"),("104380", "2", "1000", "42", "1", "12.600000000000", "266"),("104383", "2", "1000", "42", "1", "12.600000000000", "267"),("112344", "1", "15", "85", "1", "31.080000000000", "268"),("58820", "2", "10", "285", "1", "11.980000000000", "269"),("104323", "2", "9", "42", "1", "13.430000000000", "270"),("115150", "1", "4", "85", "1", "31.080000000000", "271"),("250774", "1", "1000", "745", "1", "29.670000000000", "272"),("250780", "1", "1000", "745", "1", "29.670000000000", "273"),("250771", "1", "1000", "745", "1", "29.670000000000", "274"),("250772", "1", "1000", "745", "1", "29.670000000000", "275"),("250773", "1", "1000", "745", "1", "29.670000000000", "276"),("250775", "1", "1000", "745", "1", "29.670000000000", "277"),("250776", "1", "1000", "745", "1", "29.670000000000", "278"),("250777", "1", "1000", "745", "1", "29.670000000000", "279"),("250778", "1", "1000", "745", "1", "29.670000000000", "280"),("250779", "1", "1000", "745", "1", "29.670000000000", "281"),("250781", "1", "1000", "745", "1", "29.670000000000", "282"),("250782", "1", "1000", "745", "1", "29.670000000000", "283"),("250783", "1", "1000", "745", "1", "29.670000000000", "284"),("250784", "1", "1000", "745", "1", "29.670000000000", "285"),("250785", "1", "1000", "745", "1", "29.670000000000", "286"),("250786", "1", "1000", "745", "1", "29.670000000000", "287"),("248274", "1", "1001", "122", "1", "61.500000000000", "288"),("248277", "1", "1001", "122", "1", "61.500000000000", "289"),("229322", "1", "1000", "423", "1", "252.090000000000", "290"),("112341", "1", "1007", "85", "1", "31.080000000000", "291"),("140605", "1", "1006", "360", "1", "16.900000000000", "292"),("163275", "2", "1003", "185", "1", "46.930000000000", "293"),("227441", "1", "1003", "54", "1", "44.520000000000", "294"),("227442", "1", "1003", "54", "1", "44.520000000000", "295"),("172787", "2", "1001", "105", "1", "29.400000000000", "296"),("100385", "2", "1000", "177", "1", "34.360000000000", "297"),("100386", "2", "1000", "177", "1", "34.360000000000", "298"),("100442", "2", "1000", "177", "1", "34.360000000000", "299"),("100443", "2", "1000", "177", "1", "34.360000000000", "300"),("100444", "2", "1000", "177", "1", "34.360000000000", "301"),("100447", "2", "1000", "177", "1", "34.360000000000", "302"),("100448", "2", "1000", "177", "1", "34.360000000000", "303"),("105078", "2", "1000", "42", "1", "26.880000000000", "304"),("105080", "2", "1000", "42", "1", "26.880000000000", "305"),("167338", "2", "1000", "483", "1", "28.470000000000", "306"),("113974", "2", "1000", "185", "1", "39.400000000000", "307"),("118262", "2", "1000", "105", "1", "23.430000000000", "308"),("118303", "2", "1000", "105", "1", "25.950000000000", "309"),("118304", "2", "1000", "105", "1", "25.950000000000", "310"),("118305", "2", "1000", "105", "1", "25.950000000000", "311"),("118306", "2", "1000", "105", "1", "25.950000000000", "312"),("118307", "2", "1000", "105", "1", "25.950000000000", "313"),("118308", "2", "1000", "105", "1", "25.950000000000", "314"),("227440", "1", "1000", "54", "1", "44.520000000000", "315"),("234624", "2", "1000", "185", "1", "43.150000000000", "316"),("234626", "2", "1000", "185", "1", "43.150000000000", "317"),("236153", "1", "1000", "54", "1", "9.010000000000", "318"),("98181", "2", "1000", "177", "1", "34.360000000000", "319"),("174680", "2", "1000", "423", "1", "6.290000000000", "320"),("151041", "1", "4", "122", "1", "41.080000000000", "321"),("98651", "2", "1002", "117", "1", "42.760000000000", "322"),("172785", "2", "1002", "105", "1", "29.400000000000", "323"),("172796", "2", "1002", "105", "1", "29.400000000000", "324"),("172789", "2", "1001", "105", "1", "29.400000000000", "325"),("172799", "2", "1001", "105", "1", "29.400000000000", "326"),("228641", "1", "1001", "85", "1", "29.360000000000", "327"),("98643", "2", "1000", "117", "1", "42.760000000000", "328"),("98650", "2", "1000", "117", "1", "42.760000000000", "329"),("98653", "2", "1000", "117", "1", "42.760000000000", "330"),("98656", "2", "1000", "117", "1", "42.760000000000", "331"),("227439", "1", "1000", "54", "1", "44.520000000000", "332"),("234630", "2", "1000", "185", "1", "43.150000000000", "333"),("237175", "2", "1000", "423", "1", "6.710000000000", "334"),("171983", "1", "1000", "658", "1", "36.260000000000", "335"),("228638", "1", "1000", "85", "1", "17.940000000000", "336"),("228639", "1", "1000", "85", "1", "29.360000000000", "337"),("228640", "1", "1000", "85", "1", "29.360000000000", "338"),("98655", "2", "1000", "117", "1", "42.760000000000", "339"),("151037", "1", "3", "122", "1", "41.080000000000", "340"),("112345", "1", "3", "85", "1", "31.080000000000", "341"),("66385", "2", "1", "279", "1", "41.920000000000", "342"),("98658", "2", "1", "117", "1", "42.760000000000", "343"),("151039", "1", "1", "122", "1", "34.360000000000", "344"),("244067", "1", "1000", "122", "1", "37.800000000000", "345"),("227306", "2", "1008", "528", "1", "8.390000000000", "346"),("115961", "2", "1006", "294", "1", "19.550000000000", "347"),("171763", "1", "1004", "658", "1", "33.760000000000", "348"),("171761", "1", "1002", "658", "1", "33.760000000000", "349"),("171766", "1", "1002", "658", "1", "33.760000000000", "350"),("171768", "1", "1002", "658", "1", "33.760000000000", "351"),("172794", "2", "1002", "105", "1", "29.400000000000", "352"),("210135", "1", "1002", "693", "1", "78.140000000000", "353"),("171767", "1", "1002", "658", "1", "33.760000000000", "354"),("172791", "2", "1001", "105", "1", "29.400000000000", "355"),("172804", "2", "1001", "105", "1", "29.400000000000", "356"),("104396", "2", "1000", "42", "1", "32.760000000000", "357"),("106962", "2", "1000", "279", "1", "25.950000000000", "358"),("118133", "2", "1000", "105", "1", "24.270000000000", "359"),("118134", "2", "1000", "105", "1", "24.270000000000", "360"),("118135", "2", "1000", "105", "1", "24.270000000000", "361"),("118137", "2", "1000", "105", "1", "24.270000000000", "362"),("118139", "2", "1000", "105", "1", "24.270000000000", "363"),("118140", "2", "1000", "105", "1", "24.270000000000", "364"),("119139", "2", "1000", "105", "1", "8.220000000000", "365"),("227305", "2", "1000", "528", "1", "8.390000000000", "366"),("205639", "1", "1000", "224", "1", "28.470000000000", "367"),("205641", "1", "1000", "224", "1", "28.470000000000", "368"),("245552", "1", "1000", "54", "1", "487.380000000000", "369"),("245553", "1", "1000", "54", "1", "487.380000000000", "370"),("245555", "1", "1000", "54", "1", "487.380000000000", "371"),("245556", "1", "1000", "54", "1", "487.380000000000", "372"),("236638", "1", "1000", "85", "1", "31.080000000000", "373"),("239139", "2", "1000", "85", "1", "61.330000000000", "374"),("236637", "1", "1000", "85", "1", "31.080000000000", "375"),("239140", "2", "1000", "85", "1", "61.330000000000", "376"),("171981", "1", "1000", "658", "1", "36.260000000000", "377"),("171986", "1", "1000", "658", "1", "36.260000000000", "378"),("120097", "2", "1000", "12", "1", "13.120000000000", "379"),("228642", "1", "1000", "85", "1", "29.360000000000", "380"),("171762", "1", "2", "658", "1", "33.760000000000", "381"),("171764", "1", "2", "658", "1", "33.760000000000", "382"),("150963", "1", "1", "122", "1", "37.720000000000", "383"),("168425", "2", "1000", "115", "1", "164.690000000000", "384"),("168429", "2", "1000", "115", "1", "164.690000000000", "385"),("239415", "2", "1000", "122", "1", "44.520000000000", "386"),("239418", "2", "1000", "122", "1", "44.520000000000", "387"),("171769", "1", "1002", "658", "1", "33.760000000000", "388"),("106961", "2", "1000", "279", "1", "25.950000000000", "389"),("178253", "1", "1000", "122", "1", "128.550000000000", "390"),("179468", "1", "1000", "122", "1", "74.780000000000", "391"),("187103", "1", "1000", "122", "1", "51.250000000000", "392"),("187105", "1", "1000", "122", "1", "51.250000000000", "393"),("187107", "1", "1000", "122", "1", "51.250000000000", "394"),("221713", "1", "1000", "459", "1", "73.010000000000", "395"),("221718", "1", "1000", "459", "1", "73.010000000000", "396"),("239412", "2", "1000", "122", "1", "44.520000000000", "397"),("239413", "2", "1000", "122", "1", "44.520000000000", "398"),("106908", "1", "1019", "360", "1", "15.010000000000", "399"),("132959", "1", "1000", "360", "1", "15.010000000000", "400"),("185949", "1", "1000", "122", "1", "54.610000000000", "401"),("230818", "2", "1000", "117", "1", "34.360000000000", "402"),("230948", "1", "1000", "693", "1", "86.540000000000", "403"),("221711", "1", "1000", "459", "1", "73.010000000000", "404"),("221712", "1", "1000", "459", "1", "73.010000000000", "405"),("221716", "1", "1000", "459", "1", "73.010000000000", "406"),("244919", "2", "1000", "122", "1", "22.680000000000", "407"),("244920", "2", "1000", "122", "1", "22.680000000000", "408"),("244921", "2", "1000", "122", "1", "22.680000000000", "409"),("221710", "1", "999", "459", "1", "73.010000000000", "410"),("221717", "1", "999", "459", "1", "73.010000000000", "411"),("221719", "1", "999", "459", "1", "73.010000000000", "412"),("221727", "1", "999", "459", "1", "73.010000000000", "413"),("169596", "2", "1000", "115", "1", "1387.380000000000", "414"),("229850", "2", "1001", "42", "1", "8.140000000000", "415"),("225502", "1", "1000", "122", "1", "54.610000000000", "416"),("225503", "1", "1000", "122", "1", "54.610000000000", "417"),("185947", "1", "1000", "122", "1", "54.610000000000", "418"),("187117", "2", "1000", "122", "1", "57.970000000000", "419"),("229846", "2", "1000", "42", "1", "35.280000000000", "420"),("233360", "1", "1000", "122", "1", "250.400000000000", "421"),("221715", "1", "1000", "459", "1", "73.010000000000", "422"),("221726", "1", "1000", "459", "1", "73.010000000000", "423"),("244916", "2", "1000", "122", "1", "22.680000000000", "424"),("244917", "2", "1000", "122", "1", "22.680000000000", "425"),("244922", "2", "1000", "122", "1", "22.680000000000", "426"),("244923", "2", "1000", "122", "1", "22.680000000000", "427"),("246850", "1", "1000", "745", "1", "15.450000000000", "428"),("246851", "1", "1000", "745", "1", "15.450000000000", "429"),("246853", "1", "1000", "745", "1", "15.450000000000", "430"),("246871", "1", "1000", "745", "1", "17.970000000000", "431"),("246872", "1", "1000", "745", "1", "17.970000000000", "432"),("246874", "1", "1000", "745", "1", "17.970000000000", "433"),("239560", "1", "1000", "122", "1", "22.680000000000", "434"),("239563", "1", "1000", "122", "1", "22.680000000000", "435"),("239575", "1", "1000", "122", "1", "22.680000000000", "436"),("239577", "1", "1000", "122", "1", "22.680000000000", "437"),("239582", "1", "1000", "122", "1", "22.680000000000", "438"),("239594", "1", "1000", "122", "1", "22.680000000000", "439"),("171886", "1", "1000", "658", "1", "20.640000000000", "440"),("171888", "1", "1000", "658", "1", "20.640000000000", "441"),("171889", "1", "1000", "658", "1", "20.640000000000", "442"),("171890", "1", "1000", "658", "1", "20.640000000000", "443"),("171891", "1", "1000", "658", "1", "20.640000000000", "444"),("171892", "1", "1000", "658", "1", "20.640000000000", "445"),("171893", "1", "1000", "658", "1", "20.640000000000", "446"),("237869", "2", "1000", "294", "1", "7.920000000000", "447"),("146633", "2", "1", "85", "1", "20.910000000000", "448"),("191767", "1", "1002", "122", "1", "44.520000000000", "449"),("177790", "1", "1000", "507", "1", "17.130000000000", "450"),("224294", "1", "1000", "337", "1", "36.960000000000", "451"),("224295", "1", "1000", "337", "1", "36.960000000000", "452"),("224296", "1", "1000", "337", "1", "36.960000000000", "453"),("224297", "1", "1000", "337", "1", "36.960000000000", "454"),("224299", "1", "1000", "337", "1", "36.960000000000", "455"),("224300", "1", "1000", "337", "1", "36.960000000000", "456"),("224304", "1", "1000", "337", "1", "36.960000000000", "457"),("224305", "1", "1000", "337", "1", "36.960000000000", "458"),("224306", "1", "1000", "337", "1", "36.960000000000", "459"),("224307", "1", "1000", "337", "1", "36.960000000000", "460"),("224308", "1", "1000", "337", "1", "36.960000000000", "461"),("224309", "1", "1000", "337", "1", "36.960000000000", "462"),("224310", "1", "1000", "337", "1", "36.960000000000", "463"),("246848", "1", "1000", "745", "1", "15.450000000000", "464"),("246852", "1", "1000", "745", "1", "15.450000000000", "465"),("246854", "1", "1000", "745", "1", "15.450000000000", "466"),("246869", "1", "1000", "745", "1", "17.970000000000", "467"),("246873", "1", "1000", "745", "1", "17.970000000000", "468"),("246876", "1", "1000", "745", "1", "17.970000000000", "469"),("239557", "1", "1000", "122", "1", "22.680000000000", "470"),("239576", "1", "1000", "122", "1", "22.680000000000", "471"),("239581", "1", "1000", "122", "1", "22.680000000000", "472"),("248558", "2", "1000", "170", "1", "47.610000000000", "473"),("248623", "2", "1000", "170", "1", "47.610000000000", "474"),("248665", "2", "1000", "170", "1", "47.610000000000", "475"),("128513", "2", "1000", "85", "1", "20.570000000000", "476"),("200067", "2", "1000", "224", "1", "11.670000000000", "477"),("218463", "1", "1000", "749", "1", "102.420000000000", "478"),("146631", "2", "2", "85", "1", "20.910000000000", "479"),("52273", "2", "1000", "115", "1", "1049.560000000000", "480"),("60697", "2", "1002", "189", "1", "12.500000000000", "481"),("245194", "1", "1000", "117", "1", "34.360000000000", "482"),("245197", "1", "1000", "117", "1", "34.360000000000", "483"),("245199", "1", "1000", "117", "1", "34.360000000000", "484"),("246849", "1", "1000", "745", "1", "15.450000000000", "485"),("246870", "1", "1000", "745", "1", "17.970000000000", "486"),("239568", "1", "1000", "122", "1", "22.680000000000", "487"),("239593", "1", "1000", "122", "1", "22.680000000000", "488"),("250213", "1", "1000", "42", "1", "11.570000000000", "489"),("250215", "1", "1000", "42", "1", "11.570000000000", "490"),("250217", "1", "1000", "42", "1", "11.570000000000", "491"),("200085", "2", "1000", "224", "1", "11.250000000000", "492"),("246154", "2", "12", "28", "1", "28.420000000000", "493"),("246159", "2", "11", "28", "1", "28.420000000000", "494"),("246162", "2", "9", "28", "1", "28.420000000000", "495"),("246161", "2", "7", "28", "1", "28.420000000000", "496"),("161369", "1", "1001", "637", "1", "30.240000000000", "497"),("161365", "1", "1000", "637", "1", "30.240000000000", "498"),("161367", "1", "1000", "637", "1", "30.240000000000", "499"),("161371", "1", "1000", "637", "1", "30.240000000000", "500"),("161373", "1", "1000", "637", "1", "30.240000000000", "501"),("161375", "1", "1000", "637", "1", "30.240000000000", "502"),("161379", "1", "1000", "637", "1", "30.240000000000", "503"),("161381", "1", "1000", "637", "1", "24.360000000000", "504"),("161383", "1", "1000", "637", "1", "30.240000000000", "505"),("179604", "2", "1000", "115", "1", "883.180000000000", "506"),("250020", "1", "1000", "42", "1", "38.020000000000", "507"),("250022", "1", "1000", "42", "1", "38.020000000000", "508"),("250026", "1", "1000", "42", "1", "38.020000000000", "509"),("250028", "1", "1000", "42", "1", "38.020000000000", "510"),("246160", "2", "15", "28", "1", "28.420000000000", "511"),("246136", "2", "14", "28", "1", "28.420000000000", "512"),("246138", "2", "13", "28", "1", "28.420000000000", "513"),("169307", "2", "1004", "54", "1", "54.610000000000", "514"),("169305", "2", "1003", "54", "1", "54.610000000000", "515"),("169304", "2", "1", "54", "1", "41.920000000000", "516"),("169309", "2", "1", "54", "1", "41.920000000000", "517"),("168180", "2", "1001", "115", "1", "891.590000000000", "518"),("246486", "1", "1000", "122", "1", "20.990000000000", "519"),("246488", "1", "1000", "122", "1", "20.990000000000", "520"),("246491", "1", "1000", "122", "1", "20.990000000000", "521"),("246493", "1", "1000", "122", "1", "20.990000000000", "522"),("246494", "1", "1000", "122", "1", "20.990000000000", "523"),("246497", "1", "1000", "122", "1", "20.990000000000", "524"),("246498", "1", "1000", "122", "1", "20.990000000000", "525"),("250787", "1", "1000", "745", "1", "29.670000000000", "526"),("250788", "1", "1000", "745", "1", "29.670000000000", "527"),("250789", "1", "1000", "745", "1", "29.670000000000", "528"),("250790", "1", "1000", "745", "1", "29.670000000000", "529"),("250791", "1", "1000", "745", "1", "29.670000000000", "530"),("250792", "1", "1000", "745", "1", "29.670000000000", "531"),("250793", "1", "1000", "745", "1", "29.670000000000", "532"),("250794", "1", "1000", "745", "1", "29.670000000000", "533"),("250795", "1", "1000", "745", "1", "29.670000000000", "534"),("250796", "1", "1000", "745", "1", "29.670000000000", "535"),("250797", "1", "1000", "745", "1", "29.670000000000", "536"),("250798", "1", "1000", "745", "1", "29.670000000000", "537"),("250799", "1", "1000", "745", "1", "29.670000000000", "538"),("250800", "1", "1000", "745", "1", "29.670000000000", "539"),("250801", "1", "1000", "745", "1", "29.670000000000", "540"),("250802", "1", "1000", "745", "1", "29.670000000000", "541"),("88105", "2", "1000", "423", "1", "309.230000000000", "542"),("146343", "1", "3", "98", "1", "924.360000000000", "543"),("169306", "2", "1003", "54", "1", "54.610000000000", "544"),("226934", "2", "1000", "54", "1", "71.410000000000", "545"),("226936", "2", "1000", "54", "1", "71.410000000000", "546"),("226942", "2", "1000", "54", "1", "71.410000000000", "547"),("191739", "1", "1000", "54", "1", "29.400000000000", "548"),("77415", "2", "1", "279", "1", "17.550000000000", "549"),("246496", "1", "1000", "122", "1", "20.990000000000", "550"),("248073", "1", "1000", "808", "1", "546.210000000000", "551"),("249694", "1", "1000", "87", "1", "132.150000000000", "552"),("191727", "1", "1005", "54", "1", "37.800000000000", "553"),("191719", "1", "1003", "54", "1", "37.800000000000", "554"),("191733", "1", "1003", "54", "1", "37.800000000000", "555"),("191731", "1", "1002", "54", "1", "37.800000000000", "556"),("108887", "2", "1001", "279", "1", "25.950000000000", "557"),("159677", "2", "1000", "279", "1", "25.950000000000", "558"),("147617", "1", "1000", "117", "1", "59.560000000000", "559"),("226937", "2", "1000", "54", "1", "68.650000000000", "560"),("226938", "2", "1000", "54", "1", "71.410000000000", "561"),("226939", "2", "1000", "54", "1", "71.410000000000", "562"),("226940", "2", "1000", "54", "1", "68.650000000000", "563"),("226941", "2", "1000", "54", "1", "68.650000000000", "564"),("246487", "1", "1000", "122", "1", "20.990000000000", "565"),("246489", "1", "1000", "122", "1", "20.990000000000", "566"),("246490", "1", "1000", "122", "1", "20.990000000000", "567"),("246495", "1", "1000", "122", "1", "20.990000000000", "568"),("5961", "10", "1000", "13", "1", "121.850000000000", "569"),("225441", "1", "1000", "30", "1", "463.770000000000", "570"),("1659", "10", "1000", "13", "1", "94.020000000000", "571"),("99712", "1", "1", "16", "1", "408.390000000000", "572"),("98485", "2", "1001", "117", "1", "36.880000000000", "573"),("98487", "2", "1001", "117", "1", "36.880000000000", "574"),("134913", "1", "1001", "117", "1", "59.560000000000", "575"),("134917", "1", "1001", "117", "1", "59.560000000000", "576"),("134921", "1", "1001", "117", "1", "59.560000000000", "577"),("98484", "2", "1000", "117", "1", "36.880000000000", "578"),("98488", "2", "1000", "117", "1", "39.400000000000", "579"),("108886", "2", "1000", "279", "1", "25.950000000000", "580"),("108916", "2", "1000", "279", "1", "16.880000000000", "581"),("133361", "2", "1000", "581", "1", "30.240000000000", "582"),("133365", "2", "1000", "581", "1", "30.240000000000", "583"),("134919", "1", "1000", "117", "1", "59.560000000000", "584"),("134923", "1", "1000", "117", "1", "59.560000000000", "585"),("135109", "1", "1000", "117", "1", "59.560000000000", "586"),("135113", "1", "1000", "117", "1", "59.560000000000", "587"),("226935", "2", "1000", "54", "1", "71.410000000000", "588"),("227433", "2", "1000", "54", "1", "54.610000000000", "589"),("229233", "2", "1000", "117", "1", "39.400000000000", "590"),("207803", "2", "1000", "117", "1", "39.400000000000", "591"),("133357", "2", "1", "581", "1", "30.240000000000", "592"),("246274", "2", "1000", "224", "1", "279.740000000000", "593"),("134915", "1", "1000", "117", "1", "59.560000000000", "594"),("135111", "1", "1000", "117", "1", "59.560000000000", "595"),("248390", "2", "1000", "170", "1", "54.400000000000", "596"),("248392", "2", "1000", "170", "1", "54.400000000000", "597"),("248393", "2", "1000", "170", "1", "54.400000000000", "598"),("248405", "2", "1000", "170", "1", "54.400000000000", "599"),("248412", "2", "1000", "170", "1", "54.400000000000", "600"),("248413", "2", "1000", "170", "1", "54.400000000000", "601"),("20462", "2", "1000", "42", "1", "10.070000000000", "602"),("5567", "10", "1000", "13", "1", "121.850000000000", "603"),("63830", "2", "1005", "94", "1", "36.910000000000", "604"),("165797", "2", "1003", "67", "1", "16.210000000000", "605"),("27851", "2", "1002", "94", "1", "36.910000000000", "606"),("109651", "2", "1002", "94", "1", "39.020000000000", "607"),("27853", "2", "1001", "94", "1", "36.910000000000", "608"),("109649", "2", "1001", "94", "1", "39.020000000000", "609"),("63832", "2", "1001", "94", "1", "39.020000000000", "610"),("227703", "2", "1000", "455", "1", "35.590000000000", "611"),("27850", "2", "1000", "94", "1", "36.910000000000", "612"),("27852", "2", "1000", "94", "1", "36.910000000000", "613"),("27854", "2", "1000", "94", "1", "36.910000000000", "614"),("27857", "2", "1000", "94", "1", "36.910000000000", "615"),("27862", "2", "1000", "94", "1", "36.910000000000", "616"),("92968", "2", "1000", "94", "1", "39.020000000000", "617"),("42860", "2", "1000", "94", "1", "36.910000000000", "618"),("163362", "2", "2", "455", "1", "35.590000000000", "619"),("163365", "2", "1", "455", "1", "35.590000000000", "620"),("191721", "1", "1005", "54", "1", "37.800000000000", "621"),("191723", "1", "1003", "54", "1", "37.800000000000", "622"),("106031", "1", "1001", "128", "1", "30.160000000000", "623"),("216855", "2", "1000", "279", "1", "25.950000000000", "624"),("187835", "2", "1000", "294", "1", "10.070000000000", "625"),("102447", "2", "1017", "294", "1", "11.980000000000", "626"),("191729", "1", "1005", "54", "1", "37.800000000000", "627"),("191725", "1", "1004", "54", "1", "37.800000000000", "628"),("235554", "1", "1000", "85", "1", "51.250000000000", "629"),("235555", "1", "1000", "85", "1", "51.250000000000", "630"),("172779", "2", "1000", "85", "1", "42.050000000000", "631"),("78851", "2", "1001", "67", "1", "77.300000000000", "632"),("246313", "1", "1002", "133", "1", "61.330000000000", "633"),("246316", "1", "1002", "133", "1", "61.330000000000", "634"),("246319", "1", "1002", "133", "1", "61.330000000000", "635"),("246321", "1", "1002", "133", "1", "61.330000000000", "636"),("246322", "1", "1002", "133", "1", "61.330000000000", "637"),("246320", "1", "1001", "133", "1", "61.330000000000", "638"),("246317", "1", "1001", "133", "1", "61.330000000000", "639"),("235553", "1", "1000", "85", "1", "51.250000000000", "640"),("235556", "1", "1000", "85", "1", "51.250000000000", "641"),("236581", "1", "1000", "85", "1", "44.520000000000", "642"),("236583", "1", "1000", "85", "1", "44.520000000000", "643"),("236584", "1", "1000", "85", "1", "44.520000000000", "644"),("246311", "1", "1002", "133", "1", "61.330000000000", "645"),("246312", "1", "1002", "133", "1", "61.330000000000", "646"),("246314", "1", "1002", "133", "1", "61.330000000000", "647"),("246315", "1", "1002", "133", "1", "61.330000000000", "648"),("246318", "1", "1002", "133", "1", "61.330000000000", "649"),("94189", "2", "1000", "516", "1", "28.050000000000", "650"),("233884", "2", "1000", "455", "1", "35.590000000000", "651"),("243820", "2", "1000", "85", "1", "26.030000000000", "652"),("243821", "2", "1000", "85", "1", "26.030000000000", "653"),("243822", "2", "1000", "85", "1", "26.030000000000", "654"),("243823", "2", "1000", "85", "1", "26.030000000000", "655"),("236580", "1", "1000", "85", "1", "44.520000000000", "656"),("109479", "2", "1000", "85", "1", "23.980000000000", "657"),("146657", "2", "1000", "85", "1", "30.940000000000", "658"),("146661", "2", "1000", "85", "1", "30.940000000000", "659"),("146667", "2", "1000", "85", "1", "30.940000000000", "660"),("128515", "2", "1000", "85", "1", "26.020000000000", "661"),("60734", "2", "1000", "189", "1", "11.670000000000", "662"),("233883", "2", "1000", "455", "1", "35.590000000000", "663"),("146663", "2", "1000", "85", "1", "30.940000000000", "664"),("250041", "1", "1000", "42", "1", "42.980000000000", "665"),("146671", "2", "1000", "85", "1", "38.030000000000", "666"),("146675", "2", "1000", "85", "1", "38.030000000000", "667"),("246734", "2", "4", "85", "1", "37.800000000000", "668"),("163546", "1", "1000", "455", "1", "35.590000000000", "669"),("251226", "1", "1000", "122", "1", "37.800000000000", "670"),("251229", "1", "1000", "122", "1", "37.800000000000", "671"),("251224", "1", "1000", "122", "1", "37.800000000000", "672"),("251225", "1", "1000", "122", "1", "37.800000000000", "673"),("251227", "1", "1000", "122", "1", "37.800000000000", "674"),("251228", "1", "1000", "122", "1", "37.800000000000", "675"),("251231", "1", "1000", "122", "1", "37.800000000000", "676"),("251230", "1", "1000", "122", "1", "37.800000000000", "677"),("100959", "2", "0", "177", "1", "31.000000000000", "678"),("37201", "2", "0", "177", "1", "31.000000000000", "679"),("223443", "1", "0", "459", "1", "57.000000000000", "680"),("223450", "1", "0", "459", "1", "57.000000000000", "681"),("223451", "1", "0", "459", "1", "57.000000000000", "682"),("223441", "1", "0", "459", "1", "57.000000000000", "683"),("223442", "1", "0", "459", "1", "57.000000000000", "684"),("223447", "1", "0", "459", "1", "57.000000000000", "685"),("223452", "1", "0", "459", "1", "57.000000000000", "686"),("91780", "2", "0", "85", "1", "28.480000000000", "687"),("73737", "2", "0", "185", "1", "30.000000000000", "688"),("126411", "2", "0", "581", "1", "20.170000000000", "689"),("137929", "2", "0", "581", "1", "20.170000000000", "690"),("137933", "2", "0", "581", "1", "20.170000000000", "691"),("137937", "2", "0", "581", "1", "20.170000000000", "692"),("114120", "2", "0", "185", "1", "30.210000000000", "693"),("133839", "2", "0", "341", "1", "19.330000000000", "694"),("228755", "2", "0", "117", "1", "45.280000000000", "695"),("207791", "1", "0", "117", "1", "53.690000000000", "696"),("98409", "2", "0", "117", "1", "39.000000000000", "697"),("98415", "2", "0", "117", "1", "39.000000000000", "698"),("98426", "2", "0", "117", "1", "39.000000000000", "699"),("98432", "2", "0", "117", "1", "39.000000000000", "700"),("98894", "2", "0", "117", "1", "32.000000000000", "701"),("124103", "2", "0", "117", "1", "35.000000000000", "702"),("114114", "2", "0", "185", "1", "41.170000000000", "703"),("99842", "2", "0", "117", "1", "47.000000000000", "704"),("98441", "2", "0", "117", "1", "45.000000000000", "705"),("98443", "2", "0", "117", "1", "45.000000000000", "706"),("98445", "2", "0", "117", "1", "45.000000000000", "707"),("103511", "1", "0", "185", "1", "34.000000000000", "708"),("98438", "2", "0", "117", "1", "45.000000000000", "709"),("109682", "2", "0", "85", "1", "28.130000000000", "710"),("241996", "1", "0", "11", "1", "20.960000000000", "711"),("249854", "1", "0", "54", "1", "64.690000000000", "712"),("161347", "1", "0", "637", "1", "17.500000000000", "713"),("161359", "1", "0", "637", "1", "17.500000000000", "714"),("161361", "1", "0", "637", "1", "17.500000000000", "715"),("223650", "1", "0", "296", "1", "36.960000000000", "716"),("223651", "1", "0", "296", "1", "36.960000000000", "717"),("223652", "1", "0", "296", "1", "36.960000000000", "718"),("223653", "1", "0", "296", "1", "36.960000000000", "719"),("244940", "2", "0", "122", "1", "25.700000000000", "720"),("244945", "2", "0", "122", "1", "25.700000000000", "721"),("249858", "1", "0", "54", "1", "64.690000000000", "722"),("249822", "1", "0", "100", "1", "27.840000000000", "723"),("247020", "1", "0", "117", "1", "53.690000000000", "724"),("73539", "2", "0", "185", "1", "30.000000000000", "725"),("235542", "1", "0", "54", "1", "28.270000000000", "726"),("168208", "2", "0", "115", "1", "641.000000000000", "727"),("112970", "2", "0", "24", "1", "175.000000000000", "728"),("73538", "2", "0", "185", "1", "30.000000000000", "729"),("73540", "2", "0", "185", "1", "30.000000000000", "730"),("97310", "2", "0", "185", "1", "30.000000000000", "731"),("238161", "1", "0", "656", "1", "36.880000000000", "732"),("249826", "1", "0", "100", "1", "27.840000000000", "733"),("96968", "2", "0", "185", "1", "27.000000000000", "734"),("133869", "2", "0", "341", "1", "13.280000000000", "735"),("248278", "1", "0", "122", "1", "61.500000000000", "736"),("176178", "2", "0", "492", "1", "10.900000000000", "737"),("229319", "1", "0", "423", "1", "568.050000000000", "738"),("105079", "2", "0", "42", "1", "20.000000000000", "739"),("177951", "2", "0", "185", "1", "27.480000000000", "740"),("124181", "2", "0", "337", "1", "32.350000000000", "741"),("226861", "1", "0", "459", "1", "31.000000000000", "742"),("230284", "2", "0", "42", "1", "20.000000000000", "743"),("98649", "2", "0", "117", "1", "32.000000000000", "744"),("98652", "2", "0", "117", "1", "32.000000000000", "745"),("98657", "2", "0", "117", "1", "32.000000000000", "746"),("114006", "2", "0", "185", "1", "30.000000000000", "747"),("237487", "1", "0", "361", "1", "20.000000000000", "748"),("171765", "1", "0", "658", "1", "24.390000000000", "749"),("171979", "1", "0", "658", "1", "27.720000000000", "750"),("147681", "2", "0", "117", "1", "35.000000000000", "751"),("115959", "2", "0", "294", "1", "11.250000000000", "752"),("118138", "2", "0", "105", "1", "18.000000000000", "753"),("225108", "1", "0", "528", "1", "12.610000000000", "754"),("225109", "1", "0", "528", "1", "12.610000000000", "755"),("225110", "1", "0", "528", "1", "12.610000000000", "756"),("225111", "1", "0", "528", "1", "12.610000000000", "757"),("225112", "1", "0", "528", "1", "12.610000000000", "758"),("225113", "1", "0", "528", "1", "12.610000000000", "759"),("236636", "1", "0", "85", "1", "23.130000000000", "760"),("136819", "2", "0", "296", "1", "30.380000000000", "761"),("171760", "1", "0", "658", "1", "30.490000000000", "762"),("239153", "2", "0", "85", "1", "46.270000000000", "763"),("239154", "2", "0", "85", "1", "46.270000000000", "764"),("239420", "2", "0", "122", "1", "33.420000000000", "765"),("239419", "2", "0", "122", "1", "33.420000000000", "766"),("114406", "2", "0", "287", "1", "35.450000000000", "767"),("185943", "1", "0", "122", "1", "19.840000000000", "768"),("239556", "1", "0", "122", "1", "16.710000000000", "769"),("239579", "1", "0", "122", "1", "16.710000000000", "770"),("139499", "2", "0", "48", "1", "4.200000000000", "771"),("162020", "1", "0", "507", "1", "13.700000000000", "772"),("239565", "1", "0", "122", "1", "16.710000000000", "773"),("146911", "1", "0", "17", "1", "142.000000000000", "774"),("200249", "2", "0", "224", "1", "5.510000000000", "775"),("239569", "1", "0", "122", "1", "16.710000000000", "776"),("239580", "1", "0", "122", "1", "16.710000000000", "777"),("161377", "1", "0", "637", "1", "17.500000000000", "778"),("239381", "2", "0", "59", "1", "328.550000000000", "779"),("250021", "1", "0", "42", "1", "38.020000000000", "780"),("250023", "1", "0", "42", "1", "38.020000000000", "781"),("250024", "1", "0", "42", "1", "38.020000000000", "782"),("250027", "1", "0", "42", "1", "38.020000000000", "783"),("246359", "1", "0", "122", "1", "14.140000000000", "784"),("246360", "1", "0", "122", "1", "14.140000000000", "785"),("246361", "1", "0", "122", "1", "14.140000000000", "786"),("246362", "1", "0", "122", "1", "14.140000000000", "787"),("246365", "1", "0", "122", "1", "14.140000000000", "788"),("246367", "1", "0", "122", "1", "14.140000000000", "789"),("246368", "1", "0", "122", "1", "14.140000000000", "790"),("246369", "1", "0", "122", "1", "14.140000000000", "791"),("246370", "1", "0", "122", "1", "14.140000000000", "792"),("244857", "1", "0", "122", "1", "38.560000000000", "793"),("246363", "1", "0", "122", "1", "14.140000000000", "794"),("246364", "1", "0", "122", "1", "14.140000000000", "795"),("246366", "1", "0", "122", "1", "14.140000000000", "796"),("5566", "10", "0", "13", "1", "82.000000000000", "797"),("108912", "2", "0", "279", "1", "16.880000000000", "798"),("98486", "2", "0", "117", "1", "27.000000000000", "799"),("133363", "2", "0", "581", "1", "20.170000000000", "800"),("133359", "2", "0", "581", "1", "20.170000000000", "801"),("227432", "2", "0", "54", "1", "41.130000000000", "802"),("227434", "2", "0", "54", "1", "41.130000000000", "803"),("150203", "1", "0", "507", "1", "10.000000000000", "804"),("59655", "2", "0", "67", "1", "84.210000000000", "805"),("100452", "2", "0", "177", "1", "27.000000000000", "806"),("192051", "2", "0", "280", "1", "3.320000000000", "807"),("63910", "2", "0", "85", "1", "27.310000000000", "808"),("63911", "2", "0", "85", "1", "20.370000000000", "809"),("27864", "2", "0", "94", "1", "27.180000000000", "810"),("109652", "2", "0", "94", "1", "28.770000000000", "811"),("245043", "2", "0", "54", "1", "41.130000000000", "812"),("145535", "2", "0", "67", "1", "14.800000000000", "813"),("225214", "1", "0", "224", "1", "15.220000000000", "814"),("225215", "1", "0", "224", "1", "25.700000000000", "815"),("146665", "2", "0", "85", "1", "25.650000000000", "816"),("146659", "2", "0", "85", "1", "24.490000000000", "817"),("250038", "1", "0", "42", "1", "42.980000000000", "818"),("250039", "1", "0", "42", "1", "42.980000000000", "819"),("250040", "1", "0", "42", "1", "42.980000000000", "820"),("250042", "1", "0", "42", "1", "42.980000000000", "821"),("250043", "1", "0", "42", "1", "42.980000000000", "822"),("250044", "1", "0", "42", "1", "42.980000000000", "823"),("250045", "1", "0", "42", "1", "42.980000000000", "824"),("250046", "1", "0", "42", "1", "42.980000000000", "825"),("247865", "1", "0", "85", "1", "35.990000000000", "826")

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

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

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

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

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

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

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