Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '533db586a9876246831e348086'

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 ("165618", "1", "1004", "502", "1", "76.470000000000", "1"),("165484", "2", "1004", "287", "1", "20.170000000000", "2"),("57051", "2", "1005", "67", "1", "79.830000000000", "3"),("119242", "1", "36", "12", "1", "209.930000000000", "4"),("109366", "2", "2", "12", "1", "287.750000000000", "5"),("68105", "2", "1", "12", "1", "243.770000000000", "6"),("81635", "2", "1000", "67", "1", "96.640000000000", "7"),("81636", "2", "1001", "67", "1", "96.640000000000", "8"),("25873", "2", "1000", "75", "1", "399.160000000000", "9"),("177980", "2", "1013", "13", "1", "10.840000000000", "10"),("127439", "2", "1001", "455", "1", "510.470000000000", "11"),("159593", "2", "1000", "49", "1", "54.620000000000", "12"),("185475", "1", "1000", "455", "1", "24.550000000000", "13"),("185481", "1", "1000", "455", "1", "24.550000000000", "14"),("185483", "1", "1000", "455", "1", "24.550000000000", "15"),("127443", "2", "1", "455", "1", "510.470000000000", "16"),("103906", "1", "1036", "455", "1", "4.540000000000", "17"),("185463", "2", "1002", "455", "1", "22.660000000000", "18"),("227704", "1", "1000", "455", "1", "28.330000000000", "19"),("185435", "1", "1000", "455", "1", "22.660000000000", "20"),("185459", "2", "1000", "455", "1", "22.660000000000", "21"),("185461", "2", "1000", "455", "1", "22.660000000000", "22"),("185431", "1", "1000", "455", "1", "22.660000000000", "23"),("177881", "1", "1000", "455", "1", "32.110000000000", "24"),("227705", "1", "1000", "455", "1", "28.330000000000", "25"),("177885", "1", "1000", "455", "1", "32.110000000000", "26"),("177898", "1", "1000", "455", "1", "22.660000000000", "27"),("227708", "1", "1000", "455", "1", "28.330000000000", "28"),("227710", "1", "1000", "455", "1", "28.330000000000", "29"),("103673", "1", "14", "455", "1", "2.490000000000", "30"),("165157", "1", "10", "455", "1", "245.760000000000", "31"),("177879", "1", "5", "455", "1", "32.110000000000", "32"),("82948", "2", "1", "455", "1", "443.660000000000", "33"),("112316", "1", "1", "455", "1", "226.850000000000", "34"),("229976", "2", "1000", "455", "1", "22.660000000000", "35"),("108663", "2", "1000", "75", "1", "335.290000000000", "36"),("112840", "1", "1014", "455", "1", "251.260000000000", "37"),("163289", "1", "1010", "455", "1", "30.220000000000", "38"),("185479", "1", "1005", "455", "1", "24.550000000000", "39"),("184971", "1", "1004", "455", "1", "26.440000000000", "40"),("185415", "1", "1003", "455", "1", "22.660000000000", "41"),("185417", "1", "1003", "455", "1", "22.660000000000", "42"),("112844", "1", "1002", "455", "1", "251.260000000000", "43"),("112836", "1", "1001", "455", "1", "397.040000000000", "44"),("227838", "1", "1000", "455", "1", "15.090000000000", "45"),("227707", "1", "1000", "455", "1", "28.330000000000", "46"),("185443", "1", "1000", "455", "1", "22.660000000000", "47"),("185445", "1", "1000", "455", "1", "22.660000000000", "48"),("185447", "1", "1000", "455", "1", "26.440000000000", "49"),("185449", "1", "1000", "455", "1", "26.440000000000", "50"),("185451", "1", "1000", "455", "1", "26.440000000000", "51"),("185405", "1", "1000", "455", "1", "22.660000000000", "52"),("185409", "1", "1000", "455", "1", "22.660000000000", "53"),("185413", "1", "1000", "455", "1", "22.660000000000", "54"),("185433", "1", "1000", "455", "1", "22.660000000000", "55"),("204051", "1", "1000", "455", "1", "794.080000000000", "56"),("204053", "1", "1000", "455", "1", "831.900000000000", "57"),("227706", "1", "1000", "455", "1", "28.330000000000", "58"),("227709", "1", "1000", "455", "1", "28.330000000000", "59"),("230163", "1", "1000", "455", "1", "340.300000000000", "60"),("241301", "2", "1000", "455", "1", "56.690000000000", "61"),("194499", "1", "1", "455", "1", "245.760000000000", "62"),("227861", "1", "1003", "455", "1", "359.210000000000", "63"),("227862", "1", "1000", "455", "1", "378.120000000000", "64"),("230026", "1", "1000", "455", "1", "831.900000000000", "65"),("185407", "1", "1000", "455", "1", "22.660000000000", "66"),("185411", "1", "1000", "455", "1", "22.660000000000", "67"),("204165", "1", "1000", "455", "1", "945.340000000000", "68"),("227779", "2", "1000", "455", "1", "22.660000000000", "69"),("234483", "2", "1000", "455", "1", "359.210000000000", "70"),("230162", "1", "1000", "455", "1", "340.300000000000", "71"),("234484", "2", "1000", "455", "1", "378.120000000000", "72"),("234485", "2", "1000", "455", "1", "378.120000000000", "73"),("234486", "2", "1000", "455", "1", "397.030000000000", "74"),("227860", "1", "1000", "455", "1", "340.300000000000", "75"),("112842", "1", "5", "455", "1", "252.020000000000", "76"),("238636", "1", "1004", "455", "1", "35.130000000000", "77"),("230028", "1", "1000", "455", "1", "756.270000000000", "78"),("230029", "1", "1000", "455", "1", "831.900000000000", "79"),("227716", "1", "1000", "455", "1", "58.580000000000", "80"),("227718", "1", "1000", "455", "1", "58.580000000000", "81"),("152153", "1", "1000", "455", "1", "340.300000000000", "82"),("152157", "1", "1000", "455", "1", "378.120000000000", "83"),("204159", "1", "1000", "455", "1", "831.900000000000", "84"),("204161", "1", "1000", "455", "1", "869.710000000000", "85"),("204163", "1", "1000", "455", "1", "907.530000000000", "86"),("230027", "1", "1000", "455", "1", "888.620000000000", "87"),("230033", "1", "1000", "455", "1", "359.210000000000", "88"),("227715", "1", "1000", "455", "1", "58.580000000000", "89"),("112841", "1", "2", "455", "1", "250.340000000000", "90"),("187937", "1", "1", "455", "1", "893.720000000000", "91"),("163291", "1", "1008", "455", "1", "30.220000000000", "92"),("228297", "1", "1000", "455", "1", "32.110000000000", "93"),("228298", "1", "1000", "455", "1", "32.110000000000", "94"),("228299", "1", "1000", "455", "1", "32.110000000000", "95"),("228409", "1", "1000", "455", "1", "26.440000000000", "96"),("229534", "1", "1000", "455", "1", "831.900000000000", "97"),("229535", "1", "1000", "455", "1", "794.080000000000", "98"),("229971", "1", "1000", "455", "1", "32.110000000000", "99"),("204157", "1", "1000", "455", "1", "794.080000000000", "100"),("228408", "1", "1000", "455", "1", "26.440000000000", "101"),("238055", "1", "1000", "455", "1", "43.450000000000", "102"),("238057", "1", "1000", "455", "1", "43.450000000000", "103"),("230035", "1", "1000", "455", "1", "415.930000000000", "104"),("186763", "1", "1000", "455", "1", "283.580000000000", "105"),("233884", "2", "1000", "455", "1", "34.000000000000", "106"),("238106", "1", "1000", "455", "1", "34.000000000000", "107"),("99331", "1", "1", "455", "1", "187.390000000000", "108"),("178161", "1", "1", "75", "1", "294.120000000000", "109"),("228484", "1", "1000", "455", "1", "30.220000000000", "110"),("228485", "1", "1000", "455", "1", "30.220000000000", "111"),("228486", "1", "1000", "455", "1", "30.220000000000", "112"),("228405", "1", "1000", "455", "1", "30.220000000000", "113"),("238047", "1", "1000", "455", "1", "58.580000000000", "114"),("238048", "1", "1000", "455", "1", "58.580000000000", "115"),("238056", "1", "1000", "455", "1", "43.450000000000", "116"),("238058", "1", "1000", "455", "1", "43.450000000000", "117"),("238051", "1", "1000", "455", "1", "51.020000000000", "118"),("238053", "1", "1000", "455", "1", "51.020000000000", "119"),("238353", "1", "1000", "455", "1", "1115.510000000000", "120"),("230036", "1", "1000", "455", "1", "434.840000000000", "121"),("233883", "2", "1000", "455", "1", "34.000000000000", "122"),("238046", "1", "1000", "455", "1", "58.580000000000", "123"),("238049", "1", "1000", "455", "1", "58.580000000000", "124"),("238052", "1", "1000", "455", "1", "51.020000000000", "125"),("238054", "1", "1000", "455", "1", "51.020000000000", "126"),("153837", "1", "3", "455", "1", "181.480000000000", "127"),("153833", "1", "1", "455", "1", "102.080000000000", "128"),("153835", "1", "1", "455", "1", "158.790000000000", "129"),("238637", "1", "1005", "455", "1", "39.660000000000", "130"),("37800", "2", "1000", "49", "1", "40.340000000000", "131"),("163550", "1", "1003", "455", "1", "34.000000000000", "132"),("163546", "1", "1000", "455", "1", "34.000000000000", "133"),("234597", "1", "1000", "455", "1", "24.550000000000", "134"),("234600", "1", "1000", "455", "1", "24.550000000000", "135"),("163549", "1", "1000", "455", "1", "34.000000000000", "136"),("147543", "1", "1002", "455", "1", "167.140000000000", "137"),("120009", "2", "1001", "11", "1", "19.260000000000", "138"),("64321", "2", "3", "358", "1", "35.210000000000", "139"),("64322", "2", "2", "358", "1", "38.890000000000", "140"),("184705", "2", "1003", "168", "1", "264.670000000000", "141"),("233839", "2", "1011", "360", "1", "15.880000000000", "142"),("151181", "2", "1003", "121", "1", "543.700000000000", "143"),("173646", "1", "1000", "191", "1", "301.680000000000", "144"),("173648", "1", "1000", "191", "1", "336.970000000000", "145"),("192911", "2", "1000", "121", "1", "435.290000000000", "146"),("173650", "1", "1000", "191", "1", "425.210000000000", "147"),("70784", "2", "1002", "24", "1", "470.590000000000", "148"),("176974", "2", "1002", "42", "1", "28.570000000000", "149"),("113854", "2", "1000", "24", "1", "401.680000000000", "150"),("176972", "2", "1000", "42", "1", "23.530000000000", "151"),("191193", "10", "1000", "13", "1", "317.560000000000", "152"),("176975", "2", "1000", "42", "1", "32.770000000000", "153"),("12626", "10", "1000", "13", "1", "355.380000000000", "154"),("173859", "-100", "4", "570", "1", "54.580000000000", "155"),("104000", "1", "1074", "455", "1", "18.120000000000", "156"),("213145", "1", "1000", "749", "1", "47.600000000000", "157"),("173635", "2", "1004", "191", "1", "284.030000000000", "158"),("173640", "2", "1001", "191", "1", "301.680000000000", "159"),("173642", "2", "1001", "191", "1", "301.680000000000", "160"),("113486", "2", "1000", "19", "1", "27.690000000000", "161"),("113487", "2", "1000", "19", "1", "27.690000000000", "162"),("219924", "1", "1000", "749", "1", "600.840000000000", "163"),("173623", "2", "1000", "191", "1", "284.030000000000", "164"),("173628", "2", "1000", "191", "1", "425.210000000000", "165"),("173629", "2", "1000", "191", "1", "461.340000000000", "166"),("173638", "2", "1000", "191", "1", "301.680000000000", "167"),("173643", "2", "1000", "191", "1", "322.690000000000", "168"),("173617", "2", "1000", "191", "1", "301.680000000000", "169"),("173632", "2", "1000", "191", "1", "284.030000000000", "170"),("173634", "2", "1000", "191", "1", "266.390000000000", "171"),("199889", "10", "1000", "13", "1", "399.080000000000", "172"),("173637", "2", "1000", "191", "1", "284.030000000000", "173"),("55136", "2", "1000", "27", "1", "510.920000000000", "174"),("173619", "2", "1000", "191", "1", "336.970000000000", "175"),("63662", "2", "12", "47", "1", "616.810000000000", "176"),("173641", "2", "1", "191", "1", "301.680000000000", "177"),("35523", "2", "1008", "287", "1", "32.770000000000", "178"),("237047", "1", "1000", "629", "1", "58.820000000000", "179"),("153991", "2", "1000", "204", "1", "940.340000000000", "180"),("122795", "1", "16", "358", "1", "31.930000000000", "181"),("188189", "2", "1", "121", "1", "907.530000000000", "182"),("237050", "1", "1000", "629", "1", "58.820000000000", "183"),("35064", "2", "24", "102", "1", "24.665600000000", "184"),("122789", "1", "11", "358", "1", "31.930000000000", "185"),("122783", "1", "10", "358", "1", "31.930000000000", "186"),("122785", "1", "7", "358", "1", "28.270000000000", "187"),("122791", "1", "4", "358", "1", "31.930000000000", "188"),("122787", "1", "3", "358", "1", "23.950000000000", "189"),("122781", "1", "3", "358", "1", "28.270000000000", "190"),("147547", "1", "1001", "17", "1", "207.480000000000", "191"),("147551", "1", "1001", "17", "1", "248.820000000000", "192"),("171641", "1", "1000", "648", "1", "39.920000000000", "193"),("171643", "1", "1000", "648", "1", "46.220000000000", "194"),("171243", "1", "1000", "648", "1", "46.220000000000", "195"),("171244", "1", "1000", "648", "1", "48.320000000000", "196"),("219020", "1", "1000", "749", "1", "752.100000000000", "197"),("153735", "1", "44", "358", "1", "28.270000000000", "198"),("35063", "2", "17", "102", "1", "24.665600000000", "199"),("35067", "2", "8", "102", "1", "24.665600000000", "200"),("122777", "1", "7", "358", "1", "28.270000000000", "201"),("122793", "1", "7", "358", "1", "28.550000000000", "202"),("122797", "1", "7", "358", "1", "32.770000000000", "203"),("122763", "1", "6", "358", "1", "28.270000000000", "204"),("122775", "1", "3", "358", "1", "28.270000000000", "205"),("147555", "1", "1001", "17", "1", "251.260000000000", "206"),("147557", "1", "1001", "17", "1", "199.160000000000", "207"),("219019", "1", "1000", "749", "1", "373.950000000000", "208"),("241814", "2", "1000", "119", "1", "145.190000000000", "209"),("241815", "2", "1000", "119", "1", "145.190000000000", "210"),("35066", "2", "24", "102", "1", "24.665600000000", "211"),("35065", "2", "20", "102", "1", "24.665600000000", "212"),("50710", "2", "1001", "42", "1", "20.170000000000", "213"),("168701", "2", "1001", "654", "1", "0.840000000000", "214"),("127521", "1", "1", "168", "1", "283.580000000000", "215"),("181689", "2", "1002", "500", "1", "32.190000000000", "216"),("122769", "1", "7", "358", "1", "28.270000000000", "217"),("122771", "1", "4", "358", "1", "28.270000000000", "218"),("122765", "1", "3", "358", "1", "28.270000000000", "219"),("96821", "2", "1000", "528", "1", "151.260000000000", "220"),("110887", "2", "1000", "192", "1", "352.940000000000", "221"),("155111", "2", "1001", "49", "1", "126.050000000000", "222"),("54098", "2", "1000", "382", "1", "35.290000000000", "223"),("184957", "2", "1000", "168", "1", "22.660000000000", "224"),("131821", "1", "5", "593", "1", "17.560000000000", "225"),("131619", "1", "5", "593", "1", "26.440000000000", "226"),("131819", "1", "4", "593", "1", "17.560000000000", "227"),("131613", "1", "4", "593", "1", "26.440000000000", "228"),("131617", "1", "2", "593", "1", "26.440000000000", "229"),("129695", "1", "1000", "109", "1", "138.660000000000", "230"),("108770", "2", "1000", "50", "1", "37.820000000000", "231"),("108772", "2", "1000", "50", "1", "37.820000000000", "232"),("185733", "2", "1000", "168", "1", "13.200000000000", "233"),("185735", "2", "1000", "168", "1", "13.200000000000", "234"),("131615", "1", "4", "593", "1", "17.560000000000", "235"),("108771", "2", "1000", "50", "1", "37.820000000000", "236"),("108773", "2", "1000", "50", "1", "37.820000000000", "237"),("150593", "1", "1000", "58", "1", "17.650000000000", "238"),("185719", "2", "1000", "168", "1", "16.980000000000", "239"),("185725", "2", "1000", "168", "1", "16.980000000000", "240"),("66830", "2", "3", "168", "1", "12.600000000000", "241"),("120978", "1", "1004", "96", "1", "16.810000000000", "242"),("97536", "2", "1001", "309", "1", "25.210000000000", "243"),("222356", "1", "1000", "370", "1", "41.700000000000", "244"),("185723", "2", "1000", "168", "1", "16.980000000000", "245"),("185699", "2", "1000", "168", "1", "18.870000000000", "246"),("185717", "2", "1000", "168", "1", "18.870000000000", "247"),("185715", "2", "1000", "168", "1", "18.870000000000", "248"),("245131", "1", "1010", "13", "1", "96.550000000000", "249"),("245139", "1", "1009", "13", "1", "88.150000000000", "250"),("165620", "1", "0", "502", "1", "78.710000000000", "251"),("177512", "1", "0", "12", "1", "224.830000000000", "252"),("127441", "2", "0", "455", "1", "374.970000000000", "253"),("112292", "2", "0", "455", "1", "233.300000000000", "254"),("177888", "1", "0", "455", "1", "14.980000000000", "255"),("103650", "1", "0", "455", "1", "11.180000000000", "256"),("103896", "1", "0", "455", "1", "12.480000000000", "257"),("177895", "1", "0", "455", "1", "14.980000000000", "258"),("163519", "2", "0", "455", "1", "158.810000000000", "259"),("99296", "1", "0", "455", "1", "4.230000000000", "260"),("103646", "1", "0", "455", "1", "11.120000000000", "261"),("103897", "1", "0", "455", "1", "6.220100000000", "262"),("194497", "1", "0", "455", "1", "166.630000000000", "263"),("227772", "2", "0", "455", "1", "14.980000000000", "264"),("227773", "2", "0", "455", "1", "13.730000000000", "265"),("227774", "2", "0", "455", "1", "13.730000000000", "266"),("227775", "2", "0", "455", "1", "14.980000000000", "267"),("227776", "2", "0", "455", "1", "13.730000000000", "268"),("227777", "2", "0", "455", "1", "13.730000000000", "269"),("227839", "1", "0", "455", "1", "9.980000000000", "270"),("228605", "1", "0", "455", "1", "277.290000000000", "271"),("228607", "1", "0", "455", "1", "277.290000000000", "272"),("228608", "1", "0", "455", "1", "302.500000000000", "273"),("83111", "2", "0", "455", "1", "217.530000000000", "274"),("99299", "1", "0", "455", "1", "4.980000000000", "275"),("227778", "2", "0", "455", "1", "14.980000000000", "276"),("227780", "2", "0", "455", "1", "13.730000000000", "277"),("227781", "2", "0", "455", "1", "13.730000000000", "278"),("227782", "2", "0", "455", "1", "13.730000000000", "279"),("227783", "2", "0", "455", "1", "14.980000000000", "280"),("227784", "2", "0", "455", "1", "13.730000000000", "281"),("112845", "1", "0", "455", "1", "204.180000000000", "282"),("228606", "1", "0", "455", "1", "277.290000000000", "283"),("185339", "1", "0", "455", "1", "30.220000000000", "284"),("230034", "1", "0", "455", "1", "305.530000000000", "285"),("185665", "1", "0", "455", "1", "19.980000000000", "286"),("127611", "1", "0", "455", "1", "272.250000000000", "287"),("228407", "1", "0", "455", "1", "19.980000000000", "288"),("228406", "1", "0", "455", "1", "19.980000000000", "289"),("83047", "2", "0", "455", "1", "258.040000000000", "290"),("234589", "1", "0", "455", "1", "11.230000000000", "291"),("234590", "1", "0", "455", "1", "11.980000000000", "292"),("234591", "1", "0", "455", "1", "11.230000000000", "293"),("234593", "1", "0", "455", "1", "11.980000000000", "294"),("234595", "1", "0", "455", "1", "11.980000000000", "295"),("229967", "1", "0", "455", "1", "14.980000000000", "296"),("234592", "1", "0", "455", "1", "12.480000000000", "297"),("234594", "1", "0", "455", "1", "12.480000000000", "298"),("234596", "1", "0", "455", "1", "12.480000000000", "299"),("83154", "2", "0", "455", "1", "277.750000000000", "300"),("234599", "1", "0", "455", "1", "16.230000000000", "301"),("234598", "1", "0", "455", "1", "16.230000000000", "302"),("163293", "1", "0", "455", "1", "35.130000000000", "303"),("65423", "2", "0", "121", "1", "58.820000000000", "304"),("166857", "2", "0", "455", "1", "145.430000000000", "305"),("173651", "1", "0", "191", "1", "353.570000000000", "306"),("173647", "1", "0", "191", "1", "244.760000000000", "307"),("227822", "1", "0", "455", "1", "416.640000000000", "308"),("227823", "1", "0", "455", "1", "416.640000000000", "309"),("227824", "1", "0", "455", "1", "416.640000000000", "310"),("227825", "1", "0", "455", "1", "416.640000000000", "311"),("227826", "1", "0", "455", "1", "416.640000000000", "312"),("227827", "1", "0", "455", "1", "416.640000000000", "313"),("227828", "1", "0", "455", "1", "416.640000000000", "314"),("220463", "1", "0", "749", "1", "147.060000000000", "315"),("239192", "2", "0", "59", "1", "65.840000000000", "316"),("239194", "2", "0", "59", "1", "65.840000000000", "317"),("55135", "2", "0", "27", "1", "410.000000000000", "318"),("128711", "1", "0", "150", "1", "82.020000000000", "319"),("173625", "2", "0", "191", "1", "299.170000000000", "320"),("173626", "2", "0", "191", "1", "326.390000000000", "321"),("173627", "2", "0", "191", "1", "326.390000000000", "322"),("173630", "2", "0", "191", "1", "353.570000000000", "323"),("225353", "2", "0", "437", "1", "59.290000000000", "324"),("173633", "2", "0", "191", "1", "203.970000000000", "325"),("173621", "2", "0", "191", "1", "299.170000000000", "326"),("173624", "2", "0", "191", "1", "299.170000000000", "327"),("173618", "2", "0", "191", "1", "244.760000000000", "328"),("173622", "2", "0", "191", "1", "217.580000000000", "329"),("173620", "2", "0", "191", "1", "299.170000000000", "330"),("173639", "2", "0", "191", "1", "217.580000000000", "331"),("237054", "1", "0", "629", "1", "58.820000000000", "332"),("107170", "1", "0", "168", "1", "333.300000000000", "333"),("48566", "2", "0", "17", "1", "259.660000000000", "334"),("107370", "2", "0", "192", "1", "607.000000000000", "335"),("219030", "1", "0", "749", "1", "373.950000000000", "336"),("219031", "1", "0", "749", "1", "752.100000000000", "337"),("219922", "1", "0", "749", "1", "358.820000000000", "338"),("219033", "1", "0", "749", "1", "752.100000000000", "339"),("171642", "1", "0", "648", "1", "25.000000000000", "340"),("147541", "1", "0", "17", "1", "218.570000000000", "341"),("220467", "1", "0", "749", "1", "336.130000000000", "342"),("147553", "1", "0", "17", "1", "318.490000000000", "343"),("127519", "1", "0", "168", "1", "208.310000000000", "344"),("127523", "1", "0", "168", "1", "186.607000000000", "345"),("225123", "2", "0", "322", "1", "16.470000000000", "346"),("184939", "2", "0", "168", "1", "13.730000000000", "347"),("184941", "2", "0", "168", "1", "14.980000000000", "348"),("184943", "2", "0", "168", "1", "14.980000000000", "349"),("184947", "2", "0", "168", "1", "13.730000000000", "350"),("184951", "2", "0", "168", "1", "13.730000000000", "351"),("45007", "2", "0", "168", "1", "12.480000000000", "352"),("66827", "2", "0", "168", "1", "14.980000000000", "353"),("185727", "2", "0", "168", "1", "8.730000000000", "354"),("66832", "2", "0", "168", "1", "14.980000000000", "355"),("66831", "2", "0", "168", "1", "13.290000000000", "356"),("66829", "2", "0", "168", "1", "12.570000000000", "357"),("132517", "1", "0", "58", "1", "960.000000000000", "358"),("219105", "1", "0", "26", "1", "102.400000000000", "359")

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'