Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '85e37dae80bcf3531354e35a6f'

SELECT `trigger`, `action`
FROM oc_event

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 ("221378", "1", "1000", "117", "1", "34.360000000000", "1"),("221379", "1", "1000", "117", "1", "34.360000000000", "2"),("221380", "1", "1000", "117", "1", "34.360000000000", "3"),("99071", "2", "1000", "117", "1", "72.170000000000", "4"),("99083", "2", "1001", "117", "1", "71.410000000000", "5"),("99118", "2", "1000", "117", "1", "72.170000000000", "6"),("99095", "2", "1000", "117", "1", "72.170000000000", "7"),("99090", "2", "1000", "117", "1", "72.170000000000", "8"),("100101", "1", "1", "117", "1", "72.170000000000", "9"),("135277", "1", "1002", "117", "1", "72.170000000000", "10"),("99116", "2", "1000", "117", "1", "72.170000000000", "11"),("98298", "2", "1000", "117", "1", "84.780000000000", "12"),("228966", "1", "0", "117", "1", "34.360000000000", "13"),("228967", "1", "0", "117", "1", "34.360000000000", "14"),("228968", "1", "0", "117", "1", "34.360000000000", "15"),("228969", "1", "0", "117", "1", "34.360000000000", "16"),("228970", "1", "0", "117", "1", "34.360000000000", "17"),("228971", "1", "0", "117", "1", "34.360000000000", "18"),("99089", "2", "0", "117", "1", "55.000000000000", "19"),("99088", "2", "0", "117", "1", "55.000000000000", "20"),("100097", "1", "0", "117", "1", "55.000000000000", "21"),("98660", "2", "0", "117", "1", "65.000000000000", "22"),("99112", "2", "0", "117", "1", "55.000000000000", "23"),("99073", "10", "0", "117", "1", "55.000000000000", "24"),("99093", "2", "0", "117", "1", "55.000000000000", "25"),("100096", "1", "0", "117", "1", "55.000000000000", "26"),("70949", "2", "1000", "452", "1", "254.980000000000", "27"),("22581", "2", "1000", "165", "1", "390.310000000000", "28"),("22680", "4", "1003", "165", "1", "273.890000000000", "29"),("22592", "4", "1002", "165", "1", "357.500000000000", "30"),("73243", "2", "1001", "464", "1", "25.950000000000", "31"),("22583", "2", "1001", "165", "1", "233.680000000000", "32"),("22596", "2", "1001", "165", "1", "338.980000000000", "33"),("73244", "2", "1000", "464", "1", "25.950000000000", "34"),("180208", "2", "1000", "464", "1", "25.950000000000", "35"),("180210", "2", "1000", "464", "1", "25.950000000000", "36"),("22580", "10", "1000", "165", "1", "291.360000000000", "37"),("22585", "2", "1000", "165", "1", "297.710000000000", "38"),("22588", "10", "1000", "165", "1", "240.410000000000", "39"),("22594", "10", "1000", "165", "1", "386.080000000000", "40"),("22597", "10", "1000", "165", "1", "313.590000000000", "41"),("22598", "4", "1000", "165", "1", "288.710000000000", "42"),("22587", "4", "1", "165", "1", "156.210000000000", "43"),("22589", "4", "1", "165", "1", "193.180000000000", "44"),("219481", "1", "1001", "753", "1", "966.790000000000", "45"),("180209", "2", "1000", "464", "1", "36.030000000000", "46"),("22584", "4", "1000", "165", "1", "297.710000000000", "47"),("38172", "10", "1000", "165", "1", "377.090000000000", "48"),("22590", "2", "1000", "165", "1", "307.230000000000", "49"),("22586", "4", "1", "165", "1", "313.210000000000", "50"),("219486", "1", "1", "753", "1", "189.820000000000", "51"),("22591", "2", "2", "165", "1", "273.130000000000", "52"),("22646", "10", "1", "165", "1", "375.620000000000", "53"),("219480", "1", "1", "753", "1", "231.830000000000", "54"),("219485", "1", "1", "753", "1", "1013.260000000000", "55"),("219461", "1", "1001", "753", "1", "147.800000000000", "56"),("219482", "1", "1001", "753", "1", "98.810000000000", "57"),("239217", "1", "1001", "753", "1", "140.830000000000", "58"),("239215", "1", "1000", "753", "1", "520.220000000000", "59"),("212451", "2", "1", "753", "1", "135.200000000000", "60"),("219484", "1", "1001", "753", "1", "1013.260000000000", "61"),("217415", "1", "1000", "753", "1", "152.790000000000", "62"),("239230", "2", "1000", "753", "1", "52.630000000000", "63"),("212875", "2", "1002", "753", "1", "84.780000000000", "64"),("219483", "2", "1001", "753", "1", "62.420000000000", "65"),("239225", "1", "1001", "753", "1", "262.630000000000", "66"),("239226", "1", "1001", "753", "1", "157.630000000000", "67"),("9738", "4", "1001", "165", "1", "120.430000000000", "68"),("9736", "2", "1", "165", "1", "227.650000000000", "69"),("239229", "2", "1002", "753", "1", "140.830000000000", "70"),("216351", "1", "1000", "753", "1", "337.590000000000", "71"),("216353", "1", "1000", "753", "1", "303.980000000000", "72"),("216355", "1", "1000", "753", "1", "236.790000000000", "73"),("212321", "2", "1000", "753", "1", "672.260000000000", "74"),("212881", "2", "2", "753", "1", "44.230000000000", "75"),("114806", "2", "1000", "401", "1", "21.750000000000", "76"),("9737", "4", "1001", "165", "1", "258.550000000000", "77"),("212887", "2", "1002", "753", "1", "118.420000000000", "78"),("216747", "1", "1001", "753", "1", "152.020000000000", "79"),("216795", "1", "1000", "753", "1", "44.980000000000", "80"),("212051", "2", "1001", "753", "1", "61.020000000000", "81"),("216349", "1", "1000", "753", "1", "471.980000000000", "82"),("212447", "2", "1000", "753", "1", "438.390000000000", "83"),("211531", "2", "1000", "753", "1", "34.360000000000", "84"),("212049", "2", "1", "753", "1", "118.420000000000", "85"),("212443", "2", "1", "753", "1", "185.630000000000", "86"),("68455", "2", "1000", "24", "1", "7.040000000000", "87"),("68459", "2", "1000", "24", "1", "7.460000000000", "88"),("212053", "2", "1001", "753", "1", "152.000000000000", "89"),("212045", "2", "2", "753", "1", "206.020000000000", "90"),("212047", "2", "1", "753", "1", "118.420000000000", "91"),("212439", "2", "1002", "753", "1", "185.640000000000", "92"),("216699", "1", "1000", "753", "1", "404.790000000000", "93"),("216919", "1", "1000", "753", "1", "337.590000000000", "94"),("216745", "1", "1000", "753", "1", "135.980000000000", "95"),("212871", "2", "2", "753", "1", "152.000000000000", "96"),("210615", "2", "1", "753", "1", "135.220000000000", "97"),("212453", "2", "1", "753", "1", "104.360000000000", "98"),("210611", "2", "1002", "753", "1", "303.220000000000", "99"),("210609", "2", "1001", "753", "1", "236.020000000000", "100"),("216705", "1", "1000", "753", "1", "102.380000000000", "101"),("212879", "2", "2", "753", "1", "162.830000000000", "102"),("210619", "2", "1", "753", "1", "118.420000000000", "103"),("212873", "2", "1", "753", "1", "104.110000000000", "104"),("212877", "2", "1", "753", "1", "303.230000000000", "105"),("216357", "1", "1000", "753", "1", "169.590000000000", "106"),("232660", "1", "1000", "769", "1", "75.730000000000", "107"),("232521", "1", "1000", "769", "1", "72.740000000000", "108"),("232522", "1", "1000", "769", "1", "40.810000000000", "109"),("232661", "1", "1000", "769", "1", "75.730000000000", "110"),("232662", "1", "1000", "769", "1", "75.730000000000", "111"),("152223", "1", "5", "469", "1", "34.360000000000", "112"),("152219", "1", "4", "469", "1", "52.090000000000", "113"),("172995", "10", "3", "16", "1", "378.140000000000", "114"),("152199", "1", "2", "469", "1", "34.360000000000", "115"),("152265", "1", "2", "469", "1", "34.360000000000", "116"),("152267", "1", "1", "469", "1", "30.990000000000", "117"),("173015", "10", "1", "16", "1", "376.450000000000", "118"),("152235", "1", "1", "469", "1", "34.360000000000", "119"),("73325", "2", "1000", "185", "1", "39.400000000000", "120"),("34561", "2", "1000", "185", "1", "39.400000000000", "121"),("62496", "2", "1000", "24", "1", "115.870000000000", "122"),("52443", "2", "1000", "115", "1", "34.440000000000", "123"),("52444", "2", "1000", "115", "1", "34.440000000000", "124"),("96845", "2", "16", "528", "1", "5.450000000000", "125"),("133387", "1", "2", "59", "1", "824.350000000000", "126"),("96847", "2", "1", "528", "1", "6.290000000000", "127"),("86761", "2", "1", "469", "1", "9.150000000000", "128"),("73229", "2", "1001", "464", "1", "22.680000000000", "129"),("14222", "2", "1000", "115", "1", "41.170000000000", "130"),("14223", "2", "1000", "115", "1", "41.170000000000", "131"),("14224", "2", "1000", "115", "1", "41.170000000000", "132"),("14228", "2", "1000", "115", "1", "37.800000000000", "133"),("14229", "2", "1000", "115", "1", "37.800000000000", "134"),("62500", "2", "1000", "24", "1", "68.810000000000", "135"),("170675", "2", "1000", "656", "1", "51.550000000000", "136"),("170676", "2", "1000", "656", "1", "51.550000000000", "137"),("170681", "2", "1000", "656", "1", "60.080000000000", "138"),("170682", "2", "1000", "656", "1", "60.080000000000", "139"),("170683", "2", "1000", "656", "1", "60.080000000000", "140"),("170684", "2", "1000", "656", "1", "60.080000000000", "141"),("170685", "2", "1000", "656", "1", "60.080000000000", "142"),("170686", "2", "1000", "656", "1", "60.080000000000", "143"),("170687", "2", "1000", "656", "1", "60.080000000000", "144"),("170688", "2", "1000", "656", "1", "60.080000000000", "145"),("56398", "2", "3", "98", "1", "135.270000000000", "146"),("111091", "1", "3", "168", "1", "454.560000000000", "147"),("133383", "1", "2", "59", "1", "731.830000000000", "148"),("188191", "2", "1002", "121", "1", "927.720000000000", "149"),("83248", "2", "1001", "332", "1", "36.120000000000", "150"),("88743", "2", "1000", "42", "1", "311.750000000000", "151"),("52906", "2", "1000", "115", "1", "36.880000000000", "152"),("52908", "2", "1000", "115", "1", "36.880000000000", "153"),("52909", "2", "1000", "115", "1", "36.880000000000", "154"),("123789", "2", "1000", "455", "1", "80.960000000000", "155"),("166815", "1", "5", "121", "1", "966.370000000000", "156"),("188193", "1", "1", "121", "1", "368.050000000000", "157"),("111100", "1", "1", "168", "1", "438.310000000000", "158"),("113572", "2", "1015", "187", "1", "12.500000000000", "159"),("216163", "1", "1002", "121", "1", "1236.960000000000", "160"),("52987", "2", "1001", "115", "1", "14.520000000000", "161"),("46260", "2", "1000", "58", "1", "28.470000000000", "162"),("52904", "2", "1000", "115", "1", "36.880000000000", "163"),("52905", "2", "1000", "115", "1", "36.880000000000", "164"),("52907", "2", "1000", "115", "1", "36.880000000000", "165"),("52910", "2", "1000", "115", "1", "36.880000000000", "166"),("52986", "2", "1000", "115", "1", "14.520000000000", "167"),("52988", "2", "1000", "115", "1", "14.520000000000", "168"),("193139", "1", "1000", "121", "1", "387.380000000000", "169"),("238732", "2", "1000", "30", "1", "64.910000000000", "170"),("113570", "2", "1000", "187", "1", "12.500000000000", "171"),("199589", "1", "3", "528", "1", "226.880000000000", "172"),("182301", "4", "3", "16", "1", "1654.610000000000", "173"),("115515", "2", "2", "329", "1", "208.630000000000", "174"),("52989", "2", "1", "115", "1", "13.770000000000", "175"),("148085", "2", "1", "121", "1", "1159.650000000000", "176"),("199591", "1", "1", "528", "1", "235.280000000000", "177"),("219458", "1", "1010", "30", "1", "15.120000000000", "178"),("101048", "1", "1006", "42", "1", "37.800000000000", "179"),("68271", "2", "1005", "47", "1", "159.650000000000", "180"),("219457", "1", "1002", "30", "1", "16.130000000000", "181"),("101178", "1", "1000", "42", "1", "51.250000000000", "182"),("32158", "2", "1000", "42", "1", "26.590000000000", "183"),("112290", "2", "1000", "455", "1", "455.330000000000", "184"),("112291", "2", "1000", "455", "1", "493.150000000000", "185"),("236031", "2", "1000", "654", "1", "20.070000000000", "186"),("39651", "2", "9", "42", "1", "12.500000000000", "187"),("39669", "2", "4", "42", "1", "45.200000000000", "188"),("68266", "2", "2", "47", "1", "124.360000000000", "189"),("32151", "2", "1", "42", "1", "26.590000000000", "190"),("32157", "2", "1", "42", "1", "20.990000000000", "191"),("108012", "1", "1003", "58", "1", "12.500000000000", "192"),("50375", "2", "1001", "42", "1", "168.050000000000", "193"),("118854", "2", "1001", "20", "1", "12.970000000000", "194"),("91132", "2", "1000", "42", "1", "26.590000000000", "195"),("91133", "2", "1000", "42", "1", "26.590000000000", "196"),("47581", "2", "1000", "42", "1", "168.050000000000", "197"),("47582", "2", "1000", "42", "1", "168.050000000000", "198"),("32160", "2", "1000", "42", "1", "26.590000000000", "199"),("51397", "2", "1000", "42", "1", "26.590000000000", "200"),("51398", "2", "1000", "42", "1", "26.590000000000", "201"),("51400", "2", "1000", "42", "1", "26.590000000000", "202"),("51401", "2", "1000", "42", "1", "26.590000000000", "203"),("51402", "2", "1000", "42", "1", "26.590000000000", "204"),("108013", "1", "1000", "58", "1", "12.500000000000", "205"),("179797", "1", "1000", "290", "1", "588.980000000000", "206"),("68268", "2", "1000", "47", "1", "158.100000000000", "207"),("235433", "1", "1000", "47", "1", "159.650000000000", "208"),("235434", "1", "1000", "47", "1", "149.500000000000", "209"),("235435", "1", "1000", "47", "1", "124.360000000000", "210"),("68269", "2", "1000", "47", "1", "184.440000000000", "211"),("110763", "2", "1000", "79", "1", "157.310000000000", "212"),("118855", "2", "1000", "20", "1", "12.970000000000", "213"),("118856", "2", "1000", "20", "1", "12.970000000000", "214"),("183253", "1", "1000", "20", "1", "18.650000000000", "215"),("218383", "1", "1000", "150", "1", "17.730000000000", "216"),("72882", "4", "22", "435", "1", "101.670000000000", "217"),("9094", "2", "2", "58", "1", "8.310000000000", "218"),("49179", "2", "2", "355", "1", "53.690000000000", "219"),("9100", "2", "1", "58", "1", "20.070000000000", "220"),("49174", "2", "1", "355", "1", "50.320000000000", "221"),("49175", "2", "1", "355", "1", "50.320000000000", "222"),("207137", "1", "1", "16", "1", "431.070000000000", "223"),("238615", "4", "1", "16", "1", "557.960000000000", "224"),("222653", "1", "1010", "370", "1", "17.400000000000", "225"),("222654", "1", "1002", "370", "1", "19.090000000000", "226"),("185419", "2", "1001", "353", "1", "246.600000000000", "227"),("9098", "2", "1000", "58", "1", "24.270000000000", "228"),("162215", "2", "1000", "354", "1", "20.070000000000", "229"),("185421", "2", "1000", "353", "1", "303.310000000000", "230"),("236996", "1", "1000", "47", "1", "138.640000000000", "231"),("143955", "2", "1000", "150", "1", "19.510000000000", "232"),("145029", "2", "1000", "20", "1", "12.970000000000", "233"),("183289", "1", "1000", "20", "1", "18.650000000000", "234"),("183305", "1", "1000", "20", "1", "18.650000000000", "235"),("188695", "2", "1000", "20", "1", "18.650000000000", "236"),("116308", "2", "7", "294", "1", "97.210000000000", "237"),("145571", "1", "6", "469", "1", "76.370000000000", "238"),("134815", "1", "6", "16", "1", "2757.130000000000", "239"),("145575", "1", "2", "469", "1", "76.370000000000", "240"),("145577", "1", "1", "469", "1", "84.780000000000", "241"),("200671", "1", "1", "11", "1", "1496.340000000000", "242"),("50374", "2", "1001", "42", "1", "99.980000000000", "243"),("235189", "1", "1001", "751", "1", "139.420000000000", "244"),("235190", "1", "1001", "751", "1", "139.420000000000", "245"),("47585", "2", "1000", "42", "1", "99.980000000000", "246"),("47586", "2", "1000", "42", "1", "99.980000000000", "247"),("47588", "2", "1000", "42", "1", "99.980000000000", "248"),("47630", "2", "1000", "42", "1", "107.550000000000", "249"),("47638", "2", "1000", "42", "1", "99.980000000000", "250"),("47628", "2", "2", "42", "1", "84.780000000000", "251"),("47587", "2", "1", "42", "1", "81.410000000000", "252"),("207139", "1", "1009", "16", "1", "222.680000000000", "253"),("250489", "1", "1003", "16", "1", "1290.080000000000", "254"),("250490", "1", "1002", "16", "1", "1257.850000000000", "255"),("239219", "1", "1001", "768", "1", "227.630000000000", "256"),("9093", "2", "1000", "58", "1", "15.870000000000", "257"),("221416", "2", "1000", "360", "1", "91.550000000000", "258"),("221417", "2", "1000", "360", "1", "87.770000000000", "259"),("221438", "2", "1000", "360", "1", "83.980000000000", "260"),("221441", "2", "1000", "360", "1", "80.210000000000", "261"),("183257", "1", "1000", "20", "1", "18.650000000000", "262"),("207141", "1", "1000", "16", "1", "206.710000000000", "263"),("250491", "1", "1000", "16", "1", "266.120000000000", "264"),("240071", "4", "7", "435", "1", "171.410000000000", "265"),("162644", "1", "7", "16", "1", "797.460000000000", "266"),("47633", "2", "1004", "42", "1", "14.270000000000", "267"),("47591", "2", "9", "42", "1", "15.120000000000", "268"),("47634", "2", "7", "42", "1", "13.430000000000", "269"),("47635", "2", "3", "42", "1", "13.430000000000", "270"),("47631", "2", "3", "42", "1", "14.270000000000", "271"),("174744", "1", "2", "122", "1", "55.360000000000", "272"),("47636", "2", "2", "42", "1", "13.430000000000", "273"),("47637", "2", "2", "42", "1", "13.430000000000", "274"),("99203", "1", "1", "469", "1", "59.560000000000", "275"),("213343", "1", "1", "16", "1", "271.400000000000", "276"),("247099", "1", "1000", "285", "1", "10.430000000000", "277"),("247104", "1", "1000", "285", "1", "10.430000000000", "278"),("247109", "1", "1000", "285", "1", "10.430000000000", "279"),("247110", "1", "1000", "285", "1", "10.430000000000", "280"),("63877", "2", "1020", "47", "1", "37.800000000000", "281"),("63879", "2", "19", "47", "1", "52.090000000000", "282"),("63878", "2", "16", "47", "1", "45.360000000000", "283"),("38453", "2", "1003", "75", "1", "67.970000000000", "284"),("38455", "2", "1003", "75", "1", "84.780000000000", "285"),("232883", "1", "1001", "785", "1", "40.240000000000", "286"),("232884", "1", "1000", "785", "1", "40.240000000000", "287"),("38454", "2", "1000", "75", "1", "76.370000000000", "288"),("232882", "1", "1003", "785", "1", "36.880000000000", "289"),("232881", "2", "1000", "785", "1", "36.880000000000", "290"),("73231", "2", "0", "464", "1", "16.430000000000", "291"),("212367", "2", "0", "753", "1", "36.000000000000", "292"),("212375", "2", "0", "753", "1", "31.000000000000", "293"),("212435", "2", "0", "753", "1", "96.000000000000", "294"),("216741", "1", "0", "753", "1", "61.790000000000", "295"),("212449", "2", "0", "753", "1", "48.000000000000", "296"),("216751", "1", "0", "753", "1", "85.590000000000", "297"),("212437", "2", "0", "753", "1", "168.000000000000", "298"),("210617", "2", "0", "753", "1", "108.000000000000", "299"),("216719", "1", "0", "753", "1", "168.000000000000", "300"),("210613", "2", "0", "753", "1", "240.000000000000", "301"),("216713", "1", "0", "753", "1", "135.980000000000", "302"),("10839", "2", "0", "101", "1", "38.690000000000", "303"),("49648", "2", "0", "368", "1", "111.080000000000", "304"),("158653", "1", "0", "17", "1", "64.000000000000", "305"),("152225", "1", "0", "469", "1", "23.090000000000", "306"),("152227", "1", "0", "469", "1", "34.360000000000", "307"),("152229", "1", "0", "469", "1", "34.360000000000", "308"),("152231", "1", "0", "469", "1", "34.360000000000", "309"),("123037", "1", "0", "469", "1", "34.360000000000", "310"),("123039", "1", "0", "469", "1", "34.360000000000", "311"),("123041", "1", "0", "469", "1", "52.090000000000", "312"),("123043", "1", "0", "469", "1", "34.360000000000", "313"),("119011", "2", "0", "469", "1", "4.940000000000", "314"),("119012", "2", "0", "469", "1", "3.530000000000", "315"),("83449", "2", "0", "59", "1", "1261.320000000000", "316"),("41572", "2", "0", "45", "1", "2.624000000000", "317"),("41573", "2", "0", "45", "1", "2.624000000000", "318"),("96846", "2", "0", "528", "1", "3.720000000000", "319"),("52441", "2", "0", "115", "1", "27.000000000000", "320"),("52442", "2", "0", "115", "1", "27.000000000000", "321"),("236395", "1", "0", "796", "1", "1198.100000000000", "322"),("14218", "2", "0", "115", "1", "32.000000000000", "323"),("14219", "2", "0", "115", "1", "32.000000000000", "324"),("14221", "2", "0", "115", "1", "32.000000000000", "325"),("43035", "2", "0", "12", "1", "15.090000000000", "326"),("52132", "2", "0", "115", "1", "18.880000000000", "327"),("152207", "1", "0", "469", "1", "30.770000000000", "328"),("230200", "1", "0", "168", "1", "194.420000000000", "329"),("230065", "1", "0", "294", "1", "61.300000000000", "330"),("170677", "2", "0", "656", "1", "37.540000000000", "331"),("170670", "2", "0", "656", "1", "37.540000000000", "332"),("72797", "2", "0", "464", "1", "12.680000000000", "333"),("83247", "2", "0", "332", "1", "27.731000000000", "334"),("111094", "1", "0", "168", "1", "414.040000000000", "335"),("145553", "2", "0", "469", "1", "12.030000000000", "336"),("188195", "2", "0", "121", "1", "409.770000000000", "337"),("52985", "2", "0", "115", "1", "13.770000000000", "338"),("86388", "2", "0", "469", "1", "30.770000000000", "339"),("40366", "2", "0", "42", "1", "29.000000000000", "340"),("51399", "2", "0", "42", "1", "20.500000000000", "341"),("119706", "10", "0", "16", "1", "226.880000000000", "342"),("119707", "10", "0", "16", "1", "207.820000000000", "343"),("112095", "1", "0", "16", "1", "587.040000000000", "344"),("223621", "2", "0", "768", "1", "148.640000000000", "345"),("230559", "1", "0", "59", "1", "79.020000000000", "346"),("143225", "2", "0", "79", "1", "533.160000000000", "347"),("9099", "2", "0", "58", "1", "13.900000000000", "348"),("47584", "2", "0", "42", "1", "129.000000000000", "349"),("119708", "10", "0", "16", "1", "220.420000000000", "350"),("120393", "1", "0", "469", "1", "45.160000000000", "351"),("120406", "1", "0", "469", "1", "39.400000000000", "352"),("47583", "2", "0", "42", "1", "129.000000000000", "353"),("86370", "2", "0", "469", "1", "4.450000000000", "354"),("86374", "2", "0", "469", "1", "4.450000000000", "355"),("86390", "2", "0", "469", "1", "4.450000000000", "356"),("86393", "2", "0", "469", "1", "4.450000000000", "357"),("120071", "2", "0", "79", "1", "299.000000000000", "358"),("120432", "1", "0", "469", "1", "22.020000000000", "359"),("120434", "1", "0", "469", "1", "19.460000000000", "360"),("120436", "1", "0", "469", "1", "17.550000000000", "361"),("120438", "1", "0", "469", "1", "20.070000000000", "362"),("120493", "1", "0", "469", "1", "12.900000000000", "363"),("120498", "1", "0", "469", "1", "13.980000000000", "364"),("120509", "1", "0", "469", "1", "30.770000000000", "365"),("120510", "1", "0", "469", "1", "30.770000000000", "366"),("120519", "1", "0", "469", "1", "30.770000000000", "367"),("120529", "1", "0", "469", "1", "83.000000000000", "368"),("145579", "1", "0", "469", "1", "75.160000000000", "369"),("145581", "1", "0", "469", "1", "75.160000000000", "370"),("145597", "1", "0", "469", "1", "158.000000000000", "371"),("213513", "1", "0", "11", "1", "1154.110000000000", "372"),("9097", "2", "0", "58", "1", "12.500000000000", "373"),("251097", "1", "0", "796", "1", "491.650000000000", "374"),("251098", "1", "0", "796", "1", "491.650000000000", "375"),("251099", "1", "0", "796", "1", "491.650000000000", "376"),("251100", "1", "0", "796", "1", "491.650000000000", "377"),("47589", "2", "0", "42", "1", "70.000000000000", "378"),("47632", "2", "0", "42", "1", "76.000000000000", "379"),("47639", "2", "0", "42", "1", "76.000000000000", "380"),("47640", "2", "0", "42", "1", "76.000000000000", "381"),("47641", "2", "0", "42", "1", "70.000000000000", "382"),("120831", "2", "0", "85", "1", "43.240000000000", "383"),("123017", "2", "0", "469", "1", "5.320000000000", "384"),("123019", "2", "0", "469", "1", "5.320000000000", "385"),("123021", "2", "0", "469", "1", "5.320000000000", "386"),("123023", "2", "0", "469", "1", "4.920000000000", "387"),("123025", "2", "0", "469", "1", "5.320000000000", "388"),("123027", "2", "0", "469", "1", "5.320000000000", "389"),("123029", "2", "0", "469", "1", "5.320000000000", "390"),("123031", "2", "0", "469", "1", "4.510000000000", "391"),("119022", "2", "0", "469", "1", "5.840000000000", "392"),("239214", "1", "0", "751", "1", "88.000000000000", "393"),("88738", "2", "0", "42", "1", "289.000000000000", "394"),("47592", "2", "0", "42", "1", "11.000000000000", "395"),("47629", "2", "0", "42", "1", "9.800000000000", "396"),("237262", "1", "0", "16", "1", "180.060000000000", "397"),("107256", "1", "0", "368", "1", "41.450000000000", "398"),("247102", "1", "0", "285", "1", "10.430000000000", "399")

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 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'