Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '92c53435a4f46db8094e79dc2f'

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 ("124843", "2", "1001", "289", "1", "5.880000000000", "1"),("227162", "1", "1000", "530", "1", "4.200000000000", "2"),("125449", "2", "1", "289", "1", "5.880000000000", "3"),("37089", "2", "1000", "206", "1", "7.560000000000", "4"),("22278", "2", "1000", "20", "1", "5.780000000000", "5"),("16403", "2", "1000", "42", "1", "12.610000000000", "6"),("231364", "1", "1000", "224", "1", "24.290000000000", "7"),("25764", "2", "1006", "19", "1", "49.480000000000", "8"),("227046", "1", "1022", "68", "1", "13.240000000000", "9"),("165312", "2", "1010", "68", "1", "7.140000000000", "10"),("100231", "1", "1009", "20", "1", "5.410000000000", "11"),("240426", "2", "1003", "20", "1", "17.840000000000", "12"),("32746", "2", "1000", "116", "1", "7.980000000000", "13"),("56927", "2", "1000", "15", "1", "11.380000000000", "14"),("146393", "2", "3", "68", "1", "5.250000000000", "15"),("47562", "2", "1", "42", "1", "7.480000000000", "16"),("240424", "2", "1003", "20", "1", "28.040000000000", "17"),("240430", "1", "1001", "20", "1", "17.840000000000", "18"),("32992", "2", "1001", "20", "1", "4.610000000000", "19"),("171060", "2", "1000", "289", "1", "1815.130000000000", "20"),("171061", "2", "1000", "289", "1", "193.280000000000", "21"),("174937", "2", "1000", "191", "1", "53.920000000000", "22"),("35343", "2", "1000", "289", "1", "8.400000000000", "23"),("22324", "2", "1000", "20", "1", "8.270000000000", "24"),("32989", "2", "1000", "20", "1", "8.000000000000", "25"),("176439", "2", "1000", "20", "1", "30.720000000000", "26"),("93256", "2", "3", "289", "1", "5.880000000000", "27"),("33768", "2", "1", "20", "1", "10.190000000000", "28"),("9833", "2", "1000", "116", "1", "29.410000000000", "29"),("84934", "2", "12", "100", "1", "8.400000000000", "30"),("93250", "2", "1013", "289", "1", "8.400000000000", "31"),("177038", "2", "1005", "289", "1", "18.490000000000", "32"),("42711", "2", "1005", "56", "1", "6.970000000000", "33"),("172411", "2", "1005", "224", "1", "6.220000000000", "34"),("228352", "2", "1003", "20", "1", "13.450000000000", "35"),("124705", "2", "1000", "289", "1", "5.880000000000", "36"),("177033", "2", "1000", "289", "1", "18.490000000000", "37"),("228343", "2", "1000", "20", "1", "14.200000000000", "38"),("228677", "2", "1000", "20", "1", "27.650000000000", "39"),("205249", "2", "1000", "224", "1", "19.240000000000", "40"),("217771", "2", "1000", "224", "1", "6.640000000000", "41"),("200299", "2", "1000", "224", "1", "13.360000000000", "42"),("124959", "2", "993", "289", "1", "6.720000000000", "43"),("90419", "2", "2", "503", "1", "5.290000000000", "44"),("72043", "2", "1000", "145", "1", "25.550000000000", "45"),("72047", "2", "1000", "145", "1", "23.030000000000", "46"),("93645", "2", "1011", "20", "1", "5.410000000000", "47"),("240435", "2", "1010", "20", "1", "3.240000000000", "48"),("240442", "1", "1009", "20", "1", "3.240000000000", "49"),("195021", "2", "1003", "20", "1", "17.270000000000", "50"),("240417", "2", "1003", "20", "1", "13.450000000000", "51"),("196427", "1", "1003", "20", "1", "12.190000000000", "52"),("35338", "2", "1003", "289", "1", "8.400000000000", "53"),("66085", "2", "1002", "289", "1", "6.720000000000", "54"),("228349", "2", "1001", "20", "1", "14.200000000000", "55"),("66190", "2", "1000", "289", "1", "6.720000000000", "56"),("189823", "2", "1000", "289", "1", "8.400000000000", "57"),("241034", "2", "1000", "120", "1", "15.910000000000", "58"),("130419", "2", "1000", "289", "1", "8.400000000000", "59"),("200565", "2", "1000", "224", "1", "19.240000000000", "60"),("114880", "1", "6", "469", "1", "8.320000000000", "61"),("57013", "2", "1001", "15", "1", "31.780000000000", "62"),("89265", "2", "1001", "423", "1", "2.770000000000", "63"),("57061", "2", "1000", "15", "1", "24.620000000000", "64"),("30659", "2", "1000", "49", "1", "8.320000000000", "65"),("25596", "2", "1002", "19", "1", "13.620000000000", "66"),("92235", "2", "1000", "19", "1", "14.530000000000", "67"),("170159", "1", "1000", "224", "1", "5.800000000000", "68"),("185839", "1", "1017", "20", "1", "5.410000000000", "69"),("240463", "2", "1010", "20", "1", "3.850000000000", "70"),("152497", "2", "1008", "20", "1", "8.660000000000", "71"),("93715", "2", "1005", "20", "1", "6.040000000000", "72"),("240438", "2", "1003", "20", "1", "11.530000000000", "73"),("125421", "2", "1001", "289", "1", "5.880000000000", "74"),("99028", "2", "1000", "15", "1", "30.850000000000", "75"),("125363", "2", "1000", "289", "1", "4.200000000000", "76"),("125009", "2", "1000", "289", "1", "5.880000000000", "77"),("66041", "2", "1000", "289", "1", "6.720000000000", "78"),("92384", "2", "1000", "20", "1", "8.120000000000", "79"),("172418", "1", "1000", "224", "1", "6.220000000000", "80"),("231453", "1", "1000", "224", "1", "20.080000000000", "81"),("122209", "1", "1000", "559", "1", "30.170000000000", "82"),("97055", "2", "9", "287", "1", "10.080000000000", "83"),("35367", "2", "9", "289", "1", "8.400000000000", "84"),("224661", "1", "3", "528", "1", "4.200000000000", "85"),("66183", "2", "2", "289", "1", "6.720000000000", "86"),("156293", "1", "1011", "13", "1", "12.610000000000", "87"),("33854", "2", "1002", "19", "1", "12.870000000000", "88"),("187565", "2", "2", "356", "1", "13.450000000000", "89"),("151515", "2", "1005", "285", "1", "10.040000000000", "90"),("89317", "4", "1004", "423", "1", "2.940000000000", "91"),("40280", "2", "1001", "42", "1", "3.360000000000", "92"),("36885", "2", "1001", "206", "1", "32.770000000000", "93"),("39462", "2", "1000", "42", "1", "4.200000000000", "94"),("57052", "2", "1000", "15", "1", "28.320000000000", "95"),("36971", "2", "1000", "206", "1", "18.490000000000", "96"),("21970", "2", "1000", "73", "1", "21.440000000000", "97"),("89292", "2", "1000", "423", "1", "3.780000000000", "98"),("110737", "2", "1000", "11", "1", "9.670000000000", "99"),("144639", "2", "1000", "163", "1", "3.590000000000", "100"),("57074", "2", "1", "15", "1", "18.200000000000", "101"),("227374", "2", "1047", "289", "1", "8.400000000000", "102"),("66173", "2", "1008", "289", "1", "8.400000000000", "103"),("240459", "2", "1008", "20", "1", "3.850000000000", "104"),("131793", "1", "1005", "559", "1", "26.890000000000", "105"),("146411", "2", "1004", "68", "1", "6.390000000000", "106"),("124989", "2", "1000", "289", "1", "6.720000000000", "107"),("224474", "1", "1000", "629", "1", "35.290000000000", "108"),("224476", "1", "1000", "629", "1", "25.210000000000", "109"),("224477", "1", "1000", "629", "1", "25.210000000000", "110"),("224479", "1", "1000", "629", "1", "25.210000000000", "111"),("22321", "2", "1000", "20", "1", "8.270000000000", "112"),("93784", "2", "1000", "20", "1", "7.180000000000", "113"),("199959", "2", "1000", "224", "1", "14.200000000000", "114"),("66012", "2", "8", "289", "1", "6.720000000000", "115"),("121925", "1", "1", "13", "1", "14.450000000000", "116"),("64153", "2", "1002", "15", "1", "15.730000000000", "117"),("226712", "2", "1000", "500", "1", "8.320000000000", "118"),("201795", "1", "1076", "13", "1", "13.360000000000", "119"),("201799", "1", "1070", "13", "1", "15.040000000000", "120"),("201805", "1", "1067", "13", "1", "11.680000000000", "121"),("201811", "1", "1067", "13", "1", "11.680000000000", "122"),("201797", "1", "1062", "13", "1", "14.200000000000", "123"),("201815", "1", "1059", "13", "1", "11.680000000000", "124"),("201819", "1", "1051", "13", "1", "11.680000000000", "125"),("201821", "1", "1046", "13", "1", "12.520000000000", "126"),("45193", "2", "1012", "289", "1", "8.400000000000", "127"),("95705", "2", "1011", "20", "1", "7.360000000000", "128"),("234176", "2", "1010", "68", "1", "7.980000000000", "129"),("200767", "1", "1008", "20", "1", "13.210000000000", "130"),("246022", "1", "1006", "68", "1", "8.070000000000", "131"),("185857", "2", "1004", "20", "1", "7.900000000000", "132"),("47569", "2", "1002", "42", "1", "9.240000000000", "133"),("47573", "2", "1002", "42", "1", "9.240000000000", "134"),("45218", "2", "1002", "289", "1", "6.720000000000", "135"),("47577", "2", "1002", "42", "1", "9.240000000000", "136"),("185853", "2", "1002", "20", "1", "7.900000000000", "137"),("93982", "2", "1001", "20", "1", "6.420000000000", "138"),("205657", "1", "1001", "224", "1", "7.480000000000", "139"),("66053", "2", "1000", "289", "1", "8.400000000000", "140"),("224482", "1", "1000", "629", "1", "25.210000000000", "141"),("42378", "2", "1000", "67", "1", "7.480000000000", "142"),("205255", "2", "1000", "224", "1", "10.840000000000", "143"),("223976", "1", "1000", "224", "1", "14.620000000000", "144"),("124871", "2", "10", "289", "1", "8.400000000000", "145"),("33762", "2", "2", "20", "1", "6.810000000000", "146"),("284", "2", "1", "20", "1", "5.210000000000", "147"),("222866", "1", "1095", "13", "1", "12.610000000000", "148"),("37111", "2", "1000", "206", "1", "8.400000000000", "149"),("92241", "2", "1000", "19", "1", "10.050000000000", "150"),("102603", "1", "176", "435", "1", "5.880000000000", "151"),("21976", "2", "1011", "73", "1", "23.070000000000", "152"),("21969", "2", "1003", "73", "1", "21.440000000000", "153"),("55838", "2", "1001", "109", "1", "4.620000000000", "154"),("12325", "2", "1000", "15", "1", "30.820000000000", "155"),("30732", "2", "1000", "49", "1", "4.540000000000", "156"),("110740", "2", "1000", "11", "1", "12.420000000000", "157"),("60090", "2", "1000", "187", "1", "13.360000000000", "158"),("61276", "2", "1000", "187", "1", "7.900000000000", "159"),("113497", "2", "1000", "24", "1", "6.390000000000", "160"),("63906", "-100", "55", "26", "1", "9.160000000000", "161"),("2135", "2", "48", "12", "1", "3.750000000000", "162"),("56004", "2", "2", "15", "1", "14.270000000000", "163"),("66007", "2", "1004", "289", "1", "8.400000000000", "164"),("185851", "2", "1004", "20", "1", "7.900000000000", "165"),("152577", "2", "1003", "20", "1", "8.660000000000", "166"),("171072", "2", "1000", "289", "1", "1214.290000000000", "167"),("45923", "2", "1000", "289", "1", "6.720000000000", "168"),("22331", "2", "1000", "20", "1", "8.270000000000", "169"),("154775", "1", "1000", "58", "1", "21.010000000000", "170"),("235467", "1", "996", "224", "1", "17.560000000000", "171"),("45981", "2", "2", "289", "1", "6.720000000000", "172"),("66096", "2", "1", "289", "1", "6.720000000000", "173"),("65999", "2", "1002", "289", "1", "5.880000000000", "174"),("222865", "1", "1000", "13", "1", "12.520000000000", "175"),("36757", "2", "1007", "206", "1", "9.240000000000", "176"),("144713", "2", "1007", "285", "1", "10.040000000000", "177"),("10964", "2", "1006", "68", "1", "12.350000000000", "178"),("81631", "2", "1006", "68", "1", "8.660000000000", "179"),("89302", "4", "1006", "423", "1", "3.700000000000", "180"),("100229", "1", "1004", "20", "1", "26.160000000000", "181"),("31502", "2", "1004", "42", "1", "4.620000000000", "182"),("64137", "2", "1003", "15", "1", "9.990000000000", "183"),("56889", "2", "1003", "15", "1", "9.160000000000", "184"),("58309", "2", "1002", "15", "1", "8.750000000000", "185"),("68317", "2", "1002", "73", "1", "27.200000000000", "186"),("56029", "2", "1002", "15", "1", "10.330000000000", "187"),("29566", "2", "1002", "49", "1", "10.420000000000", "188"),("62771", "2", "1002", "187", "1", "8.320000000000", "189"),("11439", "2", "1002", "68", "1", "7.140000000000", "190"),("58230", "2", "1001", "15", "1", "9.160000000000", "191"),("58211", "2", "1001", "15", "1", "8.750000000000", "192"),("68314", "2", "1001", "73", "1", "27.200000000000", "193"),("40177", "2", "1001", "68", "1", "6.890000000000", "194"),("63664", "2", "1001", "109", "1", "12.520000000000", "195"),("16375", "2", "1000", "42", "1", "13.450000000000", "196"),("57931", "2", "1000", "15", "1", "8.400000000000", "197"),("58203", "2", "1000", "15", "1", "8.750000000000", "198"),("58273", "2", "1000", "15", "1", "8.750000000000", "199"),("58280", "2", "1000", "15", "1", "8.610000000000", "200"),("58150", "2", "1000", "15", "1", "6.970000000000", "201"),("58163", "2", "1000", "15", "1", "8.400000000000", "202"),("29815", "2", "1000", "116", "1", "7.980000000000", "203"),("29767", "2", "1000", "116", "1", "7.980000000000", "204"),("32791", "2", "1000", "116", "1", "7.980000000000", "205"),("31995", "2", "1000", "116", "1", "7.980000000000", "206"),("33348", "2", "1000", "116", "1", "7.980000000000", "207"),("33364", "2", "1000", "116", "1", "7.980000000000", "208"),("37412", "2", "1000", "206", "1", "11.760000000000", "209"),("240044", "2", "1000", "206", "1", "16.810000000000", "210"),("240045", "2", "1000", "206", "1", "16.810000000000", "211"),("240046", "2", "1000", "206", "1", "16.810000000000", "212"),("240047", "2", "1000", "206", "1", "16.810000000000", "213"),("240048", "2", "1000", "206", "1", "16.810000000000", "214"),("240049", "2", "1000", "206", "1", "16.810000000000", "215"),("68320", "2", "1000", "73", "1", "25.340000000000", "216"),("36781", "2", "1000", "206", "1", "9.240000000000", "217"),("27759", "2", "1000", "49", "1", "7.230000000000", "218"),("29622", "2", "1000", "49", "1", "20.080000000000", "219"),("30675", "2", "1000", "49", "1", "10.000000000000", "220"),("84896", "2", "1000", "75", "1", "5.550000000000", "221"),("65696", "2", "1000", "19", "1", "28.700000000000", "222"),("168731", "1", "1000", "224", "1", "5.380000000000", "223"),("240050", "2", "1000", "206", "1", "16.810000000000", "224"),("52761", "-100", "63", "26", "1", "6.640000000000", "225"),("176444", "2", "26", "20", "1", "7.590000000000", "226"),("152797", "1", "11", "59", "1", "12.430000000000", "227"),("152827", "1", "5", "59", "1", "12.430000000000", "228"),("58181", "2", "4", "15", "1", "6.110000000000", "229"),("152789", "1", "4", "59", "1", "12.430000000000", "230"),("86490", "2", "3", "469", "1", "4.960000000000", "231"),("37408", "2", "2", "206", "1", "13.030000000000", "232"),("97070", "2", "1", "98", "1", "10.800000000000", "233"),("152819", "1", "1", "59", "1", "12.430000000000", "234"),("131891", "2", "1", "67", "1", "4.630000000000", "235"),("60127", "2", "1", "292", "1", "9.240000000000", "236"),("181483", "1", "1005", "13", "1", "16.720000000000", "237"),("212149", "1", "1002", "224", "1", "24.370000000000", "238"),("212159", "1", "1001", "224", "1", "17.560000000000", "239"),("169965", "2", "1000", "224", "1", "11.680000000000", "240"),("181473", "1", "1000", "13", "1", "17.560000000000", "241"),("45991", "2", "14", "289", "1", "8.400000000000", "242"),("45908", "2", "3", "289", "1", "6.720000000000", "243"),("121939", "1", "1021", "13", "1", "15.880000000000", "244"),("50674", "2", "1000", "42", "1", "10.920000000000", "245"),("45934", "2", "1001", "289", "1", "4.200000000000", "246"),("103204", "2", "1000", "119", "1", "7.980000000000", "247"),("45888", "2", "1000", "289", "1", "6.720000000000", "248"),("9266", "2", "11", "145", "1", "11.340000000000", "249"),("132753", "1", "1012", "357", "1", "9.450000000000", "250"),("177673", "2", "1010", "368", "1", "10.180000000000", "251"),("92575", "2", "1009", "73", "1", "21.440000000000", "252"),("9617", "2", "1008", "73", "1", "27.200000000000", "253"),("11730", "2", "1008", "19", "1", "12.180000000000", "254"),("143375", "2", "1007", "73", "1", "27.210000000000", "255"),("25383", "2", "1006", "73", "1", "27.200000000000", "256"),("9591", "2", "1006", "73", "1", "27.200000000000", "257"),("58299", "2", "1005", "15", "1", "8.610000000000", "258"),("228475", "1", "1005", "73", "1", "27.200000000000", "259"),("58056", "2", "1004", "15", "1", "8.400000000000", "260"),("58256", "2", "1003", "15", "1", "9.990000000000", "261"),("100330", "1", "1003", "73", "1", "15.530000000000", "262"),("25381", "2", "1003", "73", "1", "27.200000000000", "263"),("145095", "2", "1002", "19", "1", "49.480000000000", "264"),("40126", "2", "1002", "68", "1", "7.230000000000", "265"),("58063", "2", "1001", "15", "1", "8.400000000000", "266"),("203223", "1", "1001", "559", "1", "29.410000000000", "267"),("68319", "2", "1001", "73", "1", "27.200000000000", "268"),("12397", "2", "1001", "204", "1", "20.170000000000", "269"),("57968", "2", "1001", "15", "1", "15.680000000000", "270"),("27081", "2", "1001", "49", "1", "7.060000000000", "271"),("29716", "2", "1001", "49", "1", "16.720000000000", "272"),("72026", "2", "1001", "24", "1", "8.320000000000", "273"),("96090", "2", "1001", "187", "1", "10.000000000000", "274"),("114828", "2", "1001", "187", "1", "6.220000000000", "275"),("16737", "2", "1000", "42", "1", "13.030000000000", "276"),("39965", "2", "1000", "42", "1", "4.200000000000", "277"),("57961", "2", "1000", "15", "1", "10.820000000000", "278"),("57899", "2", "1000", "15", "1", "6.970000000000", "279"),("58267", "2", "1000", "15", "1", "8.610000000000", "280"),("29782", "2", "1000", "116", "1", "7.980000000000", "281"),("37793", "2", "1000", "116", "1", "17.650000000000", "282"),("41036", "2", "1000", "116", "1", "17.650000000000", "283"),("41078", "2", "1000", "116", "1", "17.650000000000", "284"),("64142", "2", "1000", "15", "1", "8.750000000000", "285"),("64127", "2", "1000", "15", "1", "8.740000000000", "286"),("16738", "2", "1000", "42", "1", "13.450000000000", "287"),("89270", "2", "1000", "423", "1", "3.950000000000", "288"),("16736", "2", "1000", "42", "1", "12.610000000000", "289"),("16463", "2", "1000", "42", "1", "9.660000000000", "290"),("64717", "2", "1000", "206", "1", "24.370000000000", "291"),("37485", "2", "1000", "204", "1", "18.490000000000", "292"),("25386", "2", "1000", "73", "1", "27.200000000000", "293"),("22308", "2", "1000", "163", "1", "4.690000000000", "294"),("26784", "2", "1000", "75", "1", "11.090000000000", "295"),("29571", "2", "1000", "49", "1", "12.940000000000", "296"),("29646", "2", "1000", "49", "1", "18.400000000000", "297"),("29671", "2", "1000", "49", "1", "20.080000000000", "298"),("29681", "2", "1000", "49", "1", "20.080000000000", "299"),("29693", "2", "1000", "49", "1", "20.080000000000", "300"),("29706", "2", "1000", "49", "1", "20.080000000000", "301"),("29830", "2", "1000", "49", "1", "16.720000000000", "302"),("29844", "2", "1000", "49", "1", "15.040000000000", "303"),("29934", "2", "1000", "49", "1", "12.520000000000", "304"),("38360", "2", "1000", "49", "1", "9.920000000000", "305"),("85162", "2", "1000", "75", "1", "13.360000000000", "306"),("92769", "2", "1000", "20", "1", "26.920000000000", "307"),("95635", "2", "1000", "20", "1", "26.920000000000", "308"),("9505", "2", "1000", "19", "1", "18.040000000000", "309"),("110746", "2", "1000", "11", "1", "12.530000000000", "310"),("95958", "2", "1000", "410", "1", "8.320000000000", "311"),("113430", "2", "1000", "410", "1", "8.240000000000", "312"),("163122", "1", "1000", "506", "1", "24.290000000000", "313"),("167974", "1", "1000", "506", "1", "30.170000000000", "314"),("200133", "1", "1000", "224", "1", "15.460000000000", "315"),("177697", "2", "1000", "368", "1", "10.180000000000", "316"),("203131", "1", "1000", "559", "1", "19.240000000000", "317"),("203145", "1", "1000", "559", "1", "27.650000000000", "318"),("86604", "2", "36", "469", "1", "5.800000000000", "319"),("86606", "2", "17", "469", "1", "6.640000000000", "320"),("86610", "2", "14", "469", "1", "5.800000000000", "321"),("127681", "2", "12", "73", "1", "19.490000000000", "322"),("152773", "1", "11", "59", "1", "12.430000000000", "323"),("86592", "2", "11", "469", "1", "4.960000000000", "324"),("12396", "2", "4", "204", "1", "12.520000000000", "325"),("152805", "1", "4", "59", "1", "12.430000000000", "326"),("86590", "2", "4", "469", "1", "5.800000000000", "327"),("152813", "1", "3", "59", "1", "12.430000000000", "328"),("53289", "2", "2", "115", "1", "4.200000000000", "329"),("86504", "2", "1", "469", "1", "3.360000000000", "330"),("60856", "2", "1", "24", "1", "7.480000000000", "331"),("163855", "1", "1005", "13", "1", "11.680000000000", "332"),("212145", "1", "1004", "224", "1", "22.610000000000", "333"),("163852", "1", "1004", "13", "1", "11.680000000000", "334"),("45970", "2", "1000", "289", "1", "8.400000000000", "335"),("133245", "2", "1", "289", "1", "8.400000000000", "336"),("9494", "2", "1002", "19", "1", "14.530000000000", "337"),("64447", "2", "12", "103", "1", "16.510000000000", "338"),("64445", "2", "6", "103", "1", "16.510000000000", "339"),("64446", "2", "4", "103", "1", "15.000000000000", "340"),("121933", "1", "1", "13", "1", "15.040000000000", "341"),("237348", "2", "1000", "20", "1", "6.420000000000", "342"),("119484", "2", "1033", "168", "1", "15.840000000000", "343"),("176447", "2", "1024", "20", "1", "7.590000000000", "344"),("119480", "2", "1024", "168", "1", "15.840000000000", "345"),("2866", "2", "1016", "73", "1", "27.200000000000", "346"),("56980", "2", "1013", "15", "1", "9.440000000000", "347"),("57019", "2", "1013", "68", "1", "18.490000000000", "348"),("2863", "2", "1009", "73", "1", "27.200000000000", "349"),("96731", "2", "1009", "30", "1", "8.400000000000", "350"),("49581", "2", "1008", "73", "1", "12.850000000000", "351"),("35240", "2", "1008", "68", "1", "11.180000000000", "352"),("99037", "2", "1007", "15", "1", "9.160000000000", "353"),("56902", "2", "1006", "15", "1", "11.380000000000", "354"),("35246", "2", "1006", "68", "1", "6.470000000000", "355"),("39221", "2", "1005", "42", "1", "3.360000000000", "356"),("238862", "2", "1005", "356", "1", "15.970000000000", "357"),("56904", "2", "1005", "15", "1", "11.380000000000", "358"),("95980", "2", "1005", "410", "1", "7.480000000000", "359"),("96100", "2", "1005", "24", "1", "8.320000000000", "360"),("63284", "2", "1005", "187", "1", "10.000000000000", "361"),("40147", "2", "1005", "68", "1", "10.080000000000", "362"),("112136", "1", "1004", "559", "1", "8.990000000000", "363"),("89282", "2", "1003", "423", "1", "5.040000000000", "364"),("56920", "2", "1003", "15", "1", "12.500000000000", "365"),("117929", "2", "1003", "58", "1", "9.240000000000", "366"),("56881", "2", "1003", "15", "1", "9.160000000000", "367"),("39227", "2", "1002", "42", "1", "2.940000000000", "368"),("56932", "2", "1002", "15", "1", "15.760000000000", "369"),("26229", "2", "1002", "75", "1", "11.260000000000", "370"),("84900", "2", "1002", "75", "1", "5.380000000000", "371"),("60853", "2", "1002", "24", "1", "7.480000000000", "372"),("62951", "2", "1002", "187", "1", "13.360000000000", "373"),("117926", "2", "1002", "58", "1", "6.720000000000", "374"),("40698", "2", "1001", "42", "1", "3.780000000000", "375"),("39346", "2", "1001", "42", "1", "2.940000000000", "376"),("99044", "2", "1001", "15", "1", "8.610000000000", "377"),("89285", "2", "1001", "423", "1", "4.790000000000", "378"),("50382", "2", "1001", "42", "1", "5.880000000000", "379"),("96038", "2", "1001", "187", "1", "7.900000000000", "380"),("63288", "2", "1001", "187", "1", "7.480000000000", "381"),("88229", "2", "1001", "68", "1", "17.230000000000", "382"),("39418", "2", "1000", "42", "1", "3.360000000000", "383"),("39928", "2", "1000", "42", "1", "4.620000000000", "384"),("39240", "2", "1000", "42", "1", "2.940000000000", "385"),("39246", "2", "1000", "42", "1", "3.360000000000", "386"),("39552", "2", "1000", "42", "1", "2.270000000000", "387"),("39581", "2", "1000", "42", "1", "2.940000000000", "388"),("39337", "2", "1000", "42", "1", "2.940000000000", "389"),("32744", "2", "1000", "116", "1", "7.980000000000", "390"),("32747", "2", "1000", "116", "1", "7.980000000000", "391"),("32748", "2", "1000", "116", "1", "7.980000000000", "392"),("33381", "2", "1000", "116", "1", "18.490000000000", "393"),("35196", "2", "1000", "15", "1", "15.680000000000", "394"),("226058", "1", "1000", "370", "1", "9.870000000000", "395"),("90397", "2", "1000", "503", "1", "19.330000000000", "396"),("39412", "2", "1000", "42", "1", "2.690000000000", "397"),("146079", "2", "1000", "73", "1", "25.090000000000", "398"),("215131", "2", "1000", "204", "1", "7.560000000000", "399"),("242872", "1", "1000", "73", "1", "29.370000000000", "400"),("99066", "2", "1000", "15", "1", "8.750000000000", "401"),("27370", "2", "1000", "49", "1", "10.000000000000", "402"),("29458", "2", "1000", "49", "1", "11.680000000000", "403"),("29551", "2", "1000", "49", "1", "16.720000000000", "404"),("29629", "2", "1000", "49", "1", "20.080000000000", "405"),("29638", "2", "1000", "49", "1", "16.720000000000", "406"),("36733", "2", "1000", "19", "1", "23.070000000000", "407"),("106446", "1", "1000", "49", "1", "18.400000000000", "408"),("106474", "1", "1000", "49", "1", "15.880000000000", "409"),("106550", "1", "1000", "50", "1", "26.810000000000", "410"),("110749", "2", "1000", "11", "1", "16.820000000000", "411"),("226601", "1", "1000", "459", "1", "50.340000000000", "412"),("95963", "2", "1000", "410", "1", "9.160000000000", "413"),("96089", "2", "1000", "187", "1", "10.000000000000", "414"),("61070", "2", "1000", "410", "1", "8.740000000000", "415"),("61081", "2", "1000", "410", "1", "9.160000000000", "416"),("62775", "2", "1000", "187", "1", "7.480000000000", "417"),("63286", "2", "1000", "187", "1", "10.000000000000", "418"),("163126", "1", "1000", "506", "1", "24.290000000000", "419"),("214345", "2", "1000", "13", "1", "7.480000000000", "420"),("169690", "1", "1000", "559", "1", "29.330000000000", "421"),("184805", "2", "1000", "559", "1", "19.240000000000", "422"),("242596", "1", "1000", "368", "1", "91.480000000000", "423"),("242570", "1", "1000", "368", "1", "91.480000000000", "424"),("36703", "2", "999", "73", "1", "27.200000000000", "425"),("125177", "-100", "47", "26", "1", "9.160000000000", "426"),("90095", "2", "46", "59", "1", "12.580000000000", "427"),("132929", "-100", "37", "26", "1", "8.320000000000", "428"),("4461", "2", "21", "96", "1", "4.620000000000", "429"),("90097", "2", "10", "59", "1", "22.690000000000", "430"),("87242", "2", "9", "354", "1", "9.160000000000", "431"),("87243", "2", "9", "354", "1", "8.320000000000", "432"),("151299", "1", "7", "121", "1", "15.970000000000", "433"),("1914", "2", "6", "12", "1", "5.170000000000", "434"),("131765", "1", "6", "559", "1", "7.480000000000", "435"),("64136", "2", "6", "15", "1", "4.390000000000", "436"),("61521", "2", "5", "24", "1", "7.480000000000", "437"),("94173", "2", "4", "58", "1", "9.160000000000", "438"),("131747", "1", "4", "559", "1", "8.320000000000", "439"),("79327", "2", "3", "327", "1", "11.180000000000", "440"),("60857", "2", "3", "24", "1", "8.320000000000", "441"),("16794", "2", "2", "42", "1", "14.290000000000", "442"),("118866", "2", "2", "19", "1", "12.120000000000", "443"),("95974", "2", "2", "410", "1", "8.320000000000", "444"),("93656", "2", "2", "20", "1", "10.920000000000", "445"),("52093", "2", "1", "116", "1", "4.120000000000", "446"),("106461", "1", "1", "49", "1", "20.080000000000", "447"),("72025", "2", "1", "24", "1", "8.320000000000", "448"),("49166", "2", "1", "352", "1", "21.470000000000", "449"),("458", "2", "1", "15", "1", "6.110000000000", "450"),("163862", "1", "1008", "13", "1", "11.680000000000", "451"),("163888", "1", "1007", "13", "1", "10.840000000000", "452"),("163885", "1", "1006", "13", "1", "10.840000000000", "453"),("163858", "1", "1005", "13", "1", "11.680000000000", "454"),("163878", "1", "1003", "13", "1", "10.840000000000", "455"),("163882", "1", "1002", "13", "1", "11.680000000000", "456"),("163895", "1", "1002", "13", "1", "11.680000000000", "457"),("163871", "1", "1001", "13", "1", "11.680000000000", "458"),("163891", "1", "1000", "13", "1", "12.520000000000", "459"),("114576", "2", "8", "493", "1", "4.620000000000", "460"),("114581", "2", "2", "493", "1", "3.080000000000", "461"),("146863", "1", "1034", "13", "1", "13.030000000000", "462"),("144235", "2", "1062", "160", "1", "11.680000000000", "463"),("119476", "2", "1031", "168", "1", "15.840000000000", "464"),("244797", "1", "1027", "163", "1", "8.030000000000", "465"),("25392", "2", "1021", "73", "1", "27.200000000000", "466"),("214615", "1", "1017", "13", "1", "12.520000000000", "467"),("145765", "2", "1017", "437", "1", "6.300000000000", "468"),("32844", "2", "1016", "73", "1", "14.370000000000", "469"),("145767", "2", "1015", "437", "1", "6.050000000000", "470"),("91095", "2", "1015", "73", "1", "27.200000000000", "471"),("229452", "2", "1014", "100", "1", "8.820000000000", "472"),("166359", "1", "1012", "559", "1", "9.660000000000", "473"),("100662", "1", "1012", "73", "1", "14.370000000000", "474"),("229446", "2", "1012", "100", "1", "8.820000000000", "475"),("93965", "2", "1011", "73", "1", "36.940000000000", "476"),("100663", "1", "1010", "73", "1", "14.370000000000", "477"),("127249", "1", "1010", "73", "1", "14.760000000000", "478"),("10959", "2", "1009", "68", "1", "8.320000000000", "479"),("161799", "1", "1008", "559", "1", "11.760000000000", "480"),("95964", "2", "1008", "410", "1", "8.320000000000", "481"),("67152", "2", "1008", "68", "1", "6.720000000000", "482"),("112566", "2", "1008", "160", "1", "11.680000000000", "483"),("229538", "2", "1008", "100", "1", "8.820000000000", "484"),("10960", "2", "1007", "68", "1", "8.320000000000", "485"),("25586", "2", "1007", "73", "1", "27.200000000000", "486"),("35203", "2", "1005", "15", "1", "9.030000000000", "487"),("214631", "1", "1005", "13", "1", "12.520000000000", "488"),("61374", "2", "1005", "24", "1", "7.480000000000", "489"),("61398", "2", "1005", "24", "1", "7.480000000000", "490"),("63293", "2", "1005", "187", "1", "9.160000000000", "491"),("93270", "2", "1005", "68", "1", "12.270000000000", "492"),("94180", "2", "1005", "58", "1", "8.320000000000", "493"),("166617", "1", "1005", "30", "1", "9.160000000000", "494"),("93276", "2", "1005", "68", "1", "12.350000000000", "495"),("25362", "2", "1004", "19", "1", "19.000000000000", "496"),("48347", "2", "1004", "67", "1", "19.330000000000", "497"),("240543", "1", "1004", "782", "1", "3.360000000000", "498"),("56931", "2", "1004", "15", "1", "15.270000000000", "499"),("77998", "2", "1004", "73", "1", "36.940000000000", "500"),("56973", "2", "1003", "15", "1", "9.030000000000", "501"),("89297", "2", "1003", "423", "1", "4.870000000000", "502"),("26293", "2", "1003", "75", "1", "2.520000000000", "503"),("91105", "2", "1003", "19", "1", "13.570000000000", "504"),("26335", "2", "1003", "75", "1", "2.860000000000", "505"),("178939", "2", "1002", "204", "1", "4.370000000000", "506"),("113875", "2", "1002", "24", "1", "7.560000000000", "507"),("5818", "2", "1002", "42", "1", "15.130000000000", "508"),("61331", "2", "1002", "24", "1", "7.480000000000", "509"),("61383", "2", "1002", "24", "1", "7.480000000000", "510"),("86565", "2", "1002", "71", "1", "13.280000000000", "511"),("108305", "1", "1002", "58", "1", "17.560000000000", "512"),("17572", "2", "1001", "42", "1", "17.650000000000", "513"),("39558", "2", "1001", "42", "1", "3.360000000000", "514"),("65626", "2", "1001", "42", "1", "2.940000000000", "515"),("50881", "2", "1001", "42", "1", "17.650000000000", "516"),("17571", "2", "1001", "42", "1", "17.650000000000", "517"),("132049", "1", "1001", "49", "1", "15.460000000000", "518"),("145043", "2", "1001", "19", "1", "13.620000000000", "519"),("96117", "2", "1001", "24", "1", "8.740000000000", "520"),("61416", "2", "1001", "24", "1", "7.480000000000", "521"),("93298", "2", "1001", "68", "1", "12.350000000000", "522"),("17567", "2", "1000", "42", "1", "17.650000000000", "523"),("17568", "2", "1000", "42", "1", "17.650000000000", "524"),("17569", "2", "1000", "42", "1", "17.650000000000", "525"),("17570", "2", "1000", "42", "1", "17.650000000000", "526"),("17391", "2", "1000", "42", "1", "7.560000000000", "527"),("40551", "2", "1000", "42", "1", "2.940000000000", "528"),("57600", "2", "1000", "15", "1", "22.210000000000", "529"),("58223", "2", "1000", "15", "1", "8.750000000000", "530"),("58248", "2", "1000", "15", "1", "8.610000000000", "531"),("56930", "2", "1000", "15", "1", "15.270000000000", "532"),("56967", "2", "1000", "15", "1", "9.440000000000", "533"),("50880", "2", "1000", "42", "1", "17.650000000000", "534"),("50479", "2", "1000", "42", "1", "20.170000000000", "535"),("50480", "2", "1000", "42", "1", "21.010000000000", "536"),("53632", "2", "1000", "382", "1", "35.290000000000", "537"),("159485", "2", "1000", "49", "1", "32.940000000000", "538"),("209025", "1", "1000", "476", "1", "22.230000000000", "539"),("222685", "1", "1000", "370", "1", "6.470000000000", "540"),("227352", "1", "1000", "54", "1", "127.730000000000", "541"),("203477", "1", "1000", "19", "1", "11.340000000000", "542"),("201127", "2", "1000", "540", "1", "10.760000000000", "543"),("57580", "2", "1000", "15", "1", "22.210000000000", "544"),("237309", "1", "1000", "19", "1", "12.770000000000", "545"),("237327", "1", "1000", "19", "1", "12.770000000000", "546"),("237339", "1", "1000", "19", "1", "10.500000000000", "547"),("226698", "2", "1000", "73", "1", "27.200000000000", "548"),("206271", "1", "1000", "160", "1", "11.640000000000", "549"),("39209", "2", "1000", "42", "1", "2.940000000000", "550"),("17566", "2", "1000", "42", "1", "17.650000000000", "551"),("131029", "2", "1000", "206", "1", "7.560000000000", "552"),("145015", "2", "1000", "73", "1", "36.940000000000", "553"),("228525", "2", "1000", "19", "1", "11.430000000000", "554"),("229454", "2", "1000", "100", "1", "8.820000000000", "555"),("39850", "2", "1000", "42", "1", "10.920000000000", "556"),("240938", "2", "1000", "73", "1", "39.870000000000", "557"),("25712", "2", "1000", "19", "1", "16.240000000000", "558"),("26311", "2", "1000", "75", "1", "5.380000000000", "559"),("27135", "2", "1000", "49", "1", "9.160000000000", "560"),("29451", "2", "1000", "49", "1", "13.360000000000", "561"),("29465", "2", "1000", "49", "1", "12.100000000000", "562"),("29544", "2", "1000", "49", "1", "13.360000000000", "563"),("29557", "2", "1000", "49", "1", "18.400000000000", "564"),("30742", "2", "1000", "49", "1", "10.840000000000", "565"),("30746", "2", "1000", "49", "1", "8.740000000000", "566"),("33856", "2", "1000", "19", "1", "19.760000000000", "567"),("156247", "2", "1000", "629", "1", "12.520000000000", "568"),("226594", "1", "1000", "459", "1", "50.340000000000", "569"),("96093", "2", "1000", "187", "1", "10.000000000000", "570"),("96096", "2", "1000", "187", "1", "9.160000000000", "571"),("96132", "2", "1000", "24", "1", "8.740000000000", "572"),("114815", "2", "1000", "187", "1", "8.320000000000", "573"),("59907", "2", "1000", "190", "1", "41.090000000000", "574"),("61425", "2", "1000", "24", "1", "7.480000000000", "575"),("63315", "2", "1000", "24", "1", "7.480000000000", "576"),("113458", "2", "1000", "187", "1", "10.000000000000", "577"),("163133", "1", "1000", "506", "1", "30.170000000000", "578"),("163591", "1", "1000", "506", "1", "28.490000000000", "579"),("165852", "1", "1000", "506", "1", "28.490000000000", "580"),("42369", "2", "1000", "67", "1", "4.370000000000", "581"),("42372", "2", "1000", "67", "1", "5.380000000000", "582"),("48348", "2", "1000", "67", "1", "20.590000000000", "583"),("170151", "1", "1000", "224", "1", "5.800000000000", "584"),("108342", "1", "1000", "58", "1", "17.560000000000", "585"),("173989", "2", "1000", "559", "1", "21.760000000000", "586"),("170050", "1", "1000", "559", "1", "33.530000000000", "587"),("184773", "1", "1000", "559", "1", "19.240000000000", "588"),("242466", "2", "1000", "559", "1", "30.170000000000", "589"),("17574", "2", "999", "42", "1", "17.650000000000", "590"),("25580", "2", "998", "73", "1", "27.200000000000", "591"),("85331", "-100", "79", "26", "1", "13.360000000000", "592"),("85327", "1", "74", "26", "1", "13.360000000000", "593"),("70118", "1", "32", "26", "1", "9.160000000000", "594"),("72049", "2", "9", "145", "1", "24.290000000000", "595"),("131779", "1", "8", "559", "1", "7.480000000000", "596"),("503", "2", "6", "15", "1", "6.640000000000", "597"),("96494", "2", "5", "98", "1", "6.720000000000", "598"),("61498", "2", "4", "24", "1", "7.480000000000", "599"),("112142", "1", "4", "559", "1", "6.640000000000", "600"),("107579", "-100", "3", "26", "1", "13.360000000000", "601"),("230618", "2", "3", "528", "1", "5.880000000000", "602"),("131681", "2", "3", "559", "1", "16.720000000000", "603"),("5816", "2", "2", "42", "1", "14.710000000000", "604"),("27088", "2", "2", "49", "1", "3.950000000000", "605"),("25601", "2", "2", "19", "1", "13.620000000000", "606"),("39958", "2", "1", "42", "1", "4.540000000000", "607"),("141099", "1", "1", "228", "1", "18.720000000000", "608"),("61380", "2", "1", "24", "1", "8.320000000000", "609"),("63334", "2", "1", "24", "1", "7.480000000000", "610"),("131773", "1", "1", "559", "1", "7.480000000000", "611"),("56986", "2", "1", "15", "1", "6.640000000000", "612"),("114561", "2", "2", "493", "1", "4.620000000000", "613"),("108438", "1", "1025", "58", "1", "12.610000000000", "614"),("214649", "1", "1019", "13", "1", "12.520000000000", "615"),("25721", "2", "1019", "19", "1", "13.870000000000", "616"),("49576", "2", "1015", "73", "1", "27.920000000000", "617"),("49579", "2", "1014", "73", "1", "27.640000000000", "618"),("94619", "2", "1014", "20", "1", "7.130000000000", "619"),("127685", "2", "1012", "73", "1", "36.940000000000", "620"),("56956", "2", "1010", "15", "1", "15.760000000000", "621"),("226218", "1", "1010", "370", "1", "11.570000000000", "622"),("104917", "2", "1010", "58", "1", "6.640000000000", "623"),("93722", "2", "1009", "20", "1", "4.970000000000", "624"),("117512", "2", "1009", "19", "1", "9.400000000000", "625"),("63000", "2", "1008", "187", "1", "6.300000000000", "626"),("214591", "1", "1008", "13", "1", "12.520000000000", "627"),("105016", "2", "1008", "58", "1", "5.800000000000", "628"),("229440", "2", "1008", "100", "1", "8.820000000000", "629"),("169218", "1", "1007", "54", "1", "23.530000000000", "630"),("39255", "2", "1007", "42", "1", "2.940000000000", "631"),("166613", "1", "1007", "30", "1", "8.400000000000", "632"),("237015", "1", "1007", "357", "1", "5.250000000000", "633"),("39234", "2", "1006", "42", "1", "2.940000000000", "634"),("115360", "2", "1006", "73", "1", "25.740000000000", "635"),("145013", "2", "1006", "73", "1", "36.940000000000", "636"),("35217", "2", "1006", "15", "1", "15.270000000000", "637"),("237087", "1", "1006", "559", "1", "24.370000000000", "638"),("61349", "2", "1006", "24", "1", "8.320000000000", "639"),("42718", "2", "1006", "67", "1", "6.720000000000", "640"),("112131", "1", "1006", "559", "1", "10.000000000000", "641"),("196825", "2", "1006", "168", "1", "27.190000000000", "642"),("39357", "2", "1005", "42", "1", "3.950000000000", "643"),("209033", "1", "1005", "476", "1", "22.230000000000", "644"),("17600", "2", "1005", "42", "1", "9.240000000000", "645"),("235369", "1", "1005", "389", "1", "13.980000000000", "646"),("29446", "2", "1005", "49", "1", "12.100000000000", "647"),("42617", "2", "1005", "67", "1", "4.540000000000", "648"),("163955", "1", "1005", "160", "1", "11.680000000000", "649"),("237181", "1", "1004", "357", "1", "6.300000000000", "650"),("212373", "1", "1004", "559", "1", "13.030000000000", "651"),("25705", "2", "1004", "19", "1", "13.770000000000", "652"),("56524", "2", "1004", "15", "1", "17.080000000000", "653"),("66101", "2", "1004", "19", "1", "8.080000000000", "654"),("63930", "2", "1003", "204", "1", "17.650000000000", "655"),("7530", "2", "1003", "15", "1", "15.270000000000", "656"),("231982", "1", "1003", "19", "1", "14.290000000000", "657"),("62781", "2", "1003", "24", "1", "7.480000000000", "658"),("113508", "2", "1003", "24", "1", "11.260000000000", "659"),("166650", "1", "1003", "30", "1", "9.160000000000", "660"),("179008", "1", "1003", "423", "1", "8.910000000000", "661"),("122537", "1", "1002", "42", "1", "7.980000000000", "662"),("39370", "2", "1002", "42", "1", "3.360000000000", "663"),("151795", "2", "1002", "19", "1", "15.280000000000", "664"),("63311", "2", "1002", "24", "1", "9.160000000000", "665"),("166655", "1", "1002", "30", "1", "9.160000000000", "666"),("104615", "1", "1002", "58", "1", "15.040000000000", "667"),("104845", "2", "1002", "58", "1", "14.200000000000", "668"),("17448", "2", "1001", "42", "1", "9.660000000000", "669"),("17339", "2", "1001", "42", "1", "6.300000000000", "670"),("89934", "2", "1001", "71", "1", "9.920000000000", "671"),("175448", "1", "1001", "206", "1", "37.820000000000", "672"),("26317", "2", "1001", "75", "1", "5.380000000000", "673"),("29264", "2", "1001", "49", "1", "4.870000000000", "674"),("104986", "2", "1001", "58", "1", "9.160000000000", "675"),("108285", "1", "1001", "58", "1", "16.720000000000", "676"),("112100", "1", "1001", "559", "1", "8.320000000000", "677"),("105046", "2", "1001", "58", "1", "8.320000000000", "678"),("17445", "2", "1000", "42", "1", "9.660000000000", "679"),("17447", "2", "1000", "42", "1", "9.660000000000", "680"),("17449", "2", "1000", "42", "1", "9.660000000000", "681"),("17450", "2", "1000", "42", "1", "9.660000000000", "682"),("17451", "2", "1000", "42", "1", "9.660000000000", "683"),("17508", "2", "1000", "42", "1", "23.530000000000", "684"),("39677", "2", "1000", "42", "1", "6.720000000000", "685"),("39379", "2", "1000", "42", "1", "3.360000000000", "686"),("53647", "2", "1000", "382", "1", "42.860000000000", "687"),("53671", "2", "1000", "382", "1", "55.040000000000", "688"),("53559", "2", "1000", "382", "1", "23.110000000000", "689"),("64174", "2", "1000", "15", "1", "11.380000000000", "690"),("117479", "2", "1000", "19", "1", "12.440000000000", "691"),("168308", "2", "1000", "356", "1", "14.290000000000", "692"),("215563", "2", "1000", "476", "1", "19.290000000000", "693"),("209057", "1", "1000", "476", "1", "22.230000000000", "694"),("226224", "1", "1000", "370", "1", "11.570000000000", "695"),("227333", "1", "1000", "370", "1", "9.920000000000", "696"),("209847", "1", "1000", "476", "1", "22.230000000000", "697"),("209869", "1", "1000", "476", "1", "22.230000000000", "698"),("210863", "1", "1000", "476", "1", "22.230000000000", "699"),("210951", "1", "1000", "476", "1", "22.230000000000", "700"),("135747", "2", "1000", "193", "1", "12.180000000000", "701"),("168035", "1", "1000", "19", "1", "14.200000000000", "702"),("203925", "2", "1000", "19", "1", "15.970000000000", "703"),("202025", "1", "1000", "19", "1", "16.220000000000", "704"),("202233", "1", "1000", "19", "1", "15.130000000000", "705"),("137063", "2", "1000", "19", "1", "14.030000000000", "706"),("137071", "2", "1000", "19", "1", "11.850000000000", "707"),("202249", "1", "1000", "19", "1", "15.290000000000", "708"),("39389", "2", "1000", "42", "1", "2.690000000000", "709"),("237137", "2", "1000", "193", "1", "12.610000000000", "710"),("237138", "2", "1000", "193", "1", "12.610000000000", "711"),("237312", "1", "1000", "19", "1", "12.100000000000", "712"),("240098", "1", "1000", "54", "1", "23.530000000000", "713"),("17583", "2", "1000", "42", "1", "10.920000000000", "714"),("240610", "2", "1000", "73", "1", "15.920000000000", "715"),("240995", "1", "1000", "15", "1", "12.600000000000", "716"),("241756", "2", "1000", "15", "1", "17.280000000000", "717"),("179032", "1", "1000", "423", "1", "9.080000000000", "718"),("25757", "2", "1000", "19", "1", "13.920000000000", "719"),("27654", "2", "1000", "49", "1", "5.800000000000", "720"),("29330", "2", "1000", "49", "1", "4.870000000000", "721"),("29427", "2", "1000", "49", "1", "16.720000000000", "722"),("29435", "2", "1000", "49", "1", "10.420000000000", "723"),("30693", "2", "1000", "49", "1", "13.110000000000", "724"),("32716", "2", "1000", "50", "1", "23.450000000000", "725"),("49777", "2", "1000", "19", "1", "11.110000000000", "726"),("68073", "2", "1000", "19", "1", "19.760000000000", "727"),("106489", "1", "1000", "49", "1", "20.920000000000", "728"),("117486", "2", "1000", "19", "1", "13.620000000000", "729"),("145085", "2", "1000", "19", "1", "11.110000000000", "730"),("207895", "1", "1000", "19", "1", "18.620000000000", "731"),("225427", "1", "1000", "19", "1", "17.450000000000", "732"),("96009", "2", "1000", "410", "1", "18.400000000000", "733"),("229396", "1", "1000", "49", "1", "16.720000000000", "734"),("61483", "2", "1000", "24", "1", "7.480000000000", "735"),("63272", "2", "1000", "410", "1", "5.800000000000", "736"),("86562", "2", "1000", "71", "1", "11.340000000000", "737"),("200283", "2", "1000", "224", "1", "9.160000000000", "738"),("200307", "1", "1000", "224", "1", "7.900000000000", "739"),("174513", "1", "1000", "224", "1", "6.640000000000", "740"),("174527", "1", "1000", "224", "1", "6.220000000000", "741"),("174532", "1", "1000", "224", "1", "6.220000000000", "742"),("174558", "1", "1000", "224", "1", "6.220000000000", "743"),("231475", "2", "1000", "224", "1", "6.220000000000", "744"),("104635", "2", "1000", "58", "1", "15.040000000000", "745"),("104930", "2", "1000", "58", "1", "6.640000000000", "746"),("104999", "2", "1000", "58", "1", "8.320000000000", "747"),("105012", "2", "1000", "58", "1", "8.320000000000", "748"),("212389", "1", "1000", "559", "1", "13.360000000000", "749"),("212625", "1", "1000", "559", "1", "13.360000000000", "750"),("237036", "1", "1000", "559", "1", "41.090000000000", "751"),("201075", "1", "1000", "224", "1", "5.800000000000", "752"),("166604", "1", "1000", "30", "1", "9.160000000000", "753"),("166644", "1", "1000", "30", "1", "9.160000000000", "754"),("241751", "2", "1000", "15", "1", "13.410000000000", "755"),("159611", "-100", "42", "26", "1", "13.360000000000", "756"),("143449", "-100", "39", "26", "1", "13.360000000000", "757"),("156673", "-100", "26", "26", "1", "13.360000000000", "758"),("81047", "2", "14", "59", "1", "24.360000000000", "759"),("173820", "2", "11", "28", "1", "11.760000000000", "760"),("112106", "1", "7", "559", "1", "4.960000000000", "761"),("112113", "1", "7", "559", "1", "5.800000000000", "762"),("63331", "2", "6", "24", "1", "7.560000000000", "763"),("112119", "1", "6", "559", "1", "4.960000000000", "764"),("120128", "2", "5", "109", "1", "13.360000000000", "765"),("207381", "2", "5", "173", "1", "20.920000000000", "766"),("113468", "2", "4", "24", "1", "6.720000000000", "767"),("96256", "2", "4", "71", "1", "25.130000000000", "768"),("86559", "2", "3", "71", "1", "15.630000000000", "769"),("230615", "2", "3", "528", "1", "5.880000000000", "770"),("112085", "1", "3", "559", "1", "4.960000000000", "771"),("65272", "2", "3", "45", "1", "8.320000000000", "772"),("86569", "2", "2", "71", "1", "11.430000000000", "773"),("123945", "1", "1", "577", "1", "7.140000000000", "774"),("123959", "1", "1", "577", "1", "7.140000000000", "775"),("123967", "1", "1", "577", "1", "7.140000000000", "776"),("235162", "2", "1", "59", "1", "19.320000000000", "777"),("113448", "1", "1", "401", "1", "5.460000000000", "778"),("29272", "2", "1", "49", "1", "4.120000000000", "779"),("104925", "2", "1", "58", "1", "6.640000000000", "780"),("112101", "1", "1", "559", "1", "5.800000000000", "781"),("181427", "1", "1094", "13", "1", "14.200000000000", "782"),("237448", "1", "1029", "13", "1", "20.080000000000", "783"),("222675", "1", "1028", "370", "1", "13.070000000000", "784"),("114486", "2", "1025", "360", "1", "11.310000000000", "785"),("209877", "1", "1021", "476", "1", "22.230000000000", "786"),("130383", "1", "1021", "507", "1", "5.970000000000", "787"),("165711", "2", "1020", "45", "1", "16.810000000000", "788"),("209065", "1", "1017", "476", "1", "22.230000000000", "789"),("145725", "2", "1016", "45", "1", "5.550000000000", "790"),("132461", "1", "1015", "30", "1", "8.400000000000", "791"),("25357", "2", "1015", "19", "1", "19.750000000000", "792"),("132891", "1", "1013", "357", "1", "9.450000000000", "793"),("96379", "2", "1012", "168", "1", "26.440000000000", "794"),("174538", "1", "1011", "224", "1", "6.640000000000", "795"),("25759", "2", "1009", "19", "1", "13.170000000000", "796"),("12395", "2", "1009", "204", "1", "21.850000000000", "797"),("159747", "1", "1009", "13", "1", "11.680000000000", "798"),("229352", "1", "1008", "360", "1", "9.450000000000", "799"),("11136", "2", "1007", "67", "1", "7.480000000000", "800"),("59755", "2", "1007", "67", "1", "6.640000000000", "801"),("61259", "2", "1005", "188", "1", "9.160000000000", "802"),("179723", "2", "1005", "354", "1", "15.040000000000", "803"),("130035", "1", "1005", "56", "1", "8.320000000000", "804"),("124931", "2", "1005", "168", "1", "27.190000000000", "805"),("37510", "2", "1004", "204", "1", "22.690000000000", "806"),("170056", "1", "1004", "559", "1", "10.080000000000", "807"),("116108", "2", "1004", "204", "1", "22.690000000000", "808"),("209855", "1", "1004", "476", "1", "22.230000000000", "809"),("56565", "2", "1003", "15", "1", "16.380000000000", "810"),("56603", "2", "1003", "15", "1", "13.180000000000", "811"),("120626", "2", "1003", "356", "1", "13.450000000000", "812"),("108297", "1", "1003", "58", "1", "9.240000000000", "813"),("178953", "1", "1003", "362", "1", "6.970000000000", "814"),("27094", "2", "1003", "49", "1", "4.200000000000", "815"),("25682", "2", "1003", "75", "1", "16.720000000000", "816"),("25747", "2", "1003", "19", "1", "13.620000000000", "817"),("61357", "2", "1003", "24", "1", "7.480000000000", "818"),("166600", "1", "1003", "30", "1", "8.400000000000", "819"),("17504", "2", "1002", "42", "1", "23.530000000000", "820"),("56584", "2", "1002", "15", "1", "16.380000000000", "821"),("27102", "2", "1002", "49", "1", "6.220000000000", "822"),("84906", "2", "1002", "75", "1", "6.220000000000", "823"),("61315", "2", "1002", "24", "1", "7.480000000000", "824"),("61337", "2", "1002", "24", "1", "7.480000000000", "825"),("17573", "2", "1001", "42", "1", "17.650000000000", "826"),("178958", "1", "1001", "362", "1", "8.570000000000", "827"),("17506", "2", "1001", "42", "1", "23.530000000000", "828"),("17513", "2", "1001", "42", "1", "23.530000000000", "829"),("172011", "1", "1001", "648", "1", "8.400000000000", "830"),("92238", "2", "1001", "19", "1", "12.920000000000", "831"),("61320", "2", "1001", "24", "1", "7.480000000000", "832"),("63298", "2", "1001", "24", "1", "8.320000000000", "833"),("63321", "2", "1001", "24", "1", "8.320000000000", "834"),("105049", "2", "1001", "58", "1", "12.520000000000", "835"),("13566", "2", "1000", "115", "1", "22.690000000000", "836"),("13571", "2", "1000", "115", "1", "13.870000000000", "837"),("13479", "2", "1000", "115", "1", "14.710000000000", "838"),("13492", "2", "1000", "115", "1", "14.710000000000", "839"),("13515", "2", "1000", "115", "1", "14.710000000000", "840"),("17505", "2", "1000", "42", "1", "23.530000000000", "841"),("17512", "2", "1000", "42", "1", "23.530000000000", "842"),("17542", "2", "1000", "42", "1", "18.490000000000", "843"),("39195", "2", "1000", "42", "1", "2.940000000000", "844"),("39198", "2", "1000", "42", "1", "3.360000000000", "845"),("99022", "2", "1000", "15", "1", "29.610000000000", "846"),("80996", "2", "1000", "115", "1", "57.560000000000", "847"),("226171", "1", "1000", "370", "1", "5.870000000000", "848"),("226177", "1", "1000", "370", "1", "5.870000000000", "849"),("226183", "1", "1000", "370", "1", "4.870000000000", "850"),("226190", "1", "1000", "370", "1", "4.870000000000", "851"),("226215", "1", "1000", "370", "1", "11.570000000000", "852"),("210961", "1", "1000", "476", "1", "22.230000000000", "853"),("210871", "1", "1000", "476", "1", "22.230000000000", "854"),("142635", "2", "1000", "48", "1", "17.650000000000", "855"),("142647", "2", "1000", "48", "1", "17.650000000000", "856"),("207415", "2", "1000", "19", "1", "15.550000000000", "857"),("89829", "2", "1000", "71", "1", "9.080000000000", "858"),("129201", "2", "1000", "19", "1", "13.450000000000", "859"),("238994", "1", "1000", "85", "1", "25.210000000000", "860"),("45109", "2", "1000", "289", "1", "8.400000000000", "861"),("176133", "2", "1000", "124", "1", "36.970000000000", "862"),("213229", "1", "1000", "73", "1", "27.210000000000", "863"),("242133", "2", "1000", "73", "1", "15.500000000000", "864"),("242202", "1", "1000", "73", "1", "16.760000000000", "865"),("242325", "2", "1000", "73", "1", "25.170000000000", "866"),("242370", "1", "1000", "73", "1", "16.760000000000", "867"),("185747", "2", "1000", "73", "1", "23.310000000000", "868"),("56551", "2", "1000", "15", "1", "13.180000000000", "869"),("17630", "2", "1000", "42", "1", "10.920000000000", "870"),("207433", "1", "1000", "19", "1", "21.760000000000", "871"),("244307", "1", "1000", "54", "1", "30.250000000000", "872"),("99132", "2", "1000", "124", "1", "13.450000000000", "873"),("29351", "2", "1000", "49", "1", "5.460000000000", "874"),("29352", "2", "1000", "49", "1", "5.460000000000", "875"),("30737", "2", "1000", "49", "1", "4.540000000000", "876"),("84843", "2", "1000", "75", "1", "6.220000000000", "877"),("84910", "2", "1000", "75", "1", "6.640000000000", "878"),("84916", "2", "1000", "75", "1", "7.060000000000", "879"),("92359", "2", "1000", "19", "1", "9.000000000000", "880"),("94994", "2", "1000", "163", "1", "5.480000000000", "881"),("106557", "1", "1000", "50", "1", "21.760000000000", "882"),("109151", "2", "1000", "47", "1", "12.500000000000", "883"),("156229", "1", "1000", "629", "1", "22.610000000000", "884"),("156245", "1", "1000", "629", "1", "22.610000000000", "885"),("207875", "2", "1000", "19", "1", "27.920000000000", "886"),("129187", "2", "1000", "19", "1", "14.200000000000", "887"),("63325", "2", "1000", "24", "1", "8.320000000000", "888"),("207633", "2", "1000", "401", "1", "20.080000000000", "889"),("86553", "2", "1000", "71", "1", "20.170000000000", "890"),("200321", "1", "1000", "224", "1", "5.800000000000", "891"),("201073", "1", "1000", "224", "1", "7.480000000000", "892"),("170140", "1", "1000", "224", "1", "5.800000000000", "893"),("174547", "1", "1000", "224", "1", "6.640000000000", "894"),("223971", "1", "1000", "224", "1", "13.360000000000", "895"),("223984", "1", "1000", "224", "1", "13.360000000000", "896"),("119289", "2", "1000", "105", "1", "13.360000000000", "897"),("104857", "2", "1000", "58", "1", "14.200000000000", "898"),("108278", "1", "1000", "58", "1", "16.720000000000", "899"),("108301", "1", "1000", "58", "1", "12.520000000000", "900"),("112125", "1", "1000", "559", "1", "7.480000000000", "901"),("61440", "2", "1000", "24", "1", "7.480000000000", "902"),("13578", "2", "1000", "115", "1", "19.330000000000", "903"),("240992", "2", "1000", "15", "1", "8.350000000000", "904"),("47796", "-100", "74", "26", "1", "13.360000000000", "905"),("25359", "2", "40", "19", "1", "20.420000000000", "906"),("101431", "2", "17", "206", "1", "16.720000000000", "907"),("63499", "2", "10", "96", "1", "3.360000000000", "908"),("39214", "2", "9", "42", "1", "3.780000000000", "909"),("25753", "2", "5", "19", "1", "12.060000000000", "910"),("164529", "2", "4", "360", "1", "49.130000000000", "911"),("100528", "1", "4", "19", "1", "11.360000000000", "912"),("61458", "2", "4", "24", "1", "7.480000000000", "913"),("120129", "2", "4", "109", "1", "13.360000000000", "914"),("143585", "2", "3", "469", "1", "16.720000000000", "915"),("171222", "1", "3", "648", "1", "7.560000000000", "916"),("203575", "2", "3", "59", "1", "13.550000000000", "917"),("43683", "2", "3", "67", "1", "10.000000000000", "918"),("42781", "2", "2", "19", "1", "9.660000000000", "919"),("56561", "2", "2", "15", "1", "6.770000000000", "920"),("64724", "2", "2", "206", "1", "19.330000000000", "921"),("117499", "2", "2", "19", "1", "9.660000000000", "922"),("129213", "2", "2", "19", "1", "13.450000000000", "923"),("143555", "2", "2", "469", "1", "13.360000000000", "924"),("81046", "2", "2", "59", "1", "24.360000000000", "925"),("86556", "2", "2", "71", "1", "11.680000000000", "926"),("130377", "1", "2", "507", "1", "5.970000000000", "927"),("132813", "1", "1", "467", "1", "3.610000000000", "928"),("17507", "2", "1", "42", "1", "23.530000000000", "929"),("92252", "2", "1", "19", "1", "10.350000000000", "930"),("86478", "2", "1", "469", "1", "4.960000000000", "931"),("165440", "2", "1", "467", "1", "6.640000000000", "932"),("27090", "2", "1", "49", "1", "4.710000000000", "933"),("63473", "2", "1", "95", "1", "26.890000000000", "934"),("163874", "1", "3", "13", "1", "10.840000000000", "935"),("181583", "1", "1004", "517", "1", "20.180000000000", "936"),("201787", "1", "2", "13", "1", "15.880000000000", "937"),("181419", "1", "1106", "13", "1", "14.200000000000", "938"),("181411", "1", "1103", "13", "1", "14.200000000000", "939"),("145747", "1", "1039", "437", "1", "14.200000000000", "940"),("214603", "1", "1025", "13", "1", "12.520000000000", "941"),("229", "2", "1024", "19", "1", "20.170000000000", "942"),("40120", "2", "1010", "68", "1", "6.390000000000", "943"),("10942", "2", "1009", "68", "1", "7.310000000000", "944"),("155811", "1", "1007", "523", "1", "28.570000000000", "945"),("34881", "2", "1006", "204", "1", "22.690000000000", "946"),("87228", "2", "1006", "354", "1", "15.040000000000", "947"),("67162", "2", "1006", "56", "1", "11.760000000000", "948"),("107662", "1", "1006", "58", "1", "6.640000000000", "949"),("181813", "2", "1005", "517", "1", "8.770000000000", "950"),("39400", "2", "1005", "42", "1", "2.940000000000", "951"),("10948", "2", "1005", "68", "1", "7.480000000000", "952"),("74727", "2", "1005", "467", "1", "5.710000000000", "953"),("74920", "2", "1005", "468", "1", "5.460000000000", "954"),("235636", "2", "1005", "19", "1", "28.570000000000", "955"),("229338", "2", "1004", "362", "1", "6.390000000000", "956"),("178951", "1", "1004", "362", "1", "4.030000000000", "957"),("58312", "2", "1004", "15", "1", "9.300000000000", "958"),("225796", "1", "1004", "648", "1", "13.030000000000", "959"),("81627", "2", "1004", "68", "1", "7.980000000000", "960"),("232798", "1", "1003", "476", "1", "13.870000000000", "961"),("185417", "1", "1003", "455", "1", "23.410000000000", "962"),("39755", "2", "1002", "42", "1", "6.720000000000", "963"),("50662", "2", "1002", "42", "1", "9.240000000000", "964"),("149233", "1", "1002", "19", "1", "11.430000000000", "965"),("225561", "-100", "1002", "15", "1", "9.480000000000", "966"),("192201", "2", "1002", "15", "1", "28.370000000000", "967"),("102192", "2", "1002", "204", "1", "10.080000000000", "968"),("181713", "1", "1002", "517", "1", "8.770000000000", "969"),("165433", "1", "1002", "67", "1", "18.910000000000", "970"),("213647", "1", "1002", "224", "1", "8.320000000000", "971"),("245286", "2", "1002", "170", "1", "10.000000000000", "972"),("174516", "1", "1002", "224", "1", "5.880000000000", "973"),("17592", "2", "1001", "42", "1", "13.450000000000", "974"),("39760", "2", "1001", "42", "1", "6.720000000000", "975"),("135725", "2", "1001", "193", "1", "16.810000000000", "976"),("89757", "2", "1001", "423", "1", "10.590000000000", "977"),("131705", "1", "1001", "559", "1", "17.650000000000", "978"),("176134", "2", "1001", "124", "1", "33.610000000000", "979"),("123321", "2", "1001", "19", "1", "11.260000000000", "980"),("95634", "2", "1001", "20", "1", "13.100000000000", "981"),("42379", "2", "1001", "67", "1", "7.480000000000", "982"),("35238", "2", "1001", "68", "1", "11.340000000000", "983"),("107384", "1", "1001", "58", "1", "8.320000000000", "984"),("13528", "2", "1000", "115", "1", "15.130000000000", "985"),("17548", "2", "1000", "42", "1", "18.490000000000", "986"),("39765", "2", "1000", "42", "1", "6.720000000000", "987"),("39774", "2", "1000", "42", "1", "6.720000000000", "988"),("39699", "2", "1000", "42", "1", "6.720000000000", "989"),("39746", "2", "1000", "42", "1", "6.720000000000", "990"),("39750", "2", "1000", "42", "1", "6.720000000000", "991"),("91204", "2", "1000", "42", "1", "10.920000000000", "992"),("91218", "2", "1000", "42", "1", "10.920000000000", "993"),("174249", "1", "1000", "500", "1", "8.660000000000", "994"),("225361", "1", "1000", "119", "1", "12.580000000000", "995"),("222548", "1", "1000", "528", "1", "11.430000000000", "996"),("135729", "2", "1000", "193", "1", "20.170000000000", "997"),("234663", "2", "1000", "85", "1", "31.930000000000", "998"),("179056", "1", "1000", "423", "1", "10.590000000000", "999"),("201113", "2", "1000", "19", "1", "42.520000000000", "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 *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'

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