Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '2a27546004872064589baa5908'

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 ("150319", "2", "1004", "54", "1", "25.54", "1"),("197575", "2", "1", "229", "1", "11.75", "2"),("158615", "1", "1000", "24", "1", "10.66", "3"),("158617", "1", "1000", "24", "1", "10.66", "4"),("158619", "1", "1000", "24", "1", "10.66", "5"),("158621", "1", "1000", "24", "1", "10.66", "6"),("158623", "1", "1000", "24", "1", "10.66", "7"),("15601", "2", "1000", "115", "1", "6.53", "8"),("15602", "2", "1000", "115", "1", "6.53", "9"),("145433", "2", "21", "12", "1", "9.01", "10"),("197577", "2", "9", "229", "1", "11.75", "11"),("150321", "2", "4", "54", "1", "23.88", "12"),("42922", "2", "1000", "155", "1", "24.71", "13"),("216833", "1", "1000", "279", "1", "51.98", "14"),("244777", "2", "1000", "54", "1", "25.54", "15"),("15512", "2", "1000", "115", "1", "23.06", "16"),("15519", "2", "1000", "115", "1", "23.06", "17"),("15520", "2", "1000", "115", "1", "23.06", "18"),("15525", "2", "1000", "115", "1", "23.06", "19"),("197579", "2", "8", "229", "1", "11.75", "20"),("168529", "2", "4", "54", "1", "28.84", "21"),("167305", "2", "2", "285", "1", "8.21", "22"),("169282", "1", "1005", "54", "1", "32.15", "23"),("73528", "2", "1003", "185", "1", "37.11", "24"),("169283", "1", "1003", "54", "1", "32.15", "25"),("131425", "2", "1003", "185", "1", "42.07", "26"),("51344", "2", "1003", "42", "1", "15.62", "27"),("73529", "2", "1002", "185", "1", "38.76", "28"),("191485", "1", "1002", "54", "1", "25.54", "29"),("191487", "1", "1002", "54", "1", "25.54", "30"),("191489", "1", "1002", "54", "1", "25.54", "31"),("191483", "1", "1002", "54", "1", "25.54", "32"),("117579", "2", "1002", "185", "1", "38.76", "33"),("150301", "1", "1002", "54", "1", "35.45", "34"),("73527", "2", "1002", "185", "1", "37.11", "35"),("73612", "2", "1002", "185", "1", "36.28", "36"),("187961", "1", "1002", "54", "1", "32.15", "37"),("96992", "2", "1001", "185", "1", "35.45", "38"),("51343", "2", "1001", "42", "1", "15.62", "39"),("51349", "2", "1001", "42", "1", "15.62", "40"),("70301", "2", "1001", "185", "1", "37.11", "41"),("169280", "1", "1001", "54", "1", "32.15", "42"),("64856", "2", "1001", "185", "1", "42.07", "43"),("119733", "2", "1000", "177", "1", "30.16", "44"),("30985", "2", "1000", "117", "1", "37.72", "45"),("170924", "2", "1000", "117", "1", "46.96", "46"),("179657", "1", "1000", "677", "1", "38.76", "47"),("179658", "1", "1000", "677", "1", "38.76", "48"),("179662", "1", "1000", "677", "1", "39.59", "49"),("179663", "1", "1000", "677", "1", "39.59", "50"),("133611", "2", "1000", "581", "1", "30.5", "51"),("108704", "2", "1000", "75", "1", "18.93", "52"),("216825", "1", "1000", "279", "1", "51.98", "53"),("216827", "1", "1000", "279", "1", "51.98", "54"),("216829", "1", "1000", "279", "1", "51.98", "55"),("216831", "1", "1000", "279", "1", "51.98", "56"),("131443", "2", "1000", "185", "1", "37.11", "57"),("113381", "2", "1000", "185", "1", "35.45", "58"),("114092", "2", "1000", "185", "1", "36.28", "59"),("70420", "2", "1000", "185", "1", "35.45", "60"),("70421", "2", "1000", "185", "1", "35.45", "61"),("73530", "2", "1000", "185", "1", "40.41", "62"),("73537", "2", "1000", "185", "1", "38.76", "63"),("73600", "2", "1000", "185", "1", "35.45", "64"),("73601", "2", "1000", "185", "1", "36.28", "65"),("73603", "2", "1000", "185", "1", "35.45", "66"),("73608", "2", "1000", "185", "1", "36.28", "67"),("97162", "2", "1000", "185", "1", "32.15", "68"),("97335", "2", "1000", "185", "1", "36.28", "69"),("226760", "2", "1000", "185", "1", "37.93", "70"),("226761", "2", "1000", "185", "1", "37.93", "71"),("226762", "2", "1000", "185", "1", "45.37", "72"),("226763", "2", "1000", "185", "1", "45.37", "73"),("244778", "2", "1000", "54", "1", "25.54", "74"),("245634", "2", "1000", "54", "1", "25.54", "75"),("114128", "2", "1000", "185", "1", "35.45", "76"),("70292", "2", "1000", "185", "1", "37.11", "77"),("70337", "2", "1000", "185", "1", "37.11", "78"),("133695", "2", "1000", "581", "1", "32.98", "79"),("73532", "2", "1000", "185", "1", "32.98", "80"),("73607", "2", "1000", "185", "1", "28.02", "81"),("113379", "2", "1000", "185", "1", "38.76", "82"),("51342", "2", "1000", "42", "1", "16.45", "83"),("51345", "2", "1000", "42", "1", "15.62", "84"),("51346", "2", "1000", "42", "1", "15.62", "85"),("51347", "2", "1000", "42", "1", "15.62", "86"),("51348", "2", "1000", "42", "1", "15.62", "87"),("51351", "2", "1000", "42", "1", "15.62", "88"),("32101", "2", "1000", "42", "1", "6.53", "89"),("32109", "2", "1000", "42", "1", "7.36", "90"),("70392", "2", "1000", "185", "1", "32.98", "91"),("63020", "2", "1000", "185", "1", "35.45", "92"),("73605", "2", "1000", "185", "1", "31.32", "93"),("10314", "2", "1000", "117", "1", "36.88", "94"),("10315", "2", "1000", "117", "1", "36.88", "95"),("10318", "2", "1000", "117", "1", "36.88", "96"),("11851", "2", "1000", "117", "1", "32.68", "97"),("10316", "2", "1000", "117", "1", "36.88", "98"),("10317", "2", "1000", "117", "1", "36.88", "99"),("29927", "2", "1000", "117", "1", "39.4", "100"),("162746", "2", "1000", "483", "1", "28.84", "101"),("10319", "2", "1000", "117", "1", "36.88", "102"),("173314", "2", "5", "54", "1", "28.84", "103"),("117814", "2", "5", "468", "1", "10.66", "104"),("169281", "1", "3", "54", "1", "32.15", "105"),("64854", "2", "3", "185", "1", "42.07", "106"),("51350", "2", "2", "42", "1", "15.62", "107"),("90067", "2", "2", "423", "1", "7.36", "108"),("32097", "2", "1", "42", "1", "7.88", "109"),("32104", "2", "1", "42", "1", "7.36", "110"),("51352", "2", "1", "42", "1", "15.62", "111"),("90069", "2", "1", "423", "1", "7.36", "112"),("90070", "2", "1", "423", "1", "8.18", "113"),("170930", "2", "1", "117", "1", "46.96", "114"),("73531", "2", "1", "185", "1", "32.98", "115"),("70343", "2", "1", "185", "1", "37.11", "116"),("113345", "2", "1", "185", "1", "37.11", "117"),("106234", "1", "1", "423", "1", "35.45", "118"),("70426", "2", "1", "185", "1", "28.02", "119"),("22167", "2", "1068", "12", "1", "5.7", "120"),("212017", "1", "1043", "224", "1", "18.93", "121"),("211933", "1", "1010", "224", "1", "15.62", "122"),("142375", "2", "1009", "48", "1", "9.83", "123"),("142371", "2", "1008", "48", "1", "9.83", "124"),("18572", "2", "1008", "54", "1", "37.93", "125"),("130487", "1", "1006", "75", "1", "7.13", "126"),("142363", "2", "1006", "48", "1", "9.83", "127"),("154601", "1", "1006", "224", "1", "13.97", "128"),("131445", "2", "1006", "185", "1", "42.07", "129"),("208409", "1", "1006", "54", "1", "35.45", "130"),("130485", "1", "1006", "75", "1", "7.13", "131"),("61166", "2", "1005", "41", "1", "9.83", "132"),("211955", "1", "1005", "224", "1", "18.93", "133"),("130483", "1", "1005", "75", "1", "7.13", "134"),("165252", "1", "1005", "611", "1", "24.71", "135"),("237931", "2", "1004", "120", "1", "19.75", "136"),("187963", "1", "1004", "54", "1", "32.15", "137"),("168926", "1", "1004", "54", "1", "32.15", "138"),("170011", "1", "1004", "224", "1", "13.97", "139"),("61162", "2", "1004", "41", "1", "9.83", "140"),("168925", "1", "1003", "54", "1", "32.15", "141"),("169993", "1", "1003", "224", "1", "13.97", "142"),("170021", "1", "1003", "224", "1", "13.97", "143"),("185881", "2", "1003", "185", "1", "50.33", "144"),("117580", "2", "1003", "185", "1", "38.76", "145"),("150295", "1", "1003", "54", "1", "35.45", "146"),("10121", "2", "1002", "117", "1", "40.24", "147"),("163279", "2", "1002", "185", "1", "37.11", "148"),("31204", "2", "1002", "117", "1", "36.12", "149"),("114002", "2", "1002", "185", "1", "37.11", "150"),("61160", "2", "1002", "41", "1", "9.83", "151"),("191491", "1", "1002", "54", "1", "25.54", "152"),("154597", "1", "1002", "224", "1", "13.97", "153"),("154609", "1", "1002", "224", "1", "13.97", "154"),("163274", "2", "1002", "185", "1", "42.07", "155"),("60787", "2", "1002", "39", "1", "7.36", "156"),("61157", "2", "1002", "41", "1", "9.83", "157"),("150299", "1", "1002", "54", "1", "35.45", "158"),("211947", "1", "1002", "224", "1", "18.93", "159"),("30777", "2", "1001", "117", "1", "42.76", "160"),("29010", "2", "1001", "117", "1", "42.76", "161"),("142349", "2", "1001", "48", "1", "9.01", "162"),("97362", "2", "1001", "185", "1", "35.45", "163"),("158527", "2", "1001", "401", "1", "10.66", "164"),("158609", "2", "1001", "401", "1", "12.31", "165"),("158611", "2", "1001", "401", "1", "11.49", "166"),("60788", "2", "1001", "39", "1", "7.36", "167"),("60789", "2", "1001", "39", "1", "7.36", "168"),("60790", "2", "1001", "39", "1", "7.36", "169"),("61161", "2", "1001", "41", "1", "9.83", "170"),("61159", "2", "1001", "41", "1", "9.83", "171"),("213111", "1", "1001", "224", "1", "13.97", "172"),("169995", "1", "1001", "224", "1", "13.97", "173"),("154599", "1", "1001", "224", "1", "13.97", "174"),("154633", "1", "1001", "224", "1", "13.97", "175"),("114001", "2", "1001", "185", "1", "37.11", "176"),("154607", "1", "1001", "224", "1", "13.97", "177"),("114127", "2", "1001", "185", "1", "35.45", "178"),("30770", "2", "1001", "117", "1", "42.76", "179"),("211279", "1", "1001", "224", "1", "23.06", "180"),("10120", "2", "1000", "117", "1", "40.24", "181"),("10127", "2", "1000", "117", "1", "42.76", "182"),("10128", "2", "1000", "117", "1", "42.76", "183"),("10248", "2", "1000", "117", "1", "42.76", "184"),("29179", "2", "1000", "117", "1", "36.03", "185"),("29180", "2", "1000", "117", "1", "36.03", "186"),("29182", "2", "1000", "117", "1", "36.03", "187"),("30029", "2", "1000", "117", "1", "41.08", "188"),("30032", "2", "1000", "117", "1", "41.08", "189"),("228747", "2", "1000", "117", "1", "39.4", "190"),("228749", "2", "1000", "117", "1", "39.4", "191"),("228750", "2", "1000", "117", "1", "39.4", "192"),("228751", "2", "1000", "117", "1", "39.4", "193"),("228752", "2", "1000", "117", "1", "39.4", "194"),("48142", "2", "1000", "105", "1", "15.62", "195"),("30769", "2", "1000", "117", "1", "42.76", "196"),("30776", "2", "1000", "117", "1", "42.76", "197"),("30899", "2", "1000", "117", "1", "40.24", "198"),("30771", "2", "1000", "117", "1", "42.76", "199"),("133495", "2", "1000", "117", "1", "36.88", "200"),("124059", "2", "1000", "117", "1", "36.88", "201"),("153117", "1", "1000", "150", "1", "57.77", "202"),("120222", "2", "1000", "117", "1", "36.88", "203"),("118171", "2", "1000", "105", "1", "30.5", "204"),("118172", "2", "1000", "105", "1", "30.5", "205"),("225357", "1", "1000", "123", "1", "37.93", "206"),("225360", "1", "1000", "123", "1", "37.93", "207"),("179477", "2", "1000", "603", "1", "65.21", "208"),("179484", "2", "1000", "603", "1", "65.21", "209"),("179659", "1", "1000", "677", "1", "38.76", "210"),("179660", "1", "1000", "677", "1", "38.76", "211"),("179661", "1", "1000", "677", "1", "38.76", "212"),("179706", "2", "1000", "115", "1", "113.14", "213"),("181977", "1", "1000", "500", "1", "18.1", "214"),("181989", "1", "1000", "500", "1", "18.1", "215"),("181995", "1", "1000", "500", "1", "18.1", "216"),("181997", "1", "1000", "500", "1", "18.1", "217"),("169577", "2", "1000", "677", "1", "38.76", "218"),("220605", "1", "1000", "603", "1", "65.21", "219"),("220665", "2", "1000", "603", "1", "65.21", "220"),("133613", "2", "1000", "581", "1", "30.5", "221"),("142359", "2", "1000", "48", "1", "9.01", "222"),("142367", "2", "1000", "48", "1", "9.01", "223"),("142373", "2", "1000", "48", "1", "9.01", "224"),("142379", "2", "1000", "48", "1", "9.01", "225"),("191925", "2", "1000", "581", "1", "33.8", "226"),("170883", "2", "1000", "117", "1", "42.76", "227"),("163264", "2", "1000", "185", "1", "37.11", "228"),("191929", "2", "1000", "581", "1", "33.8", "229"),("133607", "2", "1000", "581", "1", "28.84", "230"),("73740", "2", "1000", "185", "1", "37.93", "231"),("73741", "2", "1000", "185", "1", "35.45", "232"),("97363", "2", "1000", "185", "1", "37.93", "233"),("97364", "2", "1000", "185", "1", "37.93", "234"),("158525", "2", "1000", "401", "1", "10.66", "235"),("158529", "2", "1000", "401", "1", "10.66", "236"),("158531", "2", "1000", "401", "1", "10.66", "237"),("158533", "2", "1000", "401", "1", "10.66", "238"),("158605", "2", "1000", "401", "1", "12.31", "239"),("158607", "2", "1000", "401", "1", "12.31", "240"),("158613", "2", "1000", "401", "1", "10.66", "241"),("234234", "1", "1000", "401", "1", "25.54", "242"),("234235", "1", "1000", "401", "1", "25.54", "243"),("234236", "1", "1000", "401", "1", "25.54", "244"),("234237", "1", "1000", "401", "1", "25.54", "245"),("234238", "1", "1000", "401", "1", "25.54", "246"),("234239", "1", "1000", "401", "1", "25.54", "247"),("234240", "1", "1000", "401", "1", "25.54", "248"),("61169", "2", "1000", "41", "1", "9.83", "249"),("191605", "1", "1000", "54", "1", "35.45", "250"),("163843", "2", "1000", "13", "1", "7.36", "251"),("49788", "2", "1000", "85", "1", "28.84", "252"),("211925", "1", "1000", "224", "1", "15.62", "253"),("211931", "1", "1000", "224", "1", "15.62", "254"),("211935", "1", "1000", "224", "1", "18.93", "255"),("211937", "1", "1000", "224", "1", "18.93", "256"),("211941", "1", "1000", "224", "1", "18.93", "257"),("211943", "1", "1000", "224", "1", "18.93", "258"),("211951", "1", "1000", "224", "1", "15.62", "259"),("211953", "1", "1000", "224", "1", "18.93", "260"),("212025", "1", "1000", "224", "1", "13.97", "261"),("213107", "1", "1000", "224", "1", "13.97", "262"),("213109", "1", "1000", "224", "1", "13.97", "263"),("169994", "1", "1000", "224", "1", "13.97", "264"),("169998", "1", "1000", "224", "1", "13.97", "265"),("169999", "1", "1000", "224", "1", "13.97", "266"),("170002", "1", "1000", "224", "1", "13.97", "267"),("170003", "1", "1000", "224", "1", "13.97", "268"),("170004", "1", "1000", "224", "1", "13.97", "269"),("170009", "1", "1000", "224", "1", "13.97", "270"),("170015", "1", "1000", "224", "1", "13.97", "271"),("170022", "1", "1000", "224", "1", "13.97", "272"),("170025", "1", "1000", "224", "1", "13.97", "273"),("165821", "2", "1000", "224", "1", "132.15", "274"),("133697", "2", "1000", "581", "1", "32.98", "275"),("113999", "2", "1000", "185", "1", "32.98", "276"),("170000", "1", "1000", "224", "1", "13.97", "277"),("163287", "2", "1000", "185", "1", "42.07", "278"),("131427", "2", "1000", "185", "1", "42.07", "279"),("53231", "2", "1000", "115", "1", "23.06", "280"),("191941", "2", "1000", "581", "1", "33.8", "281"),("142355", "2", "1000", "48", "1", "9.01", "282"),("142361", "2", "1000", "48", "1", "9.01", "283"),("113995", "2", "1000", "185", "1", "26.36", "284"),("98323", "2", "1000", "117", "1", "42.76", "285"),("98325", "2", "1000", "117", "1", "42.76", "286"),("98492", "2", "1000", "117", "1", "42.76", "287"),("124055", "2", "1000", "117", "1", "36.88", "288"),("29181", "2", "1000", "117", "1", "38.55", "289"),("29982", "2", "1000", "117", "1", "41.08", "290"),("30067", "2", "1000", "117", "1", "39.4", "291"),("30095", "2", "1000", "117", "1", "39.4", "292"),("120211", "2", "1000", "177", "1", "30.16", "293"),("170023", "1", "1000", "224", "1", "13.97", "294"),("133691", "2", "1000", "581", "1", "32.98", "295"),("133693", "2", "1000", "581", "1", "32.98", "296"),("30775", "2", "1000", "117", "1", "42.76", "297"),("98671", "2", "1000", "117", "1", "32.68", "298"),("211275", "1", "1000", "224", "1", "23.06", "299"),("211277", "1", "1000", "224", "1", "23.06", "300"),("211949", "1", "1000", "224", "1", "18.93", "301"),("142339", "2", "1000", "48", "1", "9.83", "302"),("167516", "2", "1000", "483", "1", "28.84", "303"),("124057", "2", "1000", "117", "1", "36.88", "304"),("41239", "2", "19", "115", "1", "3.22", "305"),("211945", "1", "10", "224", "1", "15.62", "306"),("58820", "2", "5", "285", "1", "11.98", "307"),("187959", "1", "4", "54", "1", "32.15", "308"),("181081", "2", "3", "54", "1", "25.62", "309"),("98322", "2", "1", "117", "1", "42.76", "310"),("30103", "2", "1", "117", "1", "39.4", "311"),("142353", "2", "1", "48", "1", "9.01", "312"),("61152", "2", "1", "41", "1", "9.83", "313"),("154687", "1", "1", "224", "1", "13.97", "314"),("169284", "1", "1", "54", "1", "32.15", "315"),("219547", "2", "1023", "13", "1", "8.18", "316"),("143775", "1", "1009", "611", "1", "24.71", "317"),("143783", "1", "1004", "611", "1", "24.71", "318"),("143797", "1", "1004", "611", "1", "24.71", "319"),("163283", "2", "1003", "185", "1", "37.11", "320"),("168923", "1", "1003", "54", "1", "32.15", "321"),("154827", "1", "1003", "224", "1", "13.97", "322"),("114085", "2", "1003", "185", "1", "50.33", "323"),("131441", "2", "1003", "185", "1", "42.07", "324"),("174568", "2", "1003", "185", "1", "38.76", "325"),("99677", "2", "1003", "117", "1", "38.55", "326"),("165245", "1", "1003", "611", "1", "24.71", "327"),("165246", "1", "1003", "611", "1", "24.71", "328"),("154821", "1", "1002", "224", "1", "13.97", "329"),("226564", "2", "1002", "185", "1", "37.11", "330"),("65032", "2", "1002", "185", "1", "38.76", "331"),("227538", "2", "1002", "185", "1", "50.33", "332"),("127631", "1", "1002", "185", "1", "38.76", "333"),("127633", "1", "1002", "185", "1", "38.76", "334"),("65008", "2", "1002", "185", "1", "50.33", "335"),("31083", "2", "1002", "117", "1", "36.88", "336"),("211297", "1", "1002", "224", "1", "33.8", "337"),("154823", "1", "1002", "224", "1", "13.97", "338"),("98464", "2", "1001", "117", "1", "40.24", "339"),("94940", "2", "1001", "516", "1", "23.1", "340"),("114090", "2", "1001", "185", "1", "35.45", "341"),("131423", "2", "1001", "185", "1", "42.07", "342"),("99679", "2", "1001", "117", "1", "38.55", "343"),("31268", "2", "1001", "117", "1", "45.28", "344"),("169670", "2", "1001", "122", "1", "77.6", "345"),("209523", "1", "1001", "423", "1", "7.36", "346"),("98468", "2", "1000", "117", "1", "40.24", "347"),("98870", "2", "1000", "117", "1", "36.88", "348"),("99682", "2", "1000", "117", "1", "38.55", "349"),("100385", "2", "1000", "177", "1", "34.36", "350"),("31275", "2", "1000", "117", "1", "45.28", "351"),("135271", "1", "1000", "117", "1", "52.84", "352"),("229601", "2", "1000", "117", "1", "44.44", "353"),("207743", "1", "1000", "117", "1", "39.4", "354"),("207749", "1", "1000", "117", "1", "39.4", "355"),("207759", "1", "1000", "117", "1", "39.4", "356"),("207765", "1", "1000", "117", "1", "39.4", "357"),("98463", "2", "1000", "117", "1", "40.24", "358"),("229243", "1", "1000", "117", "1", "52.84", "359"),("98465", "2", "1000", "117", "1", "40.24", "360"),("207747", "1", "1000", "117", "1", "39.4", "361"),("207763", "1", "1000", "117", "1", "39.4", "362"),("118881", "2", "1000", "554", "1", "13.14", "363"),("153037", "2", "1000", "150", "1", "20.58", "364"),("153039", "2", "1000", "150", "1", "20.58", "365"),("153041", "2", "1000", "150", "1", "18.93", "366"),("132287", "1", "1000", "20", "1", "37.3", "367"),("132305", "1", "1000", "20", "1", "30.22", "368"),("132285", "1", "1000", "20", "1", "30.22", "369"),("207751", "1", "1000", "117", "1", "39.4", "370"),("98181", "2", "1000", "177", "1", "34.36", "371"),("105078", "2", "1000", "42", "1", "27.19", "372"),("105080", "2", "1000", "42", "1", "27.19", "373"),("94941", "2", "1000", "516", "1", "23.88", "374"),("118161", "2", "1000", "105", "1", "30.5", "375"),("118163", "2", "1000", "105", "1", "30.5", "376"),("118164", "2", "1000", "105", "1", "30.5", "377"),("118165", "2", "1000", "105", "1", "30.5", "378"),("118166", "2", "1000", "105", "1", "30.5", "379"),("118167", "2", "1000", "105", "1", "30.5", "380"),("118168", "2", "1000", "105", "1", "30.5", "381"),("118244", "2", "1000", "105", "1", "21.4", "382"),("118250", "2", "1000", "105", "1", "21.4", "383"),("118252", "2", "1000", "105", "1", "21.4", "384"),("225358", "1", "1000", "123", "1", "37.93", "385"),("225359", "1", "1000", "123", "1", "37.93", "386"),("179478", "2", "1000", "603", "1", "65.21", "387"),("179480", "2", "1000", "603", "1", "65.21", "388"),("179485", "2", "1000", "603", "1", "65.21", "389"),("179488", "2", "1000", "603", "1", "65.21", "390"),("179489", "2", "1000", "603", "1", "65.21", "391"),("179490", "2", "1000", "603", "1", "65.21", "392"),("179492", "2", "1000", "603", "1", "65.21", "393"),("179640", "2", "1000", "677", "1", "38.76", "394"),("181979", "1", "1000", "500", "1", "18.1", "395"),("181981", "1", "1000", "500", "1", "18.1", "396"),("181983", "1", "1000", "500", "1", "18.1", "397"),("181991", "1", "1000", "500", "1", "18.1", "398"),("181993", "1", "1000", "500", "1", "18.1", "399"),("169497", "2", "1000", "603", "1", "65.21", "400"),("169500", "2", "1000", "603", "1", "65.21", "401"),("169565", "2", "1000", "677", "1", "38.76", "402"),("169574", "2", "1000", "677", "1", "38.76", "403"),("133629", "2", "1000", "581", "1", "30.5", "404"),("134951", "2", "1000", "193", "1", "22.23", "405"),("223066", "1", "1000", "459", "1", "57.77", "406"),("223070", "1", "1000", "459", "1", "57.77", "407"),("223081", "1", "1000", "459", "1", "57.77", "408"),("223085", "1", "1000", "459", "1", "57.77", "409"),("223328", "1", "1000", "459", "1", "57.77", "410"),("223333", "1", "1000", "459", "1", "57.77", "411"),("223350", "1", "1000", "459", "1", "57.77", "412"),("223351", "1", "1000", "459", "1", "57.77", "413"),("225919", "1", "1000", "459", "1", "57.77", "414"),("225959", "1", "1000", "459", "1", "57.77", "415"),("225969", "1", "1000", "459", "1", "57.77", "416"),("225978", "1", "1000", "459", "1", "57.77", "417"),("225986", "1", "1000", "459", "1", "57.77", "418"),("225987", "1", "1000", "459", "1", "57.77", "419"),("237048", "1", "1000", "629", "1", "60.25", "420"),("163270", "2", "1000", "185", "1", "37.11", "421"),("181973", "1", "1000", "500", "1", "18.1", "422"),("207735", "1", "1000", "117", "1", "39.4", "423"),("133615", "2", "1000", "581", "1", "28.84", "424"),("133617", "2", "1000", "581", "1", "30.5", "425"),("133627", "2", "1000", "581", "1", "30.5", "426"),("207753", "1", "1000", "117", "1", "39.4", "427"),("226560", "2", "1000", "185", "1", "37.11", "428"),("226565", "2", "1000", "185", "1", "37.11", "429"),("244779", "2", "1000", "54", "1", "25.54", "430"),("154713", "1", "1000", "224", "1", "13.97", "431"),("226563", "2", "1000", "185", "1", "35.45", "432"),("174496", "2", "1000", "185", "1", "38.76", "433"),("174497", "2", "1000", "185", "1", "38.76", "434"),("174566", "2", "1000", "185", "1", "38.76", "435"),("53232", "2", "1000", "115", "1", "23.06", "436"),("92305", "2", "1000", "42", "1", "23.88", "437"),("92306", "2", "1000", "42", "1", "23.88", "438"),("92307", "2", "1000", "42", "1", "23.88", "439"),("92308", "2", "1000", "42", "1", "23.88", "440"),("92310", "2", "1000", "42", "1", "23.88", "441"),("104809", "2", "1000", "42", "1", "10.66", "442"),("104811", "2", "1000", "42", "1", "10.66", "443"),("104815", "2", "1000", "42", "1", "10.66", "444"),("104817", "2", "1000", "42", "1", "10.66", "445"),("104819", "2", "1000", "42", "1", "10.66", "446"),("134941", "2", "1000", "193", "1", "22.23", "447"),("134943", "2", "1000", "193", "1", "22.23", "448"),("134945", "2", "1000", "193", "1", "22.23", "449"),("134947", "2", "1000", "193", "1", "22.23", "450"),("134949", "2", "1000", "193", "1", "22.23", "451"),("98861", "2", "1000", "117", "1", "36.88", "452"),("98866", "2", "1000", "117", "1", "36.88", "453"),("98867", "2", "1000", "117", "1", "36.88", "454"),("99685", "2", "1000", "117", "1", "38.55", "455"),("99867", "2", "1000", "117", "1", "38.55", "456"),("229244", "1", "1000", "117", "1", "52.84", "457"),("207757", "1", "1000", "117", "1", "39.4", "458"),("233236", "1", "1000", "224", "1", "13.97", "459"),("204641", "1", "1000", "423", "1", "8.18", "460"),("204643", "1", "1000", "423", "1", "4.88", "461"),("31269", "2", "1000", "117", "1", "45.28", "462"),("31273", "2", "1000", "117", "1", "45.28", "463"),("98863", "2", "1000", "117", "1", "36.88", "464"),("211261", "1", "1000", "224", "1", "33.8", "465"),("211263", "1", "1000", "224", "1", "33.8", "466"),("181975", "1", "1000", "500", "1", "16.79", "467"),("257893", "1", "1000", "650", "1", "18.93", "468"),("253830", "1", "1000", "650", "1", "22.23", "469"),("253835", "1", "1000", "650", "1", "22.23", "470"),("167338", "2", "1000", "483", "1", "28.84", "471"),("167521", "2", "1000", "483", "1", "28.84", "472"),("167541", "2", "1000", "483", "1", "28.84", "473"),("118170", "2", "1000", "105", "1", "30.5", "474"),("234610", "2", "6", "185", "1", "39.59", "475"),("168768", "2", "5", "54", "1", "42.89", "476"),("181085", "2", "3", "54", "1", "42.89", "477"),("133621", "2", "3", "581", "1", "30.5", "478"),("234623", "2", "3", "185", "1", "35.45", "479"),("11852", "2", "2", "117", "1", "41.08", "480"),("98579", "2", "2", "117", "1", "42.76", "481"),("154829", "1", "2", "224", "1", "13.97", "482"),("143787", "1", "2", "611", "1", "24.71", "483"),("168769", "2", "1", "54", "1", "25.62", "484"),("104812", "2", "1", "42", "1", "10.66", "485"),("104816", "2", "1", "42", "1", "10.66", "486"),("185897", "2", "1000", "185", "1", "107.36", "487"),("181255", "1", "1016", "13", "1", "5.7", "488"),("241639", "2", "1014", "48", "1", "9.83", "489"),("181259", "1", "1010", "13", "1", "5.7", "490"),("94946", "2", "1008", "516", "1", "23.1", "491"),("241630", "2", "1008", "48", "1", "9.83", "492"),("241652", "2", "1008", "48", "1", "9.83", "493"),("241632", "2", "1008", "48", "1", "9.83", "494"),("241628", "2", "1007", "48", "1", "9.83", "495"),("241633", "2", "1007", "48", "1", "9.83", "496"),("241640", "2", "1007", "48", "1", "9.83", "497"),("241655", "2", "1007", "48", "1", "9.83", "498"),("227536", "2", "1005", "185", "1", "50.33", "499"),("165297", "1", "1005", "611", "1", "24.71", "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'