Căutare

SELECT data
FROM `oc_session`
WHERE session_id = 'cbdcec687fb5fbae7d83b0646e'

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 ("226552", "1", "1000", "401", "1", "91.65", "1"),("238730", "2", "1001", "401", "1", "74.3", "2"),("238731", "2", "1000", "401", "1", "79.26", "3"),("162636", "1", "1000", "401", "1", "74.3", "4"),("253636", "1", "1000", "401", "1", "23.06", "5"),("263243", "1", "1000", "401", "1", "170.17", "6"),("263245", "1", "1000", "401", "1", "181.74", "7"),("263244", "1", "1000", "401", "1", "175.95", "8"),("263241", "1", "1000", "401", "1", "164.38", "9"),("263242", "1", "1000", "401", "1", "164.38", "10"),("263240", "1", "1000", "401", "1", "158.6", "11"),("263400", "1", "1000", "401", "1", "294.96", "12"),("263401", "1", "1000", "401", "1", "312.31", "13"),("263402", "1", "1000", "401", "1", "323.06", "14"),("263403", "1", "1000", "401", "1", "328.84", "15"),("263404", "1", "1000", "401", "1", "340.41", "16"),("254832", "1", "1000", "401", "1", "261.07", "17"),("254833", "1", "1000", "401", "1", "266.86", "18"),("254834", "1", "1000", "401", "1", "272.64", "19"),("254835", "1", "1000", "401", "1", "277.6", "20"),("254836", "1", "1000", "401", "1", "283.39", "21"),("247754", "2", "1000", "401", "1", "147.85", "22"),("257754", "2", "1000", "401", "1", "29.67", "23"),("257756", "2", "1000", "401", "1", "29.67", "24"),("257757", "2", "1000", "401", "1", "29.67", "25"),("257758", "2", "1000", "401", "1", "29.67", "26"),("257792", "2", "1000", "401", "1", "29.67", "27"),("257793", "2", "1000", "401", "1", "29.67", "28"),("257794", "2", "1000", "401", "1", "29.67", "29"),("257795", "2", "1000", "401", "1", "29.67", "30"),("257772", "2", "1000", "401", "1", "42.89", "31"),("257774", "2", "1000", "401", "1", "42.89", "32"),("257775", "2", "1000", "401", "1", "42.89", "33"),("257776", "2", "1000", "401", "1", "42.89", "34"),("245137", "1", "1002", "401", "1", "136.28", "35"),("263604", "1", "1000", "401", "1", "47.02", "36"),("263605", "1", "1000", "401", "1", "47.02", "37"),("263606", "1", "1000", "401", "1", "47.02", "38"),("263607", "1", "1000", "401", "1", "47.02", "39"),("263697", "2", "1000", "401", "1", "37.93", "40"),("263698", "2", "1000", "401", "1", "37.93", "41"),("263699", "2", "1000", "401", "1", "37.93", "42"),("263700", "2", "1000", "401", "1", "37.93", "43"),("158315", "2", "1000", "401", "1", "324.71", "44"),("252325", "1", "1000", "401", "1", "32.15", "45"),("252327", "1", "1000", "401", "1", "28.84", "46"),("252328", "1", "1000", "401", "1", "28.84", "47"),("252330", "1", "1000", "401", "1", "28.84", "48"),("263596", "2", "1000", "401", "1", "29.67", "49"),("263597", "2", "1000", "401", "1", "29.67", "50"),("263598", "2", "1000", "401", "1", "29.67", "51"),("263599", "2", "1000", "401", "1", "29.67", "52"),("263600", "2", "1000", "401", "1", "48.68", "53"),("263601", "2", "1000", "401", "1", "48.68", "54"),("263602", "2", "1000", "401", "1", "48.68", "55"),("263603", "2", "1000", "401", "1", "48.68", "56"),("263679", "1", "1000", "401", "1", "37.93", "57"),("263680", "1", "1000", "401", "1", "37.93", "58"),("263681", "1", "1000", "401", "1", "37.93", "59"),("263682", "1", "1000", "401", "1", "37.93", "60"),("263991", "2", "1000", "401", "1", "35.45", "61"),("263992", "2", "1000", "401", "1", "35.45", "62"),("263993", "2", "1000", "401", "1", "35.45", "63"),("263994", "2", "1000", "401", "1", "35.45", "64"),("263592", "2", "1000", "401", "1", "48.68", "65"),("263593", "2", "1000", "401", "1", "48.68", "66"),("263594", "2", "1000", "401", "1", "48.68", "67"),("263595", "2", "1000", "401", "1", "48.68", "68"),("263683", "2", "1000", "401", "1", "35.45", "69"),("263686", "2", "1000", "401", "1", "35.45", "70"),("263687", "2", "1000", "401", "1", "35.45", "71"),("263688", "2", "1000", "401", "1", "35.45", "72"),("263689", "2", "1000", "401", "1", "37.93", "73"),("263691", "2", "1000", "401", "1", "37.93", "74"),("263694", "2", "1000", "401", "1", "37.93", "75"),("263695", "2", "1000", "401", "1", "37.93", "76"),("263987", "2", "1000", "401", "1", "33.8", "77"),("263988", "2", "1000", "401", "1", "33.8", "78"),("263989", "2", "1000", "401", "1", "33.8", "79"),("263990", "2", "1000", "401", "1", "33.8", "80"),("134799", "1", "1005", "401", "1", "5.7", "81"),("134737", "1", "1005", "401", "1", "5.7", "82"),("134805", "1", "1005", "401", "1", "5.7", "83"),("134807", "1", "1005", "401", "1", "5.7", "84"),("134803", "1", "1004", "401", "1", "5.7", "85"),("134801", "1", "1002", "401", "1", "5.7", "86"),("134735", "1", "1001", "401", "1", "5.7", "87"),("158313", "2", "1000", "401", "1", "304.88", "88"),("134809", "1", "1000", "401", "1", "7.36", "89"),("114799", "2", "1000", "401", "1", "52.81", "90"),("197641", "2", "1000", "401", "1", "9.83", "91"),("197643", "2", "1000", "401", "1", "9.83", "92"),("197645", "2", "1000", "401", "1", "13.97", "93"),("224621", "1", "1000", "401", "1", "207.36", "94"),("61619", "2", "1005", "401", "1", "9.01", "95"),("114491", "2", "1002", "401", "1", "48.68", "96"),("224616", "1", "1002", "401", "1", "79.26", "97"),("183739", "1", "1002", "401", "1", "10.66", "98"),("61620", "2", "1002", "401", "1", "9.01", "99"),("183737", "1", "1001", "401", "1", "10.66", "100"),("224615", "1", "1000", "401", "1", "74.3", "101"),("224617", "1", "1000", "401", "1", "85.04", "102"),("113877", "2", "1", "401", "1", "14.79", "103"),("113898", "2", "1", "401", "1", "14.79", "104"),("257790", "1", "1000", "401", "1", "46.2", "105"),("257791", "1", "1000", "401", "1", "46.2", "106"),("225891", "1", "1000", "401", "1", "49.5", "107"),("257789", "1", "1000", "401", "1", "46.2", "108"),("172587", "2", "1002", "401", "1", "8.18", "109"),("59985", "2", "1001", "401", "1", "130.5", "110"),("172571", "2", "1001", "401", "1", "7.36", "111"),("114856", "2", "1000", "401", "1", "22.23", "112"),("168444", "2", "1000", "401", "1", "148.68", "113"),("172582", "2", "1000", "401", "1", "18.93", "114"),("172594", "2", "1000", "401", "1", "7.36", "115"),("228255", "1", "1000", "401", "1", "114.79", "116"),("59962", "2", "1000", "401", "1", "126.36", "117"),("59982", "2", "1000", "401", "1", "146.2", "118"),("59983", "2", "1000", "401", "1", "168.51", "119"),("172574", "2", "1000", "401", "1", "18.1", "120"),("114798", "2", "1000", "401", "1", "5.7", "121"),("173645", "2", "999", "401", "1", "148.68", "122"),("61618", "2", "22", "401", "1", "9.01", "123"),("172591", "2", "4", "401", "1", "5.7", "124"),("114797", "2", "1", "401", "1", "34.63", "125"),("172572", "2", "1", "401", "1", "7.36", "126"),("113645", "2", "1000", "401", "1", "92.48", "127"),("158527", "2", "1001", "401", "1", "10.66", "128"),("158609", "2", "1001", "401", "1", "12.31", "129"),("158611", "2", "1001", "401", "1", "11.49", "130"),("132467", "1", "1000", "401", "1", "40.41", "131"),("224618", "1", "1000", "401", "1", "193.31", "132"),("224619", "1", "1000", "401", "1", "198.26", "133"),("224620", "1", "1000", "401", "1", "204.05", "134"),("225452", "1", "1000", "401", "1", "147.02", "135"),("225454", "1", "1000", "401", "1", "126.36", "136"),("225455", "1", "1000", "401", "1", "141.24", "137"),("225468", "1", "1000", "401", "1", "141.24", "138"),("188795", "2", "1000", "401", "1", "7.36", "139"),("188797", "2", "1000", "401", "1", "7.36", "140"),("188799", "2", "1000", "401", "1", "7.36", "141"),("188811", "1", "1000", "401", "1", "190.83", "142"),("188813", "1", "1000", "401", "1", "187.52", "143"),("188815", "1", "1000", "401", "1", "235.45", "144"),("188817", "1", "1000", "401", "1", "265.21", "145"),("158515", "2", "1000", "401", "1", "29.67", "146"),("158525", "2", "1000", "401", "1", "10.66", "147"),("158529", "2", "1000", "401", "1", "10.66", "148"),("158531", "2", "1000", "401", "1", "10.66", "149"),("158533", "2", "1000", "401", "1", "10.66", "150"),("158585", "2", "1000", "401", "1", "10.66", "151"),("158587", "2", "1000", "401", "1", "11.49", "152"),("158589", "2", "1000", "401", "1", "10.66", "153"),("158591", "2", "1000", "401", "1", "10.66", "154"),("158605", "2", "1000", "401", "1", "12.31", "155"),("158607", "2", "1000", "401", "1", "12.31", "156"),("158613", "2", "1000", "401", "1", "10.66", "157"),("167665", "1", "1000", "401", "1", "10.66", "158"),("234202", "1", "1000", "401", "1", "25.54", "159"),("234203", "1", "1000", "401", "1", "25.54", "160"),("234204", "1", "1000", "401", "1", "25.54", "161"),("234205", "1", "1000", "401", "1", "25.54", "162"),("234206", "1", "1000", "401", "1", "25.54", "163"),("234207", "1", "1000", "401", "1", "25.54", "164"),("234208", "1", "1000", "401", "1", "25.54", "165"),("234209", "1", "1000", "401", "1", "25.54", "166"),("234218", "1", "1000", "401", "1", "25.54", "167"),("234219", "1", "1000", "401", "1", "25.54", "168"),("234220", "1", "1000", "401", "1", "25.54", "169"),("234221", "1", "1000", "401", "1", "25.54", "170"),("234222", "1", "1000", "401", "1", "25.54", "171"),("234223", "1", "1000", "401", "1", "25.54", "172"),("234224", "1", "1000", "401", "1", "25.54", "173"),("234225", "1", "1000", "401", "1", "25.54", "174"),("234234", "1", "1000", "401", "1", "25.54", "175"),("234235", "1", "1000", "401", "1", "25.54", "176"),("234236", "1", "1000", "401", "1", "25.54", "177"),("234237", "1", "1000", "401", "1", "25.54", "178"),("234238", "1", "1000", "401", "1", "25.54", "179"),("234239", "1", "1000", "401", "1", "25.54", "180"),("234240", "1", "1000", "401", "1", "25.54", "181"),("230095", "1", "1000", "401", "1", "190.83", "182"),("230096", "1", "1000", "401", "1", "215.62", "183"),("225450", "1", "1000", "401", "1", "126.36", "184"),("225451", "1", "1000", "401", "1", "141.24", "185"),("225453", "1", "1000", "401", "1", "121.4", "186"),("225467", "1", "1000", "401", "1", "126.36", "187"),("158593", "2", "1000", "401", "1", "10.66", "188"),("230094", "1", "999", "401", "1", "178.43", "189"),("96022", "2", "3", "401", "1", "5.7", "190"),("103571", "1", "1", "401", "1", "5.7", "191"),("114855", "2", "1003", "401", "1", "5.7", "192"),("219006", "1", "1001", "401", "1", "187.52", "193"),("183709", "1", "1001", "401", "1", "9.83", "194"),("207939", "1", "1001", "401", "1", "351.98", "195"),("95878", "2", "1000", "401", "1", "53.64", "196"),("103579", "1", "1000", "401", "1", "10.66", "197"),("118416", "2", "1000", "401", "1", "86.69", "198"),("218999", "1", "1000", "401", "1", "237.93", "199"),("219000", "1", "1000", "401", "1", "221.4", "200"),("219001", "1", "1000", "401", "1", "221.4", "201"),("219002", "1", "1000", "401", "1", "221.4", "202"),("219003", "1", "1000", "401", "1", "204.05", "203"),("219005", "1", "1000", "401", "1", "204.05", "204"),("219007", "1", "1000", "401", "1", "187.52", "205"),("219572", "1", "1000", "401", "1", "164.38", "206"),("219573", "1", "1000", "401", "1", "261.07", "207"),("183707", "1", "1000", "401", "1", "9.83", "208"),("194889", "1", "1000", "401", "1", "90.83", "209"),("194891", "1", "1000", "401", "1", "108.18", "210"),("194893", "1", "1000", "401", "1", "113.97", "211"),("197657", "1", "1000", "401", "1", "9.83", "212"),("197659", "1", "1000", "401", "1", "9.83", "213"),("197661", "1", "1000", "401", "1", "9.83", "214"),("197663", "1", "1000", "401", "1", "9.83", "215"),("158511", "2", "1000", "401", "1", "29.67", "216"),("234210", "1", "1000", "401", "1", "25.54", "217"),("234211", "1", "1000", "401", "1", "25.54", "218"),("234212", "1", "1000", "401", "1", "25.54", "219"),("234213", "1", "1000", "401", "1", "25.54", "220"),("234214", "1", "1000", "401", "1", "25.54", "221"),("234215", "1", "1000", "401", "1", "25.54", "222"),("234216", "1", "1000", "401", "1", "25.54", "223"),("234217", "1", "1000", "401", "1", "25.54", "224"),("234226", "1", "1000", "401", "1", "25.54", "225"),("234227", "1", "1000", "401", "1", "25.54", "226"),("234228", "1", "1000", "401", "1", "25.54", "227"),("234229", "1", "1000", "401", "1", "25.54", "228"),("234230", "1", "1000", "401", "1", "25.54", "229"),("234231", "1", "1000", "401", "1", "25.54", "230"),("234232", "1", "1000", "401", "1", "25.54", "231"),("234233", "1", "1000", "401", "1", "25.54", "232"),("207913", "1", "1000", "401", "1", "431.32", "233"),("207941", "1", "1000", "401", "1", "396.61", "234"),("226748", "2", "1000", "401", "1", "17.27", "235"),("226749", "2", "1000", "401", "1", "17.27", "236"),("226750", "2", "1000", "401", "1", "17.27", "237"),("226753", "2", "1000", "401", "1", "17.27", "238"),("226754", "2", "1000", "401", "1", "17.27", "239"),("226755", "2", "1000", "401", "1", "17.27", "240"),("158513", "2", "1000", "401", "1", "28.02", "241"),("219004", "1", "1000", "401", "1", "204.05", "242"),("103578", "1", "7", "401", "1", "17.27", "243"),("129281", "2", "3", "401", "1", "5.7", "244"),("183715", "1", "1005", "401", "1", "9.83", "245"),("183631", "1", "1004", "401", "1", "9.83", "246"),("125589", "2", "1004", "401", "1", "89.17", "247"),("219140", "1", "1003", "401", "1", "124.71", "248"),("167666", "2", "1002", "401", "1", "5.7", "249"),("216669", "1", "1002", "401", "1", "99.09", "250"),("219143", "1", "1001", "401", "1", "104.05", "251"),("219519", "1", "1001", "401", "1", "240.41", "252"),("173644", "1", "1001", "401", "1", "148.68", "253"),("125585", "2", "1001", "401", "1", "104.05", "254"),("114806", "2", "1000", "401", "1", "20.58", "255"),("95883", "2", "1000", "401", "1", "46.2", "256"),("216671", "1", "1000", "401", "1", "99.09", "257"),("216675", "1", "1000", "401", "1", "101.57", "258"),("219021", "1", "1000", "401", "1", "104.05", "259"),("219023", "1", "1000", "401", "1", "112.31", "260"),("219024", "1", "1000", "401", "1", "108.18", "261"),("219025", "1", "1000", "401", "1", "116.45", "262"),("219034", "1", "1000", "401", "1", "104.05", "263"),("219035", "1", "1000", "401", "1", "108.18", "264"),("219036", "1", "1000", "401", "1", "99.92", "265"),("219037", "1", "1000", "401", "1", "95.79", "266"),("219038", "1", "1000", "401", "1", "104.05", "267"),("219141", "1", "1000", "401", "1", "112.31", "268"),("219490", "1", "1000", "401", "1", "145.37", "269"),("219495", "1", "1000", "401", "1", "161.9", "270"),("219499", "1", "1000", "401", "1", "170.17", "271"),("219516", "1", "1000", "401", "1", "211.49", "272"),("219532", "1", "1000", "401", "1", "269.34", "273"),("219534", "1", "1000", "401", "1", "232.15", "274"),("219539", "1", "1000", "401", "1", "277.6", "275"),("219542", "1", "1000", "401", "1", "228.02", "276"),("219567", "1", "1000", "401", "1", "207.36", "277"),("219568", "1", "1000", "401", "1", "199.09", "278"),("225444", "1", "1000", "401", "1", "186.69", "279"),("225445", "1", "1000", "401", "1", "203.22", "280"),("225446", "1", "1000", "401", "1", "215.62", "281"),("225447", "1", "1000", "401", "1", "203.22", "282"),("225448", "1", "1000", "401", "1", "219.75", "283"),("225449", "1", "1000", "401", "1", "219.75", "284"),("183643", "1", "1000", "401", "1", "9.83", "285"),("183719", "1", "1000", "401", "1", "9.83", "286"),("183721", "1", "1000", "401", "1", "9.83", "287"),("183723", "1", "1000", "401", "1", "9.01", "288"),("183725", "1", "1000", "401", "1", "9.83", "289"),("234241", "1", "1000", "401", "1", "14.79", "290"),("234242", "1", "1000", "401", "1", "14.79", "291"),("234243", "1", "1000", "401", "1", "14.79", "292"),("234244", "1", "1000", "401", "1", "14.79", "293"),("234245", "1", "1000", "401", "1", "14.79", "294"),("234246", "1", "1000", "401", "1", "14.79", "295"),("234247", "1", "1000", "401", "1", "14.79", "296"),("234248", "1", "1000", "401", "1", "14.79", "297"),("234249", "1", "1000", "401", "1", "14.79", "298"),("234250", "1", "1000", "401", "1", "14.79", "299"),("234251", "1", "1000", "401", "1", "16.45", "300"),("234252", "1", "1000", "401", "1", "16.45", "301"),("234253", "1", "1000", "401", "1", "16.45", "302"),("234254", "1", "1000", "401", "1", "16.45", "303"),("234255", "1", "1000", "401", "1", "16.45", "304"),("234256", "1", "1000", "401", "1", "16.45", "305"),("234257", "1", "1000", "401", "1", "16.45", "306"),("234258", "1", "1000", "401", "1", "16.45", "307"),("234259", "1", "1000", "401", "1", "16.45", "308"),("234260", "1", "1000", "401", "1", "16.45", "309"),("176127", "2", "1000", "401", "1", "46.2", "310"),("176129", "2", "1000", "401", "1", "45.37", "311"),("226746", "2", "1000", "401", "1", "17.27", "312"),("226747", "2", "1000", "401", "1", "17.27", "313"),("226752", "2", "1000", "401", "1", "17.27", "314"),("183629", "1", "1000", "401", "1", "9.83", "315"),("207607", "1", "1000", "401", "1", "403.22", "316"),("176128", "2", "1000", "401", "1", "45.37", "317"),("219535", "1", "1000", "401", "1", "252.81", "318"),("125587", "2", "1000", "401", "1", "69.34", "319"),("183717", "1", "3", "401", "1", "9.83", "320"),("207609", "1", "2", "401", "1", "465.21", "321"),("125591", "2", "1", "401", "1", "89.17", "322"),("173636", "1", "1", "401", "1", "139.59", "323"),("197671", "1", "1005", "401", "1", "9.83", "324"),("183703", "2", "1003", "401", "1", "42.07", "325"),("197669", "1", "1003", "401", "1", "9.83", "326"),("234269", "1", "1002", "401", "1", "16.45", "327"),("125597", "2", "1001", "401", "1", "82.56", "328"),("183701", "2", "1001", "401", "1", "31.32", "329"),("183705", "2", "1001", "401", "1", "53.64", "330"),("183699", "2", "1001", "401", "1", "29.67", "331"),("125593", "2", "1000", "401", "1", "64.38", "332"),("125595", "2", "1000", "401", "1", "64.38", "333"),("219569", "1", "1000", "401", "1", "170.17", "334"),("219570", "1", "1000", "401", "1", "157.77", "335"),("183645", "1", "1000", "401", "1", "9.83", "336"),("183647", "1", "1000", "401", "1", "9.83", "337"),("183649", "1", "1000", "401", "1", "9.83", "338"),("183651", "1", "1000", "401", "1", "9.83", "339"),("197665", "1", "1000", "401", "1", "9.83", "340"),("197667", "1", "1000", "401", "1", "9.83", "341"),("197673", "1", "1000", "401", "1", "13.97", "342"),("197675", "1", "1000", "401", "1", "13.97", "343"),("197677", "1", "1000", "401", "1", "17.27", "344"),("197679", "1", "1000", "401", "1", "17.27", "345"),("234261", "1", "1000", "401", "1", "16.45", "346"),("234262", "1", "1000", "401", "1", "16.45", "347"),("234263", "1", "1000", "401", "1", "16.45", "348"),("234264", "1", "1000", "401", "1", "16.45", "349"),("234265", "1", "1000", "401", "1", "16.45", "350"),("234266", "1", "1000", "401", "1", "16.45", "351"),("234267", "1", "1000", "401", "1", "16.45", "352"),("234268", "1", "1000", "401", "1", "16.45", "353"),("234270", "1", "1000", "401", "1", "16.45", "354"),("207631", "2", "1000", "401", "1", "13.97", "355"),("207633", "2", "1000", "401", "1", "19.75", "356"),("207635", "2", "1000", "401", "1", "19.75", "357"),("241379", "2", "1000", "401", "1", "45.37", "358"),("241382", "2", "1000", "401", "1", "45.37", "359"),("241383", "2", "1000", "401", "1", "45.37", "360"),("241384", "2", "1000", "401", "1", "45.37", "361"),("241385", "2", "1000", "401", "1", "45.37", "362"),("241386", "2", "1000", "401", "1", "45.37", "363"),("241387", "2", "1000", "401", "1", "45.37", "364"),("241388", "2", "1000", "401", "1", "45.37", "365"),("241389", "2", "1000", "401", "1", "45.37", "366"),("241390", "2", "1000", "401", "1", "32.15", "367"),("241391", "2", "1000", "401", "1", "45.37", "368"),("241392", "2", "1000", "401", "1", "45.37", "369"),("241393", "2", "1000", "401", "1", "45.37", "370"),("241394", "2", "1000", "401", "1", "45.37", "371"),("241395", "2", "1000", "401", "1", "45.37", "372"),("241396", "2", "1000", "401", "1", "45.37", "373"),("241397", "2", "1000", "401", "1", "45.37", "374"),("241398", "2", "1000", "401", "1", "45.37", "375"),("241399", "2", "1000", "401", "1", "45.37", "376"),("241400", "2", "1000", "401", "1", "45.37", "377"),("241401", "2", "1000", "401", "1", "45.37", "378"),("230097", "1", "1000", "401", "1", "228.02", "379"),("230098", "1", "1000", "401", "1", "236.28", "380"),("230099", "1", "1000", "401", "1", "248.68", "381"),("241381", "2", "1000", "401", "1", "45.37", "382"),("241378", "2", "1000", "401", "1", "45.37", "383"),("241380", "2", "1000", "401", "1", "45.37", "384"),("207629", "2", "1000", "401", "1", "15.62", "385"),("113232", "2", "1", "401", "1", "42.07", "386"),("237780", "2", "1003", "401", "1", "10.66", "387"),("183613", "1", "1002", "401", "1", "8.18", "388"),("183615", "1", "1001", "401", "1", "8.18", "389"),("237778", "2", "1001", "401", "1", "10.66", "390"),("237781", "2", "1001", "401", "1", "10.66", "391"),("237782", "2", "1001", "401", "1", "10.66", "392"),("237787", "2", "1001", "401", "1", "8.18", "393"),("237788", "2", "1001", "401", "1", "8.18", "394"),("237789", "2", "1001", "401", "1", "8.18", "395"),("237791", "2", "1001", "401", "1", "9.01", "396"),("237793", "2", "1001", "401", "1", "8.18", "397"),("148185", "2", "1001", "401", "1", "9.01", "398"),("148187", "2", "1001", "401", "1", "9.01", "399"),("148195", "2", "1001", "401", "1", "9.01", "400"),("148189", "2", "1001", "401", "1", "9.01", "401"),("125599", "2", "1001", "401", "1", "99.92", "402"),("125601", "2", "1000", "401", "1", "99.92", "403"),("125605", "2", "1000", "401", "1", "75.12", "404"),("125609", "2", "1000", "401", "1", "86.69", "405"),("125611", "2", "1000", "401", "1", "77.6", "406"),("125613", "2", "1000", "401", "1", "82.56", "407"),("216755", "1", "1000", "401", "1", "17.27", "408"),("216757", "1", "1000", "401", "1", "17.27", "409"),("216759", "1", "1000", "401", "1", "17.27", "410"),("216761", "1", "1000", "401", "1", "17.27", "411"),("223151", "1", "1000", "401", "1", "8.02", "412"),("183611", "1", "1000", "401", "1", "8.18", "413"),("197699", "1", "1000", "401", "1", "8.18", "414"),("237779", "2", "1000", "401", "1", "10.66", "415"),("237783", "2", "1000", "401", "1", "9.01", "416"),("237784", "2", "1000", "401", "1", "9.01", "417"),("237785", "2", "1000", "401", "1", "9.01", "418"),("237790", "2", "1000", "401", "1", "8.18", "419"),("237794", "2", "1000", "401", "1", "8.18", "420"),("148193", "2", "1000", "401", "1", "9.01", "421"),("241374", "1", "1000", "401", "1", "26.36", "422"),("241375", "1", "1000", "401", "1", "23.06", "423"),("241376", "1", "1000", "401", "1", "23.06", "424"),("241377", "1", "1000", "401", "1", "23.06", "425"),("228261", "2", "1000", "401", "1", "182.56", "426"),("228264", "2", "1000", "401", "1", "186.69", "427"),("183607", "1", "2", "401", "1", "9.01", "428"),("197651", "2", "1006", "401", "1", "9.83", "429"),("197653", "2", "1005", "401", "1", "9.83", "430"),("220500", "2", "1002", "401", "1", "51.16", "431"),("197649", "2", "1002", "401", "1", "9.83", "432"),("220495", "2", "1001", "401", "1", "64.38", "433"),("220502", "2", "1001", "401", "1", "51.16", "434"),("220515", "2", "1001", "401", "1", "51.16", "435"),("237777", "2", "1001", "401", "1", "10.66", "436"),("220494", "2", "1000", "401", "1", "64.38", "437"),("220496", "2", "1000", "401", "1", "58.6", "438"),("220497", "2", "1000", "401", "1", "58.6", "439"),("220498", "2", "1000", "401", "1", "58.6", "440"),("220499", "2", "1000", "401", "1", "51.16", "441"),("220504", "2", "1000", "401", "1", "64.38", "442"),("220505", "2", "1000", "401", "1", "64.38", "443"),("220506", "2", "1000", "401", "1", "70.17", "444"),("220508", "2", "1000", "401", "1", "70.17", "445"),("220509", "2", "1000", "401", "1", "70.17", "446"),("220510", "2", "1000", "401", "1", "64.38", "447"),("220511", "2", "1000", "401", "1", "64.38", "448"),("220512", "2", "1000", "401", "1", "58.6", "449"),("220513", "2", "1000", "401", "1", "58.6", "450"),("220514", "2", "1000", "401", "1", "51.16", "451"),("220516", "2", "1000", "401", "1", "51.16", "452"),("220517", "2", "1000", "401", "1", "70.17", "453"),("220518", "2", "1000", "401", "1", "70.17", "454"),("220519", "2", "1000", "401", "1", "64.38", "455"),("220520", "2", "1000", "401", "1", "64.38", "456"),("220521", "2", "1000", "401", "1", "58.6", "457"),("220522", "2", "1000", "401", "1", "58.6", "458"),("220523", "2", "1000", "401", "1", "51.16", "459"),("220524", "2", "1000", "401", "1", "51.16", "460"),("220525", "2", "1000", "401", "1", "51.16", "461"),("183595", "2", "1000", "401", "1", "136.28", "462"),("183597", "2", "1000", "401", "1", "147.85", "463"),("183617", "1", "1000", "401", "1", "8.18", "464"),("183619", "1", "1000", "401", "1", "8.18", "465"),("183623", "1", "1000", "401", "1", "9.83", "466"),("183625", "1", "1000", "401", "1", "9.83", "467"),("183627", "1", "1000", "401", "1", "9.83", "468"),("197647", "2", "1000", "401", "1", "9.83", "469"),("197655", "2", "1000", "401", "1", "9.83", "470"),("237786", "2", "1000", "401", "1", "8.18", "471"),("237792", "2", "1000", "401", "1", "8.18", "472"),("238124", "1", "1000", "401", "1", "12.31", "473"),("238125", "1", "1000", "401", "1", "12.31", "474"),("238127", "1", "1000", "401", "1", "12.31", "475"),("148191", "2", "1000", "401", "1", "9.01", "476"),("220507", "2", "1000", "401", "1", "61.9", "477"),("238126", "1", "1000", "401", "1", "12.31", "478"),("220501", "2", "1000", "401", "1", "51.16", "479"),("114382", "2", "1001", "401", "1", "18.1", "480"),("188819", "1", "1001", "401", "1", "113.97", "481"),("183369", "1", "1000", "24", "1", "227.19", "482"),("96183", "2", "1002", "24", "1", "5.7", "483"),("96182", "2", "1002", "24", "1", "5.7", "484"),("158597", "1", "1002", "24", "1", "9.01", "485"),("96185", "2", "1001", "24", "1", "5.7", "486"),("158603", "1", "1001", "24", "1", "9.01", "487"),("158599", "1", "1001", "24", "1", "9.83", "488"),("96186", "2", "1000", "24", "1", "6.53", "489"),("158595", "1", "1000", "24", "1", "9.01", "490"),("158615", "1", "1000", "24", "1", "10.66", "491"),("158617", "1", "1000", "24", "1", "10.66", "492"),("158619", "1", "1000", "24", "1", "10.66", "493"),("158621", "1", "1000", "24", "1", "10.66", "494"),("158623", "1", "1000", "24", "1", "10.66", "495"),("153693", "2", "1000", "24", "1", "215.62", "496"),("96184", "2", "1000", "24", "1", "5.7", "497"),("158601", "1", "1000", "24", "1", "9.01", "498"),("69990", "2", "1000", "24", "1", "5.7", "499"),("188809", "2", "1000", "163", "1", "215.62", "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'