Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '652666c3c748fe0d4b5901dee5'

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 ("42532", "2", "8", "45", "1", "4.200000000000", "1"),("2880", "2", "9", "45", "1", "4.200000000000", "2"),("171226", "2", "1004", "45", "1", "7.480000000000", "3"),("171223", "2", "8", "45", "1", "7.730000000000", "4"),("171225", "2", "7", "45", "1", "7.480000000000", "5"),("171224", "2", "5", "45", "1", "7.730000000000", "6"),("42529", "2", "0", "45", "1", "2.624000000000", "7"),("42535", "2", "0", "45", "1", "2.624000000000", "8"),("42536", "2", "0", "45", "1", "2.624000000000", "9"),("42537", "2", "0", "45", "1", "2.624000000000", "10"),("42533", "2", "0", "45", "1", "2.624000000000", "11"),("42534", "2", "0", "45", "1", "2.624000000000", "12"),("228055", "2", "1000", "168", "1", "151.980000000000", "13"),("238431", "1", "1001", "124", "1", "120.170000000000", "14"),("177308", "10", "1000", "174", "1", "525.210000000000", "15"),("177309", "10", "1000", "174", "1", "563.030000000000", "16"),("24417", "10", "1000", "255", "1", "66.460000000000", "17"),("179809", "1", "1000", "464", "1", "80.590000000000", "18"),("179811", "1", "1", "464", "1", "100.000000000000", "19"),("228480", "2", "1051", "13", "1", "79.830000000000", "20"),("228482", "2", "1002", "13", "1", "83.950000000000", "21"),("228483", "2", "1000", "13", "1", "93.190000000000", "22"),("245164", "2", "1023", "13", "1", "59.580000000000", "23"),("245157", "2", "1022", "13", "1", "66.300000000000", "24"),("245162", "2", "1009", "13", "1", "62.940000000000", "25"),("245151", "2", "1000", "13", "1", "69.660000000000", "26"),("63161", "2", "2", "27", "1", "22.690000000000", "27"),("63162", "2", "1", "27", "1", "26.050000000000", "28"),("214085", "1", "1002", "691", "1", "52.100000000000", "29"),("214087", "1", "1002", "691", "1", "52.100000000000", "30"),("214105", "1", "1002", "691", "1", "52.100000000000", "31"),("214089", "1", "1002", "691", "1", "52.100000000000", "32"),("214091", "1", "1002", "691", "1", "52.100000000000", "33"),("214093", "1", "1002", "691", "1", "52.100000000000", "34"),("214097", "1", "1002", "691", "1", "52.100000000000", "35"),("214103", "1", "1002", "691", "1", "52.100000000000", "36"),("214095", "1", "1002", "691", "1", "52.100000000000", "37"),("214099", "1", "1002", "691", "1", "52.100000000000", "38"),("214101", "1", "1002", "691", "1", "52.100000000000", "39"),("214183", "1", "1002", "691", "1", "75.630000000000", "40"),("214203", "1", "1002", "691", "1", "78.150000000000", "41"),("53333", "4", "1000", "13", "1", "51.600000000000", "42"),("214165", "1", "1003", "691", "1", "66.390000000000", "43"),("214171", "1", "1003", "691", "1", "66.390000000000", "44"),("214175", "1", "1003", "691", "1", "66.390000000000", "45"),("214127", "1", "1002", "691", "1", "65.550000000000", "46"),("214129", "1", "1002", "691", "1", "65.550000000000", "47"),("214161", "1", "1002", "691", "1", "66.390000000000", "48"),("214163", "1", "1002", "691", "1", "66.390000000000", "49"),("214185", "1", "1002", "691", "1", "75.630000000000", "50"),("214191", "1", "1002", "691", "1", "75.630000000000", "51"),("214197", "1", "1002", "691", "1", "75.630000000000", "52"),("214199", "1", "1002", "691", "1", "75.630000000000", "53"),("214205", "1", "1002", "691", "1", "78.150000000000", "54"),("214209", "1", "1002", "691", "1", "78.150000000000", "55"),("214213", "1", "1002", "691", "1", "78.150000000000", "56"),("214217", "1", "1002", "691", "1", "78.150000000000", "57"),("214219", "1", "1002", "691", "1", "78.150000000000", "58"),("214221", "1", "1002", "691", "1", "78.150000000000", "59"),("214223", "1", "1002", "691", "1", "78.150000000000", "60"),("214167", "1", "1001", "691", "1", "66.390000000000", "61"),("214169", "1", "1001", "691", "1", "66.390000000000", "62"),("214173", "1", "1001", "691", "1", "66.390000000000", "63"),("214189", "1", "1001", "691", "1", "75.630000000000", "64"),("65844", "2", "1000", "54", "1", "78.150000000000", "65"),("62906", "2", "1021", "24", "1", "42.020000000000", "66"),("12044", "2", "1011", "24", "1", "38.660000000000", "67"),("20743", "2", "1005", "42", "1", "44.540000000000", "68"),("20742", "2", "1005", "42", "1", "47.900000000000", "69"),("8783", "2", "1003", "42", "1", "71.430000000000", "70"),("214153", "1", "1003", "691", "1", "66.390000000000", "71"),("214159", "1", "1003", "691", "1", "66.390000000000", "72"),("214177", "1", "1003", "691", "1", "66.390000000000", "73"),("214107", "1", "1002", "691", "1", "65.550000000000", "74"),("214131", "1", "1002", "691", "1", "65.550000000000", "75"),("214133", "1", "1002", "691", "1", "65.550000000000", "76"),("214135", "1", "1002", "691", "1", "65.550000000000", "77"),("214137", "1", "1002", "691", "1", "65.550000000000", "78"),("214139", "1", "1002", "691", "1", "65.550000000000", "79"),("214143", "1", "1002", "691", "1", "65.550000000000", "80"),("214145", "1", "1002", "691", "1", "65.550000000000", "81"),("214149", "1", "1002", "691", "1", "65.550000000000", "82"),("214155", "1", "1002", "691", "1", "66.390000000000", "83"),("214179", "1", "1002", "691", "1", "75.630000000000", "84"),("214181", "1", "1002", "691", "1", "75.630000000000", "85"),("214193", "1", "1002", "691", "1", "75.630000000000", "86"),("214195", "1", "1002", "691", "1", "75.630000000000", "87"),("214201", "1", "1002", "691", "1", "78.150000000000", "88"),("214207", "1", "1002", "691", "1", "78.150000000000", "89"),("214211", "1", "1002", "691", "1", "78.150000000000", "90"),("214215", "1", "1002", "691", "1", "78.150000000000", "91"),("214187", "1", "1002", "691", "1", "75.630000000000", "92"),("42541", "2", "1000", "45", "1", "3.780000000000", "93"),("42544", "2", "1000", "45", "1", "3.780000000000", "94"),("8784", "2", "1007", "42", "1", "121.850000000000", "95"),("214123", "1", "1002", "691", "1", "65.550000000000", "96"),("214125", "1", "1002", "691", "1", "65.550000000000", "97"),("214141", "1", "1002", "691", "1", "65.550000000000", "98"),("214147", "1", "1002", "691", "1", "65.550000000000", "99"),("214151", "1", "1002", "691", "1", "65.550000000000", "100"),("130221", "2", "1001", "75", "1", "67.140000000000", "101"),("167197", "2", "3", "229", "1", "277.060000000000", "102"),("175412", "2", "2", "528", "1", "42.010000000000", "103"),("167196", "2", "1", "229", "1", "239.240000000000", "104"),("68201", "2", "1000", "163", "1", "152.920000000000", "105"),("114496", "2", "1000", "27", "1", "45.290000000000", "106"),("235970", "2", "1000", "224", "1", "60.420000000000", "107"),("235971", "2", "1000", "224", "1", "100.760000000000", "108"),("235972", "2", "1000", "224", "1", "69.660000000000", "109"),("37818", "2", "23", "85", "1", "131.090000000000", "110"),("212367", "2", "1", "753", "1", "56.700000000000", "111"),("212375", "2", "1", "753", "1", "41.850000000000", "112"),("42540", "2", "2", "45", "1", "3.780000000000", "113"),("212321", "2", "1001", "753", "1", "671.430000000000", "114"),("217891", "2", "1000", "370", "1", "45.040000000000", "115"),("108662", "2", "1000", "75", "1", "161.260000000000", "116"),("242725", "1", "1000", "238", "1", "283.230000000000", "117"),("48843", "2", "17", "86", "1", "42.860000000000", "118"),("42546", "2", "1000", "45", "1", "3.780000000000", "119"),("227912", "1", "1000", "53", "1", "1342.400000000000", "120"),("95934", "2", "1000", "105", "1", "80.590000000000", "121"),("177629", "1", "1000", "11", "1", "1011.600000000000", "122"),("244588", "1", "1000", "53", "1", "165.340000000000", "123"),("244689", "1", "1000", "53", "1", "101.640000000000", "124"),("244695", "1", "1000", "53", "1", "144.760000000000", "125"),("223670", "1", "1000", "768", "1", "19.660000000000", "126"),("222876", "1", "1000", "768", "1", "33.530000000000", "127"),("154765", "1", "1000", "224", "1", "25.970000000000", "128"),("244701", "1", "1000", "53", "1", "276.400000000000", "129"),("247459", "1", "1000", "120", "1", "213.510000000000", "130"),("173939", "2", "1000", "62", "1", "24.600000000000", "131"),("171220", "2", "1004", "45", "1", "7.730000000000", "132"),("171217", "2", "10", "45", "1", "7.730000000000", "133"),("171216", "2", "9", "45", "1", "7.730000000000", "134"),("171214", "2", "4", "45", "1", "7.730000000000", "135"),("239215", "1", "1001", "753", "1", "519.390000000000", "136"),("239217", "1", "1001", "753", "1", "140.000000000000", "137"),("49490", "2", "1001", "290", "1", "82.270000000000", "138"),("220354", "1", "1000", "743", "1", "585.820000000000", "139"),("49486", "2", "1000", "290", "1", "97.390000000000", "140"),("49487", "2", "1000", "290", "1", "115.880000000000", "141"),("207511", "2", "1000", "224", "1", "36.050000000000", "142"),("222875", "1", "1000", "768", "1", "33.530000000000", "143"),("49489", "2", "1", "290", "1", "172.180000000000", "144"),("172297", "1", "1000", "120", "1", "374.640000000000", "145"),("243300", "1", "1000", "11", "1", "153.180000000000", "146"),("140983", "2", "1001", "17", "1", "90.000000000000", "147"),("115454", "2", "1001", "53", "1", "121.520000000000", "148"),("140985", "2", "1000", "17", "1", "91.600000000000", "149"),("111268", "1", "1000", "53", "1", "462.740000000000", "150"),("116781", "10", "2", "280", "1", "182.620000000000", "151"),("116780", "10", "1", "280", "1", "135.750000000000", "152"),("180941", "1", "1000", "124", "1", "120.170000000000", "153"),("166959", "1", "1008", "87", "1", "319.330000000000", "154"),("166956", "1", "1006", "87", "1", "354.620000000000", "155"),("166958", "1", "1006", "87", "1", "354.620000000000", "156"),("236883", "2", "1001", "124", "1", "75.630000000000", "157"),("176605", "1", "1000", "88", "1", "1588.200000000000", "158"),("241452", "2", "1000", "115", "1", "175.630000000000", "159"),("241453", "2", "1000", "115", "1", "192.440000000000", "160"),("241457", "2", "1000", "115", "1", "200.840000000000", "161"),("241463", "2", "1000", "115", "1", "175.630000000000", "162"),("241464", "2", "1000", "115", "1", "192.440000000000", "163"),("112411", "2", "1000", "53", "1", "279.060000000000", "164"),("156725", "2", "1000", "49", "1", "500.760000000000", "165"),("156727", "2", "1000", "49", "1", "546.970000000000", "166"),("243086", "1", "1000", "75", "1", "62.940000000000", "167"),("148549", "2", "17", "87", "1", "92.700000000000", "168"),("166957", "1", "11", "87", "1", "319.330000000000", "169"),("166960", "1", "7", "87", "1", "299.920000000000", "170"),("181607", "2", "6", "211", "1", "73.870000000000", "171"),("148547", "2", "1", "87", "1", "86.710000000000", "172"),("41288", "2", "1", "67", "1", "56.300000000000", "173"),("244845", "2", "1000", "58", "1", "420.080000000000", "174"),("244847", "2", "1000", "58", "1", "471.340000000000", "175"),("244849", "2", "1000", "58", "1", "546.970000000000", "176"),("244850", "2", "1000", "58", "1", "454.540000000000", "177"),("244852", "2", "1000", "58", "1", "555.380000000000", "178"),("158397", "1", "1010", "191", "1", "170.590000000000", "179"),("170893", "2", "1002", "389", "1", "125.820000000000", "180"),("85185", "2", "1001", "115", "1", "277.310000000000", "181"),("239225", "1", "1001", "753", "1", "261.800000000000", "182"),("239226", "1", "1001", "753", "1", "156.800000000000", "183"),("85179", "2", "1000", "115", "1", "199.160000000000", "184"),("85181", "2", "1000", "115", "1", "226.890000000000", "185"),("85186", "2", "1000", "115", "1", "241.180000000000", "186"),("182205", "2", "1000", "389", "1", "115.690000000000", "187"),("174950", "1", "1000", "191", "1", "152.940000000000", "188"),("145403", "1", "1000", "124", "1", "232.010000000000", "189"),("52201", "2", "1000", "115", "1", "268.910000000000", "190"),("241458", "2", "1000", "115", "1", "133.610000000000", "191"),("242265", "2", "1000", "115", "1", "697.480000000000", "192"),("242282", "2", "1000", "115", "1", "386.550000000000", "193"),("242283", "2", "1000", "115", "1", "420.170000000000", "194"),("189161", "1", "1000", "88", "1", "291.600000000000", "195"),("173668", "2", "1000", "191", "1", "340.340000000000", "196"),("173669", "2", "1000", "191", "1", "389.920000000000", "197"),("174949", "1", "1000", "191", "1", "142.020000000000", "198"),("174951", "1", "1000", "191", "1", "152.940000000000", "199"),("170891", "2", "1000", "389", "1", "105.550000000000", "200"),("22498", "2", "1000", "53", "1", "65.310000000000", "201"),("126339", "2", "1000", "575", "1", "87.310000000000", "202"),("193007", "1", "1000", "53", "1", "50.790000000000", "203"),("193009", "1", "1000", "53", "1", "50.790000000000", "204"),("193011", "1", "1000", "53", "1", "383.530000000000", "205"),("216357", "1", "1000", "753", "1", "168.760000000000", "206"),("223685", "1", "1000", "768", "1", "30.170000000000", "207"),("158487", "1", "3", "191", "1", "134.370000000000", "208"),("158399", "1", "3", "191", "1", "149.500000000000", "209"),("85235", "2", "1", "115", "1", "335.290000000000", "210"),("170894", "2", "1", "389", "1", "132.890000000000", "211"),("181059", "1", "1005", "87", "1", "200.550000000000", "212"),("237828", "2", "1004", "389", "1", "120.930000000000", "213"),("170903", "2", "1003", "389", "1", "139.370000000000", "214"),("119318", "2", "1002", "105", "1", "105.800000000000", "215"),("170902", "2", "1001", "389", "1", "133.360000000000", "216"),("22495", "2", "1001", "53", "1", "38.050000000000", "217"),("199897", "1", "1001", "389", "1", "270.130000000000", "218"),("48917", "2", "1001", "53", "1", "477.770000000000", "219"),("68205", "2", "1001", "53", "1", "335.060000000000", "220"),("92775", "2", "1000", "53", "1", "444.550000000000", "221"),("48916", "2", "1000", "53", "1", "378.180000000000", "222"),("68203", "2", "1000", "53", "1", "69.550000000000", "223"),("68206", "2", "1000", "53", "1", "399.610000000000", "224"),("118966", "2", "1000", "53", "1", "464.130000000000", "225"),("176400", "1", "1000", "53", "1", "155.450000000000", "226"),("176401", "1", "1000", "53", "1", "228.540000000000", "227"),("176402", "1", "1000", "53", "1", "267.700000000000", "228"),("216351", "1", "1000", "753", "1", "336.760000000000", "229"),("216353", "1", "1000", "753", "1", "303.160000000000", "230"),("216355", "1", "1000", "753", "1", "235.960000000000", "231"),("198245", "1", "5", "389", "1", "214.680000000000", "232"),("198247", "1", "2", "389", "1", "156.710000000000", "233"),("11052", "2", "2", "46", "1", "18.490000000000", "234"),("237826", "2", "1010", "389", "1", "108.650000000000", "235"),("216747", "1", "1001", "753", "1", "151.200000000000", "236"),("240314", "1", "1001", "88", "1", "720.170000000000", "237"),("183259", "1", "1001", "88", "1", "342.860000000000", "238"),("178207", "1", "1000", "88", "1", "548.740000000000", "239"),("172880", "2", "1000", "191", "1", "284.030000000000", "240"),("235895", "2", "1000", "88", "1", "223.530000000000", "241"),("236044", "2", "1000", "88", "1", "205.880000000000", "242"),("236045", "2", "1000", "88", "1", "189.080000000000", "243"),("236046", "2", "1000", "88", "1", "257.140000000000", "244"),("239923", "2", "1000", "17", "1", "242.860000000000", "245"),("239924", "2", "1000", "17", "1", "259.660000000000", "246"),("239925", "2", "1000", "17", "1", "268.070000000000", "247"),("236043", "2", "1000", "88", "1", "223.530000000000", "248"),("111269", "1", "1000", "53", "1", "899.500000000000", "249"),("216795", "1", "1000", "753", "1", "44.160000000000", "250"),("237551", "2", "1000", "13", "1", "64.640000000000", "251"),("237552", "2", "1000", "13", "1", "80.590000000000", "252"),("237827", "2", "10", "389", "1", "121.230000000000", "253"),("158375", "2", "2", "122", "1", "96.550000000000", "254"),("224868", "2", "1000", "774", "1", "41386.550000000000", "255"),("175214", "1", "1008", "122", "1", "152.940000000000", "256"),("211531", "2", "1002", "753", "1", "33.530000000000", "257"),("237829", "1", "1002", "389", "1", "157.050000000000", "258"),("150765", "2", "1002", "58", "1", "554.540000000000", "259"),("212443", "2", "1001", "753", "1", "184.800000000000", "260"),("186351", "1", "1000", "88", "1", "291.600000000000", "261"),("192403", "1", "1000", "88", "1", "480.670000000000", "262"),("193467", "1", "1000", "87", "1", "284.030000000000", "263"),("193469", "1", "1000", "87", "1", "205.880000000000", "264"),("193473", "1", "1000", "87", "1", "184.870000000000", "265"),("193475", "1", "1000", "87", "1", "159.660000000000", "266"),("234090", "1", "1000", "389", "1", "177.560000000000", "267"),("185663", "1", "1000", "88", "1", "291.600000000000", "268"),("189175", "1", "1000", "88", "1", "309.240000000000", "269"),("115455", "2", "1000", "53", "1", "176.410000000000", "270"),("115456", "2", "1000", "53", "1", "313.100000000000", "271"),("115457", "2", "1000", "53", "1", "386.390000000000", "272"),("118965", "2", "1000", "53", "1", "344.850000000000", "273"),("216349", "1", "1000", "753", "1", "471.160000000000", "274"),("193471", "1", "1000", "87", "1", "194.960000000000", "275"),("150763", "2", "8", "58", "1", "537.820000000000", "276"),("192479", "1", "6", "211", "1", "26.810000000000", "277"),("150761", "2", "6", "58", "1", "500.760000000000", "278"),("116983", "2", "1", "280", "1", "193.190000000000", "279"),("224045", "2", "1163", "13", "1", "67.140000000000", "280"),("224046", "2", "1082", "13", "1", "71.340000000000", "281"),("224043", "2", "1000", "13", "1", "64.620000000000", "282"),("245861", "1", "1001", "808", "1", "158.820000000000", "283"),("245863", "1", "1001", "808", "1", "163.870000000000", "284"),("245864", "1", "1001", "808", "1", "167.230000000000", "285"),("245883", "1", "1001", "808", "1", "158.820000000000", "286"),("245884", "1", "1001", "808", "1", "163.870000000000", "287"),("199705", "1", "1005", "58", "1", "335.290000000000", "288"),("199707", "1", "1002", "58", "1", "361.340000000000", "289"),("170918", "2", "1001", "656", "1", "599.480000000000", "290"),("189327", "1", "1000", "88", "1", "309.240000000000", "291"),("194303", "1", "1000", "87", "1", "354.620000000000", "292"),("194305", "1", "1000", "87", "1", "425.210000000000", "293"),("194309", "1", "1000", "87", "1", "142.020000000000", "294"),("194311", "1", "1000", "87", "1", "159.660000000000", "295"),("185651", "1", "1000", "88", "1", "291.600000000000", "296"),("195493", "1", "1000", "88", "1", "274.790000000000", "297"),("199703", "1", "3", "58", "1", "315.130000000000", "298"),("172875", "2", "2", "795", "1", "212.610000000000", "299"),("9833", "2", "1000", "116", "1", "29.410000000000", "300"),("9834", "2", "1000", "116", "1", "29.410000000000", "301"),("164224", "2", "1002", "13", "1", "159.580000000000", "302"),("170940", "2", "1001", "656", "1", "727.860000000000", "303"),("170933", "2", "1001", "656", "1", "529.970000000000", "304"),("196041", "1", "1000", "88", "1", "274.790000000000", "305"),("216699", "1", "1000", "753", "1", "403.960000000000", "306"),("216919", "1", "1000", "753", "1", "336.760000000000", "307"),("164231", "2", "1000", "13", "1", "183.950000000000", "308"),("109351", "2", "1", "86", "1", "77.900000000000", "309"),("176028", "1", "1000", "124", "1", "131.090000000000", "310"),("219986", "2", "1045", "13", "1", "151.180000000000", "311"),("220374", "2", "1040", "13", "1", "125.970000000000", "312"),("219962", "2", "1036", "13", "1", "134.370000000000", "313"),("219978", "2", "1018", "13", "1", "142.770000000000", "314"),("177501", "2", "1012", "13", "1", "158.740000000000", "315"),("177502", "2", "1007", "13", "1", "181.430000000000", "316"),("219459", "1", "1004", "30", "1", "273.110000000000", "317"),("191151", "2", "1001", "13", "1", "189.830000000000", "318"),("176602", "1", "1000", "88", "1", "4000.000000000000", "319"),("192581", "1", "1000", "88", "1", "360.500000000000", "320"),("170846", "2", "1000", "389", "1", "104.100000000000", "321"),("216745", "1", "1000", "753", "1", "135.160000000000", "322"),("219460", "1", "1000", "30", "1", "240.250000000000", "323"),("170456", "2", "1000", "58", "1", "152.020000000000", "324"),("170457", "2", "16", "58", "1", "159.660000000000", "325"),("192475", "1", "15", "699", "1", "5.460000000000", "326"),("212871", "2", "2", "753", "1", "151.180000000000", "327"),("192477", "1", "2", "699", "1", "41.930000000000", "328"),("210615", "2", "1", "753", "1", "134.390000000000", "329"),("57059", "2", "1007", "15", "1", "34.420000000000", "330"),("57014", "2", "1004", "15", "1", "31.780000000000", "331"),("57060", "2", "1004", "15", "1", "34.420000000000", "332"),("57015", "2", "1003", "15", "1", "31.780000000000", "333"),("57066", "2", "1003", "15", "1", "30.820000000000", "334"),("57013", "2", "1001", "15", "1", "31.780000000000", "335"),("38120", "2", "1001", "168", "1", "2591.060000000000", "336"),("57067", "2", "1000", "15", "1", "33.450000000000", "337"),("57068", "2", "1000", "15", "1", "29.840000000000", "338"),("57395", "2", "1000", "123", "1", "42.230000000000", "339"),("57017", "2", "1000", "15", "1", "31.780000000000", "340"),("57061", "2", "1000", "15", "1", "24.620000000000", "341"),("57063", "2", "1000", "15", "1", "34.420000000000", "342"),("57064", "2", "1000", "15", "1", "33.870000000000", "343"),("93087", "10", "1000", "271", "1", "447.820000000000", "344"),("100566", "1", "1000", "271", "1", "259.940000000000", "345"),("100567", "1", "1000", "271", "1", "259.940000000000", "346"),("110849", "10", "1000", "271", "1", "247.820000000000", "347"),("57043", "2", "8", "15", "1", "27.480000000000", "348"),("87297", "2", "8", "100", "1", "11.760000000000", "349"),("57016", "2", "2", "15", "1", "20.160000000000", "350"),("151521", "2", "1", "366", "1", "715.040000000000", "351"),("57058", "2", "1", "15", "1", "25.130000000000", "352"),("176672", "2", "1006", "58", "1", "167.230000000000", "353"),("176674", "2", "1005", "58", "1", "189.080000000000", "354"),("150751", "2", "1004", "58", "1", "394.960000000000", "355"),("176675", "2", "1004", "58", "1", "197.480000000000", "356"),("210609", "2", "1002", "753", "1", "235.190000000000", "357"),("165788", "1", "1002", "88", "1", "360.500000000000", "358"),("210611", "2", "1002", "753", "1", "302.390000000000", "359"),("170461", "2", "1002", "58", "1", "114.200000000000", "360"),("172067", "2", "1001", "389", "1", "286.180000000000", "361"),("150753", "2", "1001", "58", "1", "416.720000000000", "362"),("176673", "2", "1001", "58", "1", "189.830000000000", "363"),("172057", "2", "1000", "389", "1", "242.780000000000", "364"),("216705", "1", "1000", "753", "1", "101.550000000000", "365"),("179126", "2", "1000", "58", "1", "479.750000000000", "366"),("170459", "2", "1000", "58", "1", "105.800000000000", "367"),("170460", "2", "1000", "58", "1", "110.000000000000", "368"),("150745", "2", "998", "58", "1", "114.200000000000", "369"),("167040", "1", "1", "305", "1", "86.970000000000", "370"),("210619", "2", "1", "753", "1", "117.600000000000", "371"),("212873", "2", "1", "753", "1", "103.280000000000", "372"),("239803", "2", "1002", "13", "1", "142.850000000000", "373"),("239804", "2", "1002", "13", "1", "159.580000000000", "374"),("239805", "2", "1002", "13", "1", "167.980000000000", "375"),("239806", "2", "1002", "13", "1", "184.790000000000", "376"),("176606", "1", "1000", "88", "1", "1200.000000000000", "377"),("178224", "1", "1000", "88", "1", "548.740000000000", "378"),("170462", "2", "1000", "58", "1", "164.620000000000", "379"),("212877", "2", "1", "753", "1", "302.400000000000", "380"),("94116", "2", "1008", "458", "1", "28.570000000000", "381"),("120037", "1", "1004", "73", "1", "33.150000000000", "382"),("57073", "2", "1003", "15", "1", "37.480000000000", "383"),("145807", "2", "1003", "45", "1", "4.120000000000", "384"),("57095", "2", "1002", "15", "1", "47.750000000000", "385"),("57097", "2", "1002", "15", "1", "53.160000000000", "386"),("57099", "2", "1002", "15", "1", "52.880000000000", "387"),("57100", "2", "1002", "15", "1", "52.880000000000", "388"),("57112", "2", "1002", "15", "1", "50.390000000000", "389"),("174279", "2", "1002", "656", "1", "38.130000000000", "390"),("174278", "2", "1002", "656", "1", "38.920000000000", "391"),("57077", "2", "1001", "15", "1", "37.480000000000", "392"),("57094", "2", "1001", "15", "1", "47.750000000000", "393"),("57040", "2", "1001", "15", "1", "32.900000000000", "394"),("71437", "2", "1001", "15", "1", "38.590000000000", "395"),("71438", "2", "1001", "15", "1", "38.590000000000", "396"),("71439", "2", "1001", "15", "1", "38.590000000000", "397"),("57037", "2", "1001", "15", "1", "32.900000000000", "398"),("57110", "2", "1001", "15", "1", "50.390000000000", "399"),("36885", "2", "1001", "206", "1", "32.770000000000", "400"),("41099", "2", "1000", "116", "1", "29.410000000000", "401"),("41100", "2", "1000", "116", "1", "29.410000000000", "402"),("57076", "2", "1000", "15", "1", "37.480000000000", "403"),("57093", "2", "1000", "15", "1", "48.860000000000", "404"),("57039", "2", "1000", "15", "1", "29.240000000000", "405"),("57041", "2", "1000", "15", "1", "29.290000000000", "406"),("57052", "2", "1000", "15", "1", "28.320000000000", "407"),("57053", "2", "1000", "15", "1", "31.780000000000", "408"),("57055", "2", "1000", "15", "1", "31.780000000000", "409"),("71433", "2", "1000", "15", "1", "38.590000000000", "410"),("71434", "2", "1000", "15", "1", "38.590000000000", "411"),("71435", "2", "1000", "15", "1", "38.590000000000", "412"),("71436", "2", "1000", "15", "1", "34.420000000000", "413"),("174277", "2", "1000", "656", "1", "29.860000000000", "414"),("224869", "2", "1000", "774", "1", "53949.580000000000", "415"),("192859", "1", "1000", "656", "1", "61.030000000000", "416"),("203823", "1", "1000", "15", "1", "68.670000000000", "417"),("204783", "1", "1000", "476", "1", "88.190000000000", "418"),("204785", "1", "1000", "476", "1", "92.390000000000", "419"),("204791", "1", "1000", "476", "1", "96.600000000000", "420"),("240015", "2", "1000", "617", "1", "209.320000000000", "421"),("120038", "1", "1000", "73", "1", "33.150000000000", "422"),("164359", "2", "1000", "535", "1", "41.180000000000", "423"),("36854", "2", "1000", "206", "1", "32.770000000000", "424"),("36965", "2", "1000", "206", "1", "15.970000000000", "425"),("36969", "2", "1000", "206", "1", "15.970000000000", "426"),("36971", "2", "1000", "206", "1", "18.490000000000", "427"),("36974", "2", "1000", "206", "1", "24.370000000000", "428"),("177307", "10", "1000", "174", "1", "221.850000000000", "429"),("57109", "2", "1000", "15", "1", "52.880000000000", "430"),("170628", "2", "1000", "656", "1", "33.500000000000", "431"),("36972", "2", "1000", "206", "1", "24.370000000000", "432"),("22070", "2", "1000", "19", "1", "58.930000000000", "433"),("80829", "2", "1000", "115", "1", "95.710000000000", "434"),("95537", "10", "1000", "82", "1", "105.820000000000", "435"),("120301", "2", "1000", "238", "1", "566.370000000000", "436"),("173838", "2", "1000", "269", "1", "361.540000000000", "437"),("183333", "1", "1000", "703", "1", "155.280000000000", "438"),("183335", "1", "1000", "705", "1", "429.750000000000", "439"),("223147", "1", "1000", "768", "1", "51.180000000000", "440"),("36857", "2", "5", "206", "1", "32.770000000000", "441"),("36883", "2", "3", "206", "1", "32.770000000000", "442"),("36878", "2", "2", "206", "1", "32.770000000000", "443"),("36867", "2", "2", "206", "1", "32.770000000000", "444"),("36864", "2", "2", "206", "1", "32.770000000000", "445"),("57102", "2", "2", "15", "1", "35.210000000000", "446"),("57074", "2", "1", "15", "1", "18.200000000000", "447"),("57054", "2", "1", "15", "1", "31.780000000000", "448"),("194003", "1", "1010", "795", "1", "212.610000000000", "449"),("176664", "2", "1006", "58", "1", "167.230000000000", "450"),("176667", "2", "1005", "58", "1", "109.240000000000", "451"),("176663", "2", "1005", "58", "1", "163.870000000000", "452"),("176662", "2", "1004", "58", "1", "151.260000000000", "453"),("176666", "2", "1004", "58", "1", "105.040000000000", "454"),("176668", "2", "1003", "58", "1", "117.650000000000", "455"),("176665", "2", "1003", "58", "1", "176.470000000000", "456"),("180591", "1", "1002", "484", "1", "284.870000000000", "457"),("180589", "1", "1002", "484", "1", "282.350000000000", "458"),("178230", "1", "1000", "88", "1", "789.080000000000", "459"),("181611", "2", "1", "695", "1", "457.390000000000", "460"),("167041", "1", "1", "305", "1", "103.360000000000", "461"),("220030", "2", "1007", "58", "1", "277.310000000000", "462"),("220029", "2", "1006", "58", "1", "247.900000000000", "463"),("178248", "1", "1000", "122", "1", "152.940000000000", "464"),("220031", "2", "1000", "58", "1", "303.280000000000", "465"),("240844", "1", "2", "305", "1", "134.870000000000", "466"),("7565", "2", "1008", "15", "1", "30.820000000000", "467"),("7562", "2", "1005", "15", "1", "30.820000000000", "468"),("7564", "2", "1003", "15", "1", "30.820000000000", "469"),("57010", "2", "1003", "15", "1", "22.900000000000", "470"),("7566", "2", "1003", "15", "1", "30.820000000000", "471"),("12326", "2", "1002", "15", "1", "33.870000000000", "472"),("54519", "2", "1001", "50", "1", "26.050000000000", "473"),("103166", "2", "1001", "15", "1", "63.850000000000", "474"),("103167", "2", "1001", "15", "1", "63.850000000000", "475"),("54517", "2", "1001", "50", "1", "26.810000000000", "476"),("7560", "2", "1000", "15", "1", "31.780000000000", "477"),("7561", "2", "1000", "15", "1", "31.370000000000", "478"),("7563", "2", "1000", "15", "1", "29.430000000000", "479"),("12325", "2", "1000", "15", "1", "30.820000000000", "480"),("8420", "2", "1000", "42", "1", "70.590000000000", "481"),("224872", "2", "1000", "774", "1", "119747.900000000000", "482"),("224874", "2", "1000", "775", "1", "23739.500000000000", "483"),("224875", "2", "1000", "775", "1", "25063.030000000000", "484"),("224876", "2", "1000", "775", "1", "25063.030000000000", "485"),("224877", "2", "1000", "775", "1", "31302.520000000000", "486"),("224878", "2", "1000", "775", "1", "31848.740000000000", "487"),("224879", "2", "1000", "775", "1", "6281.510000000000", "488"),("152839", "1", "1000", "73", "1", "33.150000000000", "489"),("36890", "2", "1000", "206", "1", "26.890000000000", "490"),("103455", "1", "1000", "494", "1", "21.010000000000", "491"),("156939", "2", "1000", "281", "1", "210.040000000000", "492"),("24366", "10", "1000", "82", "1", "215.210000000000", "493"),("43449", "10", "1000", "238", "1", "587.190000000000", "494"),("94574", "10", "1000", "271", "1", "34.760000000000", "495"),("54524", "2", "1000", "50", "1", "26.810000000000", "496"),("110851", "10", "1000", "222", "1", "161.480000000000", "497"),("127223", "2", "1000", "217", "1", "18.400000000000", "498"),("197021", "1", "1000", "271", "1", "137.730000000000", "499"),("197023", "1", "1000", "271", "1", "137.730000000000", "500"),("199113", "1", "1000", "271", "1", "437.980000000000", "501"),("73096", "2", "1000", "464", "1", "23.450000000000", "502"),("180071", "2", "1000", "684", "1", "215.040000000000", "503"),("180136", "2", "1000", "430", "1", "167.980000000000", "504"),("220531", "1", "1000", "30", "1", "65.460000000000", "505"),("40675", "2", "1000", "45", "1", "2.520000000000", "506"),("146823", "2", "1000", "105", "1", "57.900000000000", "507"),("100786", "-100", "43", "26", "1", "19.240000000000", "508"),("84965", "2", "19", "100", "1", "8.400000000000", "509"),("240642", "2", "5", "782", "1", "26.810000000000", "510"),("166206", "2", "3", "59", "1", "83.190000000000", "511"),("57005", "2", "3", "15", "1", "22.900000000000", "512"),("111981", "1", "2", "428", "1", "46.220000000000", "513"),("132395", "10", "2", "469", "1", "41.930000000000", "514"),("54521", "2", "2", "50", "1", "20.080000000000", "515"),("18074", "2", "1", "42", "1", "21.850000000000", "516"),("54520", "2", "1", "50", "1", "26.050000000000", "517"),("54525", "2", "1", "50", "1", "26.810000000000", "518"),("107082", "1", "1020", "168", "1", "18.870000000000", "519"),("31500", "2", "1008", "42", "1", "5.040000000000", "520"),("31499", "2", "1008", "42", "1", "5.460000000000", "521"),("31498", "2", "1007", "42", "1", "5.880000000000", "522"),("31501", "2", "1007", "42", "1", "4.620000000000", "523"),("20254", "2", "1006", "42", "1", "3.780000000000", "524"),("94576", "2", "1005", "271", "1", "14.770000000000", "525"),("224560", "1", "1005", "168", "1", "76.350000000000", "526"),("100229", "1", "1004", "20", "1", "26.160000000000", "527"),("31502", "2", "1004", "42", "1", "4.620000000000", "528"),("152837", "1", "1003", "73", "1", "147.020000000000", "529"),("16378", "2", "1002", "42", "1", "12.610000000000", "530"),("16404", "2", "1002", "42", "1", "12.610000000000", "531"),("31504", "2", "1002", "42", "1", "5.040000000000", "532"),("16383", "2", "1001", "42", "1", "15.130000000000", "533"),("16407", "2", "1001", "42", "1", "15.130000000000", "534"),("16409", "2", "1001", "42", "1", "15.970000000000", "535"),("20256", "2", "1001", "42", "1", "3.780000000000", "536"),("16401", "2", "1001", "42", "1", "14.290000000000", "537"),("178057", "2", "1001", "174", "1", "258.820000000000", "538"),("31503", "2", "1001", "42", "1", "4.620000000000", "539"),("179777", "1", "1001", "464", "1", "36.050000000000", "540"),("192047", "2", "1001", "105", "1", "93.190000000000", "541"),("120069", "2", "1001", "79", "1", "67.550000000000", "542"),("18079", "2", "1000", "42", "1", "135.290000000000", "543"),("8753", "2", "1000", "42", "1", "65.550000000000", "544"),("16370", "2", "1000", "42", "1", "15.130000000000", "545"),("16373", "2", "1000", "42", "1", "14.290000000000", "546"),("16375", "2", "1000", "42", "1", "13.450000000000", "547"),("16380", "2", "1000", "42", "1", "15.130000000000", "548"),("16394", "2", "1000", "42", "1", "17.650000000000", "549"),("16402", "2", "1000", "42", "1", "13.450000000000", "550"),("16403", "2", "1000", "42", "1", "12.610000000000", "551"),("16406", "2", "1000", "42", "1", "15.130000000000", "552"),("20249", "2", "1000", "42", "1", "3.780000000000", "553"),("20252", "2", "1000", "42", "1", "3.780000000000", "554"),("20255", "2", "1000", "42", "1", "3.780000000000", "555"),("41101", "2", "1000", "116", "1", "29.410000000000", "556"),("41104", "2", "1000", "116", "1", "29.410000000000", "557"),("41105", "2", "1000", "116", "1", "29.410000000000", "558"),("41106", "2", "1000", "116", "1", "29.410000000000", "559"),("57057", "2", "1000", "15", "1", "34.420000000000", "560"),("79355", "2", "1000", "42", "1", "13.450000000000", "561"),("128117", "2", "1000", "15", "1", "37.480000000000", "562"),("128119", "2", "1000", "15", "1", "37.480000000000", "563"),("168054", "1", "1000", "356", "1", "15.970000000000", "564"),("168056", "1", "1000", "356", "1", "15.970000000000", "565"),("168057", "1", "1000", "356", "1", "15.970000000000", "566"),("168068", "1", "1000", "356", "1", "15.970000000000", "567"),("168077", "1", "1000", "356", "1", "22.690000000000", "568"),("215679", "2", "1000", "656", "1", "93.920000000000", "569"),("215681", "2", "1000", "656", "1", "87.800000000000", "570"),("224867", "2", "1000", "774", "1", "52521.010000000000", "571"),("224873", "2", "1000", "775", "1", "22268.910000000000", "572"),("232961", "10", "1000", "533", "1", "68.120000000000", "573"),("57069", "2", "1000", "15", "1", "23.950000000000", "574"),("57070", "2", "1000", "15", "1", "23.950000000000", "575"),("192309", "-100", "1000", "570", "1", "54.580000000000", "576"),("128041", "2", "1000", "15", "1", "33.870000000000", "577"),("79356", "2", "1000", "42", "1", "14.290000000000", "578"),("16366", "2", "1000", "42", "1", "20.170000000000", "579"),("16368", "2", "1000", "42", "1", "17.650000000000", "580"),("16385", "2", "1000", "42", "1", "15.970000000000", "581"),("16398", "2", "1000", "42", "1", "15.970000000000", "582"),("103452", "1", "1000", "494", "1", "68.070000000000", "583"),("235979", "2", "1000", "79", "1", "2801.890000000000", "584"),("21949", "2", "1000", "73", "1", "27.200000000000", "585"),("24367", "10", "1000", "82", "1", "284.530000000000", "586"),("84805", "10", "1000", "157", "1", "120.870000000000", "587"),("94578", "10", "1000", "271", "1", "31.990000000000", "588"),("94579", "10", "1000", "271", "1", "22.440000000000", "589"),("94580", "10", "1000", "271", "1", "18.830000000000", "590"),("94722", "2", "1000", "20", "1", "26.920000000000", "591"),("94723", "2", "1000", "20", "1", "26.920000000000", "592"),("94724", "2", "1000", "20", "1", "26.920000000000", "593"),("94901", "10", "1000", "271", "1", "27.340000000000", "594"),("94938", "2", "1000", "79", "1", "2781.180000000000", "595"),("95636", "2", "1000", "20", "1", "26.920000000000", "596"),("100565", "1", "1000", "271", "1", "259.940000000000", "597"),("127225", "1", "1000", "217", "1", "18.400000000000", "598"),("149805", "10", "1000", "222", "1", "264.130000000000", "599"),("183321", "10", "1000", "238", "1", "176.340000000000", "600"),("197017", "1", "1000", "271", "1", "116.720000000000", "601"),("226616", "2", "1000", "79", "1", "2781.180000000000", "602"),("49510", "2", "1000", "364", "1", "83.950000000000", "603"),("192311", "-100", "1000", "570", "1", "54.580000000000", "604"),("79580", "2", "19", "369", "1", "257.060000000000", "605"),("87367", "2", "16", "100", "1", "13.450000000000", "606"),("165537", "1", "10", "644", "1", "25.130000000000", "607"),("165542", "1", "10", "644", "1", "25.130000000000", "608"),("165551", "1", "10", "644", "1", "25.130000000000", "609"),("165552", "1", "10", "644", "1", "25.130000000000", "610"),("165549", "1", "9", "644", "1", "25.130000000000", "611"),("165535", "1", "8", "644", "1", "25.130000000000", "612"),("165550", "1", "8", "644", "1", "25.130000000000", "613"),("165534", "1", "7", "644", "1", "25.130000000000", "614"),("165548", "1", "7", "644", "1", "25.130000000000", "615"),("165533", "1", "5", "644", "1", "25.130000000000", "616"),("237173", "1", "3", "476", "1", "39.870000000000", "617"),("100230", "1", "2", "20", "1", "19.240000000000", "618"),("57120", "2", "1", "285", "1", "6.300000000000", "619"),("184683", "1", "1", "469", "1", "38.320000000000", "620"),("166506", "2", "1", "228", "1", "105.800000000000", "621"),("100352", "1", "1", "47", "1", "26.530000000000", "622"),("9446", "1", "1213", "12", "1", "4.730000000000", "623"),("163181", "1", "1050", "455", "1", "6.050000000000", "624"),("107083", "1", "1022", "168", "1", "18.870000000000", "625"),("131397", "2", "1021", "168", "1", "18.870000000000", "626"),("107081", "1", "1017", "168", "1", "18.870000000000", "627"),("48371", "4", "1013", "13", "1", "165.460000000000", "628"),("216679", "1", "1009", "138", "1", "19.240000000000", "629"),("2382", "10", "1009", "13", "1", "7.980000000000", "630"),("143375", "2", "1007", "73", "1", "27.210000000000", "631"),("166254", "1", "1004", "47", "1", "85.710000000000", "632"),("77661", "2", "1003", "20", "1", "19.790000000000", "633"),("77659", "2", "1003", "20", "1", "19.790000000000", "634"),("205835", "4", "1003", "476", "1", "126.010000000000", "635"),("67382", "2", "1003", "168", "1", "1437.700000000000", "636"),("16461", "2", "1002", "42", "1", "10.920000000000", "637"),("50785", "2", "1002", "42", "1", "8.400000000000", "638"),("77660", "2", "1002", "20", "1", "19.790000000000", "639"),("16441", "2", "1002", "42", "1", "18.490000000000", "640"),("200507", "2", "1002", "13", "1", "61.260000000000", "641"),("48372", "10", "1002", "13", "1", "176.390000000000", "642"),("215737", "2", "1002", "656", "1", "44.150000000000", "643"),("85155", "2", "1002", "75", "1", "13.360000000000", "644"),("85157", "2", "1002", "75", "1", "13.360000000000", "645"),("92763", "2", "1002", "20", "1", "26.920000000000", "646"),("122565", "4", "1002", "24", "1", "63.780000000000", "647"),("216681", "1", "1002", "138", "1", "19.240000000000", "648"),("211679", "2", "1002", "559", "1", "30.170000000000", "649"),("11989", "2", "1002", "24", "1", "10.080000000000", "650"),("19584", "2", "1001", "42", "1", "12.610000000000", "651"),("16454", "2", "1001", "42", "1", "15.130000000000", "652"),("57091", "2", "1001", "15", "1", "48.860000000000", "653"),("57104", "2", "1001", "15", "1", "81.490000000000", "654"),("57105", "2", "1001", "15", "1", "81.200000000000", "655"),("179813", "1", "1001", "464", "1", "195.800000000000", "656"),("16460", "2", "1001", "42", "1", "10.920000000000", "657"),("16458", "2", "1001", "42", "1", "13.450000000000", "658"),("64711", "2", "1001", "206", "1", "24.370000000000", "659"),("178066", "2", "1001", "174", "1", "360.500000000000", "660"),("64716", "2", "1001", "206", "1", "24.370000000000", "661"),("239770", "2", "1001", "801", "1", "96.060000000000", "662"),("85159", "2", "1001", "75", "1", "13.360000000000", "663"),("94572", "10", "1001", "271", "1", "100.660000000000", "664"),("109700", "2", "1001", "236", "1", "15.700000000000", "665"),("200123", "1", "1001", "224", "1", "24.290000000000", "666"),("19551", "2", "1000", "42", "1", "15.550000000000", "667"),("19554", "2", "1000", "42", "1", "15.550000000000", "668"),("19555", "2", "1000", "42", "1", "15.550000000000", "669"),("19561", "2", "1000", "42", "1", "17.650000000000", "670"),("19563", "2", "1000", "42", "1", "17.650000000000", "671"),("19564", "2", "1000", "42", "1", "17.650000000000", "672"),("19565", "2", "1000", "42", "1", "17.650000000000", "673"),("19579", "2", "1000", "42", "1", "8.400000000000", "674"),("19581", "2", "1000", "42", "1", "8.400000000000", "675"),("19585", "2", "1000", "42", "1", "12.610000000000", "676"),("19591", "2", "1000", "42", "1", "15.130000000000", "677"),("8371", "2", "1000", "42", "1", "113.450000000000", "678"),("8372", "2", "1000", "42", "1", "125.210000000000", "679"),("16443", "2", "1000", "42", "1", "15.970000000000", "680"),("16446", "2", "1000", "42", "1", "14.290000000000", "681"),("16448", "2", "1000", "42", "1", "14.290000000000", "682"),("20749", "2", "1000", "42", "1", "51.260000000000", "683"),("57106", "2", "1000", "15", "1", "68.710000000000", "684"),("79353", "2", "1000", "42", "1", "17.650000000000", "685"),("205683", "1", "1000", "476", "1", "73.490000000000", "686"),("205685", "1", "1000", "476", "1", "79.790000000000", "687"),("205687", "1", "1000", "476", "1", "105.000000000000", "688"),("205693", "1", "1000", "476", "1", "100.800000000000", "689"),("205695", "1", "1000", "476", "1", "92.390000000000", "690"),("205697", "1", "1000", "476", "1", "88.190000000000", "691"),("205699", "1", "1000", "476", "1", "83.990000000000", "692"),("178071", "2", "1000", "174", "1", "825.210000000000", "693"),("232962", "10", "1000", "533", "1", "63.890000000000", "694"),("118920", "2", "1000", "73", "1", "27.210000000000", "695"),("65740", "2", "1000", "73", "1", "21.440000000000", "696"),("19598", "2", "1000", "42", "1", "6.720000000000", "697"),("79357", "2", "1000", "42", "1", "15.970000000000", "698"),("16463", "2", "1000", "42", "1", "9.660000000000", "699"),("64715", "2", "1000", "206", "1", "24.370000000000", "700"),("64717", "2", "1000", "206", "1", "24.370000000000", "701"),("241732", "1", "1000", "617", "1", "104.450000000000", "702"),("175678", "1", "1000", "124", "1", "98.440000000000", "703"),("242893", "1", "1000", "357", "1", "22.650000000000", "704"),("57090", "2", "1000", "15", "1", "50.390000000000", "705"),("64713", "2", "1000", "206", "1", "26.890000000000", "706"),("112783", "10", "1000", "73", "1", "85.870000000000", "707"),("112784", "10", "1000", "73", "1", "85.870000000000", "708"),("233768", "1", "1000", "357", "1", "16.080000000000", "709"),("24393", "10", "1000", "266", "1", "303.320000000000", "710"),("26784", "2", "1000", "75", "1", "11.090000000000", "711"),("27573", "2", "1000", "49", "1", "10.500000000000", "712"),("27574", "2", "1000", "49", "1", "10.500000000000", "713"),("38980", "2", "1000", "75", "1", "11.090000000000", "714"),("81326", "10", "1000", "82", "1", "145.460000000000", "715"),("85158", "2", "1000", "75", "1", "13.360000000000", "716"),("85160", "2", "1000", "75", "1", "13.360000000000", "717"),("85161", "2", "1000", "75", "1", "13.360000000000", "718"),("85162", "2", "1000", "75", "1", "13.360000000000", "719"),("92762", "2", "1000", "20", "1", "26.920000000000", "720"),("92764", "2", "1000", "20", "1", "26.920000000000", "721"),("92769", "2", "1000", "20", "1", "26.920000000000", "722"),("92770", "2", "1000", "20", "1", "26.920000000000", "723"),("94540", "10", "1000", "271", "1", "42.690000000000", "724"),("94903", "10", "1000", "271", "1", "49.640000000000", "725"),("94905", "4", "1000", "271", "1", "43.270000000000", "726"),("95635", "2", "1000", "20", "1", "26.920000000000", "727"),("109699", "2", "1000", "236", "1", "15.700000000000", "728"),("110854", "10", "1000", "262", "1", "368.340000000000", "729"),("168053", "10", "1000", "157", "1", "796.560000000000", "730"),("73221", "2", "1000", "464", "1", "25.970000000000", "731"),("49556", "2", "1000", "366", "1", "151.180000000000", "732"),("179810", "1", "1000", "464", "1", "99.080000000000", "733"),("180028", "4", "1000", "369", "1", "181.430000000000", "734"),("180309", "2", "1000", "464", "1", "38.570000000000", "735"),("180310", "2", "1000", "464", "1", "52.860000000000", "736"),("180509", "2", "1000", "676", "1", "102.440000000000", "737"),("200119", "1", "1000", "224", "1", "24.290000000000", "738"),("200121", "1", "1000", "224", "1", "24.290000000000", "739"),("200131", "1", "1000", "224", "1", "15.460000000000", "740"),("200133", "1", "1000", "224", "1", "15.460000000000", "741"),("200135", "1", "1000", "224", "1", "15.880000000000", "742"),("2383", "10", "1000", "13", "1", "16.810000000000", "743"),("2384", "2", "1000", "13", "1", "19.660000000000", "744"),("2385", "10", "1000", "13", "1", "22.610000000000", "745"),("48373", "10", "1000", "13", "1", "185.630000000000", "746"),("163182", "1", "1000", "455", "1", "6.810000000000", "747"),("174377", "2", "1000", "168", "1", "38.540000000000", "748"),("96728", "2", "1000", "455", "1", "125.510000000000", "749"),("211665", "2", "1000", "559", "1", "29.330000000000", "750"),("129041", "-100", "31", "570", "1", "83.950000000000", "751"),("91619", "2", "23", "100", "1", "8.400000000000", "752"),("120338", "4", "22", "28", "1", "24.370000000000", "753"),("91621", "2", "20", "100", "1", "8.400000000000", "754"),("4610", "2", "13", "95", "1", "27.730000000000", "755"),("91620", "2", "11", "100", "1", "8.400000000000", "756"),("4609", "2", "11", "95", "1", "25.210000000000", "757"),("40486", "2", "10", "45", "1", "4.960000000000", "758"),("4611", "2", "9", "95", "1", "27.730000000000", "759"),("94627", "2", "5", "271", "1", "1.700000000000", "760"),("40474", "2", "5", "45", "1", "4.960000000000", "761"),("116335", "1", "4", "391", "1", "12.660000000000", "762"),("92771", "2", "3", "20", "1", "19.240000000000", "763"),("64718", "2", "1", "206", "1", "17.560000000000", "764"),("76396", "2", "1", "469", "1", "107.560000000000", "765"),("37552", "2", "1", "47", "1", "13.360000000000", "766"),("79361", "2", "1", "42", "1", "28.570000000000", "767"),("95638", "2", "1", "20", "1", "19.240000000000", "768"),("169386", "1", "1", "54", "1", "73.950000000000", "769"),("22169", "2", "1049", "12", "1", "4.730000000000", "770"),("65775", "2", "1020", "163", "1", "8.030000000000", "771"),("11738", "2", "1018", "73", "1", "20.310000000000", "772"),("39598", "10", "1016", "45", "1", "2.940000000000", "773"),("121235", "1", "1010", "85", "1", "18.490000000000", "774"),("65727", "2", "1010", "73", "1", "20.310000000000", "775"),("22166", "2", "1009", "12", "1", "4.970000000000", "776"),("235603", "1", "1009", "370", "1", "8.130000000000", "777"),("11737", "2", "1009", "73", "1", "20.310000000000", "778"),("235604", "1", "1008", "370", "1", "8.460000000000", "779"),("156481", "1", "1008", "517", "1", "8.080000000000", "780"),("188919", "1", "1007", "517", "1", "16.150000000000", "781"),("188917", "1", "1006", "517", "1", "11.400000000000", "782"),("79519", "2", "1006", "42", "1", "5.040000000000", "783"),("10814", "2", "1006", "24", "1", "44.450000000000", "784"),("174759", "1", "1004", "423", "1", "4.120000000000", "785"),("1747", "4", "1004", "13", "1", "88.990000000000", "786"),("196439", "1", "1003", "20", "1", "30.180000000000", "787"),("196441", "1", "1003", "20", "1", "30.180000000000", "788"),("196443", "1", "1003", "20", "1", "30.180000000000", "789"),("196445", "1", "1003", "20", "1", "30.180000000000", "790"),("240425", "2", "1003", "20", "1", "17.840000000000", "791"),("240426", "2", "1003", "20", "1", "17.840000000000", "792"),("1179", "2", "1003", "19", "1", "54.890000000000", "793"),("174761", "1", "1003", "423", "1", "4.120000000000", "794"),("79628", "2", "1002", "42", "1", "14.290000000000", "795"),("124875", "2", "1002", "289", "1", "15.130000000000", "796"),("103168", "2", "1002", "15", "1", "63.850000000000", "797"),("36895", "2", "1002", "206", "1", "16.810000000000", "798"),("21516", "2", "1002", "236", "1", "14.530000000000", "799"),("92761", "2", "1002", "20", "1", "45.200000000000", "800"),("57004", "2", "1002", "15", "1", "22.900000000000", "801"),("235300", "2", "1002", "85", "1", "105.040000000000", "802"),("103172", "2", "1001", "15", "1", "83.430000000000", "803"),("101025", "2", "1001", "117", "1", "91.600000000000", "804"),("11726", "2", "1001", "19", "1", "46.860000000000", "805"),("49987", "10", "1001", "376", "1", "285.600000000000", "806"),("27471", "2", "1001", "49", "1", "50.340000000000", "807"),("110767", "2", "1001", "79", "1", "192.520000000000", "808"),("69667", "2", "1001", "24", "1", "15.880000000000", "809"),("211675", "2", "1001", "559", "1", "29.330000000000", "810"),("64124", "2", "1000", "15", "1", "34.420000000000", "811"),("79627", "2", "1000", "42", "1", "13.870000000000", "812"),("79630", "2", "1000", "42", "1", "13.450000000000", "813"),("79521", "2", "1000", "42", "1", "5.040000000000", "814"),("103171", "2", "1000", "15", "1", "81.200000000000", "815"),("96461", "2", "1000", "24", "1", "1484.870000000000", "816"),("160611", "1", "1000", "583", "1", "575.630000000000", "817"),("211349", "1", "1000", "476", "1", "19.290000000000", "818"),("210103", "1", "1000", "476", "1", "105.000000000000", "819"),("210131", "1", "1000", "476", "1", "88.190000000000", "820"),("210133", "1", "1000", "476", "1", "83.990000000000", "821"),("210137", "1", "1000", "476", "1", "79.790000000000", "822"),("219162", "2", "1000", "15", "1", "46.330000000000", "823"),("198209", "2", "1000", "119", "1", "150.540000000000", "824"),("205457", "1", "1000", "476", "1", "294.080000000000", "825"),("192703", "1", "1000", "725", "1", "558.440000000000", "826"),("216177", "2", "1000", "656", "1", "4614.250000000000", "827"),("21946", "2", "1000", "73", "1", "20.310000000000", "828"),("21956", "2", "1000", "73", "1", "21.950000000000", "829"),("121237", "1", "1000", "85", "1", "20.170000000000", "830"),("79520", "2", "1000", "42", "1", "5.040000000000", "831"),("79522", "2", "1000", "42", "1", "5.040000000000", "832"),("216175", "2", "1000", "656", "1", "4393.490000000000", "833"),("177274", "10", "1000", "174", "1", "1200.000000000000", "834"),("177272", "10", "1000", "174", "1", "825.210000000000", "835"),("235299", "2", "1000", "85", "1", "105.040000000000", "836"),("103169", "2", "1000", "15", "1", "65.660000000000", "837"),("79625", "2", "1000", "42", "1", "13.450000000000", "838"),("177273", "10", "1000", "174", "1", "863.030000000000", "839"),("21247", "2", "1000", "236", "1", "15.700000000000", "840"),("21248", "2", "1000", "236", "1", "15.700000000000", "841"),("21249", "2", "1000", "236", "1", "15.700000000000", "842"),("21517", "2", "1000", "236", "1", "14.530000000000", "843"),("21518", "2", "1000", "236", "1", "14.530000000000", "844"),("36733", "2", "1000", "19", "1", "23.070000000000", "845"),("84806", "10", "1000", "157", "1", "20.180000000000", "846"),("84817", "4", "1000", "157", "1", "137.130000000000", "847"),("93563", "2", "1000", "115", "1", "88.150000000000", "848"),("94577", "10", "1000", "271", "1", "160.170000000000", "849"),("94582", "10", "1000", "271", "1", "219.680000000000", "850"),("94902", "10", "1000", "271", "1", "31.590000000000", "851"),("106547", "1", "1000", "50", "1", "26.810000000000", "852"),("106548", "1", "1000", "50", "1", "26.810000000000", "853"),("106549", "1", "1000", "50", "1", "26.810000000000", "854"),("106550", "1", "1000", "50", "1", "26.810000000000", "855"),("106552", "1", "1000", "50", "1", "26.810000000000", "856"),("209319", "2", "1000", "75", "1", "51.180000000000", "857"),("196363", "2", "1000", "20", "1", "27.170000000000", "858"),("196365", "2", "1000", "20", "1", "27.170000000000", "859"),("197153", "1", "1000", "271", "1", "231.850000000000", "860"),("125629", "4", "1000", "24", "1", "31.850000000000", "861"),("148181", "2", "1000", "188", "1", "38.570000000000", "862"),("179812", "1", "1000", "464", "1", "122.610000000000", "863"),("180379", "2", "1000", "682", "1", "67.980000000000", "864"),("223638", "-100", "1000", "768", "1", "38.570000000000", "865"),("223639", "-100", "1000", "768", "1", "25.970000000000", "866"),("213919", "1", "1000", "224", "1", "33.530000000000", "867"),("213921", "1", "1000", "224", "1", "25.130000000000", "868"),("200125", "1", "1000", "224", "1", "18.400000000000", "869"),("200127", "1", "1000", "224", "1", "18.400000000000", "870"),("200129", "1", "1000", "224", "1", "18.400000000000", "871"),("1748", "10", "1000", "13", "1", "98.240000000000", "872"),("1749", "10", "1000", "13", "1", "120.920000000000", "873"),("1750", "10", "1000", "13", "1", "143.610000000000", "874"),("1751", "10", "1000", "13", "1", "154.870000000000", "875"),("82361", "2", "1000", "168", "1", "3630.970000000000", "876"),("211673", "2", "1000", "559", "1", "29.330000000000", "877"),("103170", "2", "1000", "15", "1", "77.030000000000", "878"),("235301", "2", "1000", "85", "1", "105.040000000000", "879"),("22167", "2", "79", "12", "1", "4.510000000000", "880"),("132929", "-100", "36", "26", "1", "8.320000000000", "881"),("45968", "2", "30", "12", "1", "4.510000000000", "882"),("132931", "-100", "28", "26", "1", "8.320000000000", "883"),("152273", "2", "17", "469", "1", "21.760000000000", "884"),("86533", "2", "14", "353", "1", "15.850000000000", "885"),("49652", "2", "9", "369", "1", "136.970000000000", "886"),("152061", "1", "6", "469", "1", "8.320000000000", "887"),("4635", "2", "6", "95", "1", "25.130000000000", "888"),("4636", "2", "5", "95", "1", "25.130000000000", "889"),("91648", "2", "5", "100", "1", "8.400000000000", "890"),("165186", "2", "4", "369", "1", "163.030000000000", "891"),("65776", "2", "4", "163", "1", "8.030000000000", "892"),("57003", "2", "3", "15", "1", "16.720000000000", "893"),("57075", "2", "3", "15", "1", "24.290000000000", "894"),("79633", "2", "2", "42", "1", "14.290000000000", "895"),("57599", "2", "2", "229", "1", "987.390000000000", "896"),("126769", "1", "2", "217", "1", "17.560000000000", "897"),("178046", "4", "1", "13", "1", "167.980000000000", "898"),("113038", "2", "1", "13", "1", "100.760000000000", "899"),("175170", "1", "1", "528", "1", "5.040000000000", "900"),("169527", "2", "1", "88", "1", "47.820000000000", "901"),("57071", "2", "1", "15", "1", "24.290000000000", "902"),("57072", "2", "1", "15", "1", "24.290000000000", "903"),("22163", "2", "1017", "12", "1", "4.950000000000", "904"),("145765", "2", "1017", "437", "1", "6.300000000000", "905"),("36092", "2", "1013", "71", "1", "4.710000000000", "906"),("185075", "2", "1012", "168", "1", "13.570000000000", "907"),("188927", "1", "1011", "517", "1", "14.520000000000", "908"),("92768", "2", "1010", "20", "1", "26.920000000000", "909"),("127651", "2", "1010", "73", "1", "11.640000000000", "910"),("153267", "1", "1009", "517", "1", "8.080000000000", "911"),("237449", "1", "1009", "13", "1", "8.320000000000", "912"),("131395", "2", "1008", "168", "1", "19.630000000000", "913"),("14458", "2", "1007", "115", "1", "15.130000000000", "914"),("174767", "1", "1007", "423", "1", "4.370000000000", "915"),("219123", "1", "1006", "13", "1", "80.590000000000", "916"),("219128", "1", "1006", "13", "1", "92.350000000000", "917"),("21990", "2", "1006", "73", "1", "13.630000000000", "918"),("219126", "1", "1006", "13", "1", "83.950000000000", "919"),("181883", "2", "1005", "168", "1", "34.000000000000", "920"),("185245", "1", "1005", "168", "1", "18.110000000000", "921"),("14459", "2", "1004", "115", "1", "10.500000000000", "922"),("228533", "2", "1004", "13", "1", "75.550000000000", "923"),("228535", "2", "1004", "13", "1", "83.950000000000", "924"),("219132", "1", "1004", "13", "1", "109.160000000000", "925"),("237092", "2", "1004", "559", "1", "29.410000000000", "926"),("22085", "2", "1004", "85", "1", "131.090000000000", "927"),("163819", "1", "1004", "13", "1", "8.320000000000", "928"),("240423", "2", "1003", "20", "1", "28.040000000000", "929"),("240424", "2", "1003", "20", "1", "28.040000000000", "930"),("240428", "1", "1003", "20", "1", "17.840000000000", "931"),("186273", "2", "1003", "19", "1", "49.480000000000", "932"),("215885", "1", "1003", "654", "1", "11.680000000000", "933"),("240432", "1", "1002", "20", "1", "17.840000000000", "934"),("242467", "2", "1002", "559", "1", "29.410000000000", "935"),("240431", "1", "1002", "20", "1", "17.840000000000", "936"),("21989", "2", "1002", "73", "1", "17.470000000000", "937"),("237450", "1", "1002", "13", "1", "7.480000000000", "938"),("36728", "2", "1002", "19", "1", "54.890000000000", "939"),("110758", "2", "1002", "79", "1", "137.340000000000", "940"),("181885", "2", "1002", "168", "1", "34.760000000000", "941"),("51267", "2", "1001", "42", "1", "13.450000000000", "942"),("51279", "2", "1001", "42", "1", "14.710000000000", "943"),("128045", "2", "1001", "587", "1", "18.320000000000", "944"),("176435", "2", "1001", "20", "1", "29.970000000000", "945"),("176436", "2", "1001", "20", "1", "29.970000000000", "946"),("176438", "2", "1001", "20", "1", "29.970000000000", "947"),("217277", "10", "1001", "476", "1", "126.010000000000", "948"),("237088", "2", "1001", "559", "1", "29.410000000000", "949"),("237089", "2", "1001", "559", "1", "29.410000000000", "950"),("219131", "1", "1001", "13", "1", "97.390000000000", "951"),("240433", "1", "1001", "20", "1", "17.840000000000", "952"),("166909", "2", "1001", "54", "1", "95.800000000000", "953"),("240430", "1", "1001", "20", "1", "17.840000000000", "954"),("209523", "1", "1001", "423", "1", "6.390000000000", "955"),("177306", "10", "1001", "174", "1", "199.160000000000", "956"),("29213", "2", "1001", "49", "1", "9.330000000000", "957"),("94554", "10", "1001", "266", "1", "12.350000000000", "958"),("183337", "10", "1001", "158", "1", "39.660000000000", "959"),("96462", "2", "1001", "24", "1", "94.030000000000", "960"),("240429", "1", "1001", "20", "1", "17.840000000000", "961"),("40657", "2", "1000", "42", "1", "8.400000000000", "962"),("51274", "2", "1000", "42", "1", "15.130000000000", "963"),("51275", "2", "1000", "42", "1", "13.450000000000", "964"),("51280", "2", "1000", "42", "1", "16.390000000000", "965"),("51281", "2", "1000", "42", "1", "14.710000000000", "966"),("51282", "2", "1000", "42", "1", "16.390000000000", "967"),("51285", "2", "1000", "42", "1", "17.650000000000", "968"),("51286", "2", "1000", "42", "1", "20.170000000000", "969"),("51287", "2", "1000", "42", "1", "17.650000000000", "970"),("71357", "2", "1000", "285", "1", "11.160000000000", "971"),("128043", "2", "1000", "587", "1", "18.320000000000", "972"),("128055", "2", "1000", "587", "1", "18.320000000000", "973"),("128057", "2", "1000", "587", "1", "18.320000000000", "974"),("128059", "2", "1000", "587", "1", "18.320000000000", "975"),("172427", "2", "1000", "120", "1", "14.970000000000", "976"),("182149", "2", "1000", "587", "1", "18.320000000000", "977"),("205747", "1", "1000", "476", "1", "16.760000000000", "978"),("205749", "1", "1000", "476", "1", "16.760000000000", "979"),("211343", "1", "1000", "476", "1", "19.290000000000", "980"),("212669", "1", "1000", "370", "1", "6.530000000000", "981"),("210371", "1", "1000", "476", "1", "19.290000000000", "982"),("194073", "1", "1000", "533", "1", "210.170000000000", "983"),("221291", "1", "1000", "357", "1", "18.870000000000", "984"),("204641", "1", "1000", "423", "1", "7.140000000000", "985"),("204643", "1", "1000", "423", "1", "4.030000000000", "986"),("201121", "2", "1000", "540", "1", "10.760000000000", "987"),("201123", "2", "1000", "540", "1", "10.760000000000", "988"),("201125", "2", "1000", "540", "1", "10.760000000000", "989"),("201127", "2", "1000", "540", "1", "10.760000000000", "990"),("201129", "2", "1000", "540", "1", "10.760000000000", "991"),("201131", "2", "1000", "540", "1", "11.680000000000", "992"),("201133", "2", "1000", "540", "1", "12.180000000000", "993"),("201135", "2", "1000", "540", "1", "12.180000000000", "994"),("201137", "2", "1000", "540", "1", "12.180000000000", "995"),("212677", "1", "1000", "370", "1", "9.220000000000", "996"),("21974", "2", "1000", "73", "1", "21.440000000000", "997"),("112578", "2", "1000", "73", "1", "27.210000000000", "998"),("156487", "1", "1000", "517", "1", "8.080000000000", "999"),("37498", "2", "1000", "204", "1", "10.080000000000", "1000")

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

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

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

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

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

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

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