Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '14b6e7e0eac89c147e5b7e7d90'

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

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'