Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '8693d20e54fd8220bfb9265819'

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 ("158615", "1", "1000", "24", "1", "10.66", "1"),("158617", "1", "1000", "24", "1", "10.66", "2"),("158619", "1", "1000", "24", "1", "10.66", "3"),("158621", "1", "1000", "24", "1", "10.66", "4"),("158623", "1", "1000", "24", "1", "10.66", "5"),("6013", "2", "1000", "115", "1", "49.5", "6"),("6012", "2", "1", "115", "1", "32.15", "7"),("197619", "2", "1002", "285", "1", "26.36", "8"),("58296", "2", "1000", "285", "1", "32.98", "9"),("58298", "2", "1000", "285", "1", "32.98", "10"),("58302", "2", "1000", "285", "1", "32.98", "11"),("144863", "1", "1003", "123", "1", "46.2", "12"),("144865", "1", "1001", "123", "1", "46.42", "13"),("144867", "1", "1001", "123", "1", "42.07", "14"),("224156", "1", "1001", "224", "1", "37.93", "15"),("263712", "1", "1000", "480", "1", "104.95", "16"),("263714", "1", "1000", "480", "1", "104.95", "17"),("134823", "1", "1000", "117", "1", "53.69", "18"),("262986", "1", "1000", "480", "1", "31.82", "19"),("262993", "1", "1000", "480", "1", "31.82", "20"),("262988", "1", "1000", "480", "1", "39.66", "21"),("262995", "1", "1000", "480", "1", "37.6", "22"),("52991", "2", "1000", "115", "1", "15.62", "23"),("15261", "2", "1000", "115", "1", "31.32", "24"),("15263", "2", "1000", "115", "1", "31.32", "25"),("12330", "2", "1004", "54", "1", "32.15", "26"),("169264", "1", "1004", "54", "1", "25.54", "27"),("191453", "1", "1003", "54", "1", "28.84", "28"),("150317", "1", "1003", "54", "1", "41.24", "29"),("191747", "1", "1002", "54", "1", "25.54", "30"),("5924", "2", "1001", "42", "1", "28.02", "31"),("9126", "2", "1000", "105", "1", "23.88", "32"),("58611", "2", "1000", "124", "1", "22.23", "33"),("58660", "2", "1000", "124", "1", "23.88", "34"),("113524", "10", "1000", "24", "1", "8.18", "35"),("191461", "1", "1000", "54", "1", "25.54", "36"),("12333", "2", "1000", "54", "1", "32.15", "37"),("5928", "2", "1000", "42", "1", "28.02", "38"),("130691", "2", "3", "229", "1", "12.31", "39"),("6017", "2", "3", "115", "1", "49.5", "40"),("113523", "10", "2", "24", "1", "7.36", "41"),("167645", "2", "1", "54", "1", "27.26", "42"),("130689", "2", "1", "229", "1", "12.31", "43"),("6014", "2", "1", "115", "1", "32.15", "44"),("169238", "1", "1004", "54", "1", "25.54", "45"),("169252", "1", "1004", "54", "1", "25.54", "46"),("191731", "1", "1002", "54", "1", "32.15", "47"),("13362", "1", "1002", "105", "1", "23.88", "48"),("262537", "1", "1000", "480", "1", "37.6", "49"),("262983", "1", "1000", "480", "1", "41.31", "50"),("5944", "2", "1", "42", "1", "28.02", "51"),("230731", "2", "1001", "503", "1", "32.55", "52"),("105058", "2", "1001", "42", "1", "23.06", "53"),("105063", "2", "1001", "42", "1", "23.88", "54"),("105065", "2", "1001", "42", "1", "25.54", "55"),("218753", "2", "1000", "206", "1", "30.16", "56"),("218754", "2", "1000", "206", "1", "32.68", "57"),("218755", "2", "1000", "206", "1", "34.36", "58"),("218756", "2", "1000", "206", "1", "36.03", "59"),("218757", "2", "1000", "206", "1", "28.47", "60"),("218758", "2", "1000", "206", "1", "30.16", "61"),("218759", "2", "1000", "206", "1", "32.68", "62"),("218760", "2", "1000", "206", "1", "34.36", "63"),("218761", "2", "1000", "206", "1", "36.03", "64"),("104993", "2", "1000", "42", "1", "23.06", "65"),("105059", "2", "1000", "42", "1", "23.88", "66"),("105061", "2", "1000", "42", "1", "23.88", "67"),("105062", "2", "1000", "42", "1", "23.88", "68"),("105067", "2", "1000", "42", "1", "25.54", "69"),("105068", "2", "1000", "42", "1", "25.54", "70"),("105069", "2", "1000", "42", "1", "25.54", "71"),("105072", "2", "1000", "42", "1", "26.36", "72"),("105074", "2", "1000", "42", "1", "26.36", "73"),("105076", "2", "1000", "42", "1", "26.36", "74"),("105078", "2", "1000", "42", "1", "27.19", "75"),("105080", "2", "1000", "42", "1", "27.19", "76"),("119174", "2", "1000", "105", "1", "23.88", "77"),("119175", "2", "1000", "105", "1", "23.88", "78"),("119176", "2", "1000", "105", "1", "23.88", "79"),("228577", "1", "1000", "150", "1", "207.36", "80"),("227435", "1", "1000", "54", "1", "51.16", "81"),("227449", "1", "1000", "54", "1", "47.85", "82"),("27303", "2", "3", "11", "1", "29.13", "83"),("27304", "2", "3", "11", "1", "29.31", "84"),("128641", "2", "1", "150", "1", "49.5", "85"),("104992", "2", "1", "42", "1", "23.06", "86"),("165297", "1", "1005", "611", "1", "24.71", "87"),("165299", "1", "1004", "611", "1", "25.54", "88"),("165300", "1", "1003", "611", "1", "16.45", "89"),("175456", "1", "1000", "117", "1", "51.17", "90"),("175457", "1", "1000", "117", "1", "51.17", "91"),("175458", "1", "1000", "117", "1", "51.17", "92"),("175459", "1", "1000", "117", "1", "51.17", "93"),("175460", "1", "1000", "117", "1", "51.17", "94"),("175462", "1", "1000", "117", "1", "51.17", "95"),("175463", "1", "1000", "117", "1", "51.17", "96"),("175465", "1", "1000", "117", "1", "51.17", "97"),("175466", "1", "1000", "117", "1", "51.17", "98"),("175467", "1", "1000", "117", "1", "51.17", "99"),("175468", "1", "1000", "117", "1", "51.17", "100"),("175469", "1", "1000", "117", "1", "51.17", "101"),("128629", "2", "1000", "150", "1", "85.87", "102"),("223037", "2", "1000", "206", "1", "36.03", "103"),("114806", "2", "1000", "401", "1", "20.58", "104"),("228580", "1", "1000", "150", "1", "207.36", "105"),("263713", "1", "1000", "480", "1", "104.95", "106"),("263715", "1", "1000", "480", "1", "104.95", "107"),("237085", "2", "8", "285", "1", "26.36", "108"),("237086", "2", "8", "285", "1", "26.36", "109"),("237084", "2", "6", "285", "1", "26.36", "110"),("91771", "2", "1006", "85", "1", "32.15", "111"),("165294", "1", "1002", "611", "1", "29.67", "112"),("100964", "2", "1001", "177", "1", "42.76", "113"),("171952", "1", "1001", "658", "1", "28.02", "114"),("238681", "2", "1001", "611", "1", "24.71", "115"),("100962", "2", "1000", "177", "1", "42.76", "116"),("37197", "2", "1000", "177", "1", "42.76", "117"),("134817", "1", "1000", "117", "1", "53.69", "118"),("134827", "1", "1000", "117", "1", "53.69", "119"),("134831", "1", "1000", "117", "1", "53.69", "120"),("134835", "1", "1000", "117", "1", "53.69", "121"),("134825", "1", "1000", "117", "1", "53.69", "122"),("171936", "1", "1000", "658", "1", "18.1", "123"),("171938", "1", "1000", "658", "1", "28.02", "124"),("171949", "1", "1000", "658", "1", "18.1", "125"),("171951", "1", "1000", "658", "1", "18.1", "126"),("171954", "1", "1000", "658", "1", "28.02", "127"),("59133", "2", "1000", "15", "1", "51.16", "128"),("170692", "1", "1000", "123", "1", "46.2", "129"),("91774", "2", "1000", "85", "1", "35.45", "130"),("171953", "1", "1000", "658", "1", "18.1", "131"),("91651", "2", "1000", "42", "1", "24.71", "132"),("91720", "2", "1000", "42", "1", "24.71", "133"),("91722", "2", "1000", "42", "1", "24.71", "134"),("91723", "2", "1000", "42", "1", "24.71", "135"),("165791", "2", "1000", "67", "1", "24.71", "136"),("101540", "1", "1", "42", "1", "24.36", "137"),("101542", "1", "1", "42", "1", "24.36", "138"),("37196", "2", "1", "177", "1", "42.76", "139"),("170693", "1", "1", "123", "1", "49.13", "140"),("213665", "1", "1010", "224", "1", "11.49", "141"),("91777", "2", "1001", "85", "1", "32.15", "142"),("171956", "1", "1000", "658", "1", "21.4", "143"),("171958", "1", "1000", "658", "1", "18.1", "144"),("171959", "1", "1000", "658", "1", "18.1", "145"),("171960", "1", "1000", "658", "1", "18.1", "146"),("171962", "1", "1000", "658", "1", "18.1", "147"),("108740", "2", "1000", "75", "1", "24.71", "148"),("108742", "2", "1000", "75", "1", "21.4", "149"),("46792", "2", "1000", "193", "1", "23.88", "150"),("46793", "2", "1000", "193", "1", "23.88", "151"),("46794", "2", "1000", "193", "1", "23.88", "152"),("46795", "2", "1000", "193", "1", "23.88", "153"),("46796", "2", "1000", "193", "1", "23.88", "154"),("46797", "2", "1000", "193", "1", "23.88", "155"),("251708", "2", "10", "776", "1", "11.49", "156"),("251709", "2", "10", "776", "1", "11.49", "157"),("251700", "2", "9", "776", "1", "11.49", "158"),("108741", "2", "1", "75", "1", "24.71", "159"),("236126", "2", "1009", "85", "1", "35.45", "160"),("236127", "2", "1005", "85", "1", "35.45", "161"),("171919", "1", "1002", "658", "1", "18.93", "162"),("171921", "1", "1002", "658", "1", "18.93", "163"),("171923", "1", "1002", "658", "1", "18.93", "164"),("171927", "1", "1002", "658", "1", "18.93", "165"),("171914", "1", "1001", "658", "1", "18.93", "166"),("171994", "1", "1001", "658", "1", "17.27", "167"),("134833", "1", "1000", "117", "1", "53.69", "168"),("228759", "2", "1000", "117", "1", "51.17", "169"),("237616", "2", "1000", "20", "1", "29.67", "170"),("237617", "2", "1000", "20", "1", "29.67", "171"),("151677", "2", "1000", "85", "1", "37.11", "172"),("151679", "2", "1000", "85", "1", "37.11", "173"),("171915", "1", "1000", "658", "1", "26.36", "174"),("171917", "1", "1000", "658", "1", "26.36", "175"),("171920", "1", "1000", "658", "1", "26.36", "176"),("171922", "1", "1000", "658", "1", "26.36", "177"),("171924", "1", "1000", "658", "1", "26.36", "178"),("171928", "1", "1000", "658", "1", "26.36", "179"),("171992", "1", "1000", "658", "1", "17.27", "180"),("171997", "1", "1000", "658", "1", "17.27", "181"),("171998", "1", "1000", "658", "1", "17.27", "182"),("172001", "1", "1000", "658", "1", "17.27", "183"),("172002", "1", "1000", "658", "1", "18.1", "184"),("172003", "1", "1000", "658", "1", "17.27", "185"),("172004", "1", "1000", "658", "1", "18.1", "186"),("91772", "2", "1000", "85", "1", "23.06", "187"),("91775", "2", "1000", "85", "1", "24.71", "188"),("171910", "1", "1000", "658", "1", "26.36", "189"),("171993", "1", "1000", "658", "1", "21.12", "190"),("222549", "1", "1000", "745", "1", "30.5", "191"),("236605", "2", "1000", "85", "1", "35.45", "192"),("236606", "2", "1000", "85", "1", "35.45", "193"),("236607", "2", "1000", "85", "1", "35.45", "194"),("236882", "2", "1000", "85", "1", "32.15", "195"),("236987", "2", "1000", "85", "1", "35.45", "196"),("245049", "1", "1000", "54", "1", "25.54", "197"),("249779", "1", "1000", "54", "1", "25.54", "198"),("249791", "1", "1000", "54", "1", "28.84", "199"),("171995", "1", "1000", "658", "1", "18.1", "200"),("171999", "1", "1000", "658", "1", "17.27", "201"),("264746", "1", "1000", "371", "1", "77.68", "202"),("236984", "2", "1000", "85", "1", "35.45", "203"),("256787", "1", "1000", "611", "1", "23.06", "204"),("171925", "1", "1", "658", "1", "26.36", "205"),("240395", "1", "1002", "658", "1", "36.28", "206"),("240396", "1", "1002", "658", "1", "36.28", "207"),("231559", "1", "1002", "658", "1", "36.28", "208"),("231561", "1", "1002", "658", "1", "36.28", "209"),("231562", "1", "1002", "658", "1", "36.28", "210"),("171929", "1", "1002", "658", "1", "18.93", "211"),("171931", "1", "1002", "658", "1", "37.11", "212"),("240397", "1", "1001", "658", "1", "36.28", "213"),("231560", "1", "1001", "658", "1", "36.28", "214"),("171916", "1", "1001", "658", "1", "26.36", "215"),("172042", "1", "1001", "658", "1", "20.58", "216"),("231558", "1", "1001", "658", "1", "36.28", "217"),("231549", "1", "1000", "658", "1", "51.98", "218"),("231550", "1", "1000", "658", "1", "51.98", "219"),("231551", "1", "1000", "658", "1", "51.98", "220"),("231552", "1", "1000", "658", "1", "51.98", "221"),("231553", "1", "1000", "658", "1", "51.98", "222"),("231554", "1", "1000", "658", "1", "47.85", "223"),("231555", "1", "1000", "658", "1", "47.85", "224"),("231556", "1", "1000", "658", "1", "47.85", "225"),("231557", "1", "1000", "658", "1", "47.85", "226"),("171913", "1", "1000", "658", "1", "26.36", "227"),("171930", "1", "1000", "658", "1", "18.93", "228"),("172018", "1", "1000", "658", "1", "21.4", "229"),("172021", "1", "1000", "658", "1", "20.58", "230"),("172023", "1", "1000", "658", "1", "22.23", "231"),("172025", "1", "1000", "658", "1", "20.58", "232"),("172026", "1", "1000", "658", "1", "21.4", "233"),("172028", "1", "1000", "658", "1", "22.23", "234"),("172029", "1", "1000", "658", "1", "20.58", "235"),("172030", "1", "1000", "658", "1", "21.4", "236"),("172031", "1", "1000", "658", "1", "22.23", "237"),("172032", "1", "1000", "658", "1", "20.58", "238"),("172033", "1", "1000", "658", "1", "21.4", "239"),("172034", "1", "1000", "658", "1", "22.23", "240"),("172039", "1", "1000", "658", "1", "20.58", "241"),("172043", "1", "1000", "658", "1", "21.4", "242"),("172044", "1", "1000", "658", "1", "22.23", "243"),("172045", "1", "1000", "658", "1", "20.58", "244"),("172046", "1", "1000", "658", "1", "21.4", "245"),("172047", "1", "1000", "658", "1", "22.23", "246"),("172048", "1", "1000", "658", "1", "20.58", "247"),("91778", "2", "1000", "85", "1", "23.06", "248"),("91781", "2", "1000", "85", "1", "24.71", "249"),("172020", "1", "1000", "658", "1", "22.23", "250"),("249800", "1", "1000", "54", "1", "28.84", "251"),("249832", "1", "1000", "54", "1", "25.54", "252"),("249840", "1", "1000", "54", "1", "28.84", "253"),("262989", "1", "1000", "480", "1", "31.82", "254"),("262991", "1", "1000", "480", "1", "28.09", "255"),("262992", "1", "1000", "480", "1", "31.82", "256"),("262996", "1", "1000", "480", "1", "31.82", "257"),("262998", "1", "1000", "480", "1", "31.82", "258"),("91780", "2", "1000", "85", "1", "37.11", "259"),("264751", "1", "1000", "371", "1", "93.38", "260"),("172035", "1", "1000", "658", "1", "20.58", "261"),("172037", "1", "1000", "658", "1", "22.23", "262"),("256243", "1", "1000", "85", "1", "32.15", "263"),("259139", "1", "1000", "85", "1", "35.45", "264"),("262987", "1", "1000", "480", "1", "31.82", "265"),("262990", "1", "1000", "480", "1", "31.82", "266"),("262994", "1", "1000", "480", "1", "31.82", "267"),("262997", "1", "1000", "480", "1", "31.82", "268"),("246555", "2", "1005", "85", "1", "35.45", "269"),("246556", "2", "1003", "85", "1", "35.45", "270"),("108745", "2", "1000", "75", "1", "21.4", "271"),("108747", "2", "1000", "75", "1", "21.4", "272"),("108746", "2", "2", "75", "1", "21.4", "273"),("145535", "2", "0", "67", "1", "14.8", "274"),("182147", "1", "0", "454", "1", "19.75", "275"),("6016", "2", "0", "115", "1", "38.5", "276"),("5927", "2", "0", "42", "1", "20.5", "277"),("67433", "2", "0", "103", "1", "8", "278"),("5943", "2", "0", "42", "1", "20.5", "279"),("5930", "2", "0", "42", "1", "22", "280"),("5932", "2", "0", "42", "1", "22", "281"),("5950", "2", "0", "42", "1", "23", "282"),("105083", "2", "0", "42", "1", "20.5", "283"),("105086", "2", "0", "42", "1", "20.5", "284"),("27305", "2", "0", "11", "1", "27.83", "285"),("128631", "2", "0", "150", "1", "65.21", "286"),("67835", "2", "0", "11", "1", "17.88", "287"),("168200", "1", "0", "150", "1", "38.26", "288"),("175461", "1", "0", "117", "1", "30", "289"),("175464", "1", "0", "117", "1", "30", "290"),("100959", "2", "0", "177", "1", "31", "291"),("177419", "2", "0", "117", "1", "30", "292"),("134829", "1", "0", "117", "1", "41", "293"),("37199", "2", "0", "177", "1", "31", "294"),("27302", "2", "0", "11", "1", "26.1", "295"),("67832", "2", "0", "11", "1", "22.95", "296"),("108739", "2", "0", "75", "1", "17.5", "297"),("67834", "2", "0", "11", "1", "22.95", "298"),("91721", "2", "0", "42", "1", "18.5", "299"),("67833", "2", "0", "11", "1", "22.95", "300"),("101541", "1", "0", "42", "1", "18.5", "301"),("171950", "1", "0", "658", "1", "26", "302"),("134821", "1", "0", "117", "1", "41", "303"),("101538", "1", "0", "42", "1", "17.8", "304"),("171926", "1", "0", "658", "1", "19.4", "305"),("108744", "2", "0", "75", "1", "15.2", "306"),("172000", "1", "0", "658", "1", "18.1", "307"),("172007", "1", "0", "658", "1", "13.13", "308"),("172005", "1", "0", "658", "1", "14.93", "309"),("171932", "1", "0", "658", "1", "26.36", "310"),("172050", "1", "0", "658", "1", "22.23", "311"),("172040", "1", "0", "658", "1", "21.11", "312"),("172041", "1", "0", "658", "1", "22.23", "313"),("172022", "1", "0", "658", "1", "21.4", "314"),("172049", "1", "0", "658", "1", "21.4", "315"),("172017", "1", "0", "658", "1", "24.89", "316"),("172036", "1", "0", "658", "1", "21.4", "317"),("255603", "1", "0", "591", "1", "32.98", "318"),("255604", "1", "0", "591", "1", "32.98", "319"),("255605", "1", "0", "591", "1", "32.98", "320"),("255606", "1", "0", "591", "1", "32.98", "321"),("255607", "1", "0", "591", "1", "32.98", "322"),("261664", "1", "0", "54", "1", "58.97", "323"),("261668", "1", "0", "54", "1", "58.97", "324"),("261670", "1", "0", "54", "1", "58.97", "325"),("261672", "1", "0", "54", "1", "63.18", "326"),("261676", "1", "0", "54", "1", "63.18", "327"),("261678", "1", "0", "54", "1", "63.18", "328")

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'