Căutare

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

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 ("30145", "2", "0", "117", "1", "30.000000000000", "1"),("29770", "2", "0", "117", "1", "29.000000000000", "2"),("29825", "2", "0", "117", "1", "29.000000000000", "3"),("100083", "1", "0", "117", "1", "32.000000000000", "4"),("10054", "2", "9", "100", "1", "15.270400000000", "5"),("5268", "2", "6", "100", "1", "15.270400000000", "6"),("816", "-100", "45", "26", "1", "23.372800000000", "7"),("815", "-100", "35", "26", "1", "13.977600000000", "8"),("818", "-100", "33", "26", "1", "9.280000000000", "9"),("4730", "2", "12", "28", "1", "48.435200000000", "10"),("4731", "2", "8", "28", "1", "14.092800000000", "11"),("4729", "2", "8", "28", "1", "22.310400000000", "12"),("2966", "2", "7", "28", "1", "8.217600000000", "13"),("237379", "2", "6", "28", "1", "17.612800000000", "14"),("193311", "-100", "4", "26", "1", "45.209600000000", "15"),("237378", "2", "3", "28", "1", "17.612800000000", "16"),("237380", "2", "6", "28", "1", "17.612800000000", "17"),("163497", "1", "1000", "75", "1", "27.008000000000", "18"),("5157", "2", "10", "69", "1", "35.225600000000", "19"),("5158", "2", "10", "69", "1", "18.790400000000", "20"),("189157", "2", "12", "625", "1", "17.612800000000", "21"),("189153", "2", "10", "625", "1", "17.612800000000", "22"),("189155", "2", "5", "625", "1", "17.612800000000", "23"),("243519", "2", "1000", "162", "1", "31.470000000000", "24"),("243522", "2", "1000", "162", "1", "31.470000000000", "25"),("200529", "2", "3", "625", "1", "17.612800000000", "26"),("2109", "-100", "30", "26", "1", "29.235200000000", "27"),("2113", "-100", "21", "26", "1", "29.235200000000", "28"),("2105", "-100", "19", "26", "1", "29.235200000000", "29"),("2112", "-100", "18", "26", "1", "29.235200000000", "30"),("2103", "-100", "15", "26", "1", "29.235200000000", "31"),("100136", "1", "13", "28", "1", "15.270400000000", "32"),("4542", "2", "13", "28", "1", "15.270400000000", "33"),("4546", "2", "12", "28", "1", "15.270400000000", "34"),("4531", "2", "11", "28", "1", "15.270400000000", "35"),("4532", "2", "10", "28", "1", "15.270400000000", "36"),("36309", "2", "9", "28", "1", "15.270400000000", "37"),("47784", "2", "8", "28", "1", "15.270400000000", "38"),("4547", "2", "6", "28", "1", "11.443200000000", "39"),("2114", "-100", "4", "26", "1", "29.235200000000", "40"),("4543", "2", "1", "28", "1", "11.443200000000", "41"),("243521", "2", "1000", "162", "1", "31.470000000000", "42"),("189159", "2", "6", "625", "1", "17.612800000000", "43"),("29962", "2", "1000", "117", "1", "39.500000000000", "44"),("111924", "-100", "80", "26", "1", "27.008000000000", "45"),("65859", "2", "33", "28", "1", "15.270400000000", "46"),("2111", "-100", "29", "26", "1", "29.235200000000", "47"),("5327", "-100", "26", "26", "1", "16.435200000000", "48"),("2104", "-100", "17", "26", "1", "29.235200000000", "49"),("86399", "2", "15", "28", "1", "15.270400000000", "50"),("237607", "-100", "12", "26", "1", "23.372800000000", "51"),("5307", "2", "10", "100", "1", "22.310400000000", "52"),("181761", "2", "10", "100", "1", "24.665600000000", "53"),("48469", "2", "9", "100", "1", "17.612800000000", "54"),("181763", "2", "9", "100", "1", "11.737600000000", "55"),("237606", "-100", "3", "26", "1", "23.372800000000", "56"),("237609", "-100", "2", "26", "1", "23.372800000000", "57"),("65334", "2", "1", "28", "1", "16.204800000000", "58"),("64546", "2", "1", "100", "1", "15.270400000000", "59"),("4530", "2", "1", "28", "1", "11.443200000000", "60"),("112586", "2", "1001", "162", "1", "99.456000000000", "61"),("112587", "2", "1001", "162", "1", "99.456000000000", "62"),("98330", "2", "1001", "117", "1", "43.700000000000", "63"),("37834", "2", "1000", "49", "1", "42.020000000000", "64"),("26445", "2", "1000", "162", "1", "58.828800000000", "65"),("112585", "2", "1000", "162", "1", "99.456000000000", "66"),("124059", "2", "1000", "117", "1", "35.290000000000", "67"),("30774", "2", "1000", "117", "1", "41.180000000000", "68"),("36396", "2", "16", "100", "1", "17.612800000000", "69"),("6564", "-100", "16", "26", "1", "35.110400000000", "70"),("6563", "-100", "14", "26", "1", "35.110400000000", "71"),("190215", "1", "12", "100", "1", "11.737600000000", "72"),("86343", "2", "12", "28", "1", "19.968000000000", "73"),("163504", "1", "11", "100", "1", "15.270400000000", "74"),("6569", "-100", "11", "26", "1", "35.110400000000", "75"),("6572", "-100", "11", "26", "1", "35.110400000000", "76"),("6567", "-100", "10", "26", "1", "35.110400000000", "77"),("237608", "-100", "8", "26", "1", "23.372800000000", "78"),("36395", "2", "6", "100", "1", "17.612800000000", "79"),("10512", "2", "2", "178", "1", "34.060800000000", "80"),("213237", "2", "1004", "162", "1", "75.590000000000", "81"),("87490", "2", "1003", "468", "1", "26.892800000000", "82"),("26971", "2", "1003", "178", "1", "90.419200000000", "83"),("11697", "2", "1003", "62", "1", "39.104000000000", "84"),("11696", "2", "1001", "62", "1", "39.104000000000", "85"),("147669", "1", "1001", "117", "1", "41.180000000000", "86"),("11698", "2", "1001", "62", "1", "39.104000000000", "87"),("37833", "2", "1000", "49", "1", "42.020000000000", "88"),("123979", "2", "1000", "337", "1", "52.940000000000", "89"),("129681", "2", "1000", "75", "1", "50.496000000000", "90"),("137169", "1", "1000", "296", "1", "32.770000000000", "91"),("33950", "2", "1000", "162", "1", "58.368000000000", "92"),("118878", "2", "1000", "162", "1", "29.610000000000", "93"),("180869", "2", "1000", "162", "1", "35.400000000000", "94"),("128321", "2", "1000", "162", "1", "82.009600000000", "95"),("68487", "2", "1000", "162", "1", "63.240000000000", "96"),("68492", "2", "1000", "162", "1", "29.310000000000", "97"),("213233", "2", "1000", "162", "1", "99.059200000000", "98"),("213235", "2", "1000", "162", "1", "99.456000000000", "99"),("213239", "2", "1000", "162", "1", "99.059200000000", "100"),("98863", "2", "1000", "117", "1", "35.290000000000", "101"),("98881", "2", "1000", "117", "1", "38.660000000000", "102"),("99631", "2", "1000", "117", "1", "43.700000000000", "103"),("170899", "1", "1000", "117", "1", "41.180000000000", "104"),("228735", "2", "1000", "117", "1", "37.820000000000", "105"),("228736", "2", "1000", "117", "1", "37.820000000000", "106"),("222918", "1", "1000", "117", "1", "66.390000000000", "107"),("207755", "1", "1000", "117", "1", "37.820000000000", "108"),("112584", "2", "1000", "162", "1", "99.456000000000", "109"),("11700", "2", "1000", "62", "1", "39.104000000000", "110"),("11701", "2", "1000", "62", "1", "44.774400000000", "111"),("11702", "2", "1000", "62", "1", "44.774400000000", "112"),("1969", "-100", "15", "26", "1", "10.457600000000", "113"),("1976", "-100", "14", "26", "1", "10.457600000000", "114"),("148243", "2", "14", "100", "1", "11.737600000000", "115"),("4871", "2", "14", "28", "1", "18.790400000000", "116"),("6570", "-100", "12", "26", "1", "35.110400000000", "117"),("1977", "-100", "12", "26", "1", "10.457600000000", "118"),("119566", "2", "12", "100", "1", "34.060800000000", "119"),("86346", "2", "11", "28", "1", "19.968000000000", "120"),("1973", "-100", "11", "26", "1", "10.457600000000", "121"),("148241", "2", "10", "100", "1", "11.737600000000", "122"),("4869", "2", "9", "28", "1", "11.737600000000", "123"),("86344", "2", "9", "28", "1", "19.968000000000", "124"),("148229", "2", "7", "100", "1", "11.737600000000", "125"),("119567", "2", "7", "100", "1", "34.060800000000", "126"),("4868", "2", "7", "28", "1", "34.060800000000", "127"),("119561", "2", "6", "100", "1", "34.060800000000", "128"),("237417", "2", "6", "28", "1", "29.363200000000", "129"),("150717", "2", "5", "100", "1", "34.060800000000", "130"),("207811", "-100", "3", "26", "1", "92.774400000000", "131"),("148237", "2", "3", "100", "1", "11.737600000000", "132"),("1967", "-100", "3", "26", "1", "10.457600000000", "133"),("150725", "2", "2", "100", "1", "34.060800000000", "134"),("117665", "2", "1", "162", "1", "60.761600000000", "135"),("148239", "2", "1", "100", "1", "11.737600000000", "136"),("68745", "2", "1008", "30", "1", "17.024000000000", "137"),("61344", "2", "1008", "30", "1", "17.024000000000", "138"),("61342", "2", "1007", "30", "1", "17.024000000000", "139"),("61407", "2", "1007", "30", "1", "17.024000000000", "140"),("61343", "2", "1006", "30", "1", "17.024000000000", "141"),("237115", "2", "1006", "30", "1", "17.024000000000", "142"),("61397", "2", "1006", "30", "1", "17.024000000000", "143"),("68581", "2", "1006", "73", "1", "108.569600000000", "144"),("61395", "2", "1005", "30", "1", "17.024000000000", "145"),("61402", "2", "1005", "30", "1", "17.024000000000", "146"),("61396", "2", "1005", "30", "1", "17.024000000000", "147"),("68752", "2", "1004", "30", "1", "17.024000000000", "148"),("114196", "2", "1004", "30", "1", "17.024000000000", "149"),("61345", "2", "1002", "30", "1", "17.024000000000", "150"),("114072", "2", "1002", "30", "1", "14.092800000000", "151"),("145227", "2", "1002", "162", "1", "49.203200000000", "152"),("114049", "2", "1002", "30", "1", "14.092800000000", "153"),("61399", "2", "1002", "30", "1", "17.024000000000", "154"),("114077", "2", "1001", "30", "1", "14.092800000000", "155"),("114053", "2", "1001", "30", "1", "14.092800000000", "156"),("106387", "1", "1001", "75", "1", "18.560000000000", "157"),("11699", "2", "1001", "62", "1", "39.104000000000", "158"),("179924", "1", "1000", "589", "1", "47.060000000000", "159"),("224220", "1", "1000", "337", "1", "47.900000000000", "160"),("230370", "1", "1000", "353", "1", "34.000000000000", "161"),("26431", "2", "1000", "162", "1", "88.371200000000", "162"),("26442", "2", "1000", "162", "1", "56.486400000000", "163"),("145193", "2", "1000", "162", "1", "88.396800000000", "164"),("145195", "2", "1000", "162", "1", "88.396800000000", "165"),("117002", "2", "1000", "162", "1", "63.692800000000", "166"),("117005", "2", "1000", "162", "1", "102.131200000000", "167"),("68560", "2", "1000", "162", "1", "29.610000000000", "168"),("68561", "2", "1000", "162", "1", "29.610000000000", "169"),("213231", "2", "1000", "162", "1", "99.059200000000", "170"),("99133", "2", "1000", "117", "1", "70.590000000000", "171"),("99153", "4", "1000", "117", "1", "83.190000000000", "172"),("99536", "2", "1000", "117", "1", "48.740000000000", "173"),("147483", "1", "1000", "117", "1", "36.970000000000", "174"),("158167", "2", "1000", "117", "1", "53.780000000000", "175"),("228725", "2", "1000", "117", "1", "37.820000000000", "176"),("219148", "1", "1000", "117", "1", "66.390000000000", "177"),("222913", "1", "1000", "117", "1", "66.390000000000", "178"),("243057", "2", "1000", "162", "1", "67.180000000000", "179"),("243059", "2", "1000", "162", "1", "67.180000000000", "180"),("243120", "2", "1000", "162", "1", "75.590000000000", "181"),("243149", "2", "1000", "162", "1", "41.970000000000", "182"),("61394", "2", "1000", "30", "1", "17.024000000000", "183"),("114048", "2", "1000", "30", "1", "14.092800000000", "184"),("114068", "2", "1000", "30", "1", "14.092800000000", "185"),("68562", "2", "1000", "62", "1", "27.980000000000", "186"),("114051", "2", "1000", "30", "1", "14.092800000000", "187"),("114054", "2", "1000", "30", "1", "14.092800000000", "188"),("100148", "1", "37", "28", "1", "19.968000000000", "189"),("1968", "-100", "24", "26", "1", "10.457600000000", "190"),("6566", "-100", "18", "26", "1", "35.110400000000", "191"),("1975", "-100", "13", "26", "1", "10.457600000000", "192"),("119562", "2", "10", "100", "1", "34.060800000000", "193"),("176813", "2", "10", "100", "1", "41.100800000000", "194"),("119565", "2", "9", "100", "1", "34.060800000000", "195"),("119564", "2", "8", "100", "1", "34.060800000000", "196"),("237394", "2", "7", "28", "1", "19.968000000000", "197"),("166756", "2", "6", "100", "1", "34.060800000000", "198"),("240197", "2", "5", "342", "1", "52.838400000000", "199"),("222237", "2", "5", "342", "1", "29.363200000000", "200"),("47519", "2", "5", "342", "1", "29.363200000000", "201"),("192065", "2", "3", "100", "1", "34.060800000000", "202"),("106389", "1", "2", "75", "1", "18.560000000000", "203"),("103019", "1", "2", "354", "1", "52.608000000000", "204"),("150723", "2", "1", "100", "1", "34.060800000000", "205"),("47527", "2", "1", "342", "1", "41.100800000000", "206"),("244553", "1", "2", "351", "1", "78.681600000000", "207"),("61346", "2", "1008", "30", "1", "17.024000000000", "208"),("63044", "2", "1008", "30", "1", "17.024000000000", "209"),("68753", "10", "1007", "30", "1", "17.024000000000", "210"),("61401", "2", "1006", "30", "1", "17.024000000000", "211"),("63043", "2", "1004", "30", "1", "17.024000000000", "212"),("61406", "2", "1004", "30", "1", "17.024000000000", "213"),("61356", "2", "1002", "30", "1", "14.092800000000", "214"),("61384", "2", "1002", "30", "1", "14.092800000000", "215"),("63045", "2", "1002", "30", "1", "14.092800000000", "216"),("114047", "2", "1001", "30", "1", "14.092800000000", "217"),("114070", "2", "1001", "30", "1", "14.092800000000", "218"),("114074", "2", "1001", "30", "1", "14.092800000000", "219"),("63046", "2", "1001", "30", "1", "14.092800000000", "220"),("114078", "2", "1001", "30", "1", "14.092800000000", "221"),("99062", "2", "1001", "117", "1", "45.380000000000", "222"),("61351", "2", "1000", "30", "1", "14.092800000000", "223"),("114071", "2", "1000", "30", "1", "14.092800000000", "224"),("230366", "1", "1000", "353", "1", "34.000000000000", "225"),("61382", "2", "1000", "30", "1", "14.092800000000", "226"),("61381", "2", "1000", "30", "1", "14.092800000000", "227"),("230371", "1", "1000", "353", "1", "34.000000000000", "228"),("68754", "2", "1000", "30", "1", "14.092800000000", "229"),("68755", "2", "1000", "30", "1", "14.092800000000", "230"),("98660", "2", "1000", "117", "1", "83.190000000000", "231"),("99043", "2", "1000", "117", "1", "66.390000000000", "232"),("99090", "2", "1000", "117", "1", "70.590000000000", "233"),("175480", "1", "1000", "178", "1", "24.370000000000", "234"),("175916", "1", "1000", "117", "1", "47.900000000000", "235"),("175941", "1", "1000", "117", "1", "49.580000000000", "236"),("175964", "1", "1000", "117", "1", "45.380000000000", "237"),("106388", "1", "1000", "75", "1", "18.560000000000", "238"),("243153", "2", "1000", "162", "1", "50.380000000000", "239"),("61372", "2", "1000", "30", "1", "14.092800000000", "240"),("114069", "2", "1000", "30", "1", "14.092800000000", "241"),("114075", "2", "1000", "30", "1", "14.092800000000", "242"),("114067", "2", "997", "30", "1", "14.092800000000", "243"),("86365", "2", "18", "28", "1", "19.968000000000", "244"),("150719", "2", "12", "100", "1", "34.060800000000", "245"),("148247", "2", "11", "100", "1", "11.737600000000", "246"),("114076", "2", "10", "30", "1", "14.092800000000", "247"),("131483", "1", "8", "565", "1", "35.225600000000", "248"),("119560", "2", "7", "100", "1", "34.060800000000", "249"),("237415", "2", "7", "28", "1", "34.060800000000", "250"),("216369", "2", "6", "28", "1", "34.060800000000", "251"),("237381", "2", "5", "28", "1", "22.310400000000", "252"),("216373", "2", "5", "28", "1", "34.060800000000", "253"),("131487", "1", "4", "565", "1", "35.225600000000", "254"),("237382", "2", "4", "28", "1", "22.310400000000", "255"),("66589", "2", "3", "342", "1", "37.580800000000", "256"),("131489", "1", "3", "565", "1", "35.225600000000", "257"),("61548", "2", "2", "30", "1", "17.612800000000", "258"),("150721", "2", "2", "100", "1", "34.060800000000", "259"),("61355", "2", "2", "30", "1", "14.092800000000", "260"),("87489", "2", "2", "468", "1", "26.892800000000", "261"),("228986", "1", "2", "351", "1", "74.688000000000", "262"),("49139", "2", "1", "351", "1", "87.961600000000", "263"),("61543", "2", "1", "30", "1", "17.612800000000", "264"),("79361", "2", "1001", "42", "1", "28.570000000000", "265"),("117799", "1", "1008", "487", "1", "25.830400000000", "266"),("117798", "1", "1007", "487", "1", "25.830400000000", "267"),("117800", "1", "1005", "487", "1", "26.892800000000", "268"),("61373", "2", "1003", "30", "1", "14.092800000000", "269"),("12439", "2", "1002", "178", "1", "88.076800000000", "270"),("61358", "2", "1001", "30", "1", "14.092800000000", "271"),("174093", "1", "1001", "30", "1", "20.170000000000", "272"),("61379", "2", "1001", "30", "1", "14.092800000000", "273"),("61390", "2", "1000", "30", "1", "14.092800000000", "274"),("61391", "2", "1000", "30", "1", "14.092800000000", "275"),("68273", "2", "1000", "141", "1", "57.536000000000", "276"),("68274", "2", "1000", "141", "1", "52.262400000000", "277"),("148101", "2", "1000", "30", "1", "25.830400000000", "278"),("114073", "2", "1000", "30", "1", "14.092800000000", "279"),("87509", "2", "1000", "468", "1", "26.892800000000", "280"),("174097", "1", "1000", "30", "1", "20.170000000000", "281"),("237025", "1", "1000", "589", "1", "41.180000000000", "282"),("174099", "1", "1000", "30", "1", "20.170000000000", "283"),("175699", "1", "1000", "117", "1", "35.290000000000", "284"),("61362", "2", "1000", "30", "1", "14.092800000000", "285"),("61546", "2", "1000", "30", "1", "17.612800000000", "286"),("137247", "2", "1000", "296", "1", "32.770000000000", "287"),("114189", "2", "10", "30", "1", "17.024000000000", "288"),("192067", "2", "8", "100", "1", "34.060800000000", "289"),("200483", "2", "7", "28", "1", "34.060800000000", "290"),("216371", "2", "4", "28", "1", "34.060800000000", "291"),("131485", "1", "2", "565", "1", "35.225600000000", "292"),("216367", "2", "2", "28", "1", "34.060800000000", "293"),("237383", "2", "2", "28", "1", "22.310400000000", "294"),("49140", "2", "1", "351", "1", "87.961600000000", "295"),("174098", "1", "1", "30", "1", "20.170000000000", "296"),("117801", "1", "1006", "487", "1", "25.830400000000", "297"),("101225", "1", "1004", "167", "1", "37.580800000000", "298"),("148107", "2", "1003", "30", "1", "25.830400000000", "299"),("148111", "2", "1002", "30", "1", "25.830400000000", "300"),("51986", "2", "1001", "167", "1", "14.796800000000", "301"),("51999", "2", "1000", "167", "1", "37.580800000000", "302"),("52000", "2", "1000", "167", "1", "37.580800000000", "303"),("217609", "1", "1000", "370", "1", "21.390000000000", "304"),("217611", "1", "1000", "370", "1", "21.390000000000", "305"),("148103", "2", "1000", "30", "1", "25.830400000000", "306"),("217607", "1", "1000", "370", "1", "21.390000000000", "307"),("220214", "1", "1000", "654", "1", "20.672000000000", "308"),("51983", "2", "1000", "167", "1", "14.796800000000", "309"),("148105", "2", "1000", "30", "1", "25.830400000000", "310"),("81588", "2", "12", "69", "1", "23.488000000000", "311"),("81592", "2", "9", "69", "1", "23.488000000000", "312"),("51696", "2", "9", "69", "1", "23.488000000000", "313"),("5083", "2", "9", "69", "1", "17.612800000000", "314"),("5091", "2", "7", "69", "1", "17.612800000000", "315"),("35094", "2", "7", "69", "1", "17.612800000000", "316"),("200481", "2", "7", "28", "1", "34.060800000000", "317"),("81590", "2", "6", "69", "1", "23.488000000000", "318"),("5096", "2", "5", "69", "1", "17.612800000000", "319"),("192063", "2", "5", "100", "1", "34.060800000000", "320"),("81594", "2", "4", "69", "1", "23.488000000000", "321"),("81587", "2", "4", "69", "1", "23.488000000000", "322"),("178193", "1", "1003", "167", "1", "37.580800000000", "323"),("101224", "1", "1002", "167", "1", "37.580800000000", "324"),("129677", "1", "1001", "75", "1", "25.241600000000", "325"),("148109", "2", "1001", "30", "1", "25.830400000000", "326"),("51987", "2", "1001", "167", "1", "10.590000000000", "327"),("51985", "2", "1001", "167", "1", "14.796800000000", "328"),("52002", "2", "1000", "167", "1", "26.890000000000", "329"),("166256", "2", "1000", "141", "1", "45.798400000000", "330"),("166250", "2", "1000", "141", "1", "54.016000000000", "331"),("217613", "1", "1000", "370", "1", "21.390000000000", "332"),("217615", "1", "1000", "370", "1", "21.390000000000", "333"),("223651", "1", "1000", "296", "1", "36.130000000000", "334"),("5176", "2", "14", "69", "1", "35.225600000000", "335"),("5093", "2", "11", "69", "1", "17.612800000000", "336"),("51695", "2", "10", "69", "1", "23.488000000000", "337"),("3389", "2", "10", "69", "1", "15.270400000000", "338"),("5177", "2", "8", "69", "1", "18.790400000000", "339"),("51694", "2", "5", "69", "1", "23.488000000000", "340"),("81591", "2", "4", "69", "1", "23.488000000000", "341"),("81589", "2", "3", "69", "1", "23.488000000000", "342"),("81595", "2", "2", "69", "1", "23.488000000000", "343"),("159023", "1", "2", "75", "1", "15.270400000000", "344"),("159017", "1", "1", "75", "1", "15.270400000000", "345"),("159019", "1", "1", "75", "1", "15.270400000000", "346"),("51995", "2", "1002", "167", "1", "18.905600000000", "347"),("91446", "2", "1001", "167", "1", "41.100800000000", "348"),("51989", "2", "1000", "167", "1", "18.905600000000", "349"),("91428", "2", "1000", "167", "1", "41.100800000000", "350"),("91429", "2", "1000", "167", "1", "50.496000000000", "351"),("91430", "2", "1000", "167", "1", "41.100800000000", "352"),("91431", "2", "1000", "167", "1", "41.100800000000", "353"),("91432", "2", "1000", "167", "1", "41.100800000000", "354"),("91433", "2", "1000", "167", "1", "41.100800000000", "355"),("91434", "2", "1000", "167", "1", "41.100800000000", "356"),("91437", "2", "1000", "167", "1", "41.100800000000", "357"),("91438", "2", "1000", "167", "1", "41.100800000000", "358"),("91439", "2", "1000", "167", "1", "23.488000000000", "359"),("91443", "2", "1000", "167", "1", "41.100800000000", "360"),("91444", "2", "1000", "167", "1", "41.100800000000", "361"),("230369", "1", "1000", "353", "1", "34.000000000000", "362"),("200487", "2", "8", "28", "1", "34.060800000000", "363"),("164370", "2", "8", "69", "1", "76.326400000000", "364"),("112093", "1", "6", "178", "1", "50.496000000000", "365"),("91442", "2", "1", "167", "1", "41.100800000000", "366"),("16417", "2", "1000", "42", "1", "19.330000000000", "367"),("16423", "2", "1000", "42", "1", "24.370000000000", "368"),("16425", "2", "1000", "42", "1", "28.570000000000", "369"),("16427", "2", "1000", "42", "1", "35.290000000000", "370"),("44520", "2", "1000", "296", "1", "32.770000000000", "371"),("91440", "2", "1000", "167", "1", "41.100800000000", "372"),("91441", "2", "1000", "167", "1", "25.830400000000", "373"),("177071", "2", "7", "69", "1", "23.488000000000", "374"),("225599", "2", "5", "625", "1", "28.185600000000", "375"),("225604", "2", "5", "625", "1", "28.185600000000", "376"),("225598", "2", "4", "625", "1", "28.185600000000", "377"),("225603", "2", "4", "625", "1", "28.185600000000", "378"),("225600", "2", "2", "625", "1", "28.185600000000", "379"),("225602", "2", "2", "625", "1", "28.185600000000", "380"),("91427", "2", "1000", "167", "1", "41.100800000000", "381"),("98298", "2", "1000", "117", "1", "83.190000000000", "382"),("88159", "2", "1000", "178", "1", "45.798400000000", "383"),("44351", "2", "1000", "296", "1", "32.770000000000", "384"),("44350", "2", "1000", "296", "1", "32.770000000000", "385"),("225601", "2", "4", "625", "1", "28.185600000000", "386"),("88160", "2", "1", "178", "1", "45.798400000000", "387"),("177072", "2", "1", "69", "1", "23.488000000000", "388"),("16435", "2", "1003", "42", "1", "35.290000000000", "389"),("16431", "2", "1000", "42", "1", "21.850000000000", "390"),("16432", "2", "1000", "42", "1", "24.370000000000", "391"),("226634", "2", "1000", "185", "1", "36.130000000000", "392"),("165338", "1", "1000", "467", "1", "6.640000000000", "393"),("128681", "1", "1000", "150", "1", "73.840000000000", "394"),("147643", "1", "1000", "117", "1", "36.970000000000", "395"),("147645", "1", "1000", "117", "1", "36.970000000000", "396"),("134875", "1", "1000", "117", "1", "41.180000000000", "397"),("77372", "2", "1", "354", "1", "23.488000000000", "398"),("129523", "2", "1", "75", "1", "17.612800000000", "399"),("137977", "2", "1000", "583", "1", "49.580000000000", "400"),("132829", "2", "1001", "467", "1", "11.680000000000", "401"),("158027", "1", "1001", "177", "1", "21.010000000000", "402"),("118115", "2", "1000", "105", "1", "16.810000000000", "403"),("98556", "2", "1000", "117", "1", "66.390000000000", "404"),("158049", "1", "1000", "177", "1", "15.970000000000", "405"),("181777", "2", "5", "100", "1", "31.705600000000", "406"),("77371", "2", "1", "354", "1", "23.488000000000", "407"),("228578", "1", "1000", "150", "1", "210.250000000000", "408"),("219484", "1", "1000", "753", "1", "1012.440000000000", "409"),("236003", "2", "1000", "224", "1", "70.590000000000", "410"),("236004", "2", "1000", "224", "1", "73.110000000000", "411"),("99673", "1", "1000", "17", "1", "294.200000000000", "412"),("117781", "2", "1000", "117", "1", "51.260000000000", "413"),("36399", "2", "10", "100", "1", "28.185600000000", "414"),("132825", "2", "1", "467", "1", "8.660000000000", "415"),("147829", "2", "1001", "17", "1", "258.740000000000", "416"),("197353", "10", "1001", "709", "1", "171.000000000000", "417"),("232769", "1", "1000", "338", "1", "881.510000000000", "418"),("232770", "1", "1000", "338", "1", "839.500000000000", "419"),("147795", "2", "1000", "17", "1", "309.330000000000", "420"),("147797", "2", "1000", "17", "1", "294.200000000000", "421"),("147827", "2", "1000", "17", "1", "309.330000000000", "422"),("147831", "2", "1000", "17", "1", "310.080000000000", "423"),("147833", "2", "1000", "17", "1", "316.890000000000", "424"),("240980", "1", "1000", "17", "1", "368.910000000000", "425"),("240983", "1", "1000", "17", "1", "360.500000000000", "426"),("240986", "1", "1000", "17", "1", "352.100000000000", "427"),("240987", "1", "1000", "17", "1", "352.100000000000", "428"),("240990", "1", "1000", "17", "1", "343.700000000000", "429"),("147801", "2", "1000", "17", "1", "294.200000000000", "430"),("36400", "2", "8", "100", "1", "28.185600000000", "431"),("36397", "2", "6", "100", "1", "28.185600000000", "432"),("1009", "2", "1008", "27", "1", "11.737600000000", "433"),("174495", "1", "1002", "487", "1", "17.650000000000", "434"),("147835", "2", "1001", "17", "1", "258.740000000000", "435"),("146873", "1", "1001", "17", "1", "316.810000000000", "436"),("141403", "1", "1001", "17", "1", "309.330000000000", "437"),("224484", "2", "1000", "338", "1", "1151.260000000000", "438"),("224485", "2", "1000", "338", "1", "1151.260000000000", "439"),("240971", "1", "1000", "17", "1", "394.120000000000", "440"),("240972", "1", "1000", "17", "1", "377.310000000000", "441"),("240973", "1", "1000", "17", "1", "377.310000000000", "442"),("240974", "1", "1000", "17", "1", "377.310000000000", "443"),("240978", "1", "1000", "17", "1", "368.910000000000", "444"),("240985", "1", "1000", "17", "1", "360.500000000000", "445"),("36398", "2", "13", "100", "1", "28.185600000000", "446"),("178473", "1", "1001", "487", "1", "20.902400000000", "447"),("174577", "1", "1000", "487", "1", "12.610000000000", "448"),("21967", "2", "1008", "73", "1", "18.950000000000", "449"),("230291", "2", "1000", "42", "1", "67.230000000000", "450"),("230293", "2", "1000", "42", "1", "109.240000000000", "451"),("204607", "1", "1000", "487", "1", "14.092800000000", "452"),("232840", "2", "1000", "224", "1", "15.130000000000", "453"),("232841", "2", "1000", "224", "1", "10.080000000000", "454"),("232842", "2", "1000", "224", "1", "10.080000000000", "455"),("235801", "2", "1000", "224", "1", "90.760000000000", "456"),("168215", "1", "1000", "150", "1", "63.520000000000", "457"),("240982", "1", "1000", "17", "1", "360.500000000000", "458"),("240989", "1", "1000", "17", "1", "352.100000000000", "459"),("240991", "1", "1000", "17", "1", "343.700000000000", "460"),("244183", "1", "1000", "117", "1", "60.500000000000", "461"),("244182", "1", "1000", "117", "1", "60.500000000000", "462"),("244190", "1", "1000", "117", "1", "91.600000000000", "463"),("8780", "2", "1002", "42", "1", "147.060000000000", "464"),("21976", "2", "1012", "73", "1", "23.070000000000", "465"),("21969", "2", "1003", "73", "1", "21.440000000000", "466"),("71185", "2", "1002", "42", "1", "47.900000000000", "467"),("146085", "2", "1001", "20", "1", "5.090000000000", "468"),("146087", "2", "1001", "20", "1", "5.090000000000", "469"),("229751", "2", "1000", "42", "1", "167.230000000000", "470"),("146095", "2", "1000", "20", "1", "9.360000000000", "471"),("146089", "2", "1000", "20", "1", "5.090000000000", "472"),("146091", "2", "1000", "20", "1", "5.090000000000", "473"),("47598", "2", "6", "12", "1", "5.290000000000", "474"),("48817", "2", "5", "160", "1", "13.260000000000", "475"),("46076", "2", "3", "12", "1", "14.410000000000", "476"),("46077", "2", "1", "12", "1", "14.410000000000", "477"),("48820", "2", "1005", "73", "1", "21.440000000000", "478"),("8781", "2", "1003", "42", "1", "166.390000000000", "479"),("37919", "2", "1002", "12", "1", "14.200000000000", "480"),("68043", "2", "1002", "11", "1", "9.240000000000", "481"),("8782", "2", "1001", "42", "1", "176.470000000000", "482"),("68041", "2", "1001", "11", "1", "16.180000000000", "483"),("68042", "2", "1001", "11", "1", "8.580000000000", "484"),("68044", "2", "1001", "11", "1", "15.080000000000", "485"),("22271", "2", "1000", "163", "1", "19.710000000000", "486"),("68106", "2", "1000", "163", "1", "8.030000000000", "487"),("79559", "2", "1000", "42", "1", "92.440000000000", "488"),("79561", "2", "1000", "42", "1", "121.850000000000", "489"),("95061", "2", "1000", "163", "1", "0.940000000000", "490"),("48819", "2", "1000", "73", "1", "21.440000000000", "491"),("21972", "2", "1000", "73", "1", "22.540000000000", "492"),("68094", "2", "1000", "160", "1", "19.410000000000", "493"),("68095", "2", "1000", "160", "1", "18.820000000000", "494"),("37895", "2", "1000", "163", "1", "1.420000000000", "495"),("68093", "2", "1000", "160", "1", "19.410000000000", "496"),("79560", "2", "1000", "42", "1", "100.840000000000", "497"),("95647", "2", "1000", "20", "1", "5.760000000000", "498"),("45973", "2", "2", "11", "1", "19.710000000000", "499"),("45960", "2", "1071", "12", "1", "1.400000000000", "500"),("137739", "1", "1021", "160", "1", "11.680000000000", "501"),("137735", "1", "1021", "160", "1", "11.680000000000", "502"),("33818", "2", "1015", "160", "1", "11.640000000000", "503"),("21992", "2", "1010", "73", "1", "21.440000000000", "504"),("33819", "2", "1010", "160", "1", "11.640000000000", "505"),("9609", "2", "1008", "73", "1", "17.480000000000", "506"),("33821", "2", "1007", "160", "1", "11.640000000000", "507"),("137747", "1", "1006", "160", "1", "11.680000000000", "508"),("137745", "1", "1006", "160", "1", "11.680000000000", "509"),("9498", "2", "1005", "19", "1", "54.130000000000", "510"),("9501", "2", "1005", "19", "1", "48.720000000000", "511"),("9608", "2", "1005", "73", "1", "17.480000000000", "512"),("21978", "2", "1003", "73", "1", "16.720000000000", "513"),("22309", "2", "1003", "163", "1", "3.820000000000", "514"),("77661", "2", "1003", "20", "1", "19.790000000000", "515"),("33820", "2", "1003", "160", "1", "11.640000000000", "516"),("77659", "2", "1003", "20", "1", "19.790000000000", "517"),("9503", "2", "1002", "19", "1", "48.720000000000", "518"),("137743", "1", "1002", "160", "1", "11.680000000000", "519"),("77660", "2", "1002", "20", "1", "19.790000000000", "520"),("9502", "2", "1002", "19", "1", "48.720000000000", "521"),("8361", "2", "1001", "42", "1", "125.210000000000", "522"),("8374", "2", "1001", "42", "1", "172.270000000000", "523"),("8360", "2", "1001", "42", "1", "113.450000000000", "524"),("8370", "2", "1001", "42", "1", "109.240000000000", "525"),("8379", "2", "1001", "42", "1", "142.860000000000", "526"),("159963", "2", "1001", "49", "1", "486.550000000000", "527"),("84521", "2", "1001", "163", "1", "24.180000000000", "528"),("92377", "2", "1001", "73", "1", "27.200000000000", "529"),("17867", "2", "1000", "42", "1", "61.340000000000", "530"),("17868", "2", "1000", "42", "1", "67.230000000000", "531"),("8368", "2", "1000", "42", "1", "79.830000000000", "532"),("8369", "2", "1000", "42", "1", "83.190000000000", "533"),("8371", "2", "1000", "42", "1", "113.450000000000", "534"),("8372", "2", "1000", "42", "1", "125.210000000000", "535"),("8375", "2", "1000", "42", "1", "205.880000000000", "536"),("8438", "2", "1000", "42", "1", "398.320000000000", "537"),("8439", "2", "1000", "42", "1", "465.550000000000", "538"),("22308", "2", "1000", "163", "1", "3.930000000000", "539"),("54347", "2", "1000", "49", "1", "1134.450000000000", "540"),("54348", "2", "1000", "49", "1", "1420.170000000000", "541"),("79562", "2", "1000", "42", "1", "116.810000000000", "542"),("84519", "2", "1000", "163", "1", "24.180000000000", "543"),("84520", "2", "1000", "163", "1", "24.180000000000", "544"),("158721", "1", "1000", "123", "1", "26.990000000000", "545"),("159407", "2", "1000", "49", "1", "352.940000000000", "546"),("159953", "2", "1000", "49", "1", "218.490000000000", "547"),("159957", "2", "1000", "49", "1", "403.360000000000", "548"),("159959", "2", "1000", "49", "1", "521.010000000000", "549"),("22316", "2", "1000", "163", "1", "3.580000000000", "550"),("22314", "2", "1000", "163", "1", "3.270000000000", "551"),("100111", "2", "1000", "271", "1", "5.300000000000", "552"),("36696", "2", "1000", "160", "1", "11.680000000000", "553"),("49789", "2", "1000", "54", "1", "30.210000000000", "554"),("54345", "2", "1000", "49", "1", "634.450000000000", "555"),("54346", "2", "1000", "49", "1", "941.180000000000", "556"),("22310", "2", "1000", "163", "1", "3.270000000000", "557"),("22313", "2", "1000", "163", "1", "3.270000000000", "558"),("159961", "2", "1000", "49", "1", "361.340000000000", "559"),("159965", "2", "1000", "49", "1", "647.060000000000", "560"),("159967", "2", "1000", "49", "1", "815.130000000000", "561"),("36697", "2", "1000", "160", "1", "11.680000000000", "562"),("92723", "2", "1000", "271", "1", "8.450000000000", "563"),("92725", "2", "1000", "271", "1", "8.450000000000", "564"),("22315", "2", "1000", "163", "1", "3.580000000000", "565"),("77458", "2", "1000", "73", "1", "21.440000000000", "566"),("48708", "2", "1000", "54", "1", "30.210000000000", "567"),("48709", "2", "1000", "54", "1", "30.210000000000", "568"),("48728", "2", "1000", "54", "1", "30.210000000000", "569"),("48822", "2", "1000", "73", "1", "38.890000000000", "570"),("37552", "2", "1", "47", "1", "13.360000000000", "571"),("92722", "2", "1", "271", "1", "3.920000000000", "572"),("22169", "2", "1051", "12", "1", "4.730000000000", "573"),("45968", "2", "1038", "12", "1", "4.510000000000", "574"),("11738", "2", "1020", "73", "1", "20.310000000000", "575"),("36702", "2", "1018", "73", "1", "27.200000000000", "576"),("36700", "2", "1013", "73", "1", "27.200000000000", "577"),("36701", "2", "1011", "73", "1", "27.200000000000", "578"),("22030", "2", "1011", "73", "1", "19.490000000000", "579"),("33826", "2", "1010", "160", "1", "11.680000000000", "580"),("11737", "2", "1008", "73", "1", "20.310000000000", "581"),("21993", "2", "1006", "73", "1", "33.040000000000", "582"),("33824", "2", "1006", "160", "1", "11.680000000000", "583"),("36692", "2", "1005", "160", "1", "11.680000000000", "584"),("68707", "2", "1005", "11", "1", "32.800000000000", "585"),("33827", "2", "1005", "160", "1", "11.680000000000", "586"),("25598", "2", "1002", "19", "1", "12.870000000000", "587"),("31719", "2", "1001", "42", "1", "80.670000000000", "588"),("20942", "2", "1001", "42", "1", "28.490000000000", "589"),("20960", "2", "1000", "42", "1", "38.660000000000", "590"),("31720", "2", "1000", "42", "1", "141.180000000000", "591"),("37927", "2", "1000", "12", "1", "5.720000000000", "592"),("76817", "2", "1000", "475", "1", "789.920000000000", "593"),("106221", "2", "1000", "49", "1", "1109.240000000000", "594"),("68698", "2", "1000", "11", "1", "32.800000000000", "595"),("36733", "2", "1000", "19", "1", "22.310000000000", "596"),("106220", "2", "1000", "49", "1", "764.710000000000", "597"),("68704", "2", "1000", "11", "1", "32.800000000000", "598"),("50952", "2", "1000", "42", "1", "113.450000000000", "599"),("46032", "2", "1000", "58", "1", "26.890000000000", "600"),("21946", "2", "1000", "73", "1", "20.310000000000", "601"),("21956", "2", "1000", "73", "1", "21.950000000000", "602"),("146077", "2", "1000", "73", "1", "25.090000000000", "603"),("146079", "2", "1000", "73", "1", "25.090000000000", "604"),("36695", "2", "1000", "160", "1", "11.680000000000", "605"),("97457", "2", "1000", "73", "1", "17.480000000000", "606"),("106222", "2", "1000", "49", "1", "1613.450000000000", "607"),("106223", "2", "1000", "49", "1", "1957.980000000000", "608"),("132311", "1", "1000", "20", "1", "18.230000000000", "609"),("37928", "2", "1000", "12", "1", "6.270000000000", "610"),("36703", "2", "998", "73", "1", "27.200000000000", "611"),("65727", "2", "14", "73", "1", "20.310000000000", "612"),("33775", "2", "11", "73", "1", "27.200000000000", "613"),("36693", "2", "10", "160", "1", "11.680000000000", "614"),("21977", "2", "6", "73", "1", "15.430000000000", "615"),("9500", "2", "5", "19", "1", "54.130000000000", "616"),("101606", "1", "1", "42", "1", "192.440000000000", "617"),("94324", "2", "1", "12", "1", "6.050000000000", "618"),("243611", "2", "1000", "73", "1", "10.460000000000", "619"),("243615", "2", "1000", "73", "1", "11.720000000000", "620"),("243613", "2", "1000", "73", "1", "11.720000000000", "621"),("93966", "2", "1018", "73", "1", "36.940000000000", "622"),("127235", "1", "1017", "73", "1", "15.580000000000", "623"),("49571", "2", "1015", "73", "1", "19.480000000000", "624"),("127247", "1", "1014", "73", "1", "14.760000000000", "625"),("127249", "1", "1012", "73", "1", "14.760000000000", "626"),("97458", "2", "1012", "73", "1", "23.070000000000", "627"),("93965", "2", "1011", "73", "1", "36.940000000000", "628"),("127243", "1", "1010", "73", "1", "14.760000000000", "629"),("9607", "2", "1008", "73", "1", "17.480000000000", "630"),("127651", "2", "1006", "73", "1", "11.640000000000", "631"),("49572", "2", "1005", "73", "1", "19.490000000000", "632"),("68705", "2", "1004", "11", "1", "32.800000000000", "633"),("25600", "2", "1004", "19", "1", "12.870000000000", "634"),("25720", "2", "1003", "19", "1", "13.070000000000", "635"),("25601", "2", "1002", "19", "1", "12.870000000000", "636"),("25595", "2", "1002", "19", "1", "12.870000000000", "637"),("25597", "2", "1002", "19", "1", "12.870000000000", "638"),("33855", "2", "1001", "19", "1", "19.000000000000", "639"),("20924", "2", "1000", "42", "1", "41.180000000000", "640"),("20971", "2", "1000", "42", "1", "54.620000000000", "641"),("20975", "2", "1000", "42", "1", "61.340000000000", "642"),("91697", "2", "1000", "371", "1", "43.240000000000", "643"),("104185", "2", "1000", "42", "1", "142.020000000000", "644"),("175863", "1", "1000", "238", "1", "853.090000000000", "645"),("175864", "1", "1000", "238", "1", "853.090000000000", "646"),("175865", "1", "1000", "238", "1", "853.090000000000", "647"),("175866", "1", "1000", "238", "1", "853.090000000000", "648"),("175867", "1", "1000", "238", "1", "853.090000000000", "649"),("175874", "1", "1000", "238", "1", "131.360000000000", "650"),("163629", "1", "1000", "238", "1", "913.280000000000", "651"),("163631", "1", "1000", "238", "1", "1004.610000000000", "652"),("163624", "1", "1000", "238", "1", "913.280000000000", "653"),("25710", "2", "1000", "19", "1", "15.480000000000", "654"),("25711", "2", "1000", "19", "1", "15.480000000000", "655"),("25712", "2", "1000", "19", "1", "15.480000000000", "656"),("68584", "2", "1000", "11", "1", "32.800000000000", "657"),("68585", "2", "1000", "11", "1", "32.800000000000", "658"),("33856", "2", "1000", "19", "1", "19.000000000000", "659"),("68101", "2", "1000", "47", "1", "9.010000000000", "660"),("68103", "2", "1000", "47", "1", "7.810000000000", "661"),("68104", "2", "1000", "47", "1", "7.080000000000", "662"),("21974", "2", "1000", "73", "1", "21.440000000000", "663"),("95510", "2", "1000", "160", "1", "9.720000000000", "664"),("25722", "2", "1000", "19", "1", "19.000000000000", "665"),("36894", "2", "1000", "11", "1", "32.390000000000", "666"),("68139", "2", "1000", "11", "1", "28.000000000000", "667"),("48804", "2", "1000", "85", "1", "21.340000000000", "668"),("48805", "2", "1000", "85", "1", "21.340000000000", "669"),("94312", "2", "75", "12", "1", "9.460000000000", "670"),("49573", "2", "31", "73", "1", "19.490000000000", "671"),("127239", "1", "11", "73", "1", "15.580000000000", "672"),("92594", "2", "6", "85", "1", "40.340000000000", "673"),("127245", "1", "5", "73", "1", "12.860000000000", "674"),("48863", "2", "5", "85", "1", "13.450000000000", "675"),("92576", "2", "5", "73", "1", "38.890000000000", "676"),("25599", "2", "4", "19", "1", "12.870000000000", "677"),("93967", "2", "3", "73", "1", "36.940000000000", "678"),("33895", "2", "2", "19", "1", "16.890000000000", "679"),("94479", "2", "1", "19", "1", "9.930000000000", "680"),("92593", "2", "1", "85", "1", "36.970000000000", "681"),("25721", "2", "1019", "19", "1", "13.870000000000", "682"),("49576", "2", "1015", "73", "1", "27.920000000000", "683"),("49579", "2", "1015", "73", "1", "27.640000000000", "684"),("25594", "2", "1010", "19", "1", "12.870000000000", "685"),("49574", "2", "1009", "73", "1", "27.920000000000", "686"),("25590", "2", "1009", "19", "1", "12.060000000000", "687"),("49575", "2", "1008", "73", "1", "27.920000000000", "688"),("25717", "2", "1008", "19", "1", "13.870000000000", "689"),("91536", "2", "1007", "11", "1", "32.800000000000", "690"),("21968", "2", "1006", "73", "1", "35.670000000000", "691"),("131933", "1", "1005", "73", "1", "27.640000000000", "692"),("25709", "2", "1005", "19", "1", "12.870000000000", "693"),("91535", "2", "1004", "11", "1", "24.870000000000", "694"),("25705", "2", "1004", "19", "1", "13.770000000000", "695"),("131937", "1", "1003", "73", "1", "21.440000000000", "696"),("25596", "2", "1002", "19", "1", "12.870000000000", "697"),("25704", "2", "1002", "19", "1", "13.770000000000", "698"),("92393", "2", "1001", "20", "1", "11.990000000000", "699"),("91699", "2", "1001", "371", "1", "43.240000000000", "700"),("93424", "2", "1001", "42", "1", "175.630000000000", "701"),("94246", "2", "1001", "20", "1", "5.030000000000", "702"),("20987", "2", "1000", "42", "1", "42.020000000000", "703"),("20991", "2", "1000", "42", "1", "42.860000000000", "704"),("68038", "2", "1000", "85", "1", "13.660000000000", "705"),("77658", "2", "1000", "20", "1", "19.790000000000", "706"),("91692", "2", "1000", "371", "1", "40.380000000000", "707"),("91693", "2", "1000", "371", "1", "40.380000000000", "708"),("91694", "2", "1000", "371", "1", "40.380000000000", "709"),("91695", "2", "1000", "371", "1", "40.380000000000", "710"),("91698", "2", "1000", "371", "1", "43.240000000000", "711"),("91702", "2", "1000", "371", "1", "43.240000000000", "712"),("175875", "1", "1000", "238", "1", "131.360000000000", "713"),("179507", "2", "1000", "603", "1", "62.180000000000", "714"),("229293", "2", "1000", "583", "1", "52.940000000000", "715"),("229294", "2", "1000", "583", "1", "52.940000000000", "716"),("229297", "2", "1000", "583", "1", "52.940000000000", "717"),("229298", "2", "1000", "583", "1", "52.940000000000", "718"),("25703", "2", "1000", "19", "1", "13.770000000000", "719"),("25730", "2", "1000", "19", "1", "13.570000000000", "720"),("92228", "2", "1000", "19", "1", "12.360000000000", "721"),("92229", "2", "1000", "19", "1", "12.360000000000", "722"),("36708", "2", "1000", "19", "1", "13.570000000000", "723"),("49777", "2", "1000", "19", "1", "10.350000000000", "724"),("49577", "2", "1000", "73", "1", "27.900000000000", "725"),("48635", "2", "1000", "19", "1", "9.950000000000", "726"),("25702", "2", "1000", "19", "1", "13.770000000000", "727"),("25756", "2", "1000", "19", "1", "13.170000000000", "728"),("17907", "2", "1000", "42", "1", "24.370000000000", "729"),("229465", "2", "1000", "42", "1", "24.370000000000", "730"),("228544", "1", "1000", "13", "1", "20.920000000000", "731"),("25757", "2", "1000", "19", "1", "13.170000000000", "732"),("49776", "2", "1000", "19", "1", "10.350000000000", "733"),("21886", "2", "30", "47", "1", "21.850000000000", "734"),("25718", "2", "23", "19", "1", "13.870000000000", "735"),("49578", "2", "11", "73", "1", "27.900000000000", "736"),("25591", "2", "9", "19", "1", "12.060000000000", "737"),("25593", "2", "3", "19", "1", "10.210000000000", "738"),("25754", "2", "2", "19", "1", "13.170000000000", "739"),("33733", "2", "1", "73", "1", "16.720000000000", "740"),("95568", "2", "1", "20", "1", "83.240000000000", "741"),("49587", "2", "1019", "160", "1", "15.630000000000", "742"),("25708", "2", "1014", "19", "1", "13.780000000000", "743"),("25751", "2", "1010", "19", "1", "12.060000000000", "744"),("25755", "2", "1010", "19", "1", "13.360000000000", "745"),("25759", "2", "1009", "19", "1", "13.170000000000", "746"),("25592", "2", "1009", "19", "1", "13.450000000000", "747"),("25736", "2", "1009", "19", "1", "11.660000000000", "748"),("21964", "2", "1008", "73", "1", "23.310000000000", "749"),("25701", "2", "1008", "19", "1", "14.960000000000", "750"),("9720", "2", "1008", "19", "1", "19.000000000000", "751"),("25706", "2", "1007", "19", "1", "13.780000000000", "752"),("25733", "2", "1007", "19", "1", "11.360000000000", "753"),("226", "2", "1006", "19", "1", "19.000000000000", "754"),("25735", "2", "1006", "19", "1", "11.660000000000", "755"),("9627", "2", "1006", "160", "1", "18.650000000000", "756"),("48877", "2", "1005", "11", "1", "4.400000000000", "757"),("25589", "2", "1005", "19", "1", "12.770000000000", "758"),("25753", "2", "1005", "19", "1", "12.060000000000", "759"),("248", "2", "1004", "19", "1", "10.000000000000", "760"),("25758", "2", "1004", "19", "1", "13.170000000000", "761"),("21955", "2", "1004", "73", "1", "29.150000000000", "762"),("25713", "2", "1004", "19", "1", "12.870000000000", "763"),("25741", "2", "1004", "19", "1", "11.660000000000", "764"),("25747", "2", "1003", "19", "1", "12.870000000000", "765"),("100326", "1", "1003", "160", "1", "13.260000000000", "766"),("77882", "2", "1003", "85", "1", "13.660000000000", "767"),("42995", "2", "1002", "163", "1", "4.720000000000", "768"),("25740", "2", "1002", "19", "1", "11.660000000000", "769"),("33854", "2", "1002", "19", "1", "12.870000000000", "770"),("25716", "2", "1002", "19", "1", "15.980000000000", "771"),("199643", "1", "1002", "105", "1", "26.890000000000", "772"),("25744", "2", "1002", "19", "1", "12.870000000000", "773"),("199659", "1", "1001", "105", "1", "28.570000000000", "774"),("92238", "2", "1001", "19", "1", "12.160000000000", "775"),("37097", "2", "1000", "163", "1", "14.170000000000", "776"),("179506", "2", "1000", "603", "1", "62.180000000000", "777"),("229464", "2", "1000", "42", "1", "155.460000000000", "778"),("25746", "2", "1000", "19", "1", "12.870000000000", "779"),("43018", "2", "1000", "19", "1", "22.780000000000", "780"),("92250", "2", "1000", "19", "1", "11.360000000000", "781"),("92253", "2", "1000", "19", "1", "12.870000000000", "782"),("95641", "2", "1000", "19", "1", "15.280000000000", "783"),("36706", "2", "1000", "19", "1", "15.980000000000", "784"),("134231", "2", "1000", "150", "1", "29.030000000000", "785"),("36705", "2", "1000", "19", "1", "13.770000000000", "786"),("92592", "2", "1000", "85", "1", "21.600000000000", "787"),("92392", "2", "1000", "20", "1", "11.990000000000", "788"),("25739", "2", "1000", "19", "1", "11.660000000000", "789"),("92236", "2", "1000", "19", "1", "12.160000000000", "790"),("21942", "2", "1000", "160", "1", "24.480000000000", "791"),("21961", "2", "1000", "73", "1", "21.440000000000", "792"),("21962", "2", "1000", "73", "1", "21.440000000000", "793"),("21963", "2", "1000", "73", "1", "21.440000000000", "794"),("31721", "2", "1000", "42", "1", "159.660000000000", "795"),("84528", "2", "1000", "163", "1", "18.250000000000", "796"),("137861", "1", "1000", "150", "1", "25.680000000000", "797"),("25715", "2", "1000", "19", "1", "15.980000000000", "798"),("43006", "2", "1000", "20", "1", "13.330000000000", "799"),("86941", "2", "23", "85", "1", "16.800000000000", "800"),("11729", "2", "12", "19", "1", "66.390000000000", "801"),("25707", "2", "5", "19", "1", "13.780000000000", "802"),("25745", "2", "3", "19", "1", "12.440000000000", "803"),("25734", "2", "2", "19", "1", "9.660000000000", "804"),("25749", "2", "2", "19", "1", "11.310000000000", "805"),("42781", "2", "2", "19", "1", "9.660000000000", "806"),("146419", "2", "2", "47", "1", "234.930000000000", "807"),("9526", "2", "2", "19", "1", "11.360000000000", "808"),("100344", "1", "1", "47", "1", "7.920000000000", "809"),("43001", "2", "1030", "11", "1", "4.730000000000", "810"),("229", "2", "1027", "19", "1", "20.170000000000", "811"),("228", "2", "1024", "19", "1", "20.170000000000", "812"),("227", "2", "1022", "19", "1", "20.170000000000", "813"),("92410", "2", "1016", "11", "1", "4.730000000000", "814"),("92409", "2", "1011", "11", "1", "4.730000000000", "815"),("92240", "2", "1009", "19", "1", "9.290000000000", "816"),("48630", "2", "1006", "160", "1", "15.920000000000", "817"),("25748", "2", "1006", "19", "1", "14.370000000000", "818"),("134241", "2", "1005", "150", "1", "22.830000000000", "819"),("134247", "2", "1005", "150", "1", "17.130000000000", "820"),("25760", "2", "1005", "19", "1", "11.760000000000", "821"),("25761", "2", "1005", "19", "1", "11.760000000000", "822"),("134243", "2", "1004", "150", "1", "17.130000000000", "823"),("134239", "2", "1003", "150", "1", "22.830000000000", "824"),("255", "2", "1003", "19", "1", "19.800000000000", "825"),("25738", "2", "1001", "19", "1", "9.250000000000", "826"),("100526", "1", "1001", "19", "1", "10.000000000000", "827"),("92407", "2", "1001", "11", "1", "7.150000000000", "828"),("92408", "2", "1001", "11", "1", "5.500000000000", "829"),("37939", "2", "1001", "20", "1", "11.940000000000", "830"),("92239", "2", "1001", "19", "1", "9.290000000000", "831"),("134237", "2", "1001", "150", "1", "17.130000000000", "832"),("48671", "2", "1001", "288", "1", "8.320000000000", "833"),("36959", "2", "1000", "163", "1", "28.340000000000", "834"),("36961", "2", "1000", "163", "1", "27.390000000000", "835"),("36962", "2", "1000", "163", "1", "28.340000000000", "836"),("36963", "2", "1000", "163", "1", "28.340000000000", "837"),("36968", "2", "1000", "163", "1", "27.390000000000", "838"),("37093", "2", "1000", "163", "1", "14.170000000000", "839"),("84523", "2", "1000", "163", "1", "28.680000000000", "840"),("232768", "1", "1000", "338", "1", "839.500000000000", "841"),("232771", "1", "1000", "338", "1", "810.920000000000", "842"),("92399", "2", "1000", "11", "1", "6.500000000000", "843"),("92406", "2", "1000", "11", "1", "7.710000000000", "844"),("92412", "2", "1000", "11", "1", "4.730000000000", "845"),("92413", "2", "1000", "11", "1", "4.730000000000", "846"),("48682", "2", "1000", "288", "1", "9.570000000000", "847"),("48629", "2", "1000", "19", "1", "17.290000000000", "848"),("36718", "2", "1000", "19", "1", "14.770000000000", "849"),("34394", "2", "1000", "19", "1", "26.130000000000", "850"),("92400", "2", "1000", "11", "1", "6.710000000000", "851"),("95648", "2", "1000", "85", "1", "21.900000000000", "852"),("201881", "1", "1000", "224", "1", "36.970000000000", "853"),("201883", "1", "1000", "224", "1", "36.970000000000", "854"),("84527", "2", "1000", "163", "1", "21.530000000000", "855"),("92258", "2", "1000", "160", "1", "16.760000000000", "856"),("92241", "2", "1000", "19", "1", "9.290000000000", "857"),("42829", "2", "1000", "554", "1", "11.950000000000", "858"),("42830", "2", "1000", "163", "1", "11.950000000000", "859"),("36719", "2", "1000", "19", "1", "14.770000000000", "860"),("36942", "2", "1000", "163", "1", "21.530000000000", "861"),("36943", "2", "1000", "163", "1", "20.940000000000", "862"),("137853", "1", "1000", "150", "1", "25.680000000000", "863"),("137855", "1", "1000", "150", "1", "25.680000000000", "864"),("137869", "1", "1000", "150", "1", "25.680000000000", "865"),("137873", "1", "1000", "150", "1", "25.680000000000", "866"),("137875", "1", "1000", "150", "1", "25.680000000000", "867"),("92411", "2", "1000", "11", "1", "4.950000000000", "868"),("84814", "10", "1000", "157", "1", "44.790000000000", "869"),("254", "2", "1000", "19", "1", "17.290000000000", "870"),("9719", "2", "44", "19", "1", "19.750000000000", "871"),("67754", "2", "32", "85", "1", "11.760000000000", "872"),("86943", "2", "24", "85", "1", "16.800000000000", "873"),("48621", "2", "3", "160", "1", "16.290000000000", "874"),("136863", "2", "2", "19", "1", "12.100000000000", "875"),("37090", "2", "1", "163", "1", "14.170000000000", "876"),("48631", "2", "1015", "160", "1", "11.680000000000", "877"),("37944", "2", "1011", "11", "1", "20.580000000000", "878"),("9612", "2", "1010", "73", "1", "21.440000000000", "879"),("48633", "2", "1004", "160", "1", "11.680000000000", "880"),("134233", "2", "1004", "150", "1", "17.130000000000", "881"),("134235", "2", "1004", "150", "1", "22.830000000000", "882"),("92414", "2", "1001", "11", "1", "5.500000000000", "883"),("84524", "2", "1000", "163", "1", "30.760000000000", "884"),("145977", "2", "1000", "19", "1", "14.740000000000", "885"),("84809", "10", "1000", "157", "1", "36.630000000000", "886"),("92415", "2", "1000", "11", "1", "7.150000000000", "887"),("92368", "2", "1000", "160", "1", "11.260000000000", "888"),("36720", "2", "1000", "19", "1", "24.230000000000", "889"),("36956", "2", "1000", "163", "1", "27.390000000000", "890"),("138233", "1", "1000", "85", "1", "9.580000000000", "891"),("138241", "1", "1000", "85", "1", "10.380000000000", "892"),("138243", "1", "1000", "85", "1", "10.380000000000", "893"),("138253", "1", "1000", "85", "1", "11.180000000000", "894"),("138255", "1", "1000", "85", "1", "11.180000000000", "895"),("21808", "2", "1000", "85", "1", "9.760000000000", "896"),("137871", "1", "1000", "150", "1", "25.680000000000", "897"),("86940", "2", "6", "85", "1", "3.770000000000", "898"),("48632", "2", "2", "160", "1", "11.680000000000", "899"),("21983", "2", "1020", "73", "1", "25.480000000000", "900"),("134245", "2", "1005", "150", "1", "22.830000000000", "901"),("108174", "1", "1004", "104", "1", "38.660000000000", "902"),("92427", "2", "1002", "11", "1", "15.130000000000", "903"),("64566", "2", "1002", "19", "1", "13.170000000000", "904"),("92401", "2", "1001", "11", "1", "10.020000000000", "905"),("138249", "1", "1001", "85", "1", "10.380000000000", "906"),("138259", "1", "1001", "85", "1", "11.180000000000", "907"),("84811", "10", "1001", "157", "1", "38.950000000000", "908"),("92201", "2", "1001", "85", "1", "32.870000000000", "909"),("31707", "2", "1000", "42", "1", "121.850000000000", "910"),("104180", "2", "1000", "42", "1", "88.240000000000", "911"),("92404", "2", "1000", "11", "1", "9.240000000000", "912"),("92426", "2", "1000", "11", "1", "16.970000000000", "913"),("203459", "2", "1000", "19", "1", "19.240000000000", "914"),("203463", "2", "1000", "19", "1", "23.530000000000", "915"),("67750", "2", "1000", "85", "1", "19.450000000000", "916"),("138229", "1", "1000", "85", "1", "9.580000000000", "917"),("138235", "1", "1000", "85", "1", "9.580000000000", "918"),("138237", "1", "1000", "85", "1", "9.580000000000", "919"),("138239", "1", "1000", "85", "1", "10.380000000000", "920"),("138245", "1", "1000", "85", "1", "10.380000000000", "921"),("138251", "1", "1000", "85", "1", "11.180000000000", "922"),("138257", "1", "1000", "85", "1", "11.180000000000", "923"),("138247", "1", "1000", "85", "1", "10.380000000000", "924"),("70449", "2", "1000", "160", "1", "9.720000000000", "925"),("127699", "1", "1000", "85", "1", "21.340000000000", "926"),("84812", "10", "1000", "157", "1", "38.950000000000", "927"),("84813", "10", "1000", "157", "1", "46.740000000000", "928"),("67758", "2", "91", "85", "1", "3.100000000000", "929"),("203461", "2", "1", "19", "1", "21.090000000000", "930"),("91580", "2", "1", "85", "1", "13.890000000000", "931"),("8350", "2", "1", "42", "1", "67.230000000000", "932"),("21966", "2", "1017", "73", "1", "22.540000000000", "933"),("152573", "2", "1008", "20", "1", "7.900000000000", "934"),("9496", "2", "1003", "19", "1", "13.770000000000", "935"),("152577", "2", "1003", "20", "1", "7.900000000000", "936"),("9495", "2", "1003", "19", "1", "13.770000000000", "937"),("235", "2", "1002", "19", "1", "12.060000000000", "938"),("9494", "2", "1002", "19", "1", "13.770000000000", "939"),("17847", "2", "1001", "42", "1", "37.820000000000", "940"),("8383", "2", "1001", "42", "1", "108.400000000000", "941"),("17906", "2", "1001", "42", "1", "76.470000000000", "942"),("8359", "2", "1001", "42", "1", "94.960000000000", "943"),("17846", "2", "1000", "42", "1", "32.770000000000", "944"),("17848", "2", "1000", "42", "1", "46.220000000000", "945"),("8358", "2", "1000", "42", "1", "88.240000000000", "946"),("8380", "2", "1000", "42", "1", "78.150000000000", "947"),("37065", "2", "1000", "163", "1", "26.110000000000", "948"),("17850", "2", "1000", "42", "1", "64.710000000000", "949"),("152575", "2", "1000", "20", "1", "7.900000000000", "950"),("8381", "2", "1000", "42", "1", "84.030000000000", "951"),("138261", "1", "1000", "85", "1", "26.970000000000", "952"),("138265", "1", "1000", "85", "1", "30.290000000000", "953"),("138271", "1", "1000", "85", "1", "33.550000000000", "954"),("207037", "1", "1000", "85", "1", "26.970000000000", "955"),("198", "2", "1", "19", "1", "11.310000000000", "956"),("17845", "2", "1", "42", "1", "20.920000000000", "957"),("9493", "2", "1", "19", "1", "11.680000000000", "958"),("92599", "2", "1002", "85", "1", "14.230000000000", "959"),("50814", "2", "1001", "42", "1", "4.620000000000", "960"),("101608", "1", "1001", "42", "1", "175.630000000000", "961"),("21944", "2", "1001", "73", "1", "15.540000000000", "962"),("17844", "2", "1000", "42", "1", "66.390000000000", "963"),("17916", "2", "1000", "42", "1", "40.340000000000", "964"),("39458", "2", "1000", "42", "1", "60.500000000000", "965"),("79502", "2", "1000", "42", "1", "116.810000000000", "966"),("101607", "1", "1000", "42", "1", "131.090000000000", "967"),("164649", "1", "1000", "42", "1", "189.080000000000", "968"),("93421", "2", "1000", "42", "1", "74.790000000000", "969"),("8363", "2", "1000", "42", "1", "83.190000000000", "970"),("67734", "2", "1000", "85", "1", "32.190000000000", "971"),("36707", "2", "3", "19", "1", "11.310000000000", "972"),("101544", "1", "1", "42", "1", "88.240000000000", "973"),("36715", "2", "1027", "19", "1", "12.610000000000", "974"),("9729", "2", "1013", "19", "1", "12.610000000000", "975"),("21939", "2", "1013", "160", "1", "17.540000000000", "976"),("79503", "2", "1001", "42", "1", "147.060000000000", "977"),("17883", "2", "1000", "42", "1", "46.220000000000", "978"),("17927", "2", "1000", "42", "1", "60.500000000000", "979"),("8385", "2", "1000", "42", "1", "108.400000000000", "980"),("101550", "1", "1000", "42", "1", "154.620000000000", "981"),("101551", "1", "1000", "42", "1", "210.080000000000", "982"),("92996", "2", "1000", "42", "1", "274.790000000000", "983"),("176094", "2", "1000", "42", "1", "90.760000000000", "984"),("17879", "2", "1000", "42", "1", "50.420000000000", "985"),("207039", "1", "1000", "85", "1", "26.970000000000", "986"),("56572", "2", "1", "287", "1", "22.690000000000", "987"),("54533", "2", "1000", "49", "1", "66.390000000000", "988"),("54538", "2", "1000", "49", "1", "71.430000000000", "989"),("37900", "2", "1011", "163", "1", "6.610000000000", "990"),("21943", "2", "1011", "73", "1", "15.540000000000", "991"),("8388", "2", "1000", "42", "1", "133.610000000000", "992"),("8390", "2", "1000", "42", "1", "150.420000000000", "993"),("79504", "2", "1000", "42", "1", "163.870000000000", "994"),("79505", "2", "1000", "42", "1", "184.030000000000", "995"),("79507", "2", "1000", "42", "1", "205.880000000000", "996"),("18130", "2", "1000", "42", "1", "57.140000000000", "997"),("54541", "2", "1000", "49", "1", "26.890000000000", "998"),("151845", "1", "1000", "364", "1", "96.640000000000", "999"),("54534", "2", "1000", "49", "1", "24.370000000000", "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 *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '30145' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '2'

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '30145' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '30145' AND a.attribute_group_id = '23' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

SELECT *
FROM oc_product_image
WHERE product_id = '30145'
ORDER BY sort_order ASC

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '100083' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '2'

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '100083' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '100083' AND a.attribute_group_id = '23' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

SELECT *
FROM oc_product_image
WHERE product_id = '100083'
ORDER BY sort_order ASC

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '4730' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '2'

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '4730' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '4730' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

SELECT *
FROM oc_product_image
WHERE product_id = '4730'
ORDER BY sort_order ASC

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '2966' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '2'

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '2966' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '2966' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

SELECT *
FROM oc_product_image
WHERE product_id = '2966'
ORDER BY sort_order ASC

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

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=30145'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' 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 '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=100083'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=4730'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=2966'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=163497'

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

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

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

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

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