Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '3fdefc62500dfdde810180d316'

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 ("202703", "1", "1000", "192", "1", "504.960000000000", "1"),("231930", "1", "1000", "224", "1", "8.320000000000", "2"),("129451", "2", "1000", "192", "1", "702.440000000000", "3"),("246316", "1", "1002", "133", "1", "60.500000000000", "4"),("104854", "2", "1000", "58", "1", "14.200000000000", "5"),("54579", "2", "1", "192", "1", "1099.160000000000", "6"),("108285", "1", "1001", "58", "1", "16.720000000000", "7"),("214203", "1", "1002", "691", "1", "78.150000000000", "8"),("208885", "1", "1001", "192", "1", "1503.360000000000", "9"),("168837", "2", "1000", "603", "1", "31.510000000000", "10"),("168698", "2", "1000", "603", "1", "31.510000000000", "11"),("168699", "2", "1000", "603", "1", "31.510000000000", "12"),("168700", "2", "1000", "603", "1", "31.510000000000", "13"),("236444", "2", "1000", "540", "1", "33.740000000000", "14"),("77860", "2", "1000", "19", "1", "48.490000000000", "15"),("165499", "1", "1000", "224", "1", "544.450000000000", "16"),("192095", "1", "1", "528", "1", "217.650000000000", "17"),("104857", "2", "1000", "58", "1", "14.200000000000", "18"),("108278", "1", "1000", "58", "1", "16.720000000000", "19"),("224173", "2", "1000", "224", "1", "18.400000000000", "20"),("213671", "1", "1004", "224", "1", "10.420000000000", "21"),("214205", "1", "1002", "691", "1", "78.150000000000", "22"),("79167", "2", "1000", "42", "1", "108.400000000000", "23"),("230468", "1", "1000", "42", "1", "268.910000000000", "24"),("132617", "1", "1000", "423", "1", "184.870000000000", "25"),("84827", "10", "1000", "495", "1", "303.770000000000", "26"),("177552", "1", "1000", "11", "1", "183.660000000000", "27"),("202361", "1", "1000", "192", "1", "1656.220000000000", "28"),("119202", "2", "1000", "105", "1", "8.740000000000", "29"),("176507", "1", "1000", "191", "1", "215.970000000000", "30"),("176508", "1", "1000", "191", "1", "215.970000000000", "31"),("66992", "2", "1", "105", "1", "117.560000000000", "32"),("214201", "1", "1002", "691", "1", "78.150000000000", "33"),("219038", "1", "1001", "401", "1", "105.800000000000", "34"),("173748", "2", "1000", "191", "1", "301.680000000000", "35"),("211417", "1", "1000", "553", "1", "1588.990000000000", "36"),("168245", "2", "1000", "115", "1", "475.550000000000", "37"),("168248", "2", "1000", "115", "1", "551.180000000000", "38"),("168405", "2", "1000", "115", "1", "512.520000000000", "39"),("219025", "1", "1000", "401", "1", "118.400000000000", "40"),("219035", "1", "1000", "401", "1", "110.000000000000", "41"),("165420", "1", "1000", "224", "1", "188.990000000000", "42"),("198433", "1", "1000", "105", "1", "206.640000000000", "43"),("193107", "1", "6", "507", "1", "27.366400000000", "44"),("147055", "1", "2", "17", "1", "189.080000000000", "45"),("211867", "1", "1005", "224", "1", "9.160000000000", "46"),("177495", "1", "1003", "13", "1", "225.130000000000", "47"),("177497", "1", "1003", "13", "1", "285.630000000000", "48"),("177498", "1", "1002", "13", "1", "333.530000000000", "49"),("193109", "1", "1001", "507", "1", "27.366400000000", "50"),("113065", "2", "1001", "30", "1", "336.890000000000", "51"),("113067", "2", "1001", "30", "1", "378.910000000000", "52"),("227283", "1", "1000", "370", "1", "251.430000000000", "53"),("236109", "1", "1000", "795", "1", "212.610000000000", "54"),("194615", "2", "1000", "87", "1", "237.820000000000", "55"),("169204", "2", "1000", "87", "1", "235.260000000000", "56"),("202377", "1", "1000", "192", "1", "1680.590000000000", "57"),("222101", "1", "1000", "459", "1", "83.950000000000", "58"),("222102", "1", "1000", "459", "1", "83.950000000000", "59"),("113066", "2", "1000", "30", "1", "398.240000000000", "60"),("177500", "1", "1000", "13", "1", "393.190000000000", "61"),("119382", "4", "1000", "105", "1", "294.870000000000", "62"),("119383", "4", "1000", "105", "1", "324.290000000000", "63"),("199545", "1", "1000", "105", "1", "500.760000000000", "64"),("199549", "1", "1000", "105", "1", "546.970000000000", "65"),("146937", "1", "1000", "17", "1", "529.410000000000", "66"),("147033", "1", "1000", "17", "1", "136.390000000000", "67"),("147839", "1", "1000", "17", "1", "151.180000000000", "68"),("147843", "1", "1000", "17", "1", "126.300000000000", "69"),("147851", "1", "1000", "17", "1", "141.430000000000", "70"),("117131", "2", "1", "280", "1", "104.120000000000", "71"),("117129", "2", "1", "280", "1", "82.940000000000", "72"),("169311", "1", "1", "54", "1", "120.170000000000", "73"),("117130", "2", "1", "280", "1", "92.360000000000", "74"),("96183", "2", "1002", "24", "1", "6.220000000000", "75"),("96184", "2", "1000", "24", "1", "6.220000000000", "76"),("165435", "1", "1001", "67", "1", "14.710000000000", "77"),("164660", "2", "1000", "42", "1", "184.870000000000", "78"),("173372", "1", "1000", "55", "1", "92.250000000000", "79"),("173363", "1", "1000", "55", "1", "189.030000000000", "80"),("177580", "1", "1000", "11", "1", "195.110000000000", "81"),("177582", "1", "1000", "11", "1", "225.760000000000", "82"),("177585", "1", "1000", "11", "1", "241.090000000000", "83"),("146593", "1", "1000", "85", "1", "31.710000000000", "84"),("207745", "1", "1000", "11", "1", "113.770000000000", "85"),("222103", "1", "1000", "459", "1", "83.950000000000", "86"),("222104", "1", "1000", "459", "1", "83.950000000000", "87"),("222105", "1", "1000", "459", "1", "83.950000000000", "88"),("222106", "1", "1000", "459", "1", "83.950000000000", "89"),("222107", "1", "1000", "459", "1", "83.950000000000", "90"),("116611", "2", "1000", "105", "1", "219.240000000000", "91"),("116612", "2", "1000", "105", "1", "240.250000000000", "92"),("192557", "2", "1000", "88", "1", "482.350000000000", "93"),("146917", "1", "1000", "17", "1", "336.050000000000", "94"),("237876", "1", "1000", "124", "1", "68.660000000000", "95"),("122211", "1", "3", "559", "1", "21.760000000000", "96"),("169739", "1", "1004", "224", "1", "7.900000000000", "97"),("169741", "1", "1000", "224", "1", "7.900000000000", "98"),("233343", "1", "1001", "122", "1", "365.550000000000", "99"),("232457", "1", "1001", "122", "1", "382.350000000000", "100"),("195787", "1", "1000", "122", "1", "602.520000000000", "101"),("236257", "1", "1000", "85", "1", "257.140000000000", "102"),("173150", "1", "1000", "55", "1", "1123.650000000000", "103"),("173151", "1", "1000", "55", "1", "1122.450000000000", "104"),("173152", "1", "1000", "55", "1", "1122.150000000000", "105"),("165163", "1", "1000", "459", "1", "83.950000000000", "106"),("179577", "1", "1000", "20", "1", "149.800000000000", "107"),("97947", "2", "8", "501", "1", "10.840000000000", "108"),("176849", "1", "1000", "42", "1", "21.010000000000", "109"),("176850", "1", "1000", "42", "1", "21.010000000000", "110"),("176851", "1", "1000", "42", "1", "21.010000000000", "111"),("176852", "1", "1000", "42", "1", "21.010000000000", "112"),("176853", "1", "1000", "42", "1", "21.010000000000", "113"),("176854", "1", "1000", "42", "1", "21.010000000000", "114"),("232436", "1", "1000", "224", "1", "11.260000000000", "115"),("232437", "1", "1000", "224", "1", "11.260000000000", "116"),("232438", "1", "1000", "224", "1", "11.260000000000", "117"),("246317", "1", "1002", "133", "1", "60.500000000000", "118"),("240831", "2", "1001", "648", "1", "132.770000000000", "119"),("195543", "1", "1000", "122", "1", "248.740000000000", "120"),("232478", "1", "1000", "122", "1", "159.660000000000", "121"),("232483", "1", "1000", "122", "1", "188.240000000000", "122"),("199077", "1", "1000", "122", "1", "299.160000000000", "123"),("111510", "2", "1000", "553", "1", "1378.910000000000", "124"),("241589", "2", "1000", "648", "1", "113.450000000000", "125"),("11133", "2", "6", "67", "1", "2.240000000000", "126"),("246311", "1", "1002", "133", "1", "60.500000000000", "127"),("246318", "1", "1002", "133", "1", "60.500000000000", "128"),("232442", "1", "1001", "122", "1", "194.960000000000", "129"),("236206", "1", "1000", "85", "1", "394.960000000000", "130"),("232394", "1", "1000", "122", "1", "248.740000000000", "131"),("236276", "1", "1000", "85", "1", "291.600000000000", "132"),("129973", "1", "1000", "85", "1", "320.250000000000", "133"),("119881", "2", "1000", "105", "1", "357.900000000000", "134"),("119882", "2", "1000", "105", "1", "383.110000000000", "135"),("174930", "2", "1000", "191", "1", "89.210000000000", "136"),("201439", "1", "1000", "17", "1", "478.910000000000", "137"),("227408", "1", "5", "122", "1", "602.520000000000", "138"),("87971", "2", "1000", "423", "1", "126.050000000000", "139"),("119612", "2", "1000", "58", "1", "51.180000000000", "140"),("55987", "2", "1000", "15", "1", "19.920000000000", "141"),("246025", "1", "1000", "224", "1", "15.880000000000", "142"),("236168", "2", "1000", "87", "1", "215.970000000000", "143"),("224746", "2", "1000", "729", "1", "53.780000000000", "144"),("118309", "2", "1000", "105", "1", "23.450000000000", "145"),("118312", "2", "1000", "105", "1", "23.450000000000", "146"),("227043", "1", "1000", "96", "1", "4.540000000000", "147"),("200229", "1", "1000", "224", "1", "5.800000000000", "148"),("231264", "2", "1", "124", "1", "225.210000000000", "149"),("104855", "2", "1004", "58", "1", "14.200000000000", "150"),("104856", "2", "1001", "58", "1", "14.200000000000", "151"),("227288", "1", "1000", "528", "1", "10.550000000000", "152"),("229218", "1", "1000", "423", "1", "139.500000000000", "153"),("102163", "1", "1000", "546", "1", "88.990000000000", "154"),("102164", "1", "1000", "546", "1", "88.990000000000", "155"),("244435", "1", "1040", "13", "1", "11.680000000000", "156"),("215837", "2", "1002", "459", "1", "60.500000000000", "157"),("215839", "2", "1002", "459", "1", "60.500000000000", "158"),("215941", "2", "1002", "459", "1", "60.500000000000", "159"),("215937", "2", "1002", "459", "1", "60.500000000000", "160"),("107691", "1", "1002", "58", "1", "7.900000000000", "161"),("215933", "2", "1001", "459", "1", "60.500000000000", "162"),("215841", "2", "1001", "459", "1", "60.500000000000", "163"),("215935", "2", "1001", "459", "1", "60.500000000000", "164"),("163493", "2", "1000", "459", "1", "61.260000000000", "165"),("107690", "1", "1000", "58", "1", "7.900000000000", "166"),("215945", "2", "2", "459", "1", "60.500000000000", "167"),("107689", "1", "2", "58", "1", "7.900000000000", "168"),("196665", "1", "1000", "122", "1", "241.180000000000", "169"),("224408", "1", "1000", "609", "1", "14.290000000000", "170"),("224414", "1", "1000", "609", "1", "14.290000000000", "171"),("244425", "1", "1046", "13", "1", "12.520000000000", "172"),("215833", "2", "1001", "459", "1", "60.500000000000", "173"),("223465", "1", "1000", "459", "1", "61.260000000000", "174"),("223468", "1", "1000", "459", "1", "61.260000000000", "175"),("223469", "1", "1000", "459", "1", "61.260000000000", "176"),("232162", "1", "1000", "459", "1", "61.260000000000", "177"),("232164", "1", "1000", "459", "1", "61.260000000000", "178"),("232168", "1", "1000", "459", "1", "61.260000000000", "179"),("232169", "1", "1000", "459", "1", "61.260000000000", "180"),("215939", "2", "1000", "459", "1", "60.500000000000", "181"),("223467", "1", "1000", "459", "1", "61.260000000000", "182"),("149441", "1", "1000", "105", "1", "723.450000000000", "183"),("244969", "1", "1000", "85", "1", "480.670000000000", "184"),("92650", "2", "1000", "85", "1", "33.630000000000", "185"),("243915", "2", "1000", "11", "1", "10.990000000000", "186"),("119585", "2", "1006", "58", "1", "12.610000000000", "187"),("119580", "2", "1004", "58", "1", "12.610000000000", "188"),("220806", "1", "1000", "58", "1", "1177.230000000000", "189"),("220807", "1", "1000", "58", "1", "1387.310000000000", "190"),("171216", "2", "9", "45", "1", "7.730000000000", "191"),("214375", "2", "1015", "13", "1", "8.320000000000", "192"),("94142", "2", "1004", "58", "1", "15.130000000000", "193"),("94130", "2", "4", "58", "1", "12.520000000000", "194"),("67187", "2", "1", "58", "1", "80.920000000000", "195"),("66983", "2", "1002", "58", "1", "32.770000000000", "196"),("104615", "1", "1002", "58", "1", "15.040000000000", "197"),("104845", "2", "1002", "58", "1", "14.200000000000", "198"),("104635", "2", "1000", "58", "1", "15.040000000000", "199"),("66984", "2", "1000", "58", "1", "36.890000000000", "200"),("198435", "1", "1000", "105", "1", "219.240000000000", "201"),("235921", "2", "1000", "224", "1", "9.160000000000", "202"),("118160", "2", "3", "105", "1", "20.920000000000", "203"),("108297", "1", "1003", "58", "1", "9.240000000000", "204"),("154261", "1", "1000", "575", "1", "28.490000000000", "205"),("108301", "1", "1000", "58", "1", "12.520000000000", "206"),("177682", "1", "1000", "58", "1", "17.560000000000", "207"),("169925", "1", "1000", "58", "1", "81.430000000000", "208"),("180983", "1", "1000", "58", "1", "147.820000000000", "209"),("119614", "1", "1006", "58", "1", "18.490000000000", "210"),("119615", "1", "1004", "58", "1", "17.650000000000", "211"),("119613", "2", "1002", "58", "1", "13.450000000000", "212"),("150511", "2", "1000", "58", "1", "30.170000000000", "213"),("119608", "2", "1001", "58", "1", "66.300000000000", "214"),("95356", "2", "1003", "58", "1", "57.980000000000", "215"),("150487", "2", "1001", "58", "1", "72.180000000000", "216"),("246024", "1", "1000", "224", "1", "16.720000000000", "217"),("150483", "2", "2", "58", "1", "55.380000000000", "218"),("150485", "2", "1", "58", "1", "59.580000000000", "219"),("244840", "1", "1000", "58", "1", "16.720000000000", "220"),("244841", "1", "1000", "58", "1", "16.720000000000", "221"),("177694", "1", "1000", "58", "1", "109.160000000000", "222"),("108494", "1", "1000", "58", "1", "67.980000000000", "223"),("168170", "1", "0", "150", "1", "779.810000000000", "224"),("97884", "2", "0", "501", "1", "4.000000000000", "225"),("48117", "2", "0", "105", "1", "13.000000000000", "226"),("87931", "2", "0", "423", "1", "185.000000000000", "227"),("77849", "2", "0", "19", "1", "25.910000000000", "228"),("161865", "1", "0", "540", "1", "169.000000000000", "229"),("229145", "1", "0", "540", "1", "294.960000000000", "230"),("109285", "2", "0", "12", "1", "77.030000000000", "231"),("79166", "2", "0", "42", "1", "75.000000000000", "232"),("141493", "2", "0", "12", "1", "109.240000000000", "233"),("149229", "2", "0", "423", "1", "100.000000000000", "234"),("118844", "1", "0", "12", "1", "95.030000000000", "235"),("207561", "1", "0", "528", "1", "407.560000000000", "236"),("141487", "2", "0", "12", "1", "131.450000000000", "237"),("194815", "1", "0", "507", "1", "19.712000000000", "238"),("199159", "1", "0", "87", "1", "76.970000000000", "239"),("147331", "1", "0", "17", "1", "194.030000000000", "240"),("229727", "1", "0", "42", "1", "181.000000000000", "241"),("229728", "1", "0", "42", "1", "184.000000000000", "242"),("229729", "1", "0", "42", "1", "187.000000000000", "243"),("211423", "1", "0", "553", "1", "1280.000000000000", "244"),("211425", "1", "0", "553", "1", "1260.000000000000", "245"),("236722", "2", "0", "124", "1", "112.190000000000", "246"),("147519", "2", "0", "17", "1", "290.000000000000", "247"),("234950", "2", "0", "11", "1", "317.130000000000", "248"),("202179", "2", "0", "67", "1", "11.430000000000", "249"),("202189", "2", "0", "67", "1", "10.340000000000", "250"),("202197", "2", "0", "67", "1", "15.970000000000", "251"),("167011", "2", "0", "67", "1", "11.100000000000", "252"),("175809", "1", "0", "124", "1", "212.070000000000", "253"),("193105", "1", "0", "507", "1", "20.352000000000", "254"),("84502", "2", "0", "11", "1", "213.020000000000", "255"),("178283", "1", "0", "122", "1", "176.790000000000", "256"),("147061", "1", "0", "17", "1", "187.000000000000", "257"),("222982", "1", "0", "17", "1", "554.540000000000", "258"),("178264", "1", "0", "122", "1", "131.570000000000", "259"),("236253", "1", "0", "85", "1", "190.350000000000", "260"),("236260", "1", "0", "85", "1", "163.170000000000", "261"),("189099", "1", "0", "88", "1", "353.570000000000", "262"),("178270", "1", "0", "122", "1", "161.790000000000", "263"),("196005", "1", "0", "122", "1", "197.490000000000", "264"),("195889", "1", "0", "122", "1", "565.010000000000", "265"),("195893", "1", "0", "122", "1", "535.260000000000", "266"),("109202", "2", "0", "85", "1", "204.800000000000", "267"),("238606", "1", "0", "85", "1", "231.190000000000", "268"),("238608", "1", "0", "85", "1", "203.970000000000", "269"),("195511", "1", "0", "122", "1", "201.250000000000", "270"),("195949", "1", "0", "122", "1", "407.980000000000", "271"),("228602", "1", "0", "455", "1", "719.220000000000", "272"),("228603", "1", "0", "455", "1", "757.030000000000", "273"),("97898", "2", "0", "501", "1", "5.000000000000", "274"),("169698", "1", "0", "122", "1", "648.790000000000", "275"),("240888", "2", "0", "151", "1", "1119.000000000000", "276"),("55993", "2", "0", "15", "1", "6.560000000000", "277"),("167107", "2", "0", "193", "1", "25.798300000000", "278"),("215943", "2", "0", "459", "1", "46.000000000000", "279"),("224409", "1", "0", "609", "1", "14.290000000000", "280"),("161457", "2", "0", "359", "1", "188.660000000000", "281"),("135741", "2", "0", "193", "1", "11.550000000000", "282"),("163484", "2", "0", "459", "1", "46.000000000000", "283"),("223464", "1", "0", "459", "1", "46.000000000000", "284"),("232166", "1", "0", "459", "1", "46.000000000000", "285"),("232167", "1", "0", "459", "1", "46.000000000000", "286"),("150467", "1", "0", "58", "1", "130.000000000000", "287"),("150469", "1", "0", "58", "1", "168.000000000000", "288")

SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t

SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '129451' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '2'

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '129451' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '129451' AND a.attribute_group_id = '7' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

SELECT *
FROM oc_product_image
WHERE product_id = '129451'
ORDER BY sort_order ASC

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=129451'

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'