Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '29aecda0490e3b054614ed6214'

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 ("168707", "1", "1001", "224", "1", "4.88", "1"),("116813", "2", "1", "280", "1", "89.82", "2"),("214247", "1", "1000", "693", "1", "61.07", "3"),("126363", "2", "1000", "193", "1", "19.75", "4"),("126369", "2", "1000", "193", "1", "20.58", "5"),("126375", "2", "1000", "193", "1", "20.58", "6"),("126381", "2", "1000", "193", "1", "25.54", "7"),("213051", "1", "1000", "224", "1", "17.27", "8"),("213053", "1", "1000", "224", "1", "18.93", "9"),("218057", "1", "1002", "193", "1", "26.36", "10"),("220151", "2", "1000", "224", "1", "60.25", "11"),("134941", "2", "1000", "193", "1", "22.23", "12"),("215043", "1", "2", "693", "1", "82.56", "13"),("214895", "1", "1002", "693", "1", "69.34", "14"),("214957", "1", "2", "693", "1", "77.6", "15"),("210135", "1", "1000", "693", "1", "77.6", "16"),("214799", "1", "1000", "693", "1", "61.9", "17"),("172810", "2", "1000", "176", "1", "8.73", "18"),("241248", "2", "1002", "193", "1", "26.36", "19"),("241856", "2", "1000", "193", "1", "30.5", "20"),("241862", "2", "1000", "193", "1", "32.98", "21"),("236034", "2", "1000", "224", "1", "24.71", "22"),("46797", "2", "1000", "193", "1", "23.88", "23"),("229462", "1", "1000", "540", "1", "23.06", "24"),("134169", "2", "1000", "606", "1", "26.36", "25"),("126301", "1", "1000", "193", "1", "16.45", "26"),("134195", "2", "1000", "606", "1", "26.36", "27"),("134315", "2", "1000", "606", "1", "26.36", "28"),("135691", "2", "1002", "193", "1", "17.27", "29"),("46663", "2", "1002", "193", "1", "13.97", "30"),("230959", "1", "1000", "693", "1", "73.47", "31"),("135701", "2", "1000", "193", "1", "17.27", "32"),("224172", "1", "1000", "224", "1", "32.98", "33"),("169989", "2", "1000", "224", "1", "13.97", "34"),("134283", "2", "1000", "606", "1", "26.36", "35"),("134349", "2", "1000", "606", "1", "26.36", "36"),("134383", "2", "1000", "606", "1", "26.36", "37"),("135681", "2", "1000", "193", "1", "16.45", "38"),("134497", "2", "1000", "606", "1", "26.36", "39"),("135313", "1", "1004", "193", "1", "15.62", "40"),("46671", "2", "1000", "193", "1", "13.14", "41"),("207261", "2", "1000", "606", "1", "26.36", "42"),("255059", "2", "1000", "606", "1", "22.23", "43"),("255068", "2", "1000", "606", "1", "24.71", "44"),("255113", "2", "1000", "606", "1", "22.23", "45"),("255124", "2", "1000", "606", "1", "23.88", "46"),("135927", "2", "1", "193", "1", "9.01", "47"),("90012", "2", "1000", "423", "1", "42.07", "48"),("167081", "1", "2", "193", "1", "6.53", "49"),("89807", "2", "1002", "423", "1", "4.05", "50"),("176147", "2", "1000", "423", "1", "9.83", "51"),("229329", "1", "1000", "540", "1", "13.97", "52"),("167077", "1", "23", "193", "1", "8.18", "53"),("167098", "2", "4", "193", "1", "9.01", "54"),("89311", "2", "1001", "423", "1", "5.7", "55"),("236689", "2", "1001", "423", "1", "134.63", "56"),("89137", "2", "1000", "423", "1", "19.75", "57"),("182091", "1", "1001", "500", "1", "32.15", "58"),("182103", "1", "1001", "500", "1", "30.5", "59"),("174333", "2", "1000", "500", "1", "25.25", "60"),("119222", "2", "1000", "105", "1", "5.65", "61"),("182077", "1", "1000", "500", "1", "27.19", "62"),("174314", "2", "1000", "500", "1", "28.02", "63"),("174326", "2", "1000", "500", "1", "28.84", "64"),("158595", "1", "1000", "24", "1", "9.01", "65"),("158619", "1", "1000", "24", "1", "10.66", "66"),("214113", "1", "1000", "224", "1", "116.45", "67"),("179058", "1", "1000", "507", "1", "13.97", "68"),("89541", "2", "2", "362", "1", "543.72", "69"),("176145", "2", "2", "540", "1", "48.68", "70"),("89138", "4", "2", "362", "1", "30.5", "71"),("176305", "1", "1010", "507", "1", "6.53", "72"),("158519", "1", "1004", "24", "1", "10.66", "73"),("96294", "2", "1003", "484", "1", "118.1", "74"),("65981", "2", "1001", "362", "1", "112.31", "75"),("11384", "2", "1000", "58", "1", "8.73", "76"),("89198", "2", "1000", "423", "1", "35.45", "77"),("89289", "2", "1000", "423", "1", "4.88", "78"),("10849", "2", "2", "24", "1", "23.88", "79"),("65532", "2", "2", "103", "1", "11.33", "80"),("66116", "2", "1", "19", "1", "28.84", "81"),("136987", "2", "1015", "362", "1", "86.69", "82"),("65794", "2", "1008", "362", "1", "56.94", "83"),("65963", "2", "1005", "362", "1", "56.94", "84"),("65814", "2", "1003", "362", "1", "54.46", "85"),("89424", "2", "1002", "362", "1", "42.89", "86"),("166301", "2", "1002", "540", "1", "18.93", "87"),("73276", "2", "1000", "58", "1", "9.56", "88"),("73278", "2", "1000", "58", "1", "10.83", "89"),("82259", "2", "1000", "58", "1", "9.56", "90"),("82262", "2", "1000", "58", "1", "8.47", "91"),("82264", "2", "1000", "58", "1", "8.47", "92"),("82265", "2", "1000", "58", "1", "9.56", "93"),("82266", "2", "1000", "58", "1", "9.56", "94"),("82267", "2", "1000", "58", "1", "9.56", "95"),("82269", "2", "1000", "58", "1", "8.31", "96"),("119204", "2", "1000", "105", "1", "18.39", "97"),("73279", "2", "1000", "58", "1", "10.83", "98"),("224859", "1", "1000", "729", "1", "173.47", "99"),("201249", "1", "1000", "224", "1", "9.83", "100"),("176643", "2", "1000", "484", "1", "24.71", "101"),("229437", "2", "1000", "423", "1", "15.62", "102"),("229458", "1", "1000", "423", "1", "7.36", "103"),("162402", "2", "1000", "362", "1", "16.45", "104"),("237265", "2", "1000", "362", "1", "504.88", "105"),("162746", "2", "1000", "483", "1", "28.84", "106"),("65969", "2", "8", "423", "1", "28.02", "107"),("106234", "1", "1", "423", "1", "35.45", "108"),("89630", "2", "1", "423", "1", "18.1", "109"),("98717", "2", "1012", "362", "1", "22.23", "110"),("90104", "2", "1005", "362", "1", "65.21", "111"),("136996", "2", "1004", "423", "1", "6.53", "112"),("123475", "2", "1003", "540", "1", "34.63", "113"),("215139", "1", "1002", "729", "1", "58.6", "114"),("215167", "1", "1002", "729", "1", "58.6", "115"),("215209", "1", "1002", "729", "1", "58.6", "116"),("192607", "1", "1001", "729", "1", "184.21", "117"),("81096", "2", "1001", "362", "1", "56.94", "118"),("228313", "1", "1001", "362", "1", "21.4", "119"),("82107", "2", "1000", "493", "1", "9.83", "120"),("82220", "2", "1000", "493", "1", "9.83", "121"),("179439", "1", "1000", "603", "1", "69.34", "122"),("179484", "2", "1000", "603", "1", "65.21", "123"),("215185", "1", "1000", "729", "1", "58.6", "124"),("158525", "2", "1000", "401", "1", "10.66", "125"),("158585", "2", "1000", "401", "1", "10.66", "126"),("158605", "2", "1000", "401", "1", "12.31", "127"),("234202", "1", "1000", "401", "1", "25.54", "128"),("234218", "1", "1000", "401", "1", "25.54", "129"),("234234", "1", "1000", "401", "1", "25.54", "130"),("215391", "1", "1000", "224", "1", "14.79", "131"),("229047", "2", "1000", "540", "1", "7.36", "132"),("229337", "2", "1000", "168", "1", "13.97", "133"),("112648", "2", "1000", "428", "1", "364.38", "134"),("237297", "2", "1000", "423", "1", "20.58", "135"),("231716", "2", "1000", "224", "1", "20.58", "136"),("89442", "2", "1000", "362", "1", "65.21", "137"),("166947", "1", "1000", "423", "1", "21.4", "138"),("123143", "2", "2", "493", "1", "13.04", "139"),("123429", "2", "1", "362", "1", "36.28", "140"),("81101", "2", "1", "423", "1", "66.86", "141"),("178101", "1", "1009", "13", "1", "15.62", "142"),("178106", "1", "1007", "13", "1", "18.93", "143"),("89275", "2", "1007", "423", "1", "4.88", "144"),("192653", "1", "1002", "729", "1", "66.03", "145"),("123473", "2", "1002", "362", "1", "15.62", "146"),("137014", "1", "1002", "540", "1", "6.53", "147"),("36266", "2", "1001", "105", "1", "25.53", "148"),("230731", "2", "1001", "503", "1", "32.55", "149"),("94940", "2", "1001", "516", "1", "23.1", "150"),("154557", "1", "1001", "224", "1", "58.6", "151"),("231022", "10", "1001", "423", "1", "26.36", "152"),("72658", "2", "1000", "58", "1", "60.25", "153"),("72745", "2", "1000", "58", "1", "56.94", "154"),("118339", "2", "1000", "105", "1", "24.71", "155"),("224880", "2", "1000", "729", "1", "42.07", "156"),("179431", "1", "1000", "603", "1", "73.47", "157"),("182001", "1", "1000", "500", "1", "15.62", "158"),("192631", "1", "1000", "729", "1", "66.03", "159"),("169358", "1", "1000", "603", "1", "65.21", "160"),("215449", "1", "1000", "729", "1", "70.99", "161"),("215481", "1", "1000", "729", "1", "70.99", "162"),("181973", "1", "1000", "500", "1", "18.1", "163"),("234210", "1", "1000", "401", "1", "25.54", "164"),("234226", "1", "1000", "401", "1", "25.54", "165"),("89443", "2", "1000", "362", "1", "56.12", "166"),("89482", "10", "1000", "362", "1", "14.79", "167"),("201119", "2", "1000", "540", "1", "13.14", "168"),("229330", "2", "1000", "540", "1", "12.31", "169"),("229341", "2", "1000", "423", "1", "9.01", "170"),("237197", "2", "1000", "423", "1", "8.18", "171"),("89486", "2", "2", "362", "1", "12.31", "172"),("89202", "2", "1", "362", "1", "172.64", "173"),("89448", "2", "1", "362", "1", "15.62", "174"),("154805", "2", "1004", "224", "1", "18.1", "175"),("79431", "2", "1004", "19", "1", "12.31", "176"),("123471", "2", "1003", "484", "1", "14.79", "177"),("89325", "2", "1001", "362", "1", "104.05", "178"),("179002", "1", "1001", "423", "1", "6.53", "179"),("237149", "2", "1001", "362", "1", "168.51", "180"),("204563", "2", "1001", "423", "1", "8.18", "181"),("237648", "2", "1000", "20", "1", "40.41", "182"),("237649", "2", "1000", "20", "1", "42.89", "183"),("118443", "2", "1000", "105", "1", "22.23", "184"),("175558", "1", "1000", "58", "1", "68.51", "185"),("192677", "1", "1000", "729", "1", "72.64", "186"),("221381", "1", "1000", "745", "1", "21.4", "187"),("234241", "1", "1000", "401", "1", "14.79", "188"),("165415", "2", "1000", "224", "1", "161.07", "189"),("89580", "2", "1000", "767", "1", "69.34", "190"),("111996", "1", "1000", "19", "1", "47.06", "191"),("229332", "1", "1000", "540", "1", "68.51", "192"),("237322", "1", "1000", "19", "1", "32.98", "193"),("263206", "1", "1000", "423", "1", "5.7", "194"),("192661", "1", "1000", "729", "1", "72.64", "195"),("94767", "2", "6", "516", "1", "11.49", "196"),("246879", "1", "5", "809", "1", "10.91", "197"),("246892", "1", "3", "809", "1", "42.25", "198"),("94649", "2", "2", "516", "1", "15.62", "199"),("204279", "1", "1002", "484", "1", "8.18", "200"),("204637", "2", "1002", "423", "1", "6.53", "201"),("89154", "2", "1001", "362", "1", "50.33", "202"),("178117", "1", "1001", "13", "1", "11.49", "203"),("156201", "2", "1000", "128", "1", "13.35", "204"),("118006", "2", "1000", "105", "1", "23.06", "205"),("192601", "1", "1000", "729", "1", "80.08", "206"),("215309", "1", "1000", "729", "1", "72.64", "207"),("215325", "1", "1000", "729", "1", "80.08", "208"),("215509", "1", "1000", "729", "1", "85.87", "209"),("215529", "1", "1000", "729", "1", "80.08", "210"),("234261", "1", "1000", "401", "1", "16.45", "211"),("209297", "1", "1000", "224", "1", "9.01", "212"),("209299", "1", "1000", "224", "1", "9.01", "213"),("209301", "1", "1000", "224", "1", "9.01", "214"),("183903", "1", "1000", "362", "1", "4.88", "215"),("204317", "1", "1000", "484", "1", "37.11", "216"),("231044", "1", "997", "423", "1", "15.62", "217"),("90108", "2", "2", "484", "1", "9.01", "218"),("96253", "2", "2", "484", "1", "171.82", "219"),("246830", "1", "2", "809", "1", "26.03", "220"),("167136", "2", "1", "103", "1", "11.33", "221"),("89335", "2", "1006", "362", "1", "13.43", "222"),("197313", "1", "1002", "423", "1", "12.31", "223"),("231166", "2", "1001", "362", "1", "274.3", "224"),("183887", "1", "1001", "484", "1", "35.45", "225"),("118028", "2", "1001", "484", "1", "33.8", "226"),("119134", "2", "1000", "105", "1", "8.22", "227"),("116611", "2", "1000", "105", "1", "220.58", "228"),("222625", "1", "1000", "58", "1", "73.47", "229"),("135751", "1", "1000", "193", "1", "13.14", "230"),("258263", "2", "1000", "109", "1", "4.05", "231"),("96224", "2", "1000", "484", "1", "252.81", "232"),("203467", "2", "1000", "19", "1", "16.45", "233"),("176332", "1", "1000", "540", "1", "28.84", "234"),("239934", "2", "1000", "362", "1", "336.28", "235"),("263180", "1", "1000", "423", "1", "53.64", "236"),("112011", "1", "3", "428", "1", "50.33", "237"),("111946", "1", "1002", "484", "1", "76.78", "238"),("123493", "1", "1001", "540", "1", "7.36", "239"),("222621", "1", "1000", "58", "1", "73.47", "240"),("224831", "1", "1000", "729", "1", "94.13", "241"),("166006", "1", "1000", "224", "1", "296.61", "242"),("89831", "2", "1000", "71", "1", "10.66", "243"),("228546", "2", "1000", "423", "1", "7.36", "244"),("228850", "1", "1000", "423", "1", "6.53", "245"),("229051", "2", "1000", "423", "1", "10.66", "246"),("249320", "2", "1000", "423", "1", "5.7", "247"),("263303", "1", "1000", "540", "1", "5.7", "248"),("246816", "2", "5", "809", "1", "20.99", "249"),("246817", "2", "4", "809", "1", "20.99", "250"),("123479", "1", "2", "540", "1", "6.53", "251"),("167180", "1", "1001", "484", "1", "13.6", "252"),("249254", "1", "1000", "109", "1", "7.36", "253"),("249260", "1", "1000", "109", "1", "8.18", "254"),("249261", "1", "1000", "109", "1", "6.53", "255"),("222553", "1", "1000", "745", "1", "30.5", "256"),("178853", "1", "1000", "193", "1", "39.59", "257"),("231905", "1", "1000", "224", "1", "344.55", "258"),("123503", "1", "1000", "540", "1", "5.7", "259"),("252649", "2", "1000", "19", "1", "28.84", "260"),("1645", "2", "4", "48", "1", "15.62", "261"),("261545", "1", "3", "224", "1", "11.57", "262"),("94182", "2", "2", "516", "1", "12.31", "263"),("150157", "1", "1001", "310", "1", "18.93", "264"),("249268", "1", "1000", "109", "1", "6.53", "265"),("249258", "1", "1000", "109", "1", "8.18", "266"),("249277", "1", "1000", "109", "1", "8.18", "267"),("245894", "1", "1000", "693", "1", "77.6", "268"),("231029", "1", "1000", "362", "1", "77.6", "269"),("263295", "1", "1000", "540", "1", "8.18", "270"),("66060", "2", "3", "19", "1", "13.14", "271"),("66056", "2", "2", "19", "1", "13.97", "272"),("46568", "2", "1001", "193", "1", "13.97", "273"),("203843", "1", "1001", "423", "1", "9.01", "274"),("245879", "1", "1000", "693", "1", "72.64", "275"),("245915", "1", "1000", "693", "1", "80.91", "276"),("263195", "1", "1000", "362", "1", "49.5", "277"),("152677", "2", "1000", "423", "1", "13.14", "278"),("264353", "1", "1011", "809", "1", "12.31", "279"),("107713", "1", "1001", "58", "1", "8.31", "280"),("263175", "1", "1000", "362", "1", "186.69", "281"),("60743", "2", "3", "189", "1", "8.18", "282"),("60751", "2", "2", "189", "1", "6.53", "283"),("154901", "1", "1003", "224", "1", "6.53", "284"),("203831", "1", "1000", "587", "1", "11.67", "285"),("203847", "1", "1000", "587", "1", "12.51", "286"),("247153", "2", "1000", "606", "1", "23.88", "287"),("247165", "2", "1000", "606", "1", "23.06", "288"),("247185", "2", "1000", "606", "1", "24.71", "289"),("246978", "2", "1000", "606", "1", "22.23", "290"),("243448", "2", "997", "423", "1", "6.53", "291"),("240844", "1", "2", "305", "1", "135.7", "292"),("205651", "1", "1000", "224", "1", "12.31", "293"),("246996", "2", "1000", "606", "1", "28.02", "294"),("247202", "2", "1000", "606", "1", "28.02", "295"),("123459", "1", "1004", "423", "1", "5.7", "296"),("213049", "1", "0", "224", "1", "15.62", "297"),("126217", "2", "0", "193", "1", "22.69", "298"),("130181", "2", "0", "193", "1", "37.32", "299"),("241850", "2", "0", "193", "1", "27.19", "300"),("207183", "2", "0", "606", "1", "33.8", "301"),("238774", "2", "0", "193", "1", "26.36", "302"),("176152", "2", "0", "540", "1", "28.4", "303"),("209895", "1", "0", "423", "1", "24.71", "304"),("65797", "2", "0", "423", "1", "35.9", "305"),("89139", "2", "0", "423", "1", "43.5", "306"),("89789", "2", "0", "423", "1", "15.62", "307"),("104074", "1", "0", "58", "1", "2.1", "308"),("110436", "2", "0", "12", "1", "29.41", "309"),("89782", "2", "0", "423", "1", "29.9", "310"),("90204", "2", "0", "423", "1", "7.36", "311"),("201761", "10", "0", "423", "1", "23.06", "312"),("65811", "2", "0", "362", "1", "44.6", "313"),("89470", "2", "0", "362", "1", "22.13", "314"),("229006", "2", "0", "362", "1", "21.4", "315"),("229020", "10", "0", "423", "1", "23.06", "316"),("228323", "1", "0", "362", "1", "21.4", "317"),("229331", "2", "0", "540", "1", "40.41", "318"),("123427", "2", "0", "362", "1", "134", "319"),("237647", "2", "0", "20", "1", "29.19", "320"),("170598", "1", "0", "58", "1", "75", "321"),("203451", "2", "0", "19", "1", "61.07", "322"),("237315", "1", "0", "19", "1", "13.14", "323"),("215401", "1", "0", "729", "1", "63", "324"),("89339", "2", "0", "362", "1", "398", "325"),("72726", "2", "0", "58", "1", "55", "326"),("207333", "1", "0", "19", "1", "24.9", "327"),("224726", "1", "0", "729", "1", "32.5", "328"),("229468", "1", "0", "362", "1", "28.84", "329"),("123375", "1", "0", "540", "1", "67.69", "330"),("89190", "2", "0", "423", "1", "109", "331"),("103458", "1", "0", "494", "1", "289.08", "332"),("231167", "2", "0", "362", "1", "218.93", "333"),("211175", "10", "0", "751", "1", "152", "334"),("217053", "1", "0", "751", "1", "164", "335"),("217333", "1", "0", "751", "1", "102", "336"),("149371", "2", "0", "362", "1", "66.66", "337"),("231897", "1", "0", "224", "1", "134.34", "338"),("172812", "2", "1000", "176", "1", "9.31", "339"),("178852", "1", "0", "193", "1", "22", "340"),("178854", "1", "0", "193", "1", "25", "341"),("224852", "1", "0", "729", "1", "63", "342"),("246882", "2", "0", "809", "1", "5", "343"),("152653", "1", "0", "484", "1", "50", "344"),("133203", "2", "0", "289", "1", "4.48", "345"),("176238", "2", "1000", "423", "1", "9.83", "346"),("176239", "2", "1000", "423", "1", "6.53", "347"),("176240", "2", "1000", "423", "1", "6.53", "348"),("176241", "2", "1000", "423", "1", "8.18", "349"),("176242", "2", "1000", "423", "1", "9.01", "350"),("134051", "1", "1009", "109", "1", "3.26", "351"),("9051", "2", "1002", "58", "1", "10.91", "352"),("134053", "1", "1001", "109", "1", "3.26", "353"),("176225", "2", "1000", "423", "1", "9.83", "354"),("176226", "2", "1000", "423", "1", "7.36", "355"),("176227", "2", "1000", "423", "1", "8.18", "356"),("176228", "2", "1000", "423", "1", "9.01", "357"),("134037", "1", "8", "109", "1", "3.26", "358"),("250502", "1", "1000", "528", "1", "15.62", "359"),("174978", "2", "1000", "67", "1", "13.14", "360"),("174979", "2", "1000", "67", "1", "14.79", "361"),("108293", "1", "1001", "58", "1", "11.67", "362"),("108274", "1", "1000", "58", "1", "17.55", "363"),("108435", "1", "1007", "58", "1", "12.6", "364"),("241261", "2", "1003", "193", "1", "26.36", "365"),("108290", "1", "1000", "58", "1", "15.87", "366"),("108291", "1", "1000", "58", "1", "13.35", "367"),("108292", "1", "1000", "58", "1", "13.35", "368"),("146807", "2", "1000", "105", "1", "33.8", "369"),("146809", "2", "1000", "105", "1", "37.11", "370"),("150533", "2", "1000", "58", "1", "56.94", "371"),("56542", "2", "1001", "98", "1", "7.97", "372"),("213569", "1", "1000", "224", "1", "16.45", "373"),("168708", "1", "1008", "224", "1", "4.05", "374"),("90132", "2", "1001", "423", "1", "9.83", "375"),("6268", "2", "1000", "117", "1", "202.42", "376"),("240977", "2", "1000", "123", "1", "41.24", "377"),("214839", "1", "1000", "693", "1", "52.81", "378"),("214861", "1", "1000", "693", "1", "56.94", "379"),("214877", "1", "1000", "693", "1", "61.07", "380"),("214833", "1", "1000", "693", "1", "52.81", "381"),("214855", "1", "1000", "693", "1", "56.94", "382"),("213571", "1", "1000", "224", "1", "37.11", "383"),("213573", "1", "1000", "224", "1", "41.24", "384"),("213575", "1", "1000", "224", "1", "65.21", "385"),("90135", "2", "1000", "423", "1", "10.66", "386"),("90137", "2", "1000", "423", "1", "10.66", "387"),("90138", "2", "1000", "423", "1", "10.66", "388"),("90240", "2", "1000", "423", "1", "10.66", "389"),("6267", "2", "2", "117", "1", "202.42", "390"),("90136", "2", "2", "423", "1", "10.66", "391"),("126365", "2", "1001", "193", "1", "24.71", "392"),("126373", "2", "1001", "193", "1", "20.58", "393"),("213581", "1", "1001", "224", "1", "28.84", "394"),("215889", "1", "1001", "224", "1", "13.14", "395"),("230002", "2", "1000", "42", "1", "13.14", "396"),("214249", "1", "1000", "693", "1", "61.07", "397"),("214253", "1", "1000", "693", "1", "61.07", "398"),("214259", "1", "1000", "693", "1", "61.07", "399"),("214831", "1", "1000", "693", "1", "52.81", "400"),("214835", "1", "1000", "693", "1", "52.81", "401"),("214837", "1", "1000", "693", "1", "52.81", "402"),("214841", "1", "1000", "693", "1", "52.81", "403"),("214853", "1", "1000", "693", "1", "56.94", "404"),("214857", "1", "1000", "693", "1", "56.94", "405"),("214863", "1", "1000", "693", "1", "56.94", "406"),("214875", "1", "1000", "693", "1", "61.07", "407"),("214879", "1", "1000", "693", "1", "61.07", "408"),("214881", "1", "1000", "693", "1", "61.07", "409"),("214883", "1", "1000", "693", "1", "61.07", "410"),("126367", "2", "1000", "193", "1", "19.75", "411"),("126371", "2", "1000", "193", "1", "20.58", "412"),("126377", "2", "1000", "193", "1", "20.58", "413"),("126379", "2", "1000", "193", "1", "20.58", "414"),("126383", "2", "1000", "193", "1", "19.75", "415"),("126385", "2", "1000", "193", "1", "19.75", "416"),("213017", "1", "1000", "224", "1", "73.47", "417"),("213019", "1", "1000", "224", "1", "73.47", "418"),("213021", "1", "1000", "224", "1", "73.47", "419"),("213025", "1", "1000", "224", "1", "77.6", "420"),("213583", "1", "1000", "224", "1", "28.84", "421"),("200259", "2", "1000", "224", "1", "75.95", "422"),("215047", "1", "1002", "693", "1", "82.56", "423"),("215055", "1", "1002", "693", "1", "82.56", "424"),("218059", "1", "1002", "193", "1", "26.36", "425"),("218061", "1", "1002", "193", "1", "26.36", "426"),("231598", "2", "1000", "193", "1", "41.17", "427"),("231599", "2", "1000", "193", "1", "41.17", "428"),("214251", "1", "1000", "693", "1", "61.07", "429"),("214255", "1", "1000", "693", "1", "61.07", "430"),("214257", "1", "1000", "693", "1", "61.07", "431"),("214261", "1", "1000", "693", "1", "61.07", "432"),("134471", "2", "1000", "606", "1", "26.36", "433"),("134477", "2", "1000", "606", "1", "26.36", "434"),("134489", "2", "1000", "606", "1", "26.36", "435"),("134951", "2", "1000", "193", "1", "22.23", "436"),("220150", "2", "1000", "224", "1", "99.09", "437"),("134943", "2", "1000", "193", "1", "22.23", "438"),("134945", "2", "1000", "193", "1", "22.23", "439"),("134947", "2", "1000", "193", "1", "22.23", "440"),("134949", "2", "1000", "193", "1", "22.23", "441"),("220152", "2", "1000", "224", "1", "113.14", "442"),("134473", "2", "1000", "606", "1", "26.36", "443"),("134475", "2", "1000", "606", "1", "26.36", "444"),("215059", "1", "2", "693", "1", "82.56", "445"),("211853", "1", "1004", "224", "1", "9.01", "446"),("213057", "1", "1004", "224", "1", "25.54", "447"),("214285", "1", "1002", "693", "1", "73.47", "448"),("214287", "1", "1002", "693", "1", "73.47", "449"),("214289", "1", "1002", "693", "1", "73.47", "450"),("214293", "1", "1002", "693", "1", "73.47", "451"),("214295", "1", "1002", "693", "1", "73.47", "452"),("214297", "1", "1002", "693", "1", "73.47", "453"),("214301", "1", "1002", "693", "1", "73.47", "454"),("214755", "1", "1002", "693", "1", "61.9", "455"),("214757", "1", "1002", "693", "1", "61.9", "456"),("214765", "1", "1002", "693", "1", "61.9", "457"),("214899", "1", "1002", "693", "1", "69.34", "458"),("214901", "1", "1002", "693", "1", "69.34", "459"),("214905", "1", "1002", "693", "1", "69.34", "460"),("214907", "1", "1002", "693", "1", "69.34", "461"),("214913", "1", "1002", "693", "1", "69.34", "462"),("214921", "1", "1002", "693", "1", "73.47", "463"),("214963", "1", "1002", "693", "1", "77.6", "464"),("214969", "1", "1002", "693", "1", "77.6", "465"),("214977", "1", "1002", "693", "1", "77.6", "466"),("215049", "1", "1002", "693", "1", "82.56", "467"),("214751", "1", "1002", "693", "1", "61.9", "468"),("214965", "1", "1001", "693", "1", "77.6", "469"),("214973", "1", "1001", "693", "1", "77.6", "470"),("215051", "1", "1001", "693", "1", "82.56", "471"),("197989", "2", "1000", "123", "1", "23.88", "472"),("197995", "2", "1000", "123", "1", "23.06", "473"),("214779", "1", "1000", "693", "1", "61.9", "474"),("214805", "1", "1000", "693", "1", "61.9", "475"),("136087", "2", "1000", "193", "1", "32.98", "476"),("211851", "1", "1000", "224", "1", "8.18", "477"),("223721", "2", "1000", "224", "1", "22.23", "478"),("223722", "2", "1000", "224", "1", "19.75", "479"),("196135", "2", "1000", "193", "1", "16.45", "480"),("213055", "1", "4", "224", "1", "19.75", "481"),("214759", "1", "2", "693", "1", "61.9", "482"),("214961", "1", "2", "693", "1", "77.6", "483"),("214971", "1", "2", "693", "1", "77.6", "484"),("214909", "1", "2", "693", "1", "69.34", "485"),("214753", "1", "1", "693", "1", "61.9", "486"),("214283", "1", "1002", "693", "1", "73.47", "487"),("214291", "1", "1002", "693", "1", "73.47", "488"),("214749", "1", "1002", "693", "1", "61.9", "489"),("214763", "1", "1002", "693", "1", "61.9", "490"),("214767", "1", "1002", "693", "1", "61.9", "491"),("214897", "1", "1002", "693", "1", "69.34", "492"),("215053", "1", "1002", "693", "1", "82.56", "493"),("126275", "2", "1001", "193", "1", "25.54", "494"),("154527", "1", "1001", "224", "1", "93.31", "495"),("214401", "1", "1000", "693", "1", "64.38", "496"),("214455", "1", "1000", "693", "1", "69.34", "497"),("214511", "1", "1000", "693", "1", "73.47", "498"),("214713", "1", "1000", "693", "1", "78.43", "499"),("214781", "1", "1000", "693", "1", "61.9", "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'