Căutare

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

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 ("221957", "1", "1000", "459", "1", "57.040000000000", "1"),("221962", "1", "1000", "459", "1", "57.040000000000", "2"),("221965", "1", "1000", "459", "1", "57.040000000000", "3"),("221966", "1", "1000", "459", "1", "57.040000000000", "4"),("221545", "1", "1000", "459", "1", "57.040000000000", "5"),("221964", "1", "1000", "459", "1", "57.040000000000", "6"),("221546", "1", "1000", "459", "1", "57.040000000000", "7"),("221958", "1", "1000", "459", "1", "57.040000000000", "8"),("221961", "1", "1000", "459", "1", "57.040000000000", "9"),("221963", "1", "1000", "459", "1", "57.040000000000", "10"),("221956", "1", "0", "459", "1", "42.000000000000", "11"),("221968", "1", "0", "459", "1", "42.000000000000", "12"),("93213", "2", "83", "369", "1", "100.800000000000", "13"),("133143", "2", "1000", "583", "1", "55.450000000000", "14"),("241420", "1", "1000", "151", "1", "47.880000000000", "15"),("241421", "1", "1000", "151", "1", "47.880000000000", "16"),("241422", "1", "1000", "151", "1", "47.880000000000", "17"),("241423", "1", "1000", "151", "1", "47.880000000000", "18"),("241424", "1", "1000", "151", "1", "47.880000000000", "19"),("224877", "2", "1000", "775", "1", "31303.390000000000", "20"),("224878", "2", "1000", "775", "1", "31849.590000000000", "21"),("69331", "2", "1002", "24", "1", "9.560000000000", "22"),("69332", "2", "1002", "24", "1", "9.560000000000", "23"),("149359", "1", "1002", "423", "1", "31.080000000000", "24"),("103451", "1", "1000", "494", "1", "93.260000000000", "25"),("149361", "1", "1000", "423", "1", "35.280000000000", "26"),("115356", "2", "1000", "73", "1", "22.260000000000", "27"),("241036", "2", "1000", "73", "1", "63.640000000000", "28"),("149363", "1", "1001", "423", "1", "26.880000000000", "29"),("89401", "10", "1000", "423", "1", "33.600000000000", "30"),("50919", "2", "1000", "42", "1", "56.290000000000", "31"),("120186", "0", "2", "570", "1", "742.980000000000", "32"),("213809", "4", "1047", "13", "1", "605.020000000000", "33"),("159351", "2", "1000", "75", "1", "20.910000000000", "34"),("126985", "2", "1000", "583", "1", "55.450000000000", "35"),("179999", "2", "1000", "364", "1", "106.630000000000", "36"),("212765", "1", "1000", "370", "1", "17.210000000000", "37"),("115745", "1", "1024", "285", "1", "8.210000000000", "38"),("213807", "4", "1022", "13", "1", "697.460000000000", "39"),("174884", "1", "1002", "191", "1", "114.270000000000", "40"),("123421", "1", "1001", "423", "1", "28.810000000000", "41"),("231213", "2", "1000", "353", "1", "1702.460000000000", "42"),("168204", "1", "1000", "150", "1", "63.220000000000", "43"),("231212", "2", "1000", "353", "1", "1967.180000000000", "44"),("145655", "1", "1", "469", "1", "39.400000000000", "45"),("215805", "1", "1002", "459", "1", "58.810000000000", "46"),("215811", "1", "1002", "459", "1", "58.810000000000", "47"),("215813", "1", "1002", "459", "1", "58.810000000000", "48"),("215817", "1", "1002", "459", "1", "58.810000000000", "49"),("215819", "1", "1002", "459", "1", "58.810000000000", "50"),("215825", "1", "1002", "459", "1", "58.810000000000", "51"),("215831", "1", "1002", "459", "1", "58.810000000000", "52"),("210377", "1", "1001", "476", "1", "76.370000000000", "53"),("226207", "1", "1000", "370", "1", "34.130000000000", "54"),("193765", "1", "1000", "533", "1", "320.020000000000", "55"),("137795", "1", "1000", "150", "1", "77.870000000000", "56"),("163998", "1", "1000", "150", "1", "63.220000000000", "57"),("164017", "1", "1000", "150", "1", "63.220000000000", "58"),("168205", "1", "1000", "150", "1", "63.220000000000", "59"),("168207", "1", "1000", "150", "1", "63.220000000000", "60"),("168211", "1", "1000", "150", "1", "63.220000000000", "61"),("128703", "1", "2", "150", "1", "61.250000000000", "62"),("123375", "1", "1", "540", "1", "67.210000000000", "63"),("215635", "1", "1024", "528", "1", "8.240000000000", "64"),("215637", "1", "1018", "528", "1", "8.890000000000", "65"),("215803", "1", "1002", "459", "1", "58.810000000000", "66"),("215807", "1", "1002", "459", "1", "58.810000000000", "67"),("215809", "1", "1002", "459", "1", "58.810000000000", "68"),("215815", "1", "1002", "459", "1", "58.810000000000", "69"),("215823", "1", "1002", "459", "1", "58.810000000000", "70"),("215827", "1", "1002", "459", "1", "58.810000000000", "71"),("222546", "1", "1000", "528", "1", "12.260000000000", "72"),("222547", "1", "1000", "528", "1", "12.260000000000", "73"),("222548", "1", "1000", "528", "1", "12.260000000000", "74"),("230964", "1", "1000", "693", "1", "78.140000000000", "75"),("233002", "2", "1000", "531", "1", "143.690000000000", "76"),("242109", "1", "1000", "797", "1", "214.720000000000", "77"),("190945", "4", "1000", "22", "1", "119.230000000000", "78"),("123425", "1", "2", "362", "1", "41.170000000000", "79"),("123419", "1", "1001", "362", "1", "59.310000000000", "80"),("108021", "1", "1000", "104", "1", "366.290000000000", "81"),("225484", "1", "1000", "729", "1", "1908.390000000000", "82"),("230948", "1", "1000", "693", "1", "86.540000000000", "83"),("230963", "1", "1000", "693", "1", "78.140000000000", "84"),("197177", "2", "1000", "50", "1", "62.930000000000", "85"),("197205", "2", "1000", "50", "1", "59.560000000000", "86"),("206283", "1", "1000", "160", "1", "51.390000000000", "87"),("164018", "1", "1000", "150", "1", "47.630000000000", "88"),("247793", "1", "1000", "370", "1", "14.460000000000", "89"),("105536", "2", "1", "128", "1", "29.060000000000", "90"),("197181", "1", "1000", "50", "1", "187.300000000000", "91"),("197189", "1", "1000", "50", "1", "187.300000000000", "92"),("246581", "2", "1000", "168", "1", "618.690000000000", "93"),("246582", "2", "1000", "168", "1", "657.260000000000", "94"),("246584", "2", "1000", "168", "1", "888.690000000000", "95"),("246585", "2", "1000", "168", "1", "1004.400000000000", "96"),("242658", "2", "1000", "475", "1", "1001.590000000000", "97"),("242660", "2", "1000", "475", "1", "1001.590000000000", "98"),("241209", "2", "1000", "360", "1", "38.600000000000", "99"),("38981", "2", "1000", "75", "1", "42.760000000000", "100"),("191761", "1", "1000", "31", "1", "79.740000000000", "101"),("118213", "1", "1005", "13", "1", "15.200000000000", "102"),("241425", "1", "1000", "151", "1", "47.880000000000", "103"),("241426", "1", "1000", "151", "1", "47.880000000000", "104"),("241427", "1", "1000", "151", "1", "47.880000000000", "105"),("241428", "1", "1000", "151", "1", "47.880000000000", "106"),("241429", "1", "1000", "151", "1", "47.880000000000", "107"),("248783", "1", "1000", "808", "1", "336.120000000000", "108"),("224870", "2", "1000", "774", "1", "54412.560000000000", "109"),("237188", "1", "1000", "357", "1", "13.400000000000", "110"),("224869", "2", "1000", "774", "1", "53950.410000000000", "111"),("88323", "2", "1001", "423", "1", "186.540000000000", "112"),("163134", "1", "1000", "506", "1", "16.710000000000", "113"),("163135", "1", "1000", "506", "1", "16.710000000000", "114"),("163136", "1", "1000", "506", "1", "16.710000000000", "115"),("72267", "2", "1000", "459", "1", "57.040000000000", "116"),("214265", "1", "1002", "693", "1", "73.930000000000", "117"),("214267", "1", "1002", "693", "1", "73.930000000000", "118"),("214271", "1", "1002", "693", "1", "73.930000000000", "119"),("214273", "1", "1002", "693", "1", "73.930000000000", "120"),("214275", "1", "1002", "693", "1", "73.930000000000", "121"),("214279", "1", "1002", "693", "1", "73.930000000000", "122"),("214281", "1", "1002", "693", "1", "73.930000000000", "123"),("116728", "2", "1001", "459", "1", "57.040000000000", "124"),("89021", "2", "1000", "459", "1", "57.040000000000", "125"),("169358", "1", "1000", "603", "1", "65.530000000000", "126"),("169368", "1", "1000", "603", "1", "65.530000000000", "127"),("169372", "1", "1000", "603", "1", "65.530000000000", "128"),("169376", "1", "1000", "603", "1", "65.530000000000", "129"),("169378", "1", "1000", "603", "1", "65.530000000000", "130"),("169380", "1", "1000", "603", "1", "65.530000000000", "131"),("126989", "2", "1000", "583", "1", "51.250000000000", "132"),("126991", "2", "1000", "583", "1", "51.250000000000", "133"),("126993", "2", "1000", "583", "1", "51.250000000000", "134"),("130149", "2", "1000", "331", "1", "58.810000000000", "135"),("130151", "2", "1000", "331", "1", "58.810000000000", "136"),("223359", "1", "1000", "459", "1", "63.770000000000", "137"),("223361", "1", "1000", "459", "1", "63.770000000000", "138"),("223378", "1", "1000", "459", "1", "57.040000000000", "139"),("223381", "1", "1000", "459", "1", "57.040000000000", "140"),("223397", "1", "1000", "459", "1", "57.040000000000", "141"),("223406", "1", "1000", "459", "1", "57.040000000000", "142"),("225917", "1", "1000", "459", "1", "63.770000000000", "143"),("200879", "2", "1000", "583", "1", "55.450000000000", "144"),("200889", "2", "1000", "583", "1", "55.450000000000", "145"),("118258", "2", "4", "105", "1", "19.830000000000", "146"),("72200", "2", "2", "459", "1", "56.290000000000", "147"),("72202", "2", "1005", "459", "1", "56.290000000000", "148"),("89237", "2", "1004", "459", "1", "56.290000000000", "149"),("116726", "2", "1002", "459", "1", "57.040000000000", "150"),("116730", "2", "1002", "459", "1", "57.040000000000", "151"),("181157", "1", "1002", "693", "1", "73.930000000000", "152"),("214263", "1", "1002", "693", "1", "73.930000000000", "153"),("214269", "1", "1002", "693", "1", "73.930000000000", "154"),("214285", "1", "1002", "693", "1", "73.930000000000", "155"),("214287", "1", "1002", "693", "1", "73.930000000000", "156"),("214289", "1", "1002", "693", "1", "73.930000000000", "157"),("214293", "1", "1002", "693", "1", "73.930000000000", "158"),("214295", "1", "1002", "693", "1", "73.930000000000", "159"),("214297", "1", "1002", "693", "1", "73.930000000000", "160"),("214301", "1", "1002", "693", "1", "73.930000000000", "161"),("214755", "1", "1002", "693", "1", "62.170000000000", "162"),("214757", "1", "1002", "693", "1", "62.170000000000", "163"),("214765", "1", "1002", "693", "1", "62.170000000000", "164"),("89236", "2", "1002", "459", "1", "56.290000000000", "165"),("112091", "1", "1001", "466", "1", "57.040000000000", "166"),("223393", "1", "1001", "459", "1", "56.290000000000", "167"),("214303", "1", "1001", "693", "1", "73.930000000000", "168"),("214751", "1", "1001", "693", "1", "62.170000000000", "169"),("169369", "1", "1000", "603", "1", "65.530000000000", "170"),("169371", "1", "1000", "603", "1", "65.530000000000", "171"),("169373", "1", "1000", "603", "1", "65.530000000000", "172"),("169381", "1", "1000", "603", "1", "65.530000000000", "173"),("174489", "2", "1000", "185", "1", "77.180000000000", "174"),("174490", "2", "1000", "185", "1", "77.180000000000", "175"),("126995", "2", "1000", "583", "1", "51.250000000000", "176"),("223357", "1", "1000", "459", "1", "57.040000000000", "177"),("223358", "1", "1000", "459", "1", "63.770000000000", "178"),("223362", "1", "1000", "459", "1", "63.770000000000", "179"),("223371", "1", "1000", "459", "1", "63.770000000000", "180"),("223373", "1", "1000", "459", "1", "63.770000000000", "181"),("223376", "1", "1000", "459", "1", "57.040000000000", "182"),("223377", "1", "1000", "459", "1", "57.040000000000", "183"),("223379", "1", "1000", "459", "1", "57.040000000000", "184"),("223380", "1", "1000", "459", "1", "57.040000000000", "185"),("223382", "1", "1000", "459", "1", "57.040000000000", "186"),("223395", "1", "1000", "459", "1", "57.040000000000", "187"),("223396", "1", "1000", "459", "1", "57.040000000000", "188"),("223399", "1", "1000", "459", "1", "57.040000000000", "189"),("223405", "1", "1000", "459", "1", "57.040000000000", "190"),("223413", "1", "1000", "459", "1", "57.040000000000", "191"),("223416", "1", "1000", "459", "1", "57.040000000000", "192"),("223420", "1", "1000", "459", "1", "57.040000000000", "193"),("179453", "1", "1000", "603", "1", "65.530000000000", "194"),("128737", "1", "1000", "150", "1", "52.440000000000", "195"),("128739", "1", "1000", "150", "1", "52.440000000000", "196"),("128745", "1", "1000", "150", "1", "52.440000000000", "197"),("116733", "2", "4", "459", "1", "56.290000000000", "198"),("116729", "2", "3", "459", "1", "56.290000000000", "199"),("5476", "2", "2", "103", "1", "18.810000000000", "200"),("72209", "2", "2", "459", "1", "56.290000000000", "201"),("116731", "2", "2", "459", "1", "57.040000000000", "202"),("214753", "1", "2", "693", "1", "62.170000000000", "203"),("214759", "1", "2", "693", "1", "62.170000000000", "204"),("72201", "10", "1", "459", "1", "56.290000000000", "205"),("72203", "2", "1006", "459", "1", "56.290000000000", "206"),("116734", "2", "1002", "459", "1", "57.040000000000", "207"),("181161", "1", "1002", "693", "1", "73.930000000000", "208"),("214277", "1", "1002", "693", "1", "73.930000000000", "209"),("214283", "1", "1002", "693", "1", "73.930000000000", "210"),("214291", "1", "1002", "693", "1", "73.930000000000", "211"),("214749", "1", "1002", "693", "1", "62.170000000000", "212"),("214763", "1", "1002", "693", "1", "62.170000000000", "213"),("214767", "1", "1002", "693", "1", "62.170000000000", "214"),("72204", "10", "1000", "459", "1", "57.040000000000", "215"),("89218", "2", "1000", "459", "1", "57.040000000000", "216"),("137959", "2", "1000", "583", "1", "63.850000000000", "217"),("137961", "2", "1000", "583", "1", "63.850000000000", "218"),("137963", "2", "1000", "583", "1", "63.850000000000", "219"),("137965", "2", "1000", "583", "1", "63.850000000000", "220"),("137967", "2", "1000", "583", "1", "63.850000000000", "221"),("117974", "2", "1000", "105", "1", "25.950000000000", "222"),("117989", "2", "1000", "105", "1", "25.950000000000", "223"),("223364", "1", "1000", "459", "1", "63.770000000000", "224"),("223365", "1", "1000", "459", "1", "63.770000000000", "225"),("223368", "1", "1000", "459", "1", "63.770000000000", "226"),("223372", "1", "1000", "459", "1", "63.770000000000", "227"),("223375", "1", "1000", "459", "1", "63.770000000000", "228"),("223387", "1", "1000", "459", "1", "57.040000000000", "229"),("223388", "1", "1000", "459", "1", "57.040000000000", "230"),("223389", "1", "1000", "459", "1", "57.040000000000", "231"),("223394", "1", "1000", "459", "1", "57.040000000000", "232"),("223398", "1", "1000", "459", "1", "57.040000000000", "233"),("223400", "1", "1000", "459", "1", "57.040000000000", "234"),("223401", "1", "1000", "459", "1", "57.040000000000", "235"),("223403", "1", "1000", "459", "1", "57.040000000000", "236"),("223404", "1", "1000", "459", "1", "57.040000000000", "237"),("223409", "1", "1000", "459", "1", "57.040000000000", "238"),("223414", "1", "1000", "459", "1", "57.040000000000", "239"),("223422", "1", "1000", "459", "1", "57.040000000000", "240"),("223423", "1", "1000", "459", "1", "57.040000000000", "241"),("223426", "1", "1000", "459", "1", "57.040000000000", "242"),("223427", "1", "1000", "459", "1", "57.040000000000", "243"),("181159", "1", "1000", "693", "1", "73.930000000000", "244"),("128735", "1", "1000", "150", "1", "52.440000000000", "245"),("128743", "1", "1000", "150", "1", "52.440000000000", "246"),("128747", "1", "1000", "150", "1", "52.440000000000", "247"),("116727", "2", "5", "459", "1", "56.290000000000", "248"),("181163", "1", "1002", "693", "1", "73.930000000000", "249"),("214299", "1", "1002", "693", "1", "73.930000000000", "250"),("214761", "1", "1002", "693", "1", "62.170000000000", "251"),("214769", "1", "1002", "693", "1", "62.170000000000", "252"),("143013", "2", "1000", "17", "1", "370.490000000000", "253"),("223360", "1", "1000", "459", "1", "63.770000000000", "254"),("223363", "1", "1000", "459", "1", "63.770000000000", "255"),("223366", "1", "1000", "459", "1", "63.770000000000", "256"),("223374", "1", "1000", "459", "1", "63.770000000000", "257"),("223383", "1", "1000", "459", "1", "57.040000000000", "258"),("223385", "1", "1000", "459", "1", "57.040000000000", "259"),("230951", "1", "1000", "693", "1", "73.930000000000", "260"),("224004", "1", "1005", "224", "1", "31.830000000000", "261"),("223367", "1", "1000", "459", "1", "63.770000000000", "262"),("224002", "1", "1000", "224", "1", "31.830000000000", "263"),("224003", "1", "1000", "224", "1", "31.830000000000", "264"),("224005", "1", "1000", "224", "1", "31.830000000000", "265"),("224006", "1", "1000", "224", "1", "31.830000000000", "266"),("224007", "1", "1000", "224", "1", "31.830000000000", "267"),("224440", "1", "1000", "609", "1", "42.840000000000", "268"),("224441", "1", "1000", "609", "1", "42.840000000000", "269"),("224442", "1", "1000", "609", "1", "42.840000000000", "270"),("224443", "1", "1000", "609", "1", "42.840000000000", "271"),("224444", "1", "1000", "609", "1", "42.840000000000", "272"),("224445", "1", "1000", "609", "1", "42.840000000000", "273"),("230950", "1", "1000", "693", "1", "73.930000000000", "274"),("230952", "1", "1000", "693", "1", "73.930000000000", "275"),("230949", "1", "1000", "693", "1", "73.930000000000", "276"),("230958", "1", "1000", "693", "1", "73.930000000000", "277"),("230959", "1", "1000", "693", "1", "73.930000000000", "278"),("245922", "1", "1000", "693", "1", "63.850000000000", "279"),("245923", "1", "1000", "693", "1", "63.850000000000", "280"),("245924", "1", "1000", "693", "1", "63.850000000000", "281"),("245926", "1", "1000", "693", "1", "63.850000000000", "282"),("245927", "1", "1000", "693", "1", "63.850000000000", "283"),("246910", "1", "1000", "11", "1", "45.230000000000", "284"),("246913", "1", "1000", "11", "1", "45.230000000000", "285"),("246914", "1", "1000", "11", "1", "45.230000000000", "286"),("65445", "2", "7", "103", "1", "18.810000000000", "287"),("65444", "2", "3", "103", "1", "18.810000000000", "288"),("230957", "1", "1000", "693", "1", "73.930000000000", "289"),("245925", "1", "1000", "693", "1", "63.850000000000", "290"),("245928", "1", "1000", "693", "1", "63.850000000000", "291"),("245929", "1", "1000", "693", "1", "63.850000000000", "292"),("245931", "1", "1000", "693", "1", "63.850000000000", "293"),("245932", "1", "1000", "693", "1", "63.850000000000", "294"),("246909", "1", "1000", "11", "1", "45.230000000000", "295"),("246911", "1", "1000", "11", "1", "45.230000000000", "296"),("223999", "1", "1000", "224", "1", "31.830000000000", "297"),("245930", "1", "1000", "693", "1", "63.850000000000", "298"),("246912", "1", "1000", "11", "1", "45.230000000000", "299"),("246915", "1", "1000", "11", "1", "45.230000000000", "300"),("223996", "1", "1000", "224", "1", "31.830000000000", "301"),("223997", "1", "1000", "224", "1", "31.830000000000", "302"),("224000", "1", "1000", "224", "1", "31.830000000000", "303"),("223998", "1", "1000", "224", "1", "31.830000000000", "304"),("132493", "1", "1000", "58", "1", "75.530000000000", "305"),("180027", "2", "0", "369", "1", "85.000000000000", "306"),("89143", "2", "0", "423", "1", "14.790000000000", "307"),("89145", "2", "0", "423", "1", "70.380000000000", "308"),("126987", "2", "0", "583", "1", "52.000000000000", "309"),("123423", "1", "0", "540", "1", "61.170000000000", "310"),("122339", "1", "0", "123", "1", "307.570000000000", "311"),("137805", "1", "0", "150", "1", "60.260000000000", "312"),("137793", "1", "0", "150", "1", "59.260000000000", "313"),("137797", "1", "0", "150", "1", "59.260000000000", "314"),("168210", "1", "0", "150", "1", "48.000000000000", "315"),("137799", "1", "0", "150", "1", "60.260000000000", "316"),("123417", "1", "0", "362", "1", "43.000000000000", "317"),("128705", "1", "0", "150", "1", "48.000000000000", "318"),("193769", "1", "0", "533", "1", "315.420000000000", "319"),("193935", "1", "0", "533", "1", "272.430000000000", "320"),("239479", "1", "0", "59", "1", "210.900000000000", "321"),("246586", "2", "0", "168", "1", "2508.690000000000", "322"),("246587", "2", "0", "168", "1", "2547.260000000000", "323"),("235704", "2", "0", "85", "1", "17.990000000000", "324"),("89456", "2", "0", "483", "1", "24.000000000000", "325"),("130153", "2", "0", "331", "1", "45.380000000000", "326"),("130155", "2", "0", "331", "1", "45.380000000000", "327"),("116725", "2", "0", "459", "1", "42.000000000000", "328"),("223370", "1", "0", "459", "1", "48.000000000000", "329"),("116732", "2", "0", "459", "1", "42.000000000000", "330"),("223429", "1", "0", "459", "1", "42.000000000000", "331"),("128741", "1", "0", "150", "1", "39.700000000000", "332"),("223369", "1", "0", "459", "1", "48.000000000000", "333"),("223384", "1", "0", "459", "1", "42.000000000000", "334"),("223412", "1", "0", "459", "1", "42.000000000000", "335"),("223417", "1", "0", "459", "1", "42.000000000000", "336"),("223424", "1", "0", "459", "1", "42.000000000000", "337"),("167901", "2", "0", "459", "1", "42.000000000000", "338"),("223386", "1", "0", "459", "1", "42.000000000000", "339"),("223411", "1", "0", "459", "1", "42.000000000000", "340"),("195373", "1", "0", "388", "1", "28.000000000000", "341"),("224001", "1", "0", "224", "1", "17.590000000000", "342")

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 = '2' AND name = 'lichidare_stoc'