Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '299bbd31f1055051c8784d2cd9'

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 ("150889", "2", "1001", "357", "1", "137.93", "1"),("57191", "2", "1023", "24", "1", "22.23", "2"),("1167", "4", "1001", "13", "1", "6.53", "3"),("1166", "10", "1000", "13", "1", "6.53", "4"),("95659", "2", "1000", "163", "1", "36.28", "5"),("49814", "2", "1008", "47", "1", "79.26", "6"),("117750", "2", "1007", "109", "1", "41.17", "7"),("97025", "2", "1004", "109", "1", "39.59", "8"),("117749", "2", "1001", "109", "1", "38.76", "9"),("210353", "2", "1001", "13", "1", "23.06", "10"),("110663", "2", "1000", "11", "1", "118.1", "11"),("178157", "2", "1000", "75", "1", "118.93", "12"),("269098", "1", "1000", "143", "1", "51.16", "13"),("210339", "2", "996", "13", "1", "19.75", "14"),("113678", "2", "5", "24", "1", "13.97", "15"),("17783", "2", "1", "42", "1", "80.91", "16"),("137883", "2", "1004", "47", "1", "31.83", "17"),("73004", "2", "1002", "464", "1", "25.95", "18"),("111880", "1", "1002", "13", "1", "25.54", "19"),("79493", "2", "1000", "42", "1", "28.02", "20"),("79494", "2", "1000", "42", "1", "31.32", "21"),("79496", "2", "1000", "42", "1", "32.15", "22"),("113853", "2", "1000", "24", "1", "21.4", "23"),("269099", "1", "1000", "143", "1", "75.95", "24"),("62428", "2", "1", "27", "1", "26.36", "25"),("170216", "1", "1", "121", "1", "78.43", "26"),("117821", "2", "1", "280", "1", "30.99", "27"),("116753", "2", "1096", "47", "1", "20.58", "28"),("62423", "2", "1014", "24", "1", "15.62", "29"),("48811", "2", "1009", "47", "1", "59.42", "30"),("87865", "2", "1007", "299", "1", "26.36", "31"),("17799", "2", "1005", "42", "1", "86.69", "32"),("57192", "2", "1003", "24", "1", "22.23", "33"),("62425", "2", "1003", "24", "1", "18.93", "34"),("17795", "2", "1003", "42", "1", "65.21", "35"),("87864", "2", "1003", "299", "1", "25.54", "36"),("70620", "2", "1002", "24", "1", "16.45", "37"),("56278", "2", "1002", "98", "1", "14.27", "38"),("55086", "2", "1001", "75", "1", "13.97", "39"),("87870", "2", "1001", "299", "1", "27.19", "40"),("225510", "2", "1000", "122", "1", "112.31", "41"),("194919", "1", "1000", "533", "1", "56.94", "42"),("194921", "1", "1000", "533", "1", "56.94", "43"),("194923", "1", "1000", "533", "1", "61.07", "44"),("194925", "1", "1000", "533", "1", "79.26", "45"),("269030", "1", "1000", "143", "1", "23.06", "46"),("269031", "1", "1000", "143", "1", "31.32", "47"),("265740", "1", "998", "143", "1", "27.19", "48"),("151339", "1", "5", "357", "1", "49.5", "49"),("35309", "2", "3", "54", "1", "232.76", "50"),("117536", "2", "3", "168", "1", "37.93", "51"),("245916", "1", "1004", "808", "1", "34.63", "52"),("245914", "1", "1003", "808", "1", "28.84", "53"),("70443", "2", "1001", "124", "1", "28.02", "54"),("70442", "2", "1000", "124", "1", "28.02", "55"),("70444", "2", "1000", "124", "1", "28.02", "56"),("36280", "2", "1000", "299", "1", "47.85", "57"),("1168", "10", "1000", "13", "1", "7.36", "58"),("96838", "2", "1000", "528", "1", "49.5", "59"),("150529", "1", "1000", "58", "1", "31.32", "60"),("232272", "2", "1000", "299", "1", "43.72", "61"),("232276", "2", "1000", "299", "1", "39.59", "62"),("232277", "2", "1000", "299", "1", "36.28", "63"),("201715", "1", "1000", "362", "1", "17.27", "64"),("247976", "1", "1000", "808", "1", "42.07", "65"),("269027", "1", "1000", "143", "1", "47.85", "66"),("116411", "2", "20", "47", "1", "21.4", "67"),("210329", "2", "1", "13", "1", "42.76", "68"),("48812", "2", "1031", "47", "1", "59.42", "69"),("48813", "2", "1008", "47", "1", "59.42", "70"),("55087", "2", "1005", "75", "1", "23.06", "71"),("123629", "2", "1005", "168", "1", "67.69", "72"),("123623", "2", "1004", "168", "1", "90.83", "73"),("188237", "1", "1003", "13", "1", "31.32", "74"),("211035", "1", "1002", "476", "1", "43.35", "75"),("211037", "1", "1002", "476", "1", "49.55", "76"),("102321", "1", "1001", "13", "1", "25.54", "77"),("237541", "1", "1001", "98", "1", "80.91", "78"),("34121", "2", "1000", "287", "1", "33.8", "79"),("111320", "2", "1000", "49", "1", "32.15", "80"),("123625", "2", "1000", "168", "1", "83.39", "81"),("123627", "2", "1000", "168", "1", "75.95", "82"),("211039", "1", "1000", "476", "1", "49.55", "83"),("211041", "1", "1000", "476", "1", "53.68", "84"),("211043", "1", "1000", "476", "1", "53.68", "85"),("207531", "1", "1000", "528", "1", "22.23", "86"),("207533", "1", "1000", "528", "1", "24.71", "87"),("179552", "4", "1000", "13", "1", "62.73", "88"),("253915", "1", "1000", "818", "1", "132.45", "89"),("253916", "1", "1000", "818", "1", "119.17", "90"),("253917", "1", "1000", "818", "1", "110.35", "91"),("251586", "1", "1000", "285", "1", "24.71", "92"),("251587", "1", "1000", "285", "1", "28.84", "93"),("251588", "1", "1000", "285", "1", "32.98", "94"),("269035", "1", "1000", "143", "1", "24.71", "95"),("269036", "1", "1000", "143", "1", "35.45", "96"),("269037", "1", "1000", "143", "1", "39.59", "97"),("269039", "1", "1000", "143", "1", "42.89", "98"),("269040", "1", "1000", "143", "1", "28.84", "99"),("64598", "2", "7", "168", "1", "58.6", "100"),("64594", "2", "2", "168", "1", "107.36", "101"),("62418", "2", "2", "24", "1", "16.45", "102"),("179795", "2", "2", "681", "1", "85.62", "103"),("180460", "1", "2", "13", "1", "13.97", "104"),("64593", "2", "1", "168", "1", "41.24", "105"),("232375", "1", "1000", "88", "1", "396.61", "106"),("232376", "1", "1000", "88", "1", "432.15", "107"),("232377", "1", "1000", "88", "1", "468.51", "108"),("159225", "1", "1008", "437", "1", "32.98", "109"),("59559", "2", "1003", "287", "1", "64.38", "110"),("187625", "2", "1001", "468", "1", "237.11", "111"),("231595", "1", "1000", "193", "1", "193.31", "112"),("231629", "2", "1000", "11", "1", "225.54", "113"),("238205", "2", "1000", "168", "1", "238.76", "114"),("238345", "2", "1000", "168", "1", "276.78", "115"),("247599", "1", "1000", "370", "1", "14.79", "116"),("250629", "1", "1000", "42", "1", "75.12", "117"),("262361", "1", "1000", "285", "1", "19.75", "118"),("262362", "1", "1000", "285", "1", "23.06", "119"),("238347", "2", "7", "168", "1", "312.31", "120"),("31146", "2", "3", "45", "1", "33.8", "121"),("238208", "2", "1", "168", "1", "276.78", "122"),("258705", "1", "1006", "370", "1", "31.32", "123"),("258708", "1", "1006", "370", "1", "34.63", "124"),("258709", "1", "1006", "370", "1", "37.93", "125"),("258711", "1", "1005", "370", "1", "41.24", "126"),("150885", "1", "1001", "360", "1", "130.5", "127"),("155329", "2", "1001", "124", "1", "75.95", "128"),("170590", "2", "1001", "58", "1", "33.8", "129"),("170592", "2", "1001", "58", "1", "42.89", "130"),("170591", "2", "1000", "58", "1", "38.76", "131"),("218812", "2", "1000", "528", "1", "72.64", "132"),("236421", "2", "1000", "191", "1", "75.95", "133"),("236422", "2", "1000", "191", "1", "56.94", "134"),("265203", "1", "1000", "528", "1", "148.68", "135"),("229532", "1", "998", "423", "1", "84.21", "136"),("225654", "1", "9", "776", "1", "127.19", "137"),("167851", "1", "5", "285", "1", "118.1", "138"),("258712", "1", "2", "370", "1", "47.02", "139"),("152325", "1", "1019", "13", "1", "40.41", "140"),("152327", "1", "1018", "13", "1", "44.55", "141"),("265791", "1", "1010", "363", "1", "18.1", "142"),("164552", "1", "1001", "13", "1", "203.22", "143"),("5849", "2", "1000", "42", "1", "270.99", "144"),("122305", "1", "1000", "528", "1", "665.21", "145"),("123615", "2", "1000", "168", "1", "86.69", "146"),("123617", "2", "1000", "168", "1", "75.95", "147"),("123619", "2", "1000", "168", "1", "67.69", "148"),("123621", "2", "1000", "168", "1", "64.38", "149"),("164553", "1", "1000", "13", "1", "145.37", "150"),("178276", "1", "1000", "122", "1", "186.69", "151"),("199307", "2", "1000", "725", "1", "221.4", "152"),("201035", "2", "1000", "727", "1", "87.52", "153"),("236728", "2", "1000", "124", "1", "147.02", "154"),("265790", "1", "1000", "363", "1", "19.75", "155"),("236727", "2", "1", "124", "1", "105.7", "156"),("70710", "10", "1000", "376", "1", "380.08", "157"),("70723", "10", "1000", "376", "1", "702.4", "158"),("247495", "1", "1000", "119", "1", "606.53", "159"),("265800", "1", "1000", "363", "1", "132.15", "160"),("265801", "1", "1000", "363", "1", "123.88", "161"),("237610", "1", "9", "287", "1", "41.24", "162"),("265789", "1", "1001", "363", "1", "19.75", "163"),("150621", "2", "1000", "58", "1", "98.26", "164"),("102079", "2", "1000", "204", "1", "54.46", "165"),("242090", "2", "1000", "725", "1", "242.07", "166"),("242091", "2", "1000", "725", "1", "281.74", "167"),("265788", "1", "1000", "363", "1", "22.23", "168"),("265792", "1", "1000", "363", "1", "51.16", "169"),("265793", "1", "1000", "363", "1", "57.77", "170"),("102078", "2", "2", "204", "1", "63.55", "171"),("228103", "2", "1004", "368", "1", "57.77", "172"),("228104", "2", "1002", "368", "1", "67.69", "173"),("228105", "2", "1002", "368", "1", "85.87", "174"),("228108", "2", "1001", "368", "1", "67.69", "175"),("177015", "2", "1000", "58", "1", "115.62", "176"),("219544", "1", "1000", "27", "1", "330.5", "177"),("240066", "2", "1000", "85", "1", "404.05", "178"),("240067", "2", "1000", "85", "1", "257.77", "179"),("261477", "1", "1000", "224", "1", "257.85", "180"),("265802", "1", "1000", "363", "1", "47.85", "181"),("265803", "1", "1000", "363", "1", "42.89", "182"),("265804", "1", "1000", "363", "1", "34.63", "183"),("267366", "1", "1000", "285", "1", "36.28", "184"),("267367", "1", "1000", "285", "1", "36.28", "185"),("269041", "1", "1000", "143", "1", "67.69", "186"),("172141", "2", "1001", "18", "1", "65.21", "187"),("172138", "2", "1000", "18", "1", "45.37", "188"),("237855", "1", "1000", "287", "1", "51.16", "189"),("179679", "1", "1000", "115", "1", "566.86", "190"),("234455", "2", "1000", "782", "1", "121.4", "191"),("262662", "1", "1000", "117", "1", "201.57", "192"),("257158", "1", "1000", "203", "1", "184.21", "193"),("266350", "2", "1000", "370", "1", "59.42", "194"),("266351", "2", "1000", "370", "1", "56.12", "195"),("266354", "2", "1000", "370", "1", "51.16", "196"),("269042", "1", "1000", "143", "1", "115.62", "197"),("269043", "1", "1000", "143", "1", "84.21", "198"),("172140", "2", "999", "18", "1", "54.46", "199"),("172515", "2", "1002", "174", "1", "351.16", "200"),("164899", "2", "1002", "360", "1", "108.18", "201"),("89100", "2", "1000", "423", "1", "57.77", "202"),("89101", "2", "1000", "423", "1", "70.17", "203"),("89103", "2", "1000", "423", "1", "64.38", "204"),("89104", "2", "1000", "423", "1", "75.12", "205"),("117985", "1", "1000", "13", "1", "85.87", "206"),("117987", "1", "1000", "13", "1", "103.22", "207"),("113649", "2", "1000", "188", "1", "32.15", "208"),("218811", "2", "1000", "528", "1", "63.55", "209"),("250761", "1", "1000", "725", "1", "60.25", "210"),("256671", "1", "1000", "87", "1", "228.02", "211"),("256672", "1", "1000", "87", "1", "228.02", "212"),("164308", "1", "10", "357", "1", "258.6", "213"),("89102", "2", "1", "423", "1", "70.17", "214"),("167850", "1", "1007", "285", "1", "128.84", "215"),("212181", "2", "1007", "370", "1", "49.5", "216"),("212183", "2", "1004", "370", "1", "56.12", "217"),("65919", "2", "1003", "423", "1", "38.76", "218"),("212187", "2", "1002", "370", "1", "72.64", "219"),("150985", "2", "1001", "357", "1", "183.39", "220"),("212177", "2", "1001", "370", "1", "67.69", "221"),("212179", "2", "1001", "370", "1", "64.38", "222"),("212185", "2", "1001", "370", "1", "76.78", "223"),("247597", "2", "1001", "285", "1", "98.26", "224"),("257777", "2", "1001", "224", "1", "118.1", "225"),("65920", "2", "998", "423", "1", "51.98", "226"),("227392", "2", "3", "280", "1", "101.57", "227"),("212125", "2", "1000", "370", "1", "101.57", "228"),("268699", "1", "1000", "143", "1", "83.39", "229"),("113642", "2", "1000", "27", "1", "75.95", "230"),("113643", "2", "1000", "27", "1", "76.78", "231"),("113644", "2", "1000", "27", "1", "90.83", "232"),("265148", "2", "1000", "541", "1", "90.91", "233"),("237527", "1", "1002", "13", "1", "93.31", "234"),("237528", "1", "1001", "13", "1", "103.22", "235"),("237529", "1", "1000", "13", "1", "111.49", "236"),("249169", "1", "1000", "476", "1", "785.08", "237"),("257172", "1", "1000", "85", "1", "367.69", "238"),("257173", "1", "1000", "85", "1", "330.5", "239"),("175680", "2", "5", "124", "1", "81.74", "240"),("106978", "1", "1000", "287", "1", "101.57", "241"),("244246", "1", "1000", "73", "1", "514.79", "242"),("68191", "2", "1000", "85", "1", "239.59", "243"),("165618", "1", "1004", "502", "1", "82.56", "244"),("244249", "1", "1001", "73", "1", "514.79", "245"),("260270", "1", "1000", "181", "1", "283.46", "246"),("260272", "1", "1000", "181", "1", "304.12", "247"),("260279", "1", "1000", "181", "1", "218.17", "248"),("260281", "1", "1000", "181", "1", "309.08", "249"),("260283", "1", "1000", "181", "1", "283.46", "250"),("260284", "1", "1000", "181", "1", "302.47", "251"),("260285", "1", "1000", "181", "1", "146.27", "252"),("268131", "1", "1000", "143", "1", "34.63", "253"),("268132", "1", "1000", "143", "1", "42.89", "254"),("264992", "2", "1000", "360", "1", "100.74", "255"),("264994", "2", "1000", "360", "1", "125.54", "256"),("269816", "1", "999", "143", "1", "37.93", "257"),("221665", "2", "1004", "360", "1", "80.91", "258"),("248242", "1", "1000", "808", "1", "98.26", "259"),("248243", "1", "1000", "808", "1", "135.45", "260"),("248244", "1", "1000", "808", "1", "173.47", "261"),("262196", "1", "1000", "360", "1", "116.45", "262"),("262195", "1", "1000", "360", "1", "94.13", "263"),("268140", "1", "1000", "143", "1", "51.16", "264"),("268141", "1", "1000", "143", "1", "59.42", "265"),("269485", "1", "1000", "360", "1", "89.17", "266"),("245988", "2", "1001", "543", "1", "361.9", "267"),("262235", "1", "1000", "357", "1", "140.41", "268"),("262236", "1", "1000", "357", "1", "162.73", "269"),("260760", "1", "1000", "181", "1", "128.09", "270"),("260762", "1", "1000", "181", "1", "142.14", "271"),("268255", "1", "1000", "143", "1", "132.15", "272"),("268173", "1", "1001", "143", "1", "42.89", "273"),("260446", "1", "1000", "76", "1", "406.6", "274"),("268171", "1", "1000", "143", "1", "37.11", "275"),("268172", "1", "1000", "143", "1", "38.76", "276"),("268174", "1", "1000", "143", "1", "75.95", "277"),("268175", "1", "1000", "143", "1", "47.85", "278"),("268177", "1", "1000", "143", "1", "75.95", "279"),("268180", "1", "1000", "143", "1", "67.69", "280"),("268257", "1", "1000", "143", "1", "132.15", "281"),("268261", "1", "1000", "143", "1", "84.21", "282"),("268265", "1", "1000", "143", "1", "95.79", "283"),("268269", "1", "1000", "143", "1", "112.31", "284"),("268271", "1", "1000", "143", "1", "107.36", "285"),("268259", "1", "1000", "143", "1", "99.09", "286"),("268264", "1", "1000", "143", "1", "148.68", "287"),("166911", "2", "0", "280", "1", "9.01", "288"),("47455", "2", "0", "47", "1", "13.92", "289"),("62427", "2", "0", "27", "1", "16.91", "290"),("1169", "10", "0", "13", "1", "7.36", "291"),("192829", "1", "0", "121", "1", "38.23", "292"),("192831", "1", "0", "121", "1", "51", "293"),("192833", "1", "0", "121", "1", "51", "294"),("192835", "1", "0", "121", "1", "51", "295"),("192837", "1", "0", "121", "1", "63.73", "296"),("192937", "1", "0", "121", "1", "61.88", "297"),("59788", "2", "0", "67", "1", "11.37", "298"),("22090", "2", "0", "163", "1", "13.27", "299"),("110621", "2", "0", "47", "1", "12.34", "300"),("82646", "2", "0", "168", "1", "66.73", "301"),("143299", "2", "0", "47", "1", "16.41", "302"),("210331", "2", "0", "13", "1", "25", "303"),("207951", "1", "0", "119", "1", "160.16", "304"),("245913", "1", "0", "808", "1", "15.7", "305"),("64595", "2", "0", "168", "1", "73.47", "306"),("62417", "2", "0", "24", "1", "9.5", "307"),("34404", "2", "0", "12", "1", "15.71", "308"),("79324", "2", "0", "468", "1", "113.68", "309"),("175163", "1", "0", "191", "1", "46.22", "310"),("39636", "2", "0", "42", "1", "205.5", "311"),("178750", "2", "0", "27", "1", "96", "312"),("178751", "2", "0", "27", "1", "110", "313"),("251591", "1", "0", "285", "1", "15", "314"),("251592", "1", "0", "285", "1", "17.5", "315"),("167849", "1", "0", "285", "1", "50.77", "316"),("164548", "1", "0", "13", "1", "150", "317"),("175681", "2", "0", "124", "1", "121.16", "318"),("236419", "2", "0", "191", "1", "47.98", "319"),("236420", "2", "0", "191", "1", "59.98", "320"),("255945", "1", "0", "47", "1", "51", "321"),("255623", "1", "0", "727", "1", "132.34", "322"),("251596", "1", "0", "285", "1", "13.75", "323"),("236722", "2", "0", "124", "1", "112.19", "324"),("236725", "2", "0", "124", "1", "107.06", "325"),("102081", "2", "0", "204", "1", "70", "326"),("255632", "1", "0", "727", "1", "235.43", "327"),("265202", "1", "0", "98", "1", "123.96", "328"),("175886", "2", "0", "12", "1", "92.53", "329"),("175888", "2", "0", "12", "1", "68.51", "330"),("238863", "2", "0", "85", "1", "180.01", "331"),("256768", "1", "0", "87", "1", "203.98", "332"),("89098", "2", "0", "423", "1", "128.02", "333"),("149849", "2", "0", "163", "1", "54.02", "334"),("178000", "4", "0", "13", "1", "32.15", "335"),("178001", "4", "0", "13", "1", "18", "336"),("178002", "4", "0", "13", "1", "32.15", "337"),("177391", "2", "0", "11", "1", "205.05", "338"),("177395", "2", "0", "11", "1", "212.98", "339"),("236045", "2", "1001", "88", "1", "162.73", "340"),("235895", "2", "1000", "88", "1", "198.26", "341"),("236043", "2", "1000", "88", "1", "198.26", "342"),("236044", "2", "1000", "88", "1", "180.08", "343"),("236046", "2", "1000", "88", "1", "234.63", "344"),("56393", "2", "0", "98", "1", "47.42", "345"),("34130", "2", "0", "287", "1", "35.41", "346"),("149845", "2", "0", "163", "1", "55.45", "347"),("166704", "1", "0", "285", "1", "50", "348"),("166742", "1", "0", "285", "1", "47.41", "349"),("228617", "1", "0", "285", "1", "70", "350"),("256097", "1", "0", "85", "1", "180.01", "351"),("255663", "1", "0", "727", "1", "88.19", "352"),("256693", "1", "0", "287", "1", "39.67", "353"),("256718", "1", "0", "287", "1", "45.45", "354"),("255915", "1", "0", "87", "1", "78.5", "355"),("256695", "1", "0", "287", "1", "61.98", "356"),("165620", "1", "0", "502", "1", "81.2", "357"),("252632", "2", "0", "455", "1", "71.82", "358"),("94630", "2", "1000", "163", "1", "69.34", "359"),("113827", "2", "1000", "24", "1", "22.23", "360"),("89394", "2", "1001", "423", "1", "38.76", "361"),("68131", "2", "1000", "163", "1", "54.46", "362"),("89404", "2", "1000", "423", "1", "38.76", "363"),("556", "2", "1000", "22", "1", "92.44", "364"),("90776", "4", "1000", "13", "1", "23.88", "365"),("174974", "2", "1000", "122", "1", "130.5", "366"),("21868", "2", "1", "12", "1", "39.74", "367"),("265178", "1", "1000", "143", "1", "51.16", "368"),("119497", "2", "6", "168", "1", "230.5", "369"),("177167", "2", "1007", "11", "1", "58.6", "370"),("177169", "2", "1003", "11", "1", "98.26", "371"),("177166", "2", "1002", "11", "1", "48.68", "372"),("85215", "2", "1000", "115", "1", "247.02", "373"),("85216", "2", "1000", "115", "1", "263.55", "374"),("109369", "2", "1000", "163", "1", "41.24", "375"),("114900", "1", "1000", "124", "1", "220.58", "376"),("113076", "2", "1000", "24", "1", "61.9", "377"),("176312", "1", "1000", "362", "1", "18.1", "378"),("85214", "2", "4", "115", "1", "231.32", "379"),("177168", "2", "2", "11", "1", "77.6", "380"),("199711", "1", "1003", "58", "1", "273.93", "381"),("92133", "2", "1001", "163", "1", "180.91", "382"),("69795", "2", "1000", "124", "1", "80.91", "383"),("69797", "2", "1000", "124", "1", "123.06", "384"),("36500", "2", "1000", "163", "1", "60.25", "385"),("120748", "2", "1000", "163", "1", "127.19", "386"),("120752", "2", "1000", "163", "1", "70.99", "387"),("165427", "2", "1000", "224", "1", "263.55", "388"),("117716", "2", "1000", "11", "1", "110.66", "389"),("117717", "2", "1000", "11", "1", "147.02", "390"),("117718", "2", "1000", "11", "1", "202.4", "391"),("231771", "1", "1000", "121", "1", "504.05", "392"),("188603", "2", "3", "87", "1", "28.31", "393"),("92134", "2", "1", "163", "1", "111.02", "394"),("240129", "1", "1003", "124", "1", "275.95", "395"),("177548", "1", "1002", "11", "1", "132.15", "396"),("109162", "2", "1001", "163", "1", "80.91", "397"),("117704", "2", "1001", "11", "1", "327.19", "398"),("220319", "1", "1001", "370", "1", "218.93", "399"),("240141", "1", "1001", "124", "1", "257.77", "400"),("9114", "2", "1000", "58", "1", "190.83", "401"),("33304", "2", "1000", "163", "1", "58.6", "402"),("33310", "2", "1000", "163", "1", "32.98", "403"),("67633", "2", "1000", "17", "1", "277.3", "404"),("67800", "2", "1000", "17", "1", "302.5", "405"),("72117", "2", "1000", "24", "1", "353.64", "406"),("72125", "2", "1000", "24", "1", "248.68", "407"),("90777", "4", "1000", "13", "1", "26.36", "408"),("90779", "4", "1000", "13", "1", "31.32", "409"),("90780", "4", "1000", "13", "1", "35.45", "410"),("109161", "2", "1000", "163", "1", "185.04", "411"),("165430", "2", "1000", "224", "1", "288.35", "412"),("128443", "2", "1000", "11", "1", "328.84", "413"),("177549", "1", "1000", "11", "1", "161.07", "414"),("231333", "1", "1000", "121", "1", "251.98", "415"),("231334", "1", "1000", "121", "1", "216.45", "416"),("231335", "1", "1000", "121", "1", "216.45", "417"),("225951", "1", "1000", "224", "1", "165.21", "418"),("220026", "1", "1000", "224", "1", "210.66", "419"),("220039", "1", "1000", "224", "1", "319.75", "420"),("220041", "1", "1000", "224", "1", "275.95", "421"),("220166", "1", "1000", "224", "1", "199.09", "422"),("220320", "1", "1000", "370", "1", "201.57", "423"),("240126", "1", "1000", "124", "1", "220.58", "424"),("240128", "1", "1000", "124", "1", "275.95", "425"),("240140", "1", "1000", "124", "1", "275.95", "426"),("240142", "1", "1000", "124", "1", "257.77", "427"),("240143", "1", "1000", "124", "1", "257.77", "428"),("240144", "1", "1000", "124", "1", "238.76", "429"),("240145", "1", "1000", "124", "1", "238.76", "430"),("240146", "1", "1000", "124", "1", "238.76", "431"),("240164", "1", "1000", "85", "1", "312.31", "432"),("240165", "1", "1000", "85", "1", "294.13", "433"),("235672", "1", "1000", "88", "1", "432.15", "434"),("235673", "1", "1000", "88", "1", "396.61", "435"),("235674", "1", "1000", "88", "1", "360.25", "436"),("235675", "1", "1000", "88", "1", "324.71", "437"),("33296", "2", "1", "163", "1", "33.96", "438"),("220017", "1", "1", "224", "1", "219.75", "439"),("210369", "1", "1012", "13", "1", "66.03", "440"),("210363", "1", "1008", "13", "1", "84.21", "441"),("210367", "1", "1008", "13", "1", "80.91", "442"),("188605", "1", "1006", "87", "1", "417.27", "443"),("210379", "1", "1005", "13", "1", "59.42", "444"),("199713", "1", "1002", "58", "1", "286.69", "445"),("169704", "1", "1001", "58", "1", "241.24", "446"),("220545", "2", "1001", "58", "1", "270.99", "447"),("220547", "2", "1001", "58", "1", "321.4", "448"),("237003", "1", "1001", "124", "1", "238.76", "449"),("9703", "10", "1000", "163", "1", "181.74", "450"),("150767", "2", "1000", "58", "1", "128.02", "451"),("109118", "2", "1000", "11", "1", "276.39", "452"),("109124", "2", "1000", "11", "1", "252.81", "453"),("169697", "1", "1000", "58", "1", "194.96", "454"),("169700", "1", "1000", "58", "1", "224.71", "455"),("161789", "2", "1000", "58", "1", "253.64", "456"),("161791", "2", "1000", "58", "1", "279.26", "457"),("103028", "4", "1000", "124", "1", "59.89", "458"),("103029", "4", "1000", "124", "1", "64.38", "459"),("192525", "1", "1000", "725", "1", "354.46", "460"),("193483", "1", "1000", "87", "1", "379.26", "461"),("193485", "1", "1000", "87", "1", "379.26", "462"),("220215", "1", "1000", "224", "1", "253.64", "463"),("220218", "1", "1000", "224", "1", "209.01", "464"),("220546", "2", "1000", "58", "1", "295.79", "465"),("220548", "2", "1000", "58", "1", "337.11", "466"),("236091", "1", "1000", "87", "1", "455.29", "467"),("236092", "1", "1000", "87", "1", "417.27", "468"),("236093", "1", "1000", "87", "1", "455.29", "469"),("236097", "1", "1000", "87", "1", "417.27", "470"),("236098", "1", "1000", "87", "1", "379.26", "471"),("236099", "1", "1000", "87", "1", "417.27", "472"),("236100", "1", "1000", "87", "1", "417.27", "473"),("240229", "1", "1000", "124", "1", "184.21", "474"),("240232", "1", "1000", "124", "1", "128.84", "475"),("240233", "1", "1000", "124", "1", "128.84", "476"),("169699", "1", "1", "58", "1", "216.45", "477"),("119637", "2", "1003", "27", "1", "254.46", "478"),("172543", "2", "1003", "27", "1", "94.96", "479"),("150743", "2", "1002", "58", "1", "252.09", "480"),("119634", "2", "1002", "27", "1", "191.65", "481"),("172542", "2", "1002", "27", "1", "118.1", "482"),("85176", "2", "1001", "115", "1", "162.73", "483"),("85217", "2", "1001", "115", "1", "348.68", "484"),("220144", "2", "1001", "58", "1", "295.79", "485"),("85179", "2", "1000", "115", "1", "203.22", "486"),("85181", "2", "1000", "115", "1", "231.32", "487"),("85186", "2", "1000", "115", "1", "247.02", "488"),("90778", "10", "1000", "13", "1", "29.67", "489"),("119635", "2", "1000", "27", "1", "198.26", "490"),("119636", "2", "1000", "27", "1", "255.29", "491"),("158265", "2", "1000", "58", "1", "502.4", "492"),("122833", "2", "1000", "58", "1", "161.9", "493"),("172532", "2", "1000", "27", "1", "106.53", "494"),("106095", "2", "1000", "49", "1", "479.26", "495"),("114898", "1", "1000", "124", "1", "202.4", "496"),("220145", "2", "1000", "58", "1", "309.01", "497"),("220146", "2", "1000", "58", "1", "313.14", "498"),("220820", "1", "1000", "105", "1", "204.05", "499"),("220821", "1", "1000", "105", "1", "212.31", "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 = '210353' 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 = '210353' 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 = '210353' AND a.attribute_group_id = '10' 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 = '210353'
ORDER BY sort_order ASC

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%FL NIRO%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%ARROW INTERNATIONAL%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%ARROW INTERNATIONAL%' AND language_id = '2'

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

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

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%FL NIRO%' AND language_id = '2'

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%BEST FOR FISHING SRL%' 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'