Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '35d40816fcfe79b9c81bb4fe32'

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 ("53996", "2", "1000", "382", "1", "5.700000000000", "1"),("54012", "2", "1000", "382", "1", "5.700000000000", "2"),("144099", "1", "1000", "150", "1", "59.450000000000", "3"),("144103", "1", "1001", "150", "1", "59.450000000000", "4"),("118914", "2", "1000", "554", "1", "107.080000000000", "5"),("144095", "1", "1000", "150", "1", "59.450000000000", "6"),("144109", "1", "1000", "150", "1", "59.450000000000", "7"),("177632", "2", "1000", "11", "1", "61.740000000000", "8"),("177634", "2", "1000", "11", "1", "61.740000000000", "9"),("72826", "2", "1000", "464", "1", "23.430000000000", "10"),("101694", "1", "1000", "115", "1", "63.770000000000", "11"),("163897", "2", "1000", "483", "1", "28.470000000000", "12"),("163926", "2", "1000", "483", "1", "28.470000000000", "13"),("107896", "2", "1000", "192", "1", "1245.280000000000", "14"),("231578", "1", "1000", "658", "1", "45.340000000000", "15"),("231579", "1", "1000", "658", "1", "45.340000000000", "16"),("231580", "1", "1000", "658", "1", "45.340000000000", "17"),("231581", "1", "1000", "658", "1", "45.340000000000", "18"),("231582", "1", "1000", "658", "1", "45.340000000000", "19"),("94765", "2", "1002", "516", "1", "26.710000000000", "20"),("101692", "1", "1000", "115", "1", "66.290000000000", "21"),("101693", "1", "1000", "115", "1", "63.770000000000", "22"),("229894", "1", "1000", "677", "1", "984.780000000000", "23"),("229899", "1", "1000", "677", "1", "984.780000000000", "24"),("94755", "2", "3", "516", "1", "14.330000000000", "25"),("94649", "2", "2", "516", "1", "19.230000000000", "26"),("101696", "1", "2", "115", "1", "63.010000000000", "27"),("94751", "2", "1006", "516", "1", "25.950000000000", "28"),("181033", "1", "1000", "475", "1", "841.080000000000", "29"),("94753", "2", "4", "516", "1", "14.330000000000", "30"),("105292", "1", "1001", "58", "1", "42.760000000000", "31"),("231620", "1", "1000", "658", "1", "39.530000000000", "32"),("231621", "1", "1000", "658", "1", "39.530000000000", "33"),("231622", "1", "1000", "658", "1", "39.530000000000", "34"),("231623", "1", "1000", "658", "1", "39.530000000000", "35"),("154013", "2", "1000", "553", "1", "2295.700000000000", "36"),("149715", "2", "1000", "20", "1", "56.330000000000", "37"),("41410", "2", "1002", "56", "1", "11.920000000000", "38"),("119628", "2", "1000", "105", "1", "21.750000000000", "39"),("119629", "2", "1000", "105", "1", "21.750000000000", "40"),("119630", "2", "1000", "105", "1", "21.750000000000", "41"),("119631", "2", "1000", "105", "1", "21.750000000000", "42"),("126999", "1", "1000", "585", "1", "1635.280000000000", "43"),("94574", "10", "1000", "271", "1", "34.830000000000", "44"),("41416", "2", "1003", "56", "1", "11.920000000000", "45"),("41405", "2", "1003", "56", "1", "11.920000000000", "46"),("149703", "2", "1001", "20", "1", "40.840000000000", "47"),("94580", "10", "1000", "271", "1", "18.900000000000", "48"),("91090", "2", "1003", "42", "1", "6.710000000000", "49"),("93607", "2", "1002", "163", "1", "28.860000000000", "50"),("94572", "10", "1001", "271", "1", "100.730000000000", "51"),("172444", "2", "1000", "123", "1", "27.490000000000", "52"),("172447", "2", "1000", "123", "1", "27.490000000000", "53"),("202501", "1", "1000", "224", "1", "39.400000000000", "54"),("218229", "1", "1000", "224", "1", "34.130000000000", "55"),("229510", "10", "1000", "20", "1", "70.390000000000", "56"),("121359", "2", "1000", "85", "1", "30.120000000000", "57"),("238985", "1", "1005", "782", "1", "16.710000000000", "58"),("88187", "2", "1004", "368", "1", "18.560000000000", "59"),("108919", "2", "1001", "279", "1", "16.880000000000", "60"),("121363", "2", "1001", "85", "1", "32.830000000000", "61"),("172448", "2", "1000", "123", "1", "27.490000000000", "62"),("172450", "2", "1000", "123", "1", "27.490000000000", "63"),("154011", "1", "1000", "206", "1", "18.390000000000", "64"),("108918", "2", "1000", "279", "1", "16.880000000000", "65"),("224866", "2", "1000", "729", "1", "42.000000000000", "66"),("179319", "2", "1000", "185", "1", "58.270000000000", "67"),("206313", "2", "1000", "160", "1", "24.140000000000", "68"),("206317", "2", "1000", "160", "1", "24.140000000000", "69"),("238515", "1", "1000", "492", "1", "429.400000000000", "70"),("21730", "2", "1000", "94", "1", "29.170000000000", "71"),("21731", "2", "1000", "94", "1", "29.170000000000", "72"),("121361", "2", "1000", "85", "1", "32.830000000000", "73"),("229499", "1", "1000", "20", "1", "49.450000000000", "74"),("169297", "1", "4", "54", "1", "41.920000000000", "75"),("89238", "2", "1", "459", "1", "49.980000000000", "76"),("124711", "1", "1", "309", "1", "18.330000000000", "77"),("123473", "2", "1003", "362", "1", "15.530000000000", "78"),("188185", "2", "1002", "121", "1", "38.550000000000", "79"),("217915", "1", "1002", "476", "1", "39.170000000000", "80"),("238983", "1", "1002", "782", "1", "16.710000000000", "81"),("109796", "2", "1002", "94", "1", "29.170000000000", "82"),("21726", "2", "1001", "94", "1", "29.170000000000", "83"),("108922", "2", "1000", "279", "1", "16.880000000000", "84"),("224860", "2", "1000", "729", "1", "42.000000000000", "85"),("224861", "2", "1000", "729", "1", "42.000000000000", "86"),("224862", "2", "1000", "729", "1", "42.000000000000", "87"),("224863", "2", "1000", "729", "1", "42.000000000000", "88"),("224864", "2", "1000", "729", "1", "42.000000000000", "89"),("224865", "2", "1000", "729", "1", "42.000000000000", "90"),("224880", "2", "1000", "729", "1", "42.000000000000", "91"),("226841", "1", "1000", "459", "1", "89.820000000000", "92"),("179318", "2", "1000", "185", "1", "58.270000000000", "93"),("219571", "1", "1000", "401", "1", "157.040000000000", "94"),("21729", "2", "1000", "94", "1", "29.170000000000", "95"),("21727", "2", "1000", "94", "1", "29.170000000000", "96"),("226834", "1", "1000", "459", "1", "89.820000000000", "97"),("226839", "1", "1000", "459", "1", "89.820000000000", "98"),("169296", "1", "2", "54", "1", "41.920000000000", "99"),("179317", "2", "2", "185", "1", "58.270000000000", "100"),("157833", "2", "1", "631", "1", "117.550000000000", "101"),("108917", "2", "1", "279", "1", "18.310000000000", "102"),("238984", "1", "1004", "782", "1", "16.710000000000", "103"),("238001", "1", "1001", "54", "1", "54.610000000000", "104"),("168468", "2", "1000", "115", "1", "782.260000000000", "105"),("168469", "2", "1000", "115", "1", "799.060000000000", "106"),("177194", "2", "1000", "117", "1", "51.170000000000", "107"),("177195", "2", "1000", "117", "1", "51.170000000000", "108"),("177196", "2", "1000", "117", "1", "51.170000000000", "109"),("177197", "2", "1000", "117", "1", "51.170000000000", "110"),("177204", "2", "1000", "117", "1", "53.690000000000", "111"),("177205", "2", "1000", "117", "1", "53.690000000000", "112"),("177206", "2", "1000", "117", "1", "53.690000000000", "113"),("177207", "2", "1000", "117", "1", "56.210000000000", "114"),("177208", "2", "1000", "117", "1", "56.210000000000", "115"),("106641", "2", "1000", "49", "1", "367.970000000000", "116"),("108920", "2", "1000", "279", "1", "16.880000000000", "117"),("223858", "2", "1000", "459", "1", "71.330000000000", "118"),("223912", "2", "1000", "459", "1", "71.330000000000", "119"),("223918", "2", "1000", "459", "1", "71.330000000000", "120"),("223919", "2", "1000", "459", "1", "71.330000000000", "121"),("223920", "2", "1000", "459", "1", "71.330000000000", "122"),("223921", "2", "1000", "459", "1", "71.330000000000", "123"),("223922", "2", "1000", "459", "1", "71.330000000000", "124"),("223923", "2", "1000", "459", "1", "71.330000000000", "125"),("223924", "2", "1000", "459", "1", "71.330000000000", "126"),("223927", "2", "1000", "459", "1", "71.330000000000", "127"),("223928", "2", "1000", "459", "1", "71.330000000000", "128"),("223936", "2", "1000", "459", "1", "71.330000000000", "129"),("223938", "2", "1000", "459", "1", "71.330000000000", "130"),("226843", "1", "1000", "459", "1", "89.820000000000", "131"),("248142", "2", "1000", "811", "1", "43.330000000000", "132"),("248144", "2", "1000", "811", "1", "43.330000000000", "133"),("248146", "2", "1000", "811", "1", "43.330000000000", "134"),("109795", "2", "1000", "94", "1", "29.170000000000", "135"),("206387", "1", "1000", "124", "1", "434.950000000000", "136"),("223915", "2", "1000", "459", "1", "71.330000000000", "137"),("223917", "2", "1000", "459", "1", "71.330000000000", "138"),("223931", "2", "1000", "459", "1", "71.330000000000", "139"),("223933", "2", "1000", "459", "1", "71.330000000000", "140"),("223929", "2", "1000", "459", "1", "71.330000000000", "141"),("160985", "1", "22", "124", "1", "419.780000000000", "142"),("238646", "1", "6", "59", "1", "101.660000000000", "143"),("166317", "1", "2", "85", "1", "29.400000000000", "144"),("175332", "1", "1", "124", "1", "114.730000000000", "145"),("238986", "1", "1005", "782", "1", "16.710000000000", "146"),("172744", "2", "1004", "105", "1", "11.670000000000", "147"),("172756", "2", "1002", "105", "1", "12.420000000000", "148"),("172738", "2", "1001", "105", "1", "12.420000000000", "149"),("165750", "1", "1000", "324", "1", "11.170000000000", "150"),("172735", "2", "1000", "105", "1", "12.420000000000", "151"),("172741", "2", "1000", "105", "1", "12.420000000000", "152"),("172747", "2", "1000", "105", "1", "12.420000000000", "153"),("172750", "2", "1000", "105", "1", "12.420000000000", "154"),("172753", "2", "1000", "105", "1", "12.420000000000", "155"),("172759", "2", "1000", "105", "1", "12.420000000000", "156"),("172762", "2", "1000", "105", "1", "12.420000000000", "157"),("172765", "2", "1000", "105", "1", "12.420000000000", "158"),("172768", "2", "1000", "105", "1", "12.420000000000", "159"),("175927", "1", "1000", "117", "1", "51.170000000000", "160"),("175931", "1", "1000", "117", "1", "51.170000000000", "161"),("175933", "1", "1000", "117", "1", "51.170000000000", "162"),("175935", "1", "1000", "117", "1", "51.170000000000", "163"),("175936", "1", "1000", "117", "1", "51.170000000000", "164"),("175937", "1", "1000", "117", "1", "51.170000000000", "165"),("175938", "1", "1000", "117", "1", "51.170000000000", "166"),("175940", "1", "1000", "117", "1", "51.170000000000", "167"),("175941", "1", "1000", "117", "1", "51.170000000000", "168"),("175945", "1", "1000", "117", "1", "51.170000000000", "169"),("175946", "1", "1000", "117", "1", "51.170000000000", "170"),("175947", "1", "1000", "117", "1", "51.170000000000", "171"),("115845", "1", "1000", "285", "1", "23.330000000000", "172"),("118336", "2", "1000", "105", "1", "20.910000000000", "173"),("223913", "2", "1000", "459", "1", "71.330000000000", "174"),("223930", "2", "1000", "459", "1", "71.330000000000", "175"),("223934", "2", "1000", "459", "1", "71.330000000000", "176"),("223935", "2", "1000", "459", "1", "71.330000000000", "177"),("229468", "1", "1000", "362", "1", "28.140000000000", "178"),("231408", "1", "1000", "124", "1", "199.980000000000", "179"),("109150", "2", "1000", "47", "1", "10.610000000000", "180"),("176087", "2", "1000", "94", "1", "31.260000000000", "181"),("176088", "2", "1000", "94", "1", "31.260000000000", "182"),("176089", "2", "1000", "94", "1", "31.260000000000", "183"),("176090", "2", "1000", "94", "1", "31.260000000000", "184"),("176091", "2", "1000", "94", "1", "31.260000000000", "185"),("84504", "2", "1000", "163", "1", "29.510000000000", "186"),("119367", "2", "1000", "105", "1", "36.120000000000", "187"),("173464", "1", "1000", "55", "1", "140.320000000000", "188"),("115842", "1", "1000", "285", "1", "23.330000000000", "189"),("221949", "1", "1000", "459", "1", "57.040000000000", "190"),("221950", "1", "1000", "459", "1", "57.040000000000", "191"),("221951", "1", "1000", "459", "1", "57.040000000000", "192"),("223914", "2", "1000", "459", "1", "71.330000000000", "193"),("226477", "1", "1000", "459", "1", "62.090000000000", "194"),("226478", "1", "1000", "459", "1", "62.090000000000", "195"),("226479", "1", "1000", "459", "1", "62.090000000000", "196"),("226480", "1", "1000", "459", "1", "62.090000000000", "197"),("226481", "1", "1000", "459", "1", "62.090000000000", "198"),("226482", "1", "1000", "459", "1", "62.090000000000", "199"),("226823", "2", "1000", "459", "1", "67.970000000000", "200"),("226824", "2", "1000", "459", "1", "67.970000000000", "201"),("226825", "2", "1000", "459", "1", "67.970000000000", "202"),("226826", "2", "1000", "459", "1", "67.970000000000", "203"),("226827", "2", "1000", "459", "1", "67.970000000000", "204"),("226828", "2", "1000", "459", "1", "67.970000000000", "205"),("229527", "1", "1000", "540", "1", "30.320000000000", "206"),("205803", "2", "1000", "476", "1", "135.240000000000", "207"),("231406", "1", "1000", "124", "1", "196.630000000000", "208"),("236629", "1", "1000", "85", "1", "29.400000000000", "209"),("166313", "1", "1000", "85", "1", "19.690000000000", "210"),("235038", "1", "1000", "11", "1", "43.830000000000", "211"),("175969", "2", "1000", "94", "1", "31.260000000000", "212"),("166315", "1", "1000", "85", "1", "19.690000000000", "213"),("131835", "2", "4", "593", "1", "20.910000000000", "214"),("116704", "2", "1001", "459", "1", "67.970000000000", "215"),("117852", "2", "1001", "58", "1", "24.270000000000", "216"),("158299", "2", "1000", "27", "1", "248.640000000000", "217"),("173189", "1", "1000", "55", "1", "943.690000000000", "218"),("173190", "1", "1000", "55", "1", "979.820000000000", "219"),("173193", "1", "1000", "55", "1", "943.690000000000", "220"),("126675", "1", "1000", "128", "1", "152.840000000000", "221"),("126679", "1", "1000", "128", "1", "168.810000000000", "222"),("126685", "1", "1000", "128", "1", "152.840000000000", "223"),("126705", "1", "1000", "128", "1", "152.840000000000", "224"),("134783", "2", "1000", "193", "1", "25.200000000000", "225"),("134785", "2", "1000", "193", "1", "25.200000000000", "226"),("134789", "2", "1000", "193", "1", "25.200000000000", "227"),("134791", "2", "1000", "193", "1", "25.200000000000", "228"),("134797", "2", "1000", "193", "1", "25.200000000000", "229"),("221952", "1", "1000", "459", "1", "57.040000000000", "230"),("221953", "1", "1000", "459", "1", "57.040000000000", "231"),("234642", "1", "1000", "224", "1", "356.210000000000", "232"),("237055", "2", "1000", "559", "1", "34.360000000000", "233"),("118846", "2", "1000", "85", "1", "238.660000000000", "234"),("235039", "1", "1000", "11", "1", "43.830000000000", "235"),("235040", "1", "1000", "11", "1", "43.830000000000", "236"),("173188", "1", "1000", "55", "1", "979.820000000000", "237"),("164550", "2", "2", "593", "1", "20.910000000000", "238"),("164829", "2", "2", "593", "1", "20.910000000000", "239"),("134793", "2", "1", "193", "1", "25.200000000000", "240"),("225495", "1", "1", "59", "1", "126.880000000000", "241"),("18505", "2", "1000", "105", "1", "39.400000000000", "242"),("126697", "1", "1000", "128", "1", "168.810000000000", "243"),("117850", "2", "1000", "105", "1", "25.950000000000", "244"),("221954", "1", "1000", "459", "1", "57.040000000000", "245"),("246547", "2", "1000", "559", "1", "27.640000000000", "246"),("236586", "1", "1000", "85", "1", "64.690000000000", "247"),("93011", "10", "1000", "222", "1", "390.330000000000", "248"),("235037", "1", "1000", "11", "1", "43.830000000000", "249"),("63655", "-100", "18", "26", "1", "14.790000000000", "250"),("105313", "1", "1003", "58", "1", "48.730000000000", "251"),("210745", "10", "1002", "751", "1", "150.630000000000", "252"),("105293", "1", "1001", "58", "1", "42.760000000000", "253"),("105320", "1", "1001", "58", "1", "84.780000000000", "254"),("105716", "1", "1001", "58", "1", "25.120000000000", "255"),("105314", "1", "1000", "58", "1", "53.690000000000", "256"),("105856", "1", "1000", "58", "1", "25.950000000000", "257"),("126677", "1", "1000", "128", "1", "152.840000000000", "258"),("126681", "1", "1000", "128", "1", "152.840000000000", "259"),("126687", "1", "1000", "128", "1", "168.810000000000", "260"),("183215", "1", "1000", "701", "1", "36.880000000000", "261"),("242660", "2", "1000", "475", "1", "1001.590000000000", "262"),("105319", "1", "1000", "58", "1", "81.410000000000", "263"),("105316", "1", "1000", "58", "1", "67.970000000000", "264"),("105728", "1", "1000", "58", "1", "89.820000000000", "265"),("210747", "10", "1", "751", "1", "150.630000000000", "266"),("113179", "2", "1001", "27", "1", "16.710000000000", "267"),("166697", "1", "1000", "285", "1", "98.360000000000", "268"),("183217", "1", "1000", "701", "1", "36.880000000000", "269"),("238353", "1", "1000", "455", "1", "1117.100000000000", "270"),("183221", "1", "1000", "701", "1", "36.880000000000", "271"),("183219", "1", "1000", "701", "1", "36.880000000000", "272"),("191751", "1", "1003", "122", "1", "44.520000000000", "273"),("244189", "1", "1000", "122", "1", "44.520000000000", "274"),("244192", "1", "1000", "122", "1", "44.520000000000", "275"),("244194", "1", "1000", "122", "1", "44.520000000000", "276"),("244216", "1", "1000", "122", "1", "44.520000000000", "277"),("244219", "1", "1000", "122", "1", "44.520000000000", "278"),("243291", "1", "1000", "122", "1", "44.520000000000", "279"),("244700", "1", "1000", "122", "1", "44.520000000000", "280"),("81563", "2", "0", "287", "1", "22.810000000000", "281"),("177633", "2", "0", "11", "1", "45.120000000000", "282"),("177635", "2", "0", "11", "1", "45.120000000000", "283"),("179855", "1", "0", "664", "1", "344.000000000000", "284"),("94650", "2", "0", "516", "1", "17.950000000000", "285"),("94762", "2", "0", "516", "1", "13.500000000000", "286"),("181047", "1", "0", "475", "1", "500.000000000000", "287"),("9334", "2", "0", "151", "1", "588.980000000000", "288"),("12914", "2", "0", "49", "1", "9.000000000000", "289"),("13946", "2", "0", "115", "1", "10.000000000000", "290"),("172443", "2", "0", "123", "1", "19.200000000000", "291"),("172452", "2", "0", "123", "1", "19.200000000000", "292"),("172436", "2", "0", "123", "1", "19.200000000000", "293"),("35518", "2", "0", "287", "1", "25.810000000000", "294"),("43420", "2", "0", "297", "1", "10.920000000000", "295"),("172449", "2", "0", "123", "1", "19.200000000000", "296"),("172451", "2", "0", "123", "1", "19.200000000000", "297"),("124713", "1", "0", "309", "1", "20.000000000000", "298"),("172445", "2", "0", "123", "1", "19.200000000000", "299"),("172453", "2", "0", "123", "1", "19.200000000000", "300"),("172456", "2", "0", "123", "1", "19.200000000000", "301"),("108921", "2", "0", "279", "1", "16.880000000000", "302"),("116594", "2", "0", "105", "1", "150.000000000000", "303"),("21728", "2", "0", "94", "1", "21.000000000000", "304"),("177209", "2", "0", "117", "1", "35.000000000000", "305"),("177210", "2", "0", "117", "1", "35.000000000000", "306"),("116916", "4", "0", "280", "1", "39.780000000000", "307"),("223916", "2", "0", "459", "1", "54.000000000000", "308"),("223937", "2", "0", "459", "1", "54.000000000000", "309"),("226842", "1", "0", "459", "1", "67.000000000000", "310"),("248140", "2", "0", "811", "1", "43.330000000000", "311"),("248145", "2", "0", "811", "1", "43.330000000000", "312"),("248143", "2", "0", "811", "1", "43.330000000000", "313"),("229384", "1", "0", "351", "1", "33.830000000000", "314"),("229461", "1", "0", "540", "1", "28.140000000000", "315"),("46037", "2", "0", "11", "1", "21.570000000000", "316"),("166309", "1", "0", "85", "1", "16.550000000000", "317"),("166310", "1", "0", "85", "1", "19.690000000000", "318"),("166312", "1", "0", "85", "1", "19.690000000000", "319"),("173398", "1", "0", "55", "1", "56.600000000000", "320"),("176350", "1", "0", "124", "1", "166.640000000000", "321"),("144499", "1", "0", "353", "1", "30.310000000000", "322"),("236631", "1", "0", "85", "1", "21.850000000000", "323"),("173434", "1", "0", "55", "1", "56.600000000000", "324"),("173445", "1", "0", "55", "1", "102.910000000000", "325"),("236630", "1", "0", "85", "1", "21.850000000000", "326"),("170993", "1", "0", "55", "1", "61.740000000000", "327"),("164812", "2", "0", "593", "1", "19.980000000000", "328"),("173192", "1", "0", "55", "1", "773.450000000000", "329"),("173380", "1", "0", "55", "1", "61.740000000000", "330"),("131831", "2", "0", "593", "1", "19.980000000000", "331"),("131881", "2", "0", "593", "1", "19.980000000000", "332"),("134787", "2", "0", "193", "1", "16.220000000000", "333"),("135051", "2", "0", "193", "1", "3.190000000000", "334"),("219587", "1", "0", "749", "1", "95.700000000000", "335"),("239036", "1", "0", "59", "1", "185.690000000000", "336"),("131827", "2", "0", "593", "1", "19.980000000000", "337"),("173391", "1", "0", "55", "1", "110.620000000000", "338"),("105284", "1", "0", "58", "1", "16.500000000000", "339"),("105322", "1", "0", "58", "1", "69.600000000000", "340"),("251174", "2", "0", "170", "1", "124.400000000000", "341"),("251178", "2", "0", "170", "1", "188.690000000000", "342"),("250671", "1", "0", "170", "1", "127.260000000000", "343"),("250765", "1", "0", "170", "1", "71.180000000000", "344"),("250767", "1", "0", "170", "1", "212.970000000000", "345"),("244188", "1", "0", "122", "1", "33.420000000000", "346")

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'