Căutare

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

CREATE TEMPORARY TABLE oc_bf_tmp_product ( 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_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("96294", "2", "1001", "484", "1", "122.23", "1"),("197869", "1", "9", "361", "1", "9.83", "2"),("197871", "1", "8", "361", "1", "9.83", "3"),("197873", "1", "3", "361", "1", "9.83", "4"),("197911", "1", "1", "361", "1", "5.74", "5"),("269495", "1", "1000", "484", "1", "49.5", "6"),("269496", "1", "1000", "484", "1", "49.5", "7"),("257954", "1", "1000", "484", "1", "74.3", "8"),("257956", "1", "1000", "484", "1", "74.3", "9"),("269403", "1", "1000", "484", "1", "113.14", "10"),("269406", "1", "1000", "484", "1", "113.14", "11"),("269408", "1", "1000", "484", "1", "113.14", "12"),("252620", "1", "1000", "484", "1", "37.93", "13"),("249781", "1", "1001", "484", "1", "337.93", "14"),("249776", "1", "1000", "484", "1", "344.55", "15"),("81692", "2", "2", "484", "1", "361.9", "16"),("176315", "2", "1000", "484", "1", "181.74", "17"),("180599", "-100", "1039", "484", "1", "237.11", "18"),("180601", "-100", "1032", "484", "1", "224.71", "19"),("180595", "-100", "1023", "484", "1", "242.07", "20"),("180603", "-100", "1014", "484", "1", "253.64", "21"),("180593", "-100", "1002", "484", "1", "199.92", "22"),("180597", "-100", "1002", "484", "1", "376.78", "23"),("180605", "-100", "1000", "484", "1", "361.07", "24"),("180607", "-100", "1000", "484", "1", "385.87", "25"),("81689", "2", "1029", "484", "1", "364.38", "26"),("81690", "2", "1005", "484", "1", "375.12", "27"),("162384", "2", "1000", "484", "1", "338.76", "28"),("136913", "2", "1000", "484", "1", "135.45", "29"),("136915", "2", "1000", "484", "1", "153.64", "30"),("136925", "2", "1000", "484", "1", "132.98", "31"),("177738", "2", "1000", "484", "1", "174.3", "32"),("177732", "1", "1000", "484", "1", "70.17", "33"),("177734", "1", "1000", "484", "1", "70.17", "34"),("252630", "2", "1001", "484", "1", "234.63", "35"),("252626", "2", "1000", "484", "1", "349.5", "36"),("252629", "2", "1000", "484", "1", "228.84", "37"),("81081", "2", "1000", "484", "1", "394.96", "38"),("81082", "2", "2", "484", "1", "411.49", "39"),("99214", "1", "1", "484", "1", "177.6", "40"),("162392", "1", "1000", "484", "1", "78.43", "41"),("162393", "1", "1000", "484", "1", "102.4", "42"),("249728", "1", "1000", "484", "1", "440.41", "43"),("81088", "2", "1002", "484", "1", "96.61", "44"),("179115", "2", "1000", "484", "1", "35.45", "45"),("209255", "1", "2", "484", "1", "42.07", "46"),("81107", "2", "1009", "484", "1", "18.93", "47"),("81105", "2", "1008", "484", "1", "17.27", "48"),("81108", "2", "1006", "484", "1", "19.75", "49"),("209909", "1", "1005", "484", "1", "23.06", "50"),("81104", "2", "1004", "484", "1", "13.14", "51"),("81106", "2", "1002", "484", "1", "18.1", "52"),("119978", "2", "1000", "484", "1", "461.07", "53"),("112952", "2", "5", "484", "1", "247.85", "54"),("119975", "2", "2", "484", "1", "480.08", "55"),("88443", "2", "1", "484", "1", "182.56", "56"),("237245", "1", "1", "484", "1", "42.07", "57"),("64792", "2", "1004", "484", "1", "328.02", "58"),("64787", "2", "1003", "484", "1", "300.74", "59"),("179113", "2", "1003", "484", "1", "35.45", "60"),("167180", "1", "1001", "484", "1", "14.79", "61"),("167181", "1", "1001", "484", "1", "23.06", "62"),("209261", "1", "1001", "484", "1", "42.07", "63"),("179061", "2", "1000", "484", "1", "9.83", "64"),("64782", "2", "2", "484", "1", "313.97", "65"),("64798", "2", "2", "484", "1", "316.45", "66"),("165761", "1", "1040", "484", "1", "213.97", "67"),("118034", "2", "1013", "484", "1", "364.38", "68"),("165764", "1", "1001", "484", "1", "216.45", "69"),("165767", "1", "1000", "484", "1", "224.71", "70"),("88090", "2", "3", "484", "1", "356.94", "71"),("149375", "2", "1000", "484", "1", "187.52", "72"),("151417", "2", "1006", "484", "1", "594.13", "73"),("179060", "2", "1004", "484", "1", "28.02", "74"),("65923", "2", "1003", "484", "1", "375.12", "75"),("152659", "1", "1000", "484", "1", "187.52", "76"),("201645", "1", "1008", "484", "1", "22.23", "77"),("179063", "2", "1005", "484", "1", "20.58", "78"),("111345", "1", "1000", "484", "1", "437.11", "79"),("111346", "1", "1000", "484", "1", "479.26", "80"),("149241", "2", "1000", "484", "1", "480.08", "81"),("111347", "1", "3", "484", "1", "499.92", "82"),("111348", "1", "2", "484", "1", "532.15", "83"),("204569", "2", "1000", "484", "1", "32.34", "84"),("174931", "1", "1000", "484", "1", "447.85", "85"),("174932", "1", "1", "484", "1", "439.59", "86"),("252633", "1", "1000", "484", "1", "50.33", "87"),("119967", "1", "1000", "484", "1", "878.43", "88"),("119968", "1", "1000", "484", "1", "920.58", "89"),("119970", "1", "1000", "484", "1", "1004.88", "90"),("119971", "1", "1000", "484", "1", "1141.24", "91"),("119972", "1", "3", "484", "1", "1141.24", "92"),("151413", "2", "1006", "484", "1", "450.33", "93"),("151415", "2", "1005", "484", "1", "594.13", "94"),("151419", "2", "1003", "484", "1", "628.02", "95"),("179114", "2", "1003", "484", "1", "20.58", "96"),("88925", "2", "1002", "484", "1", "27.19", "97"),("179062", "2", "1002", "484", "1", "23.88", "98"),("88904", "2", "1001", "484", "1", "31.32", "99"),("88922", "2", "1001", "484", "1", "28.02", "100"),("88927", "2", "1001", "484", "1", "27.19", "101"),("88930", "2", "1001", "484", "1", "27.19", "102"),("167920", "1", "1001", "484", "1", "423.06", "103"),("152675", "1", "1001", "484", "1", "213.14", "104"),("88902", "2", "1000", "484", "1", "26.36", "105"),("88906", "2", "1000", "484", "1", "31.32", "106"),("88921", "2", "1000", "484", "1", "28.02", "107"),("88923", "2", "1000", "484", "1", "28.02", "108"),("88924", "2", "1000", "484", "1", "28.02", "109"),("88926", "2", "1000", "484", "1", "27.19", "110"),("88928", "2", "1000", "484", "1", "27.19", "111"),("88929", "2", "1000", "484", "1", "28.02", "112"),("88932", "2", "1000", "484", "1", "28.02", "113"),("88933", "2", "1000", "484", "1", "27.19", "114"),("88931", "2", "1", "484", "1", "27.19", "115"),("269607", "1", "1000", "484", "1", "57.77", "116"),("180585", "1", "1014", "484", "1", "217.27", "117"),("180581", "1", "1011", "484", "1", "187.52", "118"),("180577", "1", "1006", "484", "1", "179.26", "119"),("180587", "1", "1006", "484", "1", "231.32", "120"),("180583", "1", "1005", "484", "1", "213.14", "121"),("180579", "1", "1004", "484", "1", "182.56", "122"),("179112", "2", "1003", "484", "1", "23.88", "123"),("152655", "1", "1000", "484", "1", "75.12", "124"),("228384", "1", "1013", "484", "1", "9.01", "125"),("228390", "1", "1012", "484", "1", "9.01", "126"),("228428", "1", "1012", "484", "1", "9.01", "127"),("228430", "1", "1012", "484", "1", "9.01", "128"),("228431", "1", "1011", "484", "1", "9.01", "129"),("228385", "1", "1010", "484", "1", "9.01", "130"),("228386", "1", "1008", "484", "1", "9.01", "131"),("228433", "1", "1008", "484", "1", "9.01", "132"),("228391", "1", "1007", "484", "1", "9.01", "133"),("228387", "1", "1005", "484", "1", "9.01", "134"),("228388", "1", "1005", "484", "1", "9.01", "135"),("228427", "1", "1005", "484", "1", "9.01", "136"),("228432", "1", "1005", "484", "1", "9.01", "137"),("166140", "2", "1004", "484", "1", "182.56", "138"),("228426", "1", "1003", "484", "1", "9.01", "139"),("88115", "2", "1002", "484", "1", "332.98", "140"),("166137", "2", "1002", "484", "1", "170.17", "141"),("228394", "1", "1002", "484", "1", "9.01", "142"),("228395", "1", "1002", "484", "1", "9.01", "143"),("228429", "1", "1002", "484", "1", "9.01", "144"),("228389", "1", "1001", "484", "1", "9.01", "145"),("166138", "2", "1000", "484", "1", "174.3", "146"),("228392", "1", "1000", "484", "1", "9.01", "147"),("228393", "1", "1000", "484", "1", "9.01", "148"),("228434", "1", "1000", "484", "1", "9.01", "149"),("228435", "1", "1000", "484", "1", "9.01", "150"),("228436", "1", "1000", "484", "1", "9.01", "151"),("228437", "1", "1000", "484", "1", "9.01", "152"),("137008", "1", "1005", "484", "1", "35.45", "153"),("137006", "1", "1004", "484", "1", "26.36", "154"),("137010", "1", "1003", "484", "1", "37.11", "155"),("137012", "1", "1003", "484", "1", "39.59", "156"),("137004", "1", "1000", "484", "1", "30.5", "157"),("176318", "1", "1000", "484", "1", "356.12", "158"),("111386", "1", "1000", "484", "1", "148.68", "159"),("136979", "1", "1000", "484", "1", "61.9", "160"),("161873", "1", "1000", "484", "1", "23.06", "161"),("161875", "1", "1000", "484", "1", "42.07", "162"),("209901", "2", "1000", "484", "1", "51.16", "163"),("209911", "1", "1000", "484", "1", "81.89", "164"),("119965", "1", "1000", "484", "1", "618.93", "165"),("180609", "1", "3", "484", "1", "409.83", "166"),("176324", "1", "2", "484", "1", "423.06", "167"),("111404", "2", "1003", "484", "1", "40.41", "168"),("123471", "2", "1002", "484", "1", "16.45", "169"),("111400", "1", "1001", "484", "1", "119.75", "170"),("149377", "2", "1001", "484", "1", "64.38", "171"),("111394", "1", "1000", "484", "1", "75.12", "172"),("111395", "1", "1000", "484", "1", "70.17", "173"),("111397", "1", "1000", "484", "1", "70.17", "174"),("111398", "1", "1000", "484", "1", "105.7", "175"),("204567", "2", "1000", "484", "1", "37.75", "176"),("111390", "1", "1", "484", "1", "85.04", "177"),("81109", "2", "1004", "484", "1", "46.2", "178"),("81694", "2", "1004", "484", "1", "46.2", "179"),("81111", "2", "1003", "484", "1", "39.59", "180"),("81695", "2", "1002", "484", "1", "51.98", "181"),("81110", "2", "1000", "484", "1", "49.5", "182"),("174612", "1", "1000", "484", "1", "504.88", "183"),("249785", "1", "1000", "484", "1", "251.98", "184"),("249789", "1", "1000", "484", "1", "245.37", "185"),("136893", "2", "1001", "484", "1", "45.37", "186"),("136897", "2", "1001", "484", "1", "45.37", "187"),("174605", "1", "1000", "484", "1", "494.13", "188"),("136895", "2", "1000", "484", "1", "45.37", "189"),("136899", "2", "1000", "484", "1", "45.37", "190"),("136903", "2", "1000", "484", "1", "44.55", "191"),("136905", "2", "1000", "484", "1", "40.41", "192"),("136909", "2", "1000", "484", "1", "42.89", "193"),("183755", "2", "1000", "484", "1", "118.93", "194"),("183757", "2", "1000", "484", "1", "118.93", "195"),("183759", "2", "1000", "484", "1", "118.93", "196"),("183761", "2", "1000", "484", "1", "118.93", "197"),("136907", "2", "999", "484", "1", "42.89", "198"),("136901", "2", "998", "484", "1", "40.41", "199"),("152651", "2", "6", "484", "1", "23.06", "200"),("152639", "2", "4", "484", "1", "23.06", "201"),("152643", "2", "2", "484", "1", "23.06", "202"),("152645", "2", "2", "484", "1", "23.06", "203"),("152647", "2", "2", "484", "1", "23.06", "204"),("252634", "1", "1002", "484", "1", "38.76", "205"),("183787", "1", "998", "484", "1", "34.63", "206"),("166530", "1", "1003", "484", "1", "9.83", "207"),("166531", "1", "1003", "484", "1", "9.83", "208"),("111384", "1", "1001", "484", "1", "37.11", "209"),("111399", "1", "1001", "484", "1", "119.75", "210"),("111401", "1", "1000", "484", "1", "119.75", "211"),("136983", "2", "1000", "484", "1", "61.9", "212"),("136985", "2", "1000", "484", "1", "58.6", "213"),("143901", "2", "1000", "484", "1", "156.12", "214"),("123463", "1", "1000", "484", "1", "138.76", "215"),("166782", "1", "1000", "484", "1", "8.18", "216"),("90108", "2", "2", "484", "1", "9.83", "217"),("243348", "2", "1000", "484", "1", "438.76", "218"),("118028", "2", "1001", "484", "1", "35.45", "219"),("152663", "1", "1001", "484", "1", "106.53", "220"),("162385", "2", "1000", "484", "1", "58.6", "221"),("81086", "2", "1000", "484", "1", "68.51", "222"),("164497", "1", "1000", "484", "1", "313.97", "223"),("97591", "2", "1002", "484", "1", "353.64", "224"),("97592", "2", "1001", "484", "1", "376.78", "225"),("97590", "2", "1000", "484", "1", "668.51", "226"),("111935", "1", "1000", "484", "1", "42.89", "227"),("111934", "1", "1", "484", "1", "47.85", "228"),("111979", "1", "1", "484", "1", "57.77", "229"),("111391", "1", "1000", "484", "1", "230.5", "230"),("226699", "1", "1000", "484", "1", "147.02", "231"),("149367", "2", "1", "484", "1", "398.26", "232"),("152671", "1", "1", "484", "1", "75.12", "233"),("237189", "1", "1000", "484", "1", "121.4", "234"),("237190", "1", "1000", "484", "1", "113.14", "235"),("65927", "2", "1002", "484", "1", "180.08", "236"),("176647", "1", "1000", "484", "1", "160.25", "237"),("237229", "1", "1000", "484", "1", "442.89", "238"),("237230", "1", "1000", "484", "1", "432.15", "239"),("243364", "1", "1003", "484", "1", "58.6", "240"),("111342", "1", "1001", "484", "1", "204.05", "241"),("111341", "1", "1000", "484", "1", "213.14", "242"),("119976", "1", "1001", "484", "1", "55.29", "243"),("152673", "1", "1001", "484", "1", "70.99", "244"),("119987", "2", "1000", "484", "1", "75.12", "245"),("174281", "1", "1002", "484", "1", "9.83", "246"),("183917", "1", "1001", "484", "1", "45.37", "247"),("229528", "1", "1000", "484", "1", "177.6", "248"),("183785", "1", "1000", "484", "1", "42.89", "249"),("183913", "1", "1000", "484", "1", "40.41", "250"),("183915", "1", "1", "484", "1", "42.07", "251"),("111714", "1", "1002", "448", "1", "13.97", "252"),("111713", "1", "1001", "448", "1", "13.97", "253"),("111388", "1", "1006", "484", "1", "27.19", "254"),("96289", "2", "1000", "484", "1", "66.03", "255"),("111706", "1", "1002", "448", "1", "25.54", "256"),("111707", "1", "1002", "448", "1", "23.88", "257"),("111712", "1", "1001", "448", "1", "6.53", "258"),("111708", "1", "1000", "448", "1", "20.58", "259"),("111710", "1", "1000", "448", "1", "20.58", "260"),("228859", "1", "1000", "484", "1", "25.54", "261"),("111711", "1", "2", "448", "1", "9.83", "262"),("109855", "1", "2", "484", "1", "418.1", "263"),("111709", "1", "1", "448", "1", "18.1", "264"),("237184", "1", "1000", "484", "1", "275.95", "265"),("237186", "1", "1000", "484", "1", "269.34", "266"),("96281", "2", "1002", "484", "1", "64.38", "267"),("96282", "2", "1000", "484", "1", "70.17", "268"),("176643", "2", "1000", "484", "1", "26.36", "269"),("111818", "1", "1000", "448", "1", "6.53", "270"),("81085", "2", "1001", "484", "1", "59.42", "271"),("237151", "0", "1002", "484", "1", "87.52", "272"),("111937", "1", "1000", "484", "1", "61.9", "273"),("111940", "1", "1", "484", "1", "76.78", "274"),("96287", "2", "3", "484", "1", "80.08", "275"),("203887", "2", "1001", "484", "1", "44.55", "276"),("96227", "2", "1000", "484", "1", "165.21", "277"),("96277", "2", "1", "484", "1", "37.11", "278"),("61756", "2", "1009", "24", "1", "11.49", "279"),("61746", "2", "1007", "24", "1", "6.53", "280"),("61745", "2", "1000", "24", "1", "6.53", "281"),("112012", "1", "1000", "484", "1", "91.65", "282"),("180591", "1", "1000", "484", "1", "291.65", "283"),("61752", "2", "1023", "24", "1", "9.83", "284"),("61750", "2", "1015", "24", "1", "9.83", "285"),("61754", "2", "1014", "24", "1", "11.49", "286"),("61748", "2", "1008", "24", "1", "9.83", "287"),("61755", "2", "1000", "24", "1", "12.31", "288"),("61757", "2", "1000", "24", "1", "9.83", "289"),("204281", "1", "1003", "484", "1", "12.31", "290"),("204279", "1", "1002", "484", "1", "9.01", "291"),("96226", "2", "1000", "484", "1", "196.61", "292"),("176642", "1", "1000", "484", "1", "110.66", "293"),("204317", "1", "1000", "484", "1", "38.76", "294"),("237150", "0", "1000", "484", "1", "442.89", "295"),("96253", "2", "2", "484", "1", "177.6", "296"),("62613", "2", "1003", "24", "1", "12.31", "297"),("96224", "2", "1000", "484", "1", "258.6", "298"),("183887", "1", "1000", "484", "1", "37.11", "299"),("257725", "1", "1000", "163", "1", "264.38", "300"),("61328", "2", "1005", "24", "1", "8.18", "301"),("61332", "2", "1005", "24", "1", "8.18", "302"),("61333", "2", "1003", "24", "1", "8.18", "303"),("61330", "2", "1001", "24", "1", "8.18", "304"),("69311", "2", "1000", "24", "1", "8.18", "305"),("61331", "2", "1000", "24", "1", "8.18", "306"),("35991", "2", "1000", "24", "1", "21.4", "307"),("111946", "1", "1000", "484", "1", "80.08", "308"),("112650", "2", "1000", "484", "1", "224.71", "309"),("61465", "2", "1005", "24", "1", "8.18", "310"),("61464", "2", "1003", "24", "1", "8.18", "311"),("61466", "2", "1003", "24", "1", "8.18", "312"),("66148", "2", "1003", "19", "1", "14.79", "313"),("25754", "2", "1000", "19", "1", "15.62", "314"),("25756", "2", "1000", "19", "1", "15.62", "315"),("88796", "2", "1", "423", "1", "37.93", "316"),("25753", "2", "1010", "19", "1", "14.79", "317"),("25751", "2", "1009", "19", "1", "13.97", "318"),("61323", "2", "1007", "24", "1", "8.18", "319"),("61314", "2", "1005", "24", "1", "8.18", "320"),("61316", "2", "1005", "24", "1", "8.18", "321"),("61456", "2", "1005", "24", "1", "8.18", "322"),("61458", "2", "1005", "24", "1", "8.18", "323"),("61461", "2", "1005", "24", "1", "8.18", "324"),("25759", "2", "1005", "19", "1", "15.62", "325"),("61457", "2", "1004", "24", "1", "8.18", "326"),("61327", "2", "1003", "24", "1", "8.18", "327"),("61459", "2", "1003", "24", "1", "8.18", "328"),("25758", "2", "1003", "19", "1", "15.62", "329"),("61315", "2", "1002", "24", "1", "8.18", "330"),("61324", "2", "1002", "24", "1", "8.18", "331"),("61320", "2", "1001", "24", "1", "8.18", "332"),("61462", "2", "1001", "24", "1", "8.18", "333"),("60294", "2", "1001", "24", "1", "7.36", "334"),("61311", "2", "1000", "24", "1", "8.18", "335"),("61312", "2", "1000", "24", "1", "8.18", "336"),("61313", "2", "1000", "24", "1", "8.18", "337"),("61317", "2", "1000", "24", "1", "8.18", "338"),("61319", "2", "1000", "24", "1", "8.18", "339"),("61451", "2", "1000", "24", "1", "8.18", "340"),("61455", "2", "1000", "24", "1", "8.18", "341"),("25755", "2", "3", "19", "1", "16.45", "342"),("25749", "2", "2", "19", "1", "12.14", "343"),("25752", "2", "2", "19", "1", "10.16", "344"),("111835", "1", "2", "448", "1", "13.97", "345"),("25748", "2", "1005", "19", "1", "15.62", "346"),("145079", "2", "1000", "19", "1", "13.97", "347"),("125543", "1", "1000", "13", "1", "119.75", "348"),("151711", "2", "1000", "19", "1", "15.62", "349"),("60692", "2", "2", "24", "1", "8.18", "350"),("60693", "2", "1", "24", "1", "8.18", "351"),("64891", "2", "1000", "300", "1", "48.68", "352"),("96228", "2", "1000", "484", "1", "33.8", "353"),("129631", "2", "1002", "49", "1", "47.02", "354"),("68998", "2", "1004", "24", "1", "7.36", "355"),("69000", "2", "1003", "24", "1", "7.36", "356"),("68999", "2", "1002", "24", "1", "7.36", "357"),("64885", "2", "1002", "300", "1", "28.02", "358"),("64886", "2", "1000", "300", "1", "28.02", "359"),("64887", "2", "1000", "300", "1", "28.02", "360"),("69001", "2", "4", "24", "1", "7.36", "361"),("60515", "2", "1", "24", "1", "12.31", "362"),("119981", "2", "1001", "300", "1", "25.54", "363"),("64566", "2", "1000", "19", "1", "15.62", "364"),("119982", "2", "1000", "300", "1", "25.54", "365"),("119983", "2", "1000", "300", "1", "25.54", "366"),("119984", "2", "1000", "300", "1", "26.36", "367"),("61417", "2", "1022", "24", "1", "8.18", "368"),("61416", "2", "1005", "24", "1", "8.18", "369"),("61419", "2", "1004", "24", "1", "8.18", "370"),("61418", "2", "1003", "24", "1", "8.18", "371"),("61409", "2", "1000", "24", "1", "8.18", "372"),("96729", "2", "1001", "484", "1", "578.43", "373"),("125547", "1", "1002", "13", "1", "109.01", "374"),("125545", "1", "1000", "13", "1", "119.75", "375"),("33860", "2", "1009", "19", "1", "14.79", "376"),("33859", "2", "1000", "19", "1", "14.79", "377"),("36714", "2", "1000", "19", "1", "14.79", "378"),("95503", "2", "1000", "19", "1", "14.79", "379"),("253202", "2", "1003", "24", "1", "17.27", "380"),("108531", "1", "1000", "58", "1", "110.66", "381"),("64565", "2", "1007", "19", "1", "15.62", "382"),("66240", "2", "1000", "19", "1", "10.66", "383"),("66239", "2", "4", "19", "1", "11.49", "384"),("60202", "2", "1", "24", "1", "96.61", "385"),("60204", "2", "1", "24", "1", "108.18", "386"),("11985", "2", "1013", "24", "1", "4.05", "387"),("12004", "2", "1005", "24", "1", "4.05", "388"),("11987", "4", "1003", "24", "1", "4.05", "389"),("62284", "2", "1002", "24", "1", "63.55", "390"),("122543", "2", "1001", "24", "1", "109.83", "391"),("11986", "2", "1000", "24", "1", "4.05", "392"),("122535", "2", "1000", "24", "1", "121.4", "393"),("122541", "2", "1000", "24", "1", "103.22", "394"),("62360", "2", "1004", "24", "1", "51.16", "395"),("62384", "2", "1002", "24", "1", "55.29", "396"),("62357", "2", "1000", "24", "1", "51.16", "397"),("62397", "2", "1000", "24", "1", "22.23", "398"),("62398", "2", "3", "24", "1", "34.63", "399"),("62358", "2", "2", "24", "1", "46.2", "400"),("62361", "2", "1", "24", "1", "45.37", "401"),("100341", "1", "1002", "271", "1", "19.75", "402"),("100340", "1", "1000", "271", "1", "18.1", "403"),("151267", "1", "1", "191", "1", "35.45", "404"),("258024", "1", "1000", "58", "1", "4.05", "405"),("258026", "1", "2", "58", "1", "4.05", "406"),("62368", "2", "1003", "24", "1", "18.93", "407"),("62372", "2", "1001", "24", "1", "18.93", "408"),("62379", "2", "1001", "24", "1", "26.36", "409"),("62381", "2", "1001", "24", "1", "27.19", "410"),("62370", "2", "1000", "24", "1", "11.49", "411"),("62371", "2", "1000", "24", "1", "14.79", "412"),("62374", "2", "1000", "24", "1", "22.23", "413"),("62382", "2", "1000", "24", "1", "32.98", "414"),("118963", "2", "1000", "160", "1", "3643.72", "415"),("62278", "2", "1", "24", "1", "90", "416"),("221812", "1", "1033", "370", "1", "5.7", "417"),("111329", "2", "1000", "49", "1", "106.53", "418"),("108005", "1", "1000", "58", "1", "9.82", "419"),("108006", "1", "1000", "58", "1", "10.83", "420"),("141251", "2", "1000", "85", "1", "269.34", "421"),("141253", "2", "1000", "85", "1", "187.84", "422"),("141255", "2", "1000", "85", "1", "304.75", "423"),("143415", "2", "1005", "160", "1", "20.58", "424"),("199437", "1", "1001", "570", "1", "20.62", "425"),("199433", "1", "1000", "570", "1", "30.99", "426"),("199435", "1", "1000", "570", "1", "30.99", "427"),("88942", "2", "1001", "423", "1", "17.27", "428"),("88943", "2", "1000", "423", "1", "18.93", "429"),("209663", "1", "1001", "487", "1", "19.73", "430"),("174777", "2", "1000", "423", "1", "7.36", "431"),("204305", "1", "1000", "487", "1", "26.94", "432"),("65756", "2", "1003", "85", "1", "184.21", "433"),("247200", "1", "1009", "357", "1", "12.31", "434"),("247199", "1", "1008", "357", "1", "13.97", "435"),("247201", "1", "1000", "357", "1", "11.49", "436"),("103199", "2", "1006", "119", "1", "20.58", "437"),("103200", "2", "1000", "119", "1", "20.58", "438"),("256486", "1", "1000", "224", "1", "593.31", "439"),("250846", "1", "1000", "808", "1", "11.49", "440"),("74916", "2", "5", "468", "1", "6.53", "441"),("74717", "2", "4", "468", "1", "43.72", "442"),("74836", "2", "3", "468", "1", "6.53", "443"),("74697", "2", "2", "468", "1", "6.53", "444"),("169706", "1", "1004", "49", "1", "18.47", "445"),("169705", "1", "1001", "49", "1", "14.94", "446"),("234012", "1", "1000", "119", "1", "666.03", "447"),("234013", "1", "1000", "119", "1", "607.36", "448"),("129629", "2", "1000", "49", "1", "18.1", "449"),("140617", "1", "2", "353", "1", "5.7", "450"),("140619", "1", "1", "353", "1", "7.36", "451"),("234078", "1", "1000", "119", "1", "310.66", "452"),("138393", "2", "999", "85", "1", "217.17", "453"),("115385", "2", "1008", "11", "1", "11.49", "454"),("230754", "1", "1000", "727", "1", "13.97", "455"),("201687", "1", "1000", "102", "1", "5.7", "456"),("63335", "2", "1001", "24", "1", "8.18", "457"),("63334", "2", "1000", "24", "1", "8.18", "458"),("145249", "2", "1000", "160", "1", "33.8", "459"),("62782", "2", "1001", "24", "1", "8.18", "460"),("68191", "2", "1000", "85", "1", "239.59", "461"),("9974", "10", "13", "73", "1", "16.36", "462"),("247350", "1", "1019", "357", "1", "23.06", "463"),("88177", "2", "1016", "368", "1", "13.14", "464"),("88178", "2", "1006", "368", "1", "13.14", "465"),("258451", "2", "1000", "62", "1", "11.56", "466"),("258452", "2", "1000", "62", "1", "11.56", "467"),("261729", "1", "1000", "62", "1", "7.43", "468"),("78096", "2", "1001", "85", "1", "220.58", "469"),("98600", "2", "1027", "368", "1", "13.14", "470"),("265509", "1", "1026", "143", "1", "8.18", "471"),("98601", "2", "1013", "368", "1", "13.14", "472"),("265508", "1", "1013", "143", "1", "8.18", "473"),("265510", "1", "1010", "143", "1", "8.18", "474"),("265507", "1", "1007", "143", "1", "8.18", "475"),("242747", "2", "1004", "75", "1", "9.83", "476"),("242752", "2", "1004", "75", "1", "10.66", "477"),("242749", "2", "1002", "75", "1", "10.66", "478"),("111832", "1", "1001", "124", "1", "7.36", "479"),("258442", "2", "1000", "62", "1", "5.78", "480"),("258443", "2", "1000", "62", "1", "5.78", "481"),("258444", "2", "1000", "62", "1", "5.78", "482"),("186269", "1", "1023", "357", "1", "14.79", "483"),("113665", "2", "1002", "24", "1", "18.93", "484"),("175270", "2", "1002", "528", "1", "5.87", "485"),("113666", "2", "1001", "24", "1", "19.75", "486"),("175271", "2", "1001", "528", "1", "5.87", "487"),("102650", "2", "1000", "294", "1", "10.66", "488"),("113664", "2", "1000", "24", "1", "14.79", "489"),("113667", "2", "1000", "24", "1", "19.75", "490"),("113669", "2", "1000", "24", "1", "25.54", "491"),("102653", "2", "1009", "294", "1", "9.01", "492"),("186255", "1", "2", "357", "1", "13.14", "493"),("186279", "1", "1", "357", "1", "13.14", "494"),("268231", "2", "1001", "75", "1", "49.5", "495"),("186205", "1", "1004", "357", "1", "40.41", "496"),("186203", "1", "1002", "357", "1", "40.41", "497"),("133231", "2", "1000", "289", "1", "11.49", "498"),("133233", "2", "1000", "289", "1", "11.49", "499"),("171646", "1", "1000", "59", "1", "13.14", "500")

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 = '249776' 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 = '249776' 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 = '249776' AND a.attribute_group_id = '8' 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 = '249776'
ORDER BY sort_order ASC

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PESCUITLAFEEDER S.R.L%' AND language_id = '2'

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 p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'