Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '570807c417aac68de3383a0666'

CREATE TEMPORARY TABLE oc_tmp_elastic ( 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_tmp_elastic (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("4455", "2", "1000", "96", "1", "5.87", "1"),("116340", "2", "1", "391", "1", "15.77", "2"),("156471", "2", "1002", "517", "1", "9.83", "3"),("156473", "2", "1000", "517", "1", "8.18", "4"),("212763", "1", "1000", "370", "1", "26.36", "5"),("212765", "1", "1000", "370", "1", "17.27", "6"),("143379", "2", "1000", "73", "1", "25.54", "7"),("212761", "1", "1000", "370", "1", "26.36", "8"),("216215", "2", "1000", "476", "1", "16.49", "9"),("34940", "2", "7", "59", "1", "10.66", "10"),("187741", "2", "1001", "59", "1", "15.94", "11"),("158597", "1", "1002", "24", "1", "9.01", "12"),("158603", "1", "1001", "24", "1", "9.01", "13"),("158599", "1", "1001", "24", "1", "9.83", "14"),("143393", "1", "1001", "62", "1", "9.01", "15"),("158595", "1", "1000", "24", "1", "9.01", "16"),("158615", "1", "1000", "24", "1", "10.66", "17"),("158617", "1", "1000", "24", "1", "10.66", "18"),("158619", "1", "1000", "24", "1", "10.66", "19"),("158621", "1", "1000", "24", "1", "10.66", "20"),("158623", "1", "1000", "24", "1", "10.66", "21"),("60052", "2", "1000", "187", "1", "5.7", "22"),("211327", "2", "1000", "476", "1", "18.97", "23"),("158601", "1", "1000", "24", "1", "9.01", "24"),("154899", "1", "1005", "224", "1", "6.53", "25"),("107061", "1", "1003", "75", "1", "18.93", "26"),("154897", "1", "1002", "224", "1", "6.53", "27"),("143385", "2", "1000", "73", "1", "23.88", "28"),("12013", "2", "1011", "27", "1", "10.66", "29"),("168730", "1", "1007", "224", "1", "6.53", "30"),("110636", "1", "1006", "163", "1", "8.18", "31"),("25373", "2", "1006", "160", "1", "18.93", "32"),("25371", "2", "1006", "160", "1", "18.93", "33"),("171817", "1", "1002", "224", "1", "6.53", "34"),("37601", "2", "1000", "204", "1", "6.63", "35"),("110637", "1", "1000", "163", "1", "10.66", "36"),("110639", "1", "1000", "163", "1", "4.88", "37"),("110635", "1", "1000", "163", "1", "5.7", "38"),("209919", "2", "1000", "476", "1", "14.83", "39"),("209921", "2", "1000", "476", "1", "14.83", "40"),("209923", "2", "1000", "476", "1", "14.83", "41"),("168731", "1", "1000", "224", "1", "6.53", "42"),("168732", "1", "1000", "224", "1", "6.53", "43"),("168733", "1", "1000", "224", "1", "6.53", "44"),("171818", "1", "1000", "224", "1", "6.53", "45"),("171819", "1", "1000", "224", "1", "6.53", "46"),("110638", "1", "1000", "163", "1", "3.22", "47"),("25374", "2", "1000", "160", "1", "18.93", "48"),("25372", "2", "1000", "160", "1", "18.93", "49"),("52761", "-100", "53", "26", "1", "6.53", "50"),("102549", "-100", "39", "26", "1", "6.53", "51"),("91616", "2", "37", "100", "1", "11.49", "52"),("91617", "2", "33", "100", "1", "11.49", "53"),("91623", "2", "27", "100", "1", "11.49", "54"),("91603", "2", "25", "100", "1", "16.45", "55"),("68031", "2", "1000", "73", "1", "32.98", "56"),("206915", "2", "1002", "517", "1", "10.66", "57"),("25385", "2", "1017", "73", "1", "30.5", "58"),("25386", "2", "1015", "73", "1", "30.5", "59"),("2854", "2", "1012", "73", "1", "30.5", "60"),("25397", "2", "1012", "73", "1", "30.5", "61"),("165168", "2", "1011", "492", "1", "9.83", "62"),("25364", "2", "1011", "160", "1", "11.49", "63"),("25383", "2", "1010", "73", "1", "30.5", "64"),("92376", "2", "1009", "73", "1", "30.5", "65"),("61061", "2", "1008", "410", "1", "8.18", "66"),("60914", "2", "1008", "41", "1", "9.83", "67"),("94380", "2", "1008", "45", "1", "9.83", "68"),("25381", "2", "1008", "73", "1", "30.5", "69"),("25396", "2", "1007", "73", "1", "30.5", "70"),("61093", "2", "1006", "410", "1", "5.7", "71"),("2859", "2", "1006", "73", "1", "30.5", "72"),("144223", "1", "1006", "160", "1", "13.97", "73"),("25384", "2", "1006", "73", "1", "30.5", "74"),("2851", "2", "1006", "73", "1", "30.5", "75"),("77649", "2", "1004", "73", "1", "30.5", "76"),("94382", "2", "1004", "45", "1", "9.83", "77"),("25382", "2", "1004", "73", "1", "30.5", "78"),("25365", "2", "1004", "160", "1", "11.49", "79"),("61060", "2", "1003", "410", "1", "8.18", "80"),("25367", "2", "1003", "160", "1", "11.49", "81"),("145095", "2", "1002", "19", "1", "51.16", "82"),("216281", "1", "1002", "476", "1", "12.36", "83"),("10782", "2", "1001", "41", "1", "9.83", "84"),("115030", "2", "1001", "73", "1", "30.5", "85"),("2860", "2", "1001", "73", "1", "30.5", "86"),("131397", "2", "1001", "168", "1", "19.75", "87"),("220192", "1", "1000", "138", "1", "13.35", "88"),("96546", "2", "1000", "98", "1", "15.12", "89"),("94480", "2", "1000", "19", "1", "51.16", "90"),("95413", "2", "1000", "163", "1", "4.05", "91"),("145051", "2", "1000", "19", "1", "51.16", "92"),("117492", "2", "1000", "19", "1", "51.16", "93"),("117493", "2", "1000", "19", "1", "64.38", "94"),("117494", "2", "1000", "19", "1", "60.25", "95"),("117495", "2", "1000", "19", "1", "51.16", "96"),("95414", "2", "1000", "163", "1", "4.07", "97"),("61087", "2", "1000", "410", "1", "8.18", "98"),("61094", "2", "1000", "410", "1", "5.7", "99"),("117491", "2", "1000", "19", "1", "54.46", "100"),("216211", "1", "1000", "476", "1", "18.97", "101"),("101840", "2", "1000", "116", "1", "9.01", "102"),("61092", "2", "1000", "410", "1", "6.53", "103"),("109451", "2", "1000", "160", "1", "13.97", "104"),("109452", "2", "1000", "160", "1", "13.97", "105"),("25366", "2", "1000", "160", "1", "11.49", "106"),("77646", "2", "1000", "160", "1", "13.97", "107"),("60913", "2", "1000", "41", "1", "9.83", "108"),("100488", "2", "1000", "271", "1", "6.53", "109"),("188529", "1", "28", "26", "1", "8.18", "110"),("91619", "2", "25", "100", "1", "11.49", "111"),("91621", "2", "22", "100", "1", "11.49", "112"),("91620", "2", "22", "100", "1", "11.49", "113"),("116335", "1", "4", "391", "1", "13.49", "114"),("132791", "2", "3", "322", "1", "4.88", "115"),("61029", "2", "1", "184", "1", "32.98", "116"),("206913", "2", "1000", "517", "1", "11.49", "117"),("2862", "2", "1018", "73", "1", "30.5", "118"),("2863", "2", "1014", "73", "1", "30.5", "119"),("63282", "2", "1012", "187", "1", "8.18", "120"),("163941", "1", "1011", "13", "1", "9.01", "121"),("25387", "2", "1011", "73", "1", "30.5", "122"),("4467", "2", "1011", "96", "1", "11.33", "123"),("2861", "2", "1011", "73", "1", "30.5", "124"),("142219", "2", "1011", "73", "1", "26.36", "125"),("2865", "2", "1010", "73", "1", "30.5", "126"),("25401", "2", "1008", "73", "1", "30.5", "127"),("65733", "2", "1008", "73", "1", "19.75", "128"),("107354", "1", "1007", "58", "1", "4.86", "129"),("53067", "2", "1007", "68", "1", "14.79", "130"),("53065", "2", "1007", "68", "1", "13.14", "131"),("2866", "2", "1007", "73", "1", "30.5", "132"),("4461", "2", "1007", "96", "1", "5.45", "133"),("77648", "2", "1006", "73", "1", "30.5", "134"),("107355", "1", "1005", "58", "1", "4.94", "135"),("170757", "1", "1005", "224", "1", "6.53", "136"),("61138", "2", "1005", "410", "1", "8.18", "137"),("63284", "2", "1005", "187", "1", "9.83", "138"),("163939", "1", "1005", "13", "1", "9.01", "139"),("163940", "1", "1005", "13", "1", "8.18", "140"),("12014", "2", "1005", "27", "1", "19.75", "141"),("4477", "2", "1005", "96", "1", "11.33", "142"),("25399", "2", "1005", "73", "1", "30.5", "143"),("107353", "1", "1004", "58", "1", "4.86", "144"),("163935", "1", "1004", "13", "1", "8.18", "145"),("145023", "2", "1004", "73", "1", "30.5", "146"),("163936", "1", "1004", "13", "1", "9.01", "147"),("107356", "1", "1003", "58", "1", "4.94", "148"),("107357", "1", "1003", "58", "1", "4.94", "149"),("61064", "2", "1003", "410", "1", "8.18", "150"),("61084", "2", "1003", "410", "1", "8.18", "151"),("170850", "1", "1003", "224", "1", "6.53", "152"),("163938", "1", "1003", "13", "1", "9.01", "153"),("61195", "2", "1003", "41", "1", "9.83", "154"),("25398", "2", "1003", "73", "1", "30.5", "155"),("211341", "1", "1003", "476", "1", "14.83", "156"),("225176", "1", "1002", "68", "1", "6.71", "157"),("153259", "2", "1002", "517", "1", "12.31", "158"),("61069", "2", "1002", "410", "1", "9.01", "159"),("61140", "2", "1002", "410", "1", "9.01", "160"),("77647", "2", "1002", "160", "1", "13.97", "161"),("117490", "2", "1001", "19", "1", "56.94", "162"),("158527", "2", "1001", "401", "1", "10.66", "163"),("61137", "2", "1001", "410", "1", "8.18", "164"),("170851", "1", "1001", "224", "1", "6.53", "165"),("148057", "2", "1001", "19", "1", "16.45", "166"),("145021", "2", "1001", "73", "1", "30.5", "167"),("107358", "1", "1000", "58", "1", "4.94", "168"),("112137", "1", "1000", "559", "1", "9.82", "169"),("225174", "1", "1000", "68", "1", "6.71", "170"),("225175", "1", "1000", "68", "1", "6.71", "171"),("269", "2", "1000", "19", "1", "18.93", "172"),("92746", "2", "1000", "20", "1", "13.14", "173"),("92753", "2", "1000", "20", "1", "18.1", "174"),("92757", "2", "1000", "20", "1", "26.36", "175"),("143253", "2", "1000", "20", "1", "13.14", "176"),("145049", "2", "1000", "19", "1", "51.16", "177"),("145053", "2", "1000", "19", "1", "56.94", "178"),("148053", "2", "1000", "19", "1", "16.45", "179"),("174357", "1", "1000", "500", "1", "7.36", "180"),("220743", "2", "1000", "603", "1", "17.27", "181"),("108885", "2", "1000", "279", "1", "26.36", "182"),("72029", "2", "1000", "41", "1", "9.83", "183"),("158525", "2", "1000", "401", "1", "10.66", "184"),("158529", "2", "1000", "401", "1", "10.66", "185"),("158531", "2", "1000", "401", "1", "10.66", "186"),("158533", "2", "1000", "401", "1", "10.66", "187"),("61066", "2", "1000", "410", "1", "9.01", "188"),("61068", "2", "1000", "410", "1", "9.01", "189"),("61070", "2", "1000", "410", "1", "8.18", "190"),("61075", "2", "1000", "410", "1", "8.18", "191"),("61187", "2", "1000", "41", "1", "8.18", "192"),("62777", "2", "1000", "24", "1", "8.18", "193"),("210313", "1", "1000", "476", "1", "14.42", "194"),("210315", "1", "1000", "476", "1", "14.42", "195"),("215565", "1", "1000", "476", "1", "18.97", "196"),("216391", "1", "1000", "476", "1", "13.6", "197"),("61192", "2", "1000", "41", "1", "9.83", "198"),("202541", "4", "1000", "224", "1", "16.45", "199"),("145047", "2", "1000", "19", "1", "56.94", "200"),("61095", "2", "1000", "410", "1", "8.18", "201"),("156469", "2", "1000", "279", "1", "26.36", "202"),("109455", "2", "1000", "160", "1", "11.49", "203"),("109457", "2", "1000", "73", "1", "30.5", "204"),("159277", "2", "1000", "73", "1", "23.88", "205"),("153249", "2", "1000", "517", "1", "14.2", "206"),("61197", "2", "1000", "41", "1", "8.18", "207"),("194", "2", "1000", "19", "1", "11.49", "208"),("195", "2", "1000", "19", "1", "11.49", "209"),("125177", "-100", "59", "26", "1", "9.01", "210"),("85324", "-100", "48", "26", "1", "13.14", "211"),("90095", "2", "41", "59", "1", "13.4", "212"),("85325", "-100", "37", "26", "1", "13.14", "213"),("132931", "-100", "36", "26", "1", "8.18", "214"),("91719", "2", "36", "100", "1", "14.79", "215"),("91625", "2", "30", "100", "1", "11.49", "216"),("224334", "-100", "26", "26", "1", "13.22", "217"),("224333", "-100", "25", "26", "1", "13.22", "218"),("91618", "2", "23", "100", "1", "18.1", "219"),("224335", "-100", "22", "26", "1", "13.22", "220"),("119478", "2", "19", "168", "1", "14.79", "221"),("646", "2", "16", "15", "1", "4.88", "222"),("119483", "2", "16", "168", "1", "14.79", "223"),("2864", "2", "12", "73", "1", "28.84", "224"),("660", "2", "11", "15", "1", "4.88", "225"),("9992", "2", "10", "73", "1", "16.71", "226"),("25388", "2", "10", "73", "1", "16.71", "227"),("119481", "2", "10", "168", "1", "14.79", "228"),("119482", "2", "9", "168", "1", "14.79", "229"),("90097", "2", "8", "59", "1", "18.93", "230"),("90098", "4", "8", "59", "1", "15.62", "231"),("131739", "1", "7", "559", "1", "6.53", "232"),("69358", "2", "7", "187", "1", "11.49", "233"),("131763", "1", "7", "559", "1", "6.53", "234"),("674", "2", "6", "15", "1", "4.88", "235"),("119479", "2", "6", "168", "1", "14.79", "236"),("61083", "2", "5", "410", "1", "9.01", "237"),("90096", "2", "4", "59", "1", "15.62", "238"),("119477", "2", "3", "168", "1", "14.79", "239"),("91648", "2", "3", "100", "1", "11.49", "240"),("54788", "2", "2", "279", "1", "14.79", "241"),("131761", "1", "2", "559", "1", "6.53", "242"),("10778", "2", "2", "41", "1", "9.83", "243"),("119484", "2", "2", "168", "1", "14.79", "244"),("92752", "2", "1", "20", "1", "17.27", "245"),("61184", "2", "1", "41", "1", "9.83", "246"),("54794", "2", "1", "279", "1", "20.58", "247"),("61071", "1", "1", "410", "1", "8.18", "248"),("144641", "2", "1001", "163", "1", "4.88", "249"),("144643", "2", "1000", "163", "1", "4.88", "250"),("144645", "2", "1000", "163", "1", "5.7", "251"),("144635", "2", "1000", "163", "1", "4.05", "252"),("144647", "2", "1000", "163", "1", "5.7", "253"),("144649", "2", "1000", "163", "1", "5.7", "254"),("144651", "2", "1000", "163", "1", "5.7", "255"),("144637", "2", "1000", "163", "1", "3.61", "256"),("109438", "2", "1026", "160", "1", "13.97", "257"),("144235", "2", "1022", "160", "1", "13.97", "258"),("202709", "4", "1018", "224", "1", "27.19", "259"),("25585", "2", "1015", "73", "1", "30.5", "260"),("112568", "2", "1014", "160", "1", "13.97", "261"),("25392", "2", "1014", "73", "1", "30.5", "262"),("144229", "2", "1013", "160", "1", "13.97", "263"),("145015", "2", "1009", "73", "1", "41.24", "264"),("112572", "2", "1009", "160", "1", "13.97", "265"),("204629", "2", "1009", "19", "1", "13.42", "266"),("165455", "1", "1009", "45", "1", "5.7", "267"),("109437", "2", "1009", "160", "1", "13.97", "268"),("109439", "2", "1009", "160", "1", "13.97", "269"),("96495", "2", "1008", "98", "1", "7.55", "270"),("154705", "1", "1008", "224", "1", "18.93", "271"),("166621", "1", "1008", "30", "1", "9.01", "272"),("112789", "2", "1008", "160", "1", "13.97", "273"),("165815", "1", "1008", "467", "1", "4.88", "274"),("153267", "1", "1007", "517", "1", "8.9", "275"),("63306", "2", "1007", "24", "1", "7.36", "276"),("208583", "2", "1007", "75", "1", "22.23", "277"),("163969", "1", "1007", "13", "1", "8.18", "278"),("25586", "2", "1007", "73", "1", "30.5", "279"),("119486", "2", "1007", "168", "1", "14.79", "280"),("112567", "2", "1007", "160", "1", "13.97", "281"),("394", "2", "1006", "15", "1", "10.26", "282"),("144233", "1", "1006", "160", "1", "13.97", "283"),("148467", "2", "1006", "160", "1", "13.97", "284"),("112791", "2", "1006", "160", "1", "13.97", "285"),("153269", "1", "1006", "517", "1", "8.9", "286"),("109456", "1", "1006", "160", "1", "13.97", "287"),("25583", "2", "1006", "73", "1", "30.5", "288"),("25369", "2", "1006", "160", "1", "11.49", "289"),("144237", "2", "1006", "160", "1", "13.97", "290"),("96492", "2", "1005", "98", "1", "7.55", "291"),("96493", "2", "1005", "98", "1", "7.55", "292"),("96494", "2", "1005", "98", "1", "7.55", "293"),("91540", "2", "1005", "11", "1", "25.54", "294"),("63293", "2", "1005", "187", "1", "9.01", "295"),("114815", "2", "1005", "187", "1", "8.18", "296"),("166622", "1", "1005", "30", "1", "9.01", "297"),("9583", "2", "1005", "73", "1", "22.23", "298"),("112571", "2", "1005", "160", "1", "13.97", "299"),("119485", "2", "1005", "168", "1", "14.79", "300"),("165819", "1", "1005", "467", "1", "4.88", "301"),("144239", "2", "1005", "160", "1", "13.97", "302"),("25368", "2", "1005", "160", "1", "11.49", "303"),("551", "2", "1004", "15", "1", "16.5", "304"),("163972", "1", "1004", "13", "1", "8.18", "305"),("243033", "2", "1004", "73", "1", "30.5", "306"),("273", "2", "1004", "19", "1", "29.67", "307"),("145025", "2", "1004", "73", "1", "30.5", "308"),("145027", "2", "1004", "73", "1", "30.5", "309"),("148463", "2", "1004", "160", "1", "13.97", "310"),("33829", "2", "1004", "73", "1", "30.5", "311"),("163970", "1", "1004", "13", "1", "8.18", "312"),("92378", "2", "1004", "73", "1", "30.5", "313"),("2868", "2", "1004", "73", "1", "30.5", "314"),("209005", "1", "1003", "670", "1", "6.71", "315"),("96498", "2", "1003", "98", "1", "7.55", "316"),("186273", "2", "1003", "19", "1", "51.16", "317"),("148061", "2", "1003", "19", "1", "16.45", "318"),("208591", "2", "1003", "75", "1", "22.23", "319"),("163966", "1", "1003", "13", "1", "8.18", "320"),("131395", "2", "1003", "168", "1", "19.75", "321"),("208595", "2", "1003", "75", "1", "22.23", "322"),("427", "2", "1003", "15", "1", "10.82", "323"),("163971", "1", "1003", "13", "1", "8.18", "324"),("25370", "2", "1003", "160", "1", "11.49", "325"),("11531", "2", "1003", "75", "1", "10.07", "326"),("2867", "2", "1003", "73", "1", "30.5", "327"),("190", "2", "1003", "19", "1", "13.14", "328"),("112566", "2", "1003", "160", "1", "13.97", "329"),("96504", "2", "1002", "98", "1", "7.55", "330"),("118548", "2", "1002", "11", "1", "25.54", "331"),("25390", "2", "1002", "73", "1", "30.5", "332"),("25580", "2", "1002", "73", "1", "30.5", "333"),("170760", "1", "1002", "224", "1", "5.7", "334"),("25581", "2", "1002", "73", "1", "30.5", "335"),("166617", "1", "1002", "30", "1", "9.01", "336"),("96516", "2", "1001", "98", "1", "7.55", "337"),("143263", "2", "1001", "19", "1", "45.37", "338"),("174356", "1", "1001", "500", "1", "6.53", "339"),("139931", "2", "1001", "48", "1", "17.27", "340"),("139933", "2", "1001", "48", "1", "21.4", "341"),("139951", "2", "1001", "48", "1", "21.4", "342"),("140147", "2", "1001", "48", "1", "21.4", "343"),("140411", "2", "1001", "48", "1", "21.4", "344"),("123913", "1", "1001", "577", "1", "6.53", "345"),("123919", "1", "1001", "577", "1", "6.53", "346"),("155309", "2", "1001", "120", "1", "14.55", "347"),("36728", "2", "1001", "19", "1", "56.94", "348"),("63335", "2", "1001", "24", "1", "7.36", "349"),("63334", "2", "1001", "24", "1", "8.18", "350"),("202707", "4", "1001", "224", "1", "20.58", "351"),("36729", "2", "1001", "19", "1", "56.94", "352"),("114816", "2", "1001", "187", "1", "8.18", "353"),("208599", "2", "1001", "75", "1", "22.23", "354"),("91083", "2", "1001", "163", "1", "6.53", "355"),("149157", "2", "1001", "11", "1", "7.36", "356"),("148465", "2", "1001", "160", "1", "13.97", "357"),("11530", "2", "1001", "75", "1", "10.83", "358"),("57958", "2", "1000", "15", "1", "11.65", "359"),("159487", "2", "1000", "49", "1", "33.77", "360"),("159489", "2", "1000", "49", "1", "33.77", "361"),("159491", "2", "1000", "49", "1", "32.42", "362"),("128101", "2", "1000", "15", "1", "9.43", "363"),("112080", "1", "1000", "559", "1", "12.09", "364"),("166357", "1", "1000", "559", "1", "11.25", "365"),("96496", "2", "1000", "98", "1", "7.55", "366"),("96499", "2", "1000", "98", "1", "7.55", "367"),("96505", "2", "1000", "98", "1", "7.55", "368"),("96506", "2", "1000", "98", "1", "7.55", "369"),("96507", "2", "1000", "98", "1", "7.55", "370"),("96508", "2", "1000", "98", "1", "7.55", "371"),("96509", "2", "1000", "98", "1", "7.55", "372"),("96510", "2", "1000", "98", "1", "7.55", "373"),("96511", "2", "1000", "98", "1", "7.55", "374"),("96512", "2", "1000", "98", "1", "7.55", "375"),("96515", "2", "1000", "98", "1", "7.55", "376"),("96517", "2", "1000", "98", "1", "7.55", "377"),("96518", "2", "1000", "98", "1", "7.55", "378"),("96519", "2", "1000", "98", "1", "7.55", "379"),("96520", "2", "1000", "98", "1", "7.55", "380"),("96523", "2", "1000", "98", "1", "7.55", "381"),("96524", "2", "1000", "98", "1", "7.55", "382"),("96525", "2", "1000", "98", "1", "7.55", "383"),("96526", "2", "1000", "98", "1", "7.55", "384"),("96529", "2", "1000", "98", "1", "7.55", "385"),("96530", "2", "1000", "98", "1", "7.55", "386"),("96531", "2", "1000", "98", "1", "7.55", "387"),("96532", "2", "1000", "98", "1", "7.55", "388"),("143323", "1", "1000", "163", "1", "6.53", "389"),("110358", "2", "1000", "19", "1", "32.15", "390"),("91541", "2", "1000", "11", "1", "25.54", "391"),("91604", "2", "1000", "371", "1", "56.12", "392"),("91605", "2", "1000", "371", "1", "56.12", "393"),("91613", "2", "1000", "371", "1", "56.12", "394"),("144445", "2", "1000", "150", "1", "25.54", "395"),("153043", "1", "1000", "150", "1", "34.63", "396"),("149159", "2", "1000", "11", "1", "5.7", "397"),("176479", "2", "1000", "42", "1", "10.66", "398"),("169255", "2", "1000", "115", "1", "28.02", "399"),("153653", "2", "1000", "120", "1", "7.36", "400"),("139813", "2", "1000", "48", "1", "17.27", "401"),("139815", "2", "1000", "48", "1", "17.27", "402"),("139817", "2", "1000", "48", "1", "15.62", "403"),("139827", "2", "1000", "48", "1", "15.62", "404"),("139831", "2", "1000", "48", "1", "15.62", "405"),("139833", "2", "1000", "48", "1", "15.62", "406"),("139835", "2", "1000", "48", "1", "15.62", "407"),("139839", "2", "1000", "48", "1", "17.27", "408"),("139841", "2", "1000", "48", "1", "15.62", "409"),("139845", "2", "1000", "48", "1", "15.62", "410"),("139853", "2", "1000", "48", "1", "15.62", "411"),("139855", "2", "1000", "48", "1", "15.62", "412"),("139857", "2", "1000", "48", "1", "15.62", "413"),("139859", "2", "1000", "48", "1", "15.62", "414"),("139861", "2", "1000", "48", "1", "15.62", "415"),("139863", "2", "1000", "48", "1", "15.62", "416"),("139865", "2", "1000", "48", "1", "15.62", "417"),("139871", "2", "1000", "48", "1", "15.62", "418"),("139873", "2", "1000", "48", "1", "15.62", "419"),("139875", "2", "1000", "48", "1", "15.62", "420"),("139879", "2", "1000", "48", "1", "15.62", "421"),("139883", "2", "1000", "48", "1", "15.62", "422"),("139885", "2", "1000", "48", "1", "15.62", "423"),("139889", "2", "1000", "48", "1", "15.62", "424"),("139903", "2", "1000", "48", "1", "17.27", "425"),("139905", "2", "1000", "48", "1", "17.27", "426"),("139917", "2", "1000", "48", "1", "17.27", "427"),("139921", "2", "1000", "48", "1", "17.27", "428"),("139925", "2", "1000", "48", "1", "17.27", "429"),("139927", "2", "1000", "48", "1", "17.27", "430"),("139929", "2", "1000", "48", "1", "17.27", "431"),("139937", "2", "1000", "48", "1", "17.27", "432"),("139943", "2", "1000", "48", "1", "17.27", "433"),("139953", "2", "1000", "48", "1", "17.27", "434"),("139955", "2", "1000", "48", "1", "17.27", "435"),("139957", "2", "1000", "48", "1", "17.27", "436"),("139961", "2", "1000", "48", "1", "17.27", "437"),("139963", "2", "1000", "48", "1", "17.27", "438"),("139967", "2", "1000", "48", "1", "17.27", "439"),("139969", "2", "1000", "48", "1", "17.27", "440"),("139971", "2", "1000", "48", "1", "17.27", "441"),("139973", "2", "1000", "48", "1", "17.27", "442"),("139981", "2", "1000", "48", "1", "17.27", "443"),("140141", "2", "1000", "48", "1", "21.4", "444"),("140143", "2", "1000", "48", "1", "21.4", "445"),("140145", "2", "1000", "48", "1", "21.4", "446"),("140413", "2", "1000", "48", "1", "21.4", "447"),("108884", "2", "1000", "279", "1", "26.36", "448"),("54800", "2", "1000", "279", "1", "26.36", "449"),("217591", "1", "1000", "370", "1", "5.7", "450"),("197781", "2", "1000", "48", "1", "21.4", "451"),("197789", "2", "1000", "48", "1", "21.4", "452"),("114817", "2", "1000", "187", "1", "8.18", "453"),("70211", "2", "1000", "187", "1", "8.18", "454"),("61142", "2", "1000", "410", "1", "9.01", "455"),("62784", "2", "1000", "24", "1", "7.36", "456"),("63256", "2", "1000", "410", "1", "8.18", "457"),("63302", "2", "1000", "24", "1", "7.36", "458"),("63315", "2", "1000", "24", "1", "7.36", "459"),("205791", "2", "1000", "476", "1", "9.88", "460"),("205793", "2", "1000", "476", "1", "9.88", "461"),("205867", "2", "1000", "476", "1", "17.31", "462"),("205869", "1", "1000", "476", "1", "14.83", "463"),("243032", "2", "1000", "73", "1", "30.5", "464"),("211343", "1", "1000", "476", "1", "18.97", "465"),("210371", "1", "1000", "476", "1", "18.97", "466"),("201021", "2", "1000", "224", "1", "9.01", "467"),("201023", "2", "1000", "224", "1", "9.01", "468"),("202705", "4", "1000", "224", "1", "21.4", "469"),("170150", "1", "1000", "224", "1", "7.36", "470"),("170151", "1", "1000", "224", "1", "7.36", "471"),("170152", "1", "1000", "224", "1", "7.36", "472"),("170758", "1", "1000", "224", "1", "5.7", "473"),("170759", "1", "1000", "224", "1", "5.7", "474"),("171809", "1", "1000", "224", "1", "7.36", "475"),("171810", "1", "1000", "224", "1", "7.36", "476"),("171811", "1", "1000", "224", "1", "7.36", "477"),("171814", "1", "1000", "224", "1", "7.36", "478"),("171815", "1", "1000", "224", "1", "7.36", "479"),("221291", "1", "1000", "357", "1", "19.75", "480"),("116346", "2", "1000", "285", "1", "5.7", "481"),("116347", "2", "1000", "285", "1", "5.7", "482"),("116348", "2", "1000", "285", "1", "5.7", "483"),("123909", "1", "1000", "577", "1", "4.88", "484"),("39995", "2", "1000", "42", "1", "78.43", "485"),("39996", "2", "1000", "42", "1", "82.56", "486"),("39997", "2", "1000", "42", "1", "85.87", "487"),("39999", "2", "1000", "42", "1", "94.13", "488"),("40001", "2", "1000", "42", "1", "97.44", "489"),("40002", "2", "1000", "42", "1", "106.53", "490"),("40003", "2", "1000", "42", "1", "111.49", "491"),("40031", "2", "1000", "42", "1", "82.56", "492"),("40048", "2", "1000", "42", "1", "86.69", "493"),("40052", "2", "1000", "42", "1", "94.13", "494"),("40053", "2", "1000", "42", "1", "94.96", "495"),("40054", "2", "1000", "42", "1", "96.61", "496"),("40055", "2", "1000", "42", "1", "106.53", "497"),("40057", "2", "1000", "42", "1", "111.49", "498"),("40058", "2", "1000", "42", "1", "118.1", "499"),("40059", "2", "1000", "42", "1", "80.91", "500")

CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, if (SUM(if((f.filter_group = "m0" AND filter_id IN (24)), 1, 0)) > 0, 1, 0) AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
INNER JOIN `oc_tmp_elastic` AS te ON (te.product_id = p.product_id)
WHERE p2s.store_id = '0' AND p.manufacturer_id = '24' AND p.status_filtru > 0 AND p.price > 0 AND te.product_id IS NOT NULL GROUP BY p.product_id
ORDER BY te.sort ASC

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 tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id

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

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