Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '7345073a8e3698add991a50dab'

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 ("253852", "1", "1000", "650", "1", "22.23", "1"),("254123", "1", "1000", "650", "1", "18.1", "2"),("254131", "1", "1000", "650", "1", "18.1", "3"),("254688", "1", "1000", "650", "1", "22.23", "4"),("259322", "1", "1000", "650", "1", "20.58", "5"),("259334", "1", "1000", "650", "1", "20.58", "6"),("254696", "1", "1000", "650", "1", "22.23", "7"),("256082", "1", "1000", "650", "1", "18.93", "8"),("256732", "1", "1000", "611", "1", "26.36", "9"),("259247", "1", "1000", "650", "1", "18.1", "10"),("259248", "1", "1000", "650", "1", "18.1", "11"),("259250", "1", "1000", "650", "1", "18.1", "12"),("257861", "1", "1000", "650", "1", "18.1", "13"),("257872", "1", "1000", "650", "1", "18.1", "14"),("257882", "1", "1000", "650", "1", "18.93", "15"),("253830", "1", "1000", "650", "1", "22.23", "16"),("253835", "1", "1000", "650", "1", "22.23", "17"),("253844", "1", "1000", "650", "1", "22.23", "18"),("253847", "1", "1000", "650", "1", "22.23", "19"),("253851", "1", "1000", "650", "1", "22.23", "20"),("253855", "1", "1000", "650", "1", "22.23", "21"),("254126", "1", "1000", "650", "1", "18.1", "22"),("254694", "1", "1000", "650", "1", "22.23", "23"),("254695", "1", "1000", "650", "1", "22.23", "24"),("254697", "1", "1000", "650", "1", "22.23", "25"),("254701", "1", "1000", "650", "1", "22.23", "26"),("256089", "1", "1000", "650", "1", "18.93", "27"),("256735", "1", "1000", "611", "1", "26.36", "28"),("256737", "1", "1000", "611", "1", "26.36", "29"),("256795", "1", "1000", "611", "1", "23.06", "30"),("259020", "1", "1000", "650", "1", "22.23", "31"),("259249", "1", "1000", "650", "1", "18.1", "32"),("259324", "1", "1000", "650", "1", "20.58", "33"),("259325", "1", "1000", "650", "1", "20.58", "34"),("259329", "1", "1000", "650", "1", "20.58", "35"),("259333", "1", "1000", "650", "1", "20.58", "36"),("258261", "1", "1000", "650", "1", "22.23", "37"),("258262", "1", "1000", "650", "1", "22.23", "38"),("257862", "1", "1000", "650", "1", "18.1", "39"),("257867", "1", "1000", "650", "1", "18.1", "40"),("257871", "1", "1000", "650", "1", "18.1", "41"),("257883", "1", "1000", "650", "1", "18.93", "42"),("257884", "1", "1000", "650", "1", "18.93", "43"),("257893", "1", "1000", "650", "1", "18.93", "44"),("273301", "2", "1005", "809", "1", "12.31", "45"),("273302", "2", "1004", "809", "1", "10.66", "46"),("253833", "1", "1003", "650", "1", "22.23", "47"),("252425", "1", "1000", "654", "1", "20.58", "48"),("253832", "1", "1000", "650", "1", "22.23", "49"),("253836", "1", "1000", "650", "1", "22.23", "50"),("253840", "1", "1000", "650", "1", "22.23", "51"),("253842", "1", "1000", "650", "1", "22.23", "52"),("253845", "1", "1000", "650", "1", "22.23", "53"),("253853", "1", "1000", "650", "1", "22.23", "54"),("253856", "1", "1000", "650", "1", "22.23", "55"),("254692", "1", "1000", "650", "1", "22.23", "56"),("224722", "1", "1000", "729", "1", "44.55", "57"),("224724", "1", "1000", "729", "1", "44.55", "58"),("256084", "1", "1000", "650", "1", "18.93", "59"),("263713", "1", "1000", "480", "1", "104.95", "60"),("263715", "1", "1000", "480", "1", "104.95", "61"),("256792", "1", "1000", "611", "1", "23.06", "62"),("259323", "1", "1000", "650", "1", "20.58", "63"),("259326", "1", "1000", "650", "1", "20.58", "64"),("259327", "1", "1000", "650", "1", "20.58", "65"),("259345", "1", "1000", "650", "1", "18.93", "66"),("259351", "1", "1000", "650", "1", "18.1", "67"),("259525", "1", "1000", "654", "1", "20.58", "68"),("258260", "1", "1000", "650", "1", "22.23", "69"),("257865", "1", "1000", "650", "1", "18.1", "70"),("257873", "1", "1000", "650", "1", "18.1", "71"),("257885", "1", "1000", "650", "1", "18.93", "72"),("257887", "1", "1000", "650", "1", "18.93", "73"),("257888", "1", "1000", "650", "1", "18.93", "74"),("267934", "1", "1000", "143", "1", "8.18", "75"),("267935", "1", "1000", "143", "1", "8.18", "76"),("267936", "1", "1000", "143", "1", "8.18", "77"),("267937", "1", "1000", "143", "1", "8.18", "78"),("267938", "1", "1000", "143", "1", "8.18", "79"),("267939", "1", "1000", "143", "1", "9.01", "80"),("267940", "1", "1000", "143", "1", "9.01", "81"),("267941", "1", "1000", "143", "1", "9.01", "82"),("267942", "1", "1000", "143", "1", "9.01", "83"),("267943", "1", "1000", "143", "1", "9.01", "84"),("253831", "1", "1000", "650", "1", "22.23", "85"),("253834", "1", "1000", "650", "1", "22.23", "86"),("253850", "1", "1000", "650", "1", "22.23", "87"),("253861", "1", "1000", "650", "1", "22.23", "88"),("254698", "1", "1000", "650", "1", "22.23", "89"),("254700", "1", "1000", "650", "1", "22.23", "90"),("256081", "1", "1000", "650", "1", "18.93", "91"),("256085", "1", "1000", "650", "1", "18.93", "92"),("256086", "1", "1000", "650", "1", "18.93", "93"),("262464", "1", "1000", "371", "1", "50.4", "94"),("262521", "1", "1000", "480", "1", "15.29", "95"),("262522", "1", "1000", "480", "1", "15.29", "96"),("262523", "1", "1000", "480", "1", "15.29", "97"),("262524", "1", "1000", "480", "1", "15.29", "98"),("262525", "1", "1000", "480", "1", "15.29", "99"),("262526", "1", "1000", "480", "1", "15.29", "100"),("262527", "1", "1000", "480", "1", "19", "101"),("262528", "1", "1000", "480", "1", "19", "102"),("262529", "1", "1000", "480", "1", "19", "103"),("262530", "1", "1000", "480", "1", "19", "104"),("262531", "1", "1000", "480", "1", "19", "105"),("262532", "1", "1000", "480", "1", "19", "106"),("263712", "1", "1000", "480", "1", "104.95", "107"),("263714", "1", "1000", "480", "1", "104.95", "108"),("256790", "1", "1000", "611", "1", "23.06", "109"),("257863", "1", "1000", "650", "1", "18.1", "110"),("257866", "1", "1000", "650", "1", "18.1", "111"),("257886", "1", "1000", "650", "1", "18.93", "112"),("257889", "1", "1000", "650", "1", "18.93", "113"),("257890", "1", "1000", "650", "1", "18.93", "114"),("54837", "2", "1000", "279", "1", "26.36", "115"),("15273", "2", "1000", "115", "1", "14.79", "116"),("15279", "2", "1000", "115", "1", "14.79", "117"),("15280", "2", "1000", "115", "1", "14.79", "118"),("15286", "2", "1000", "115", "1", "19.75", "119"),("252433", "1", "1000", "654", "1", "20.58", "120"),("253837", "1", "1000", "650", "1", "22.23", "121"),("253839", "1", "1000", "650", "1", "22.23", "122"),("254146", "1", "1000", "650", "1", "18.93", "123"),("224725", "1", "1000", "729", "1", "44.55", "124"),("247748", "1", "1000", "455", "1", "6.53", "125"),("247751", "1", "1000", "455", "1", "7.36", "126"),("256087", "1", "1000", "650", "1", "18.93", "127"),("256090", "1", "1000", "650", "1", "18.93", "128"),("262460", "1", "1000", "371", "1", "50.4", "129"),("262461", "1", "1000", "371", "1", "50.4", "130"),("262462", "1", "1000", "371", "1", "50.4", "131"),("262463", "1", "1000", "371", "1", "50.4", "132"),("259532", "1", "1000", "654", "1", "20.58", "133"),("258225", "1", "1000", "650", "1", "18.1", "134"),("257869", "1", "1000", "650", "1", "18.1", "135"),("257891", "1", "1000", "650", "1", "18.93", "136"),("247749", "1", "1049", "455", "1", "6.53", "137"),("252427", "1", "1000", "654", "1", "20.58", "138"),("252428", "1", "1000", "654", "1", "20.58", "139"),("252429", "1", "1000", "654", "1", "20.58", "140"),("252430", "1", "1000", "654", "1", "20.58", "141"),("253838", "1", "1000", "650", "1", "22.23", "142"),("247747", "1", "1000", "455", "1", "6.53", "143"),("247750", "1", "1000", "455", "1", "7.36", "144"),("247752", "1", "1000", "455", "1", "7.36", "145"),("256088", "1", "1000", "650", "1", "18.93", "146"),("262465", "1", "1000", "371", "1", "50.4", "147"),("259526", "1", "1000", "654", "1", "20.58", "148"),("259527", "1", "1000", "654", "1", "20.58", "149"),("259528", "1", "1000", "654", "1", "20.58", "150"),("259529", "1", "1000", "654", "1", "20.58", "151"),("257892", "1", "1000", "650", "1", "18.93", "152"),("7660", "2", "1005", "54", "1", "32.98", "153"),("168884", "2", "1003", "54", "1", "32.98", "154"),("15268", "2", "1000", "115", "1", "14.79", "155"),("15281", "2", "1000", "115", "1", "14.79", "156"),("15287", "2", "1000", "115", "1", "19.75", "157"),("15288", "2", "1000", "115", "1", "19.75", "158"),("53034", "2", "1000", "115", "1", "21.4", "159"),("168886", "2", "8", "54", "1", "23.88", "160"),("252431", "1", "1000", "654", "1", "20.58", "161"),("247810", "1", "1000", "85", "1", "28.84", "162"),("247813", "1", "1000", "85", "1", "28.84", "163"),("256345", "1", "1000", "85", "1", "28.84", "164"),("256346", "1", "1000", "85", "1", "28.84", "165"),("262837", "2", "1000", "193", "1", "14.79", "166"),("262845", "2", "1000", "193", "1", "14.79", "167"),("262846", "2", "1000", "193", "1", "14.79", "168"),("262854", "2", "1000", "193", "1", "14.79", "169"),("262855", "2", "1000", "193", "1", "14.79", "170"),("259530", "1", "1000", "654", "1", "20.58", "171"),("42838", "2", "1000", "85", "1", "23.06", "172"),("77459", "2", "1000", "85", "1", "23.06", "173"),("168538", "2", "1003", "54", "1", "32.98", "174"),("170778", "1", "1002", "656", "1", "31.32", "175"),("183739", "1", "1002", "401", "1", "11.49", "176"),("118705", "2", "1001", "105", "1", "17.27", "177"),("224925", "1", "1001", "729", "1", "44.55", "178"),("15272", "2", "1000", "115", "1", "14.79", "179"),("15274", "2", "1000", "115", "1", "14.79", "180"),("15284", "2", "1000", "115", "1", "19.75", "181"),("15285", "2", "1000", "115", "1", "19.75", "182"),("118702", "2", "1000", "105", "1", "12.5", "183"),("170777", "1", "1000", "656", "1", "31.32", "184"),("170780", "1", "1000", "656", "1", "31.32", "185"),("170782", "1", "1000", "656", "1", "31.32", "186"),("183737", "1", "1000", "401", "1", "11.49", "187"),("168540", "2", "1000", "54", "1", "32.98", "188"),("224918", "1", "1000", "729", "1", "44.55", "189"),("224924", "1", "1000", "729", "1", "44.55", "190"),("168887", "2", "8", "54", "1", "23.88", "191"),("168541", "2", "5", "54", "1", "32.98", "192"),("165270", "1", "5", "611", "1", "48.68", "193"),("165269", "1", "2", "611", "1", "28.84", "194"),("252432", "1", "1000", "654", "1", "20.58", "195"),("256344", "1", "1000", "85", "1", "28.84", "196"),("259531", "1", "1000", "654", "1", "20.58", "197"),("15267", "2", "1000", "115", "1", "14.79", "198"),("262675", "2", "1000", "193", "1", "14.79", "199"),("262683", "2", "1000", "193", "1", "14.79", "200"),("262684", "2", "1000", "193", "1", "14.79", "201"),("262685", "2", "1000", "193", "1", "14.79", "202"),("262686", "2", "1000", "193", "1", "14.79", "203"),("264028", "1", "1000", "193", "1", "17.27", "204"),("264029", "1", "1000", "193", "1", "17.27", "205"),("264030", "1", "1000", "193", "1", "17.27", "206"),("264031", "1", "1000", "193", "1", "17.27", "207"),("264032", "1", "1000", "193", "1", "17.27", "208"),("264033", "1", "1000", "193", "1", "17.27", "209"),("264034", "1", "1000", "193", "1", "17.27", "210"),("264035", "1", "1000", "193", "1", "17.27", "211"),("264036", "1", "1000", "193", "1", "17.27", "212"),("264037", "1", "1000", "193", "1", "17.27", "213"),("264038", "1", "1000", "193", "1", "17.27", "214"),("264039", "1", "1000", "193", "1", "17.27", "215"),("163179", "1", "1049", "455", "1", "5.7", "216"),("163181", "1", "1048", "455", "1", "5.7", "217"),("163180", "1", "1040", "455", "1", "5.7", "218"),("163177", "1", "1038", "455", "1", "5.7", "219"),("168881", "2", "1009", "54", "1", "32.98", "220"),("165306", "1", "1005", "611", "1", "27.19", "221"),("118754", "2", "1002", "105", "1", "15.02", "222"),("168539", "2", "1002", "54", "1", "32.98", "223"),("103309", "2", "1001", "15", "1", "24.71", "224"),("103310", "2", "1001", "15", "1", "24.71", "225"),("103318", "2", "1001", "15", "1", "29.67", "226"),("185659", "1", "1001", "455", "1", "27.19", "227"),("15315", "2", "1000", "115", "1", "17.27", "228"),("15276", "2", "1000", "115", "1", "14.79", "229"),("15309", "2", "1000", "115", "1", "21.4", "230"),("118756", "2", "1000", "105", "1", "15.02", "231"),("118757", "2", "1000", "105", "1", "21.4", "232"),("103308", "2", "1000", "15", "1", "24.71", "233"),("103311", "2", "1000", "15", "1", "24.71", "234"),("103312", "2", "1000", "15", "1", "24.71", "235"),("103313", "2", "1000", "15", "1", "24.71", "236"),("103314", "2", "1000", "15", "1", "24.71", "237"),("103315", "2", "1000", "15", "1", "24.71", "238"),("103322", "2", "1000", "15", "1", "29.67", "239"),("53029", "2", "1000", "115", "1", "23.06", "240"),("53032", "2", "1000", "115", "1", "23.06", "241"),("53259", "2", "1000", "115", "1", "6.53", "242"),("182123", "1", "1000", "656", "1", "32.98", "243"),("182127", "1", "1000", "656", "1", "32.98", "244"),("163178", "1", "1000", "455", "1", "5.7", "245"),("163182", "1", "1000", "455", "1", "5.7", "246"),("224912", "1", "1000", "729", "1", "42.89", "247"),("224913", "1", "1000", "729", "1", "42.89", "248"),("224914", "1", "1000", "729", "1", "42.89", "249"),("224915", "1", "1000", "729", "1", "42.89", "250"),("224916", "1", "1000", "729", "1", "42.89", "251"),("224917", "1", "1000", "729", "1", "42.89", "252"),("224919", "1", "1000", "729", "1", "44.55", "253"),("224920", "1", "1000", "729", "1", "44.55", "254"),("224923", "1", "1000", "729", "1", "44.55", "255"),("225228", "1", "1000", "528", "1", "9.65", "256"),("225229", "1", "1000", "528", "1", "9.65", "257"),("225230", "1", "1000", "528", "1", "9.65", "258"),("225232", "1", "1000", "528", "1", "9.65", "259"),("168533", "2", "5", "54", "1", "32.98", "260"),("15312", "2", "1000", "115", "1", "21.4", "261"),("15671", "2", "1000", "115", "1", "23.06", "262"),("54813", "2", "1000", "279", "1", "26.36", "263"),("54830", "2", "1000", "279", "1", "26.36", "264"),("54831", "2", "1000", "279", "1", "26.36", "265"),("188545", "2", "1005", "54", "1", "32.98", "266"),("165309", "1", "1003", "611", "1", "27.19", "267"),("15313", "2", "1000", "115", "1", "17.27", "268"),("118752", "2", "1000", "105", "1", "21.4", "269"),("118753", "2", "1000", "105", "1", "15.02", "270"),("118755", "2", "1000", "105", "1", "21.4", "271"),("103317", "2", "1000", "15", "1", "29.67", "272"),("103320", "2", "1000", "15", "1", "29.67", "273"),("103321", "2", "1000", "15", "1", "29.67", "274"),("103323", "2", "1000", "15", "1", "29.67", "275"),("108246", "2", "1000", "15", "1", "29.67", "276"),("108247", "2", "1000", "15", "1", "29.67", "277"),("108248", "2", "1000", "15", "1", "29.67", "278"),("53030", "2", "1000", "115", "1", "23.06", "279"),("53031", "2", "1000", "115", "1", "20.58", "280"),("53033", "2", "1000", "115", "1", "23.06", "281"),("170183", "2", "1000", "483", "1", "30.5", "282"),("170188", "2", "1000", "483", "1", "33.8", "283"),("170192", "2", "1000", "483", "1", "30.5", "284"),("170197", "2", "1000", "483", "1", "33.8", "285"),("182121", "1", "1000", "656", "1", "32.98", "286"),("182129", "1", "1000", "656", "1", "32.98", "287"),("167357", "2", "1000", "483", "1", "30.5", "288"),("167358", "2", "1000", "483", "1", "33.8", "289"),("167364", "2", "1000", "483", "1", "30.5", "290"),("224910", "1", "1000", "729", "1", "42.89", "291"),("224926", "1", "1000", "729", "1", "44.55", "292"),("225231", "1", "1000", "528", "1", "9.65", "293"),("203969", "1", "8", "54", "1", "10.39", "294"),("203967", "1", "7", "54", "1", "10.39", "295"),("203973", "1", "7", "54", "1", "11.79", "296"),("187951", "2", "6", "54", "1", "35.45", "297"),("168758", "2", "6", "54", "1", "35.45", "298"),("168761", "2", "6", "54", "1", "21.4", "299"),("187947", "2", "5", "54", "1", "21.4", "300"),("123143", "2", "2", "493", "1", "14.79", "301"),("187955", "2", "2", "54", "1", "35.45", "302"),("203965", "1", "2", "54", "1", "9.4", "303"),("203971", "1", "2", "54", "1", "10.39", "304"),("123145", "2", "1", "493", "1", "12.31", "305"),("203975", "1", "1", "54", "1", "11.49", "306"),("203979", "1", "1", "54", "1", "11.79", "307"),("38526", "2", "1002", "279", "1", "25.54", "308"),("158597", "1", "1001", "24", "1", "9.83", "309"),("158603", "1", "1001", "24", "1", "9.83", "310"),("38527", "2", "1000", "279", "1", "25.54", "311"),("15673", "2", "1000", "115", "1", "23.06", "312"),("15679", "2", "1000", "115", "1", "23.06", "313"),("15680", "2", "1000", "115", "1", "23.06", "314"),("15294", "2", "1000", "115", "1", "20.58", "315"),("15302", "2", "1000", "115", "1", "20.58", "316"),("15303", "2", "1000", "115", "1", "20.58", "317"),("15305", "2", "1000", "115", "1", "21.4", "318"),("15308", "2", "1000", "115", "1", "21.4", "319"),("110896", "2", "1000", "279", "1", "26.36", "320"),("52991", "2", "1000", "115", "1", "16.45", "321"),("52992", "2", "1000", "115", "1", "16.45", "322"),("52994", "2", "1000", "115", "1", "16.45", "323"),("52998", "2", "1000", "115", "1", "16.45", "324"),("54825", "2", "1000", "279", "1", "26.36", "325"),("158595", "1", "1000", "24", "1", "9.83", "326"),("158599", "1", "1000", "24", "1", "10.66", "327"),("158601", "1", "1000", "24", "1", "9.83", "328"),("158615", "1", "1000", "24", "1", "11.49", "329"),("158617", "1", "1000", "24", "1", "11.49", "330"),("158619", "1", "1000", "24", "1", "11.49", "331"),("158621", "1", "1000", "24", "1", "11.49", "332"),("158623", "1", "1000", "24", "1", "11.49", "333"),("38530", "2", "2", "279", "1", "14.79", "334"),("143601", "1", "1004", "611", "1", "27.19", "335"),("143613", "1", "1004", "611", "1", "27.19", "336"),("134473", "2", "1001", "606", "1", "28.84", "337"),("103316", "2", "1000", "15", "1", "29.67", "338"),("103319", "2", "1000", "15", "1", "29.67", "339"),("109600", "2", "1000", "554", "1", "21.4", "340"),("109601", "2", "1000", "554", "1", "21.4", "341"),("153043", "1", "1000", "150", "1", "35.45", "342"),("134471", "2", "1000", "606", "1", "18.53", "343"),("134475", "2", "1000", "606", "1", "28.02", "344"),("134477", "2", "1000", "606", "1", "28.02", "345"),("134479", "2", "1000", "606", "1", "28.02", "346"),("134485", "2", "1000", "606", "1", "28.02", "347"),("134487", "2", "1000", "606", "1", "28.02", "348"),("134489", "2", "1000", "606", "1", "28.02", "349"),("134491", "2", "1000", "606", "1", "28.02", "350"),("134493", "2", "1000", "606", "1", "28.02", "351"),("134745", "2", "1000", "193", "1", "19.75", "352"),("170189", "2", "1000", "483", "1", "30.5", "353"),("170232", "2", "1000", "483", "1", "27.19", "354"),("182125", "1", "1000", "656", "1", "32.98", "355"),("232418", "1", "1000", "117", "1", "37.93", "356"),("232419", "1", "1000", "117", "1", "37.93", "357"),("232420", "1", "1000", "117", "1", "37.93", "358"),("232421", "1", "1000", "117", "1", "37.93", "359"),("232422", "1", "1000", "117", "1", "37.93", "360"),("232423", "1", "1000", "117", "1", "37.93", "361"),("232424", "1", "1000", "117", "1", "37.93", "362"),("167362", "2", "1000", "483", "1", "30.5", "363"),("224911", "1", "1000", "729", "1", "42.89", "364"),("224922", "1", "1000", "729", "1", "44.55", "365"),("229770", "1", "1000", "117", "1", "37.93", "366"),("229771", "1", "1000", "117", "1", "37.93", "367"),("229772", "1", "1000", "117", "1", "37.93", "368"),("229773", "1", "1000", "117", "1", "37.93", "369"),("229774", "1", "1000", "117", "1", "37.93", "370"),("143619", "1", "2", "611", "1", "27.19", "371"),("165305", "1", "2", "611", "1", "22.23", "372"),("256243", "1", "1000", "85", "1", "35.45", "373"),("259139", "1", "1000", "85", "1", "38.76", "374"),("259141", "1", "1000", "658", "1", "21.4", "375"),("158519", "1", "1003", "24", "1", "11.49", "376"),("38529", "2", "1000", "279", "1", "25.54", "377"),("38532", "2", "1000", "279", "1", "25.54", "378"),("15310", "2", "1000", "115", "1", "21.4", "379"),("15311", "2", "1000", "115", "1", "21.4", "380"),("15289", "2", "1000", "115", "1", "20.58", "381"),("15291", "2", "1000", "115", "1", "20.58", "382"),("15293", "2", "1000", "115", "1", "20.58", "383"),("15295", "2", "1000", "115", "1", "20.58", "384"),("15300", "2", "1000", "115", "1", "20.58", "385"),("15307", "2", "1000", "115", "1", "21.4", "386"),("52990", "2", "1000", "115", "1", "13.14", "387"),("52993", "2", "1000", "115", "1", "13.14", "388"),("52997", "2", "1000", "115", "1", "14.79", "389"),("53258", "2", "1000", "115", "1", "6.53", "390"),("53260", "2", "1000", "115", "1", "6.53", "391"),("54845", "2", "1000", "279", "1", "26.36", "392"),("54863", "2", "1000", "279", "1", "26.36", "393"),("158523", "1", "1000", "24", "1", "11.49", "394"),("38528", "2", "2", "279", "1", "14.79", "395"),("54811", "2", "2", "279", "1", "14.79", "396"),("54844", "2", "2", "279", "1", "14.79", "397"),("143617", "1", "1005", "611", "1", "27.19", "398"),("97607", "2", "1000", "67", "1", "23.88", "399"),("97611", "2", "1000", "67", "1", "23.88", "400"),("97652", "2", "1000", "67", "1", "23.88", "401"),("109602", "2", "1000", "554", "1", "21.4", "402"),("53261", "2", "1000", "115", "1", "6.53", "403"),("152989", "1", "1000", "150", "1", "35.45", "404"),("134739", "2", "1000", "193", "1", "19.75", "405"),("134925", "2", "1000", "193", "1", "22.23", "406"),("134927", "2", "1000", "193", "1", "22.23", "407"),("134929", "2", "1000", "193", "1", "22.23", "408"),("134931", "2", "1000", "193", "1", "22.23", "409"),("134933", "2", "1000", "193", "1", "22.23", "410"),("134935", "2", "1000", "193", "1", "22.23", "411"),("196135", "2", "1000", "193", "1", "18.1", "412"),("196137", "2", "1000", "193", "1", "18.1", "413"),("196139", "2", "1000", "193", "1", "18.1", "414"),("196141", "2", "1000", "193", "1", "18.1", "415"),("196143", "2", "1000", "193", "1", "18.1", "416"),("196145", "2", "1000", "193", "1", "18.1", "417"),("196147", "2", "1000", "193", "1", "18.1", "418"),("196149", "2", "1000", "193", "1", "18.1", "419"),("196153", "2", "1000", "193", "1", "18.1", "420"),("196155", "2", "1000", "193", "1", "18.1", "421"),("196157", "2", "1000", "193", "1", "18.1", "422"),("182135", "1", "1000", "123", "1", "27.19", "423"),("182143", "1", "1000", "123", "1", "27.19", "424"),("182735", "1", "1000", "701", "1", "41.24", "425"),("172103", "1", "1000", "658", "1", "24.71", "426"),("172104", "1", "1000", "658", "1", "27.19", "427"),("235428", "1", "1000", "85", "1", "28.84", "428"),("235429", "1", "1000", "85", "1", "28.84", "429"),("235432", "1", "1000", "85", "1", "28.84", "430"),("187945", "2", "16", "54", "1", "35.45", "431"),("187953", "2", "9", "54", "1", "35.45", "432"),("97613", "2", "3", "67", "1", "23.88", "433"),("131821", "1", "3", "593", "1", "14.79", "434"),("97604", "2", "2", "67", "1", "23.88", "435"),("109604", "2", "2", "554", "1", "19.72", "436"),("131819", "1", "2", "593", "1", "14.79", "437"),("229458", "1", "1004", "423", "1", "8.18", "438"),("48136", "2", "1002", "105", "1", "18.93", "439"),("38535", "2", "1000", "279", "1", "26.36", "440"),("38538", "2", "1000", "279", "1", "26.36", "441"),("15319", "2", "1000", "115", "1", "17.27", "442"),("15290", "2", "1000", "115", "1", "20.58", "443"),("15292", "2", "1000", "115", "1", "20.58", "444"),("15296", "2", "1000", "115", "1", "20.58", "445"),("15297", "2", "1000", "115", "1", "23.06", "446"),("15298", "2", "1000", "115", "1", "20.58", "447"),("15299", "2", "1000", "115", "1", "20.58", "448"),("15301", "2", "1000", "115", "1", "20.58", "449"),("48709", "2", "1000", "54", "1", "32.98", "450"),("48728", "2", "1000", "54", "1", "32.15", "451"),("66357", "2", "1000", "279", "1", "26.36", "452"),("66361", "2", "1000", "279", "1", "26.36", "453"),("66362", "2", "1000", "279", "1", "26.36", "454"),("66367", "2", "1000", "279", "1", "25.54", "455"),("92534", "2", "1000", "11", "1", "34.63", "456"),("53257", "2", "1000", "115", "1", "6.53", "457"),("54853", "2", "1000", "279", "1", "26.36", "458"),("54860", "2", "1000", "279", "1", "26.36", "459"),("54861", "2", "1000", "279", "1", "26.36", "460"),("161955", "1", "1000", "540", "1", "11.49", "461"),("229457", "1", "1000", "423", "1", "10.66", "462"),("66345", "2", "2", "279", "1", "13.97", "463"),("66366", "2", "1", "279", "1", "14.79", "464"),("54812", "2", "1", "279", "1", "14.79", "465"),("112266", "1", "1005", "455", "1", "17.27", "466"),("134604", "2", "1001", "193", "1", "19.75", "467"),("97599", "2", "1000", "67", "1", "23.88", "468"),("97606", "2", "1000", "67", "1", "23.88", "469"),("97608", "2", "1000", "67", "1", "23.88", "470"),("97609", "2", "1000", "67", "1", "23.88", "471"),("97610", "2", "1000", "67", "1", "23.88", "472"),("97612", "2", "1000", "67", "1", "23.88", "473"),("97614", "2", "1000", "67", "1", "23.88", "474"),("75929", "2", "1000", "193", "1", "18.1", "475"),("134532", "2", "1000", "193", "1", "19.75", "476"),("134536", "2", "1000", "193", "1", "19.75", "477"),("134538", "2", "1000", "193", "1", "19.75", "478"),("134743", "2", "1000", "193", "1", "19.75", "479"),("182145", "1", "1000", "123", "1", "27.19", "480"),("183309", "2", "1000", "20", "1", "13.97", "481"),("183311", "2", "1000", "20", "1", "13.97", "482"),("172087", "1", "1000", "658", "1", "23.88", "483"),("172090", "1", "1000", "658", "1", "27.19", "484"),("172095", "1", "1000", "658", "1", "27.19", "485"),("172096", "1", "1000", "658", "1", "24.71", "486"),("172097", "1", "1000", "658", "1", "27.19", "487"),("172098", "1", "1000", "658", "1", "24.71", "488"),("172099", "1", "1000", "658", "1", "27.19", "489"),("172100", "1", "1000", "658", "1", "18.1", "490"),("172102", "1", "1000", "658", "1", "37.93", "491"),("172106", "1", "1000", "658", "1", "27.19", "492"),("172107", "1", "1000", "658", "1", "18.1", "493"),("172108", "1", "1000", "658", "1", "24.71", "494"),("235430", "1", "1000", "85", "1", "28.84", "495"),("187949", "2", "8", "54", "1", "21.4", "496"),("187957", "2", "8", "54", "1", "35.45", "497"),("131859", "1", "4", "593", "1", "14.79", "498"),("131627", "1", "3", "593", "1", "14.79", "499"),("131823", "1", "2", "593", "1", "14.79", "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 *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '158519' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'

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

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

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

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

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'