Căutare

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

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 ("136093", "2", "1000", "193", "1", "32.760000000000", "1"),("120163", "2", "2", "280", "1", "6.630000000000", "2"),("175526", "1", "1000", "11", "1", "58.670000000000", "3"),("119158", "2", "1004", "105", "1", "26.790000000000", "4"),("119157", "2", "1000", "105", "1", "26.790000000000", "5"),("119156", "2", "1", "105", "1", "26.790000000000", "6"),("118146", "2", "1000", "105", "1", "21.750000000000", "7"),("118147", "2", "1000", "105", "1", "21.750000000000", "8"),("119155", "2", "1000", "105", "1", "26.790000000000", "9"),("210561", "1", "1000", "224", "1", "15.020000000000", "10"),("210563", "1", "1000", "224", "1", "15.020000000000", "11"),("210565", "1", "1000", "224", "1", "15.020000000000", "12"),("144001", "2", "1000", "150", "1", "49.880000000000", "13"),("144005", "2", "1000", "150", "1", "49.880000000000", "14"),("210567", "1", "1000", "224", "1", "15.020000000000", "15"),("144003", "2", "1000", "150", "1", "49.880000000000", "16"),("172260", "1", "1000", "658", "1", "28.910000000000", "17"),("172263", "1", "1000", "658", "1", "28.910000000000", "18"),("136099", "2", "1000", "193", "1", "36.960000000000", "19"),("224315", "1", "1000", "337", "1", "58.810000000000", "20"),("224316", "1", "1000", "337", "1", "58.810000000000", "21"),("224317", "1", "1000", "337", "1", "58.810000000000", "22"),("224318", "1", "1000", "337", "1", "58.810000000000", "23"),("224319", "1", "1000", "337", "1", "58.810000000000", "24"),("224320", "1", "1000", "337", "1", "58.810000000000", "25"),("171995", "1", "1000", "658", "1", "17.740000000000", "26"),("171998", "1", "1000", "658", "1", "17.010000000000", "27"),("172000", "1", "1000", "658", "1", "17.740000000000", "28"),("172002", "1", "1000", "658", "1", "17.740000000000", "29"),("172004", "1", "1000", "658", "1", "17.740000000000", "30"),("63824", "2", "1000", "94", "1", "23.210000000000", "31"),("224227", "1", "1000", "337", "1", "42.000000000000", "32"),("224228", "1", "1000", "337", "1", "42.000000000000", "33"),("224229", "1", "1000", "337", "1", "42.000000000000", "34"),("224230", "1", "1000", "337", "1", "42.000000000000", "35"),("224231", "1", "1000", "337", "1", "42.000000000000", "36"),("224232", "1", "1000", "337", "1", "42.000000000000", "37"),("224233", "1", "1000", "337", "1", "42.000000000000", "38"),("224234", "1", "1000", "337", "1", "42.000000000000", "39"),("214085", "1", "1002", "691", "1", "52.930000000000", "40"),("214087", "1", "1002", "691", "1", "52.930000000000", "41"),("214105", "1", "1002", "691", "1", "52.930000000000", "42"),("120171", "2", "2", "280", "1", "6.630000000000", "43"),("120172", "2", "1", "280", "1", "6.630000000000", "44"),("214089", "1", "1002", "691", "1", "52.930000000000", "45"),("214091", "1", "1002", "691", "1", "52.930000000000", "46"),("214093", "1", "1002", "691", "1", "52.930000000000", "47"),("214097", "1", "1002", "691", "1", "52.930000000000", "48"),("214103", "1", "1002", "691", "1", "52.930000000000", "49"),("120143", "2", "5", "280", "1", "6.630000000000", "50"),("120148", "2", "4", "280", "1", "6.630000000000", "51"),("238771", "1", "1000", "193", "1", "24.360000000000", "52"),("238772", "1", "1000", "193", "1", "24.360000000000", "53"),("238773", "1", "1000", "193", "1", "24.360000000000", "54"),("112339", "1", "1004", "85", "1", "29.400000000000", "55"),("214095", "1", "1002", "691", "1", "52.930000000000", "56"),("214099", "1", "1002", "691", "1", "52.930000000000", "57"),("214101", "1", "1002", "691", "1", "52.930000000000", "58"),("197619", "2", "1001", "285", "1", "24.940000000000", "59"),("73968", "2", "1000", "145", "1", "34.360000000000", "60"),("168698", "2", "1000", "603", "1", "32.340000000000", "61"),("168699", "2", "1000", "603", "1", "32.340000000000", "62"),("168700", "2", "1000", "603", "1", "32.340000000000", "63"),("168837", "2", "1000", "603", "1", "32.340000000000", "64"),("168838", "2", "1000", "603", "1", "32.340000000000", "65"),("169610", "1", "1000", "459", "1", "57.040000000000", "66"),("159373", "1", "1000", "75", "1", "21.750000000000", "67"),("163748", "1", "1000", "459", "1", "57.040000000000", "68"),("147631", "1", "1000", "117", "1", "38.550000000000", "69"),("147635", "1", "1000", "117", "1", "38.550000000000", "70"),("147639", "1", "1000", "117", "1", "38.550000000000", "71"),("147653", "1", "1000", "117", "1", "38.550000000000", "72"),("147655", "1", "1000", "117", "1", "38.550000000000", "73"),("147657", "1", "1000", "117", "1", "38.550000000000", "74"),("221893", "1", "1000", "459", "1", "57.040000000000", "75"),("221900", "1", "1000", "459", "1", "57.040000000000", "76"),("221901", "1", "1000", "459", "1", "57.040000000000", "77"),("226354", "2", "1000", "459", "1", "57.040000000000", "78"),("226355", "2", "1000", "459", "1", "57.040000000000", "79"),("226357", "2", "1000", "459", "1", "57.040000000000", "80"),("73666", "2", "6", "145", "1", "26.020000000000", "81"),("73979", "2", "1011", "145", "1", "29.400000000000", "82"),("73670", "2", "1009", "145", "1", "22.680000000000", "83"),("73969", "2", "1009", "145", "1", "29.400000000000", "84"),("112336", "1", "1008", "85", "1", "29.400000000000", "85"),("115149", "1", "1008", "85", "1", "27.790000000000", "86"),("73680", "2", "1004", "145", "1", "20.160000000000", "87"),("214127", "1", "1002", "691", "1", "66.370000000000", "88"),("214129", "1", "1002", "691", "1", "66.370000000000", "89"),("73678", "2", "1002", "145", "1", "33.930000000000", "90"),("174219", "1", "1001", "649", "1", "23.510000000000", "91"),("147649", "1", "1001", "117", "1", "38.550000000000", "92"),("14911", "2", "1000", "115", "1", "27.640000000000", "93"),("14912", "2", "1000", "115", "1", "27.640000000000", "94"),("14913", "2", "1000", "115", "1", "27.640000000000", "95"),("72021", "2", "1000", "145", "1", "25.120000000000", "96"),("73981", "2", "1000", "145", "1", "23.430000000000", "97"),("159375", "1", "1000", "75", "1", "21.750000000000", "98"),("159377", "1", "1000", "75", "1", "32.680000000000", "99"),("163746", "1", "1000", "459", "1", "57.040000000000", "100"),("174200", "1", "1000", "649", "1", "23.510000000000", "101"),("174205", "1", "1000", "649", "1", "23.510000000000", "102"),("174208", "1", "1000", "649", "1", "23.510000000000", "103"),("174210", "1", "1000", "649", "1", "23.510000000000", "104"),("174214", "1", "1000", "649", "1", "23.510000000000", "105"),("174216", "1", "1000", "649", "1", "23.510000000000", "106"),("174217", "1", "1000", "649", "1", "23.510000000000", "107"),("174220", "1", "1000", "649", "1", "23.510000000000", "108"),("147637", "1", "1000", "117", "1", "38.550000000000", "109"),("147641", "1", "1000", "117", "1", "38.550000000000", "110"),("147643", "1", "1000", "117", "1", "38.550000000000", "111"),("147647", "1", "1000", "117", "1", "38.550000000000", "112"),("147659", "1", "1000", "117", "1", "38.550000000000", "113"),("119174", "2", "1000", "105", "1", "23.430000000000", "114"),("119175", "2", "1000", "105", "1", "23.430000000000", "115"),("119176", "2", "1000", "105", "1", "23.430000000000", "116"),("221894", "1", "1000", "459", "1", "57.040000000000", "117"),("226119", "1", "1000", "459", "1", "93.180000000000", "118"),("226353", "2", "1000", "459", "1", "57.040000000000", "119"),("226829", "1", "1000", "459", "1", "93.180000000000", "120"),("226830", "1", "1000", "459", "1", "93.180000000000", "121"),("226831", "1", "1000", "459", "1", "93.180000000000", "122"),("194739", "1", "1000", "20", "1", "21.160000000000", "123"),("194743", "1", "1000", "20", "1", "21.160000000000", "124"),("194745", "1", "1000", "20", "1", "21.160000000000", "125"),("194747", "1", "1000", "20", "1", "21.160000000000", "126"),("194749", "1", "1000", "20", "1", "21.160000000000", "127"),("194751", "1", "1000", "20", "1", "21.160000000000", "128"),("72020", "2", "4", "145", "1", "25.120000000000", "129"),("73672", "2", "4", "145", "1", "22.600000000000", "130"),("73982", "2", "4", "145", "1", "22.600000000000", "131"),("167043", "2", "4", "145", "1", "21.750000000000", "132"),("112338", "1", "4", "85", "1", "25.980000000000", "133"),("177146", "1", "1002", "11", "1", "232.970000000000", "134"),("172916", "2", "1000", "795", "1", "231.920000000000", "135"),("240193", "1", "1000", "54", "1", "242.000000000000", "136"),("237085", "2", "1008", "285", "1", "26.920000000000", "137"),("237086", "2", "1008", "285", "1", "26.920000000000", "138"),("237084", "2", "1007", "285", "1", "26.920000000000", "139"),("210559", "1", "1005", "224", "1", "13.350000000000", "140"),("214107", "1", "1002", "691", "1", "66.370000000000", "141"),("214131", "1", "1002", "691", "1", "66.370000000000", "142"),("214133", "1", "1002", "691", "1", "66.370000000000", "143"),("214135", "1", "1002", "691", "1", "66.370000000000", "144"),("214137", "1", "1002", "691", "1", "66.370000000000", "145"),("214139", "1", "1002", "691", "1", "66.370000000000", "146"),("214143", "1", "1002", "691", "1", "66.370000000000", "147"),("214145", "1", "1002", "691", "1", "66.370000000000", "148"),("214149", "1", "1002", "691", "1", "66.370000000000", "149"),("14914", "2", "1001", "115", "1", "27.640000000000", "150"),("14915", "2", "1000", "115", "1", "27.640000000000", "151"),("14916", "2", "1000", "115", "1", "27.640000000000", "152"),("160583", "2", "1000", "583", "1", "59.650000000000", "153"),("160585", "2", "1000", "583", "1", "59.650000000000", "154"),("160587", "2", "1000", "583", "1", "59.650000000000", "155"),("160591", "2", "1000", "583", "1", "59.650000000000", "156"),("147629", "1", "1000", "117", "1", "38.550000000000", "157"),("147633", "1", "1000", "117", "1", "38.550000000000", "158"),("136087", "2", "1000", "193", "1", "32.760000000000", "159"),("136089", "2", "1000", "193", "1", "32.760000000000", "160"),("136095", "2", "1000", "193", "1", "32.760000000000", "161"),("226348", "2", "1000", "459", "1", "57.040000000000", "162"),("226351", "2", "1000", "459", "1", "57.040000000000", "163"),("226833", "1", "1000", "459", "1", "93.180000000000", "164"),("210547", "1", "1000", "224", "1", "13.350000000000", "165"),("210555", "1", "1000", "224", "1", "13.350000000000", "166"),("194737", "1", "1000", "20", "1", "21.160000000000", "167"),("194741", "1", "1000", "20", "1", "21.160000000000", "168"),("194753", "1", "1000", "20", "1", "21.160000000000", "169"),("194755", "1", "1000", "20", "1", "21.160000000000", "170"),("128629", "2", "1000", "150", "1", "85.600000000000", "171"),("128631", "2", "1000", "150", "1", "85.600000000000", "172"),("168198", "1", "1000", "150", "1", "49.740000000000", "173"),("228634", "1", "1000", "85", "1", "27.790000000000", "174"),("228635", "1", "1000", "85", "1", "27.790000000000", "175"),("228636", "1", "1000", "85", "1", "27.790000000000", "176"),("228633", "1", "1000", "85", "1", "17.000000000000", "177"),("214123", "1", "1002", "691", "1", "66.370000000000", "178"),("214125", "1", "1002", "691", "1", "66.370000000000", "179"),("214141", "1", "1002", "691", "1", "66.370000000000", "180"),("214147", "1", "1002", "691", "1", "66.370000000000", "181"),("214151", "1", "1002", "691", "1", "66.370000000000", "182"),("137369", "2", "1001", "296", "1", "34.440000000000", "183"),("112340", "1", "1001", "85", "1", "27.790000000000", "184"),("162688", "2", "1000", "459", "1", "62.090000000000", "185"),("137371", "2", "1000", "296", "1", "34.440000000000", "186"),("137389", "2", "1000", "296", "1", "34.440000000000", "187"),("137391", "2", "1000", "296", "1", "34.440000000000", "188"),("137393", "2", "1000", "296", "1", "34.440000000000", "189"),("226323", "2", "1000", "459", "1", "62.090000000000", "190"),("226349", "2", "1000", "459", "1", "57.040000000000", "191"),("226350", "2", "1000", "459", "1", "57.040000000000", "192"),("226582", "2", "1000", "459", "1", "62.090000000000", "193"),("210557", "1", "1000", "224", "1", "13.350000000000", "194"),("188551", "2", "1000", "105", "1", "23.430000000000", "195"),("147651", "1", "1000", "117", "1", "38.550000000000", "196"),("228637", "1", "1000", "85", "1", "27.790000000000", "197"),("137373", "2", "3", "296", "1", "34.440000000000", "198"),("137367", "2", "2", "296", "1", "34.440000000000", "199"),("137383", "2", "2", "296", "1", "34.440000000000", "200"),("137375", "2", "1", "296", "1", "34.440000000000", "201"),("233356", "1", "1000", "122", "1", "233.600000000000", "202"),("232475", "1", "4", "122", "1", "118.470000000000", "203"),("66951", "2", "1002", "105", "1", "22.680000000000", "204"),("66900", "2", "1000", "105", "1", "23.430000000000", "205"),("169481", "2", "1000", "603", "1", "82.340000000000", "206"),("169483", "2", "1000", "603", "1", "82.340000000000", "207"),("169486", "2", "1000", "603", "1", "82.340000000000", "208"),("169488", "2", "1000", "603", "1", "82.340000000000", "209"),("169494", "2", "1000", "603", "1", "82.340000000000", "210"),("226577", "2", "1000", "459", "1", "62.090000000000", "211"),("226578", "2", "1000", "459", "1", "62.090000000000", "212"),("226580", "2", "1000", "459", "1", "62.090000000000", "213"),("231588", "2", "1000", "193", "1", "17.300000000000", "214"),("231589", "2", "1000", "193", "1", "17.300000000000", "215"),("231590", "2", "1000", "193", "1", "17.300000000000", "216"),("231591", "2", "1000", "193", "1", "17.300000000000", "217"),("235345", "1", "1000", "224", "1", "9.150000000000", "218"),("213655", "1", "1000", "224", "1", "14.190000000000", "219"),("241856", "2", "1000", "193", "1", "30.240000000000", "220"),("241857", "2", "1000", "193", "1", "30.240000000000", "221"),("241858", "2", "1000", "193", "1", "30.240000000000", "222"),("241859", "2", "1000", "193", "1", "30.240000000000", "223"),("241860", "2", "1000", "193", "1", "30.240000000000", "224"),("241861", "2", "1000", "193", "1", "30.240000000000", "225"),("236639", "1", "1000", "85", "1", "29.400000000000", "226"),("127901", "1", "1000", "150", "1", "67.060000000000", "227"),("66897", "2", "1", "105", "1", "19.230000000000", "228"),("66898", "2", "1", "105", "1", "23.430000000000", "229"),("81364", "2", "1", "105", "1", "22.680000000000", "230"),("232448", "1", "1001", "122", "1", "333.600000000000", "231"),("137361", "2", "1001", "296", "1", "34.440000000000", "232"),("188553", "2", "1001", "105", "1", "23.430000000000", "233"),("155777", "2", "1001", "85", "1", "11.200000000000", "234"),("169490", "2", "1000", "603", "1", "82.340000000000", "235"),("137355", "2", "1000", "296", "1", "34.440000000000", "236"),("137359", "2", "1000", "296", "1", "34.440000000000", "237"),("226321", "2", "1000", "459", "1", "62.090000000000", "238"),("226322", "2", "1000", "459", "1", "62.090000000000", "239"),("226579", "2", "1000", "459", "1", "62.090000000000", "240"),("230721", "1", "1000", "693", "1", "86.540000000000", "241"),("230723", "1", "1000", "693", "1", "86.540000000000", "242"),("155779", "2", "1000", "85", "1", "11.200000000000", "243"),("155781", "2", "1000", "85", "1", "11.200000000000", "244"),("66952", "2", "5", "105", "1", "22.680000000000", "245"),("182607", "1", "2", "701", "1", "69.740000000000", "246"),("182609", "1", "2", "701", "1", "69.740000000000", "247"),("182605", "1", "2", "701", "1", "69.740000000000", "248"),("182617", "1", "1002", "701", "1", "69.740000000000", "249"),("169489", "2", "1000", "603", "1", "82.340000000000", "250"),("169491", "2", "1000", "603", "1", "82.340000000000", "251"),("169492", "2", "1000", "603", "1", "82.340000000000", "252"),("184015", "1", "1000", "701", "1", "36.030000000000", "253"),("184017", "1", "1000", "701", "1", "36.030000000000", "254"),("230722", "1", "1000", "693", "1", "86.540000000000", "255"),("182601", "1", "2", "701", "1", "69.740000000000", "256"),("91414", "2", "1000", "677", "1", "185.620000000000", "257"),("223642", "1", "1000", "296", "1", "37.800000000000", "258"),("223643", "1", "1000", "296", "1", "37.800000000000", "259"),("223644", "1", "1000", "296", "1", "37.800000000000", "260"),("223645", "1", "1000", "296", "1", "37.800000000000", "261"),("223646", "1", "1000", "296", "1", "37.800000000000", "262"),("184019", "1", "1000", "701", "1", "36.030000000000", "263"),("243649", "1", "1000", "117", "1", "36.030000000000", "264"),("169070", "2", "1012", "87", "1", "47.040000000000", "265"),("169087", "2", "1003", "87", "1", "54.610000000000", "266"),("218391", "1", "1000", "749", "1", "23.430000000000", "267"),("240240", "1", "1000", "124", "1", "100.830000000000", "268"),("177556", "1", "1000", "11", "1", "118.110000000000", "269"),("188603", "2", "10", "87", "1", "28.310000000000", "270"),("154963", "2", "1", "192", "1", "665.450000000000", "271"),("182961", "1", "1002", "701", "1", "31.080000000000", "272"),("168240", "2", "1000", "115", "1", "367.130000000000", "273"),("188765", "1", "1000", "87", "1", "133.150000000000", "274"),("199169", "1", "1000", "87", "1", "105.790000000000", "275"),("182963", "1", "1002", "701", "1", "31.080000000000", "276"),("246520", "1", "1000", "122", "1", "24.360000000000", "277"),("246521", "1", "1000", "122", "1", "24.360000000000", "278"),("246522", "1", "1000", "122", "1", "24.360000000000", "279"),("246523", "1", "1000", "122", "1", "24.360000000000", "280"),("246528", "1", "1000", "122", "1", "24.360000000000", "281"),("247396", "1", "1000", "122", "1", "24.360000000000", "282"),("247397", "1", "1000", "122", "1", "24.360000000000", "283"),("247398", "1", "1000", "122", "1", "24.360000000000", "284"),("247399", "1", "1000", "122", "1", "24.360000000000", "285"),("240232", "1", "1000", "124", "1", "110.910000000000", "286"),("169187", "2", "1", "87", "1", "125.200000000000", "287"),("246526", "1", "1000", "122", "1", "24.360000000000", "288"),("246529", "1", "1000", "122", "1", "24.360000000000", "289"),("199171", "1", "1000", "87", "1", "189.870000000000", "290"),("220820", "1", "1000", "105", "1", "203.260000000000", "291"),("246525", "1", "1000", "122", "1", "24.360000000000", "292"),("220817", "1", "1001", "105", "1", "203.260000000000", "293"),("231411", "2", "1000", "124", "1", "178.140000000000", "294"),("231415", "2", "1000", "124", "1", "152.090000000000", "295"),("194515", "2", "1", "87", "1", "134.440000000000", "296"),("245451", "2", "1002", "170", "1", "168.690000000000", "297"),("178260", "2", "1000", "122", "1", "143.690000000000", "298"),("244081", "1", "1000", "11", "1", "169.740000000000", "299"),("231340", "2", "1001", "124", "1", "72.260000000000", "300"),("231269", "2", "1000", "124", "1", "194.110000000000", "301"),("175524", "1", "0", "11", "1", "46.650000000000", "302"),("175525", "1", "0", "11", "1", "44.110000000000", "303"),("175522", "1", "0", "11", "1", "42.410000000000", "304"),("105083", "2", "0", "42", "1", "20.500000000000", "305"),("105086", "2", "0", "42", "1", "20.500000000000", "306"),("230285", "2", "0", "42", "1", "20.500000000000", "307"),("172262", "1", "0", "658", "1", "20.800000000000", "308"),("171993", "1", "0", "658", "1", "15.600000000000", "309"),("172007", "1", "0", "658", "1", "26.000000000000", "310"),("120159", "2", "0", "280", "1", "3.320000000000", "311"),("120167", "2", "0", "280", "1", "3.320000000000", "312"),("120170", "2", "0", "280", "1", "3.533000000000", "313"),("176004", "2", "0", "117", "1", "185.000000000000", "314"),("201909", "1", "0", "11", "1", "110.040000000000", "315"),("120144", "2", "0", "280", "1", "3.320000000000", "316"),("141299", "2", "0", "12", "1", "85.760000000000", "317"),("168197", "1", "0", "150", "1", "38.260000000000", "318"),("163745", "1", "0", "459", "1", "42.000000000000", "319"),("174211", "1", "0", "649", "1", "13.500000000000", "320"),("147627", "1", "0", "117", "1", "29.000000000000", "321"),("147645", "1", "0", "117", "1", "29.000000000000", "322"),("226832", "1", "0", "459", "1", "72.000000000000", "323"),("218319", "1", "0", "749", "1", "44.440000000000", "324"),("218321", "1", "0", "749", "1", "44.440000000000", "325"),("174221", "1", "0", "649", "1", "13.500000000000", "326"),("101714", "1", "0", "11", "1", "181.460000000000", "327"),("168200", "1", "0", "150", "1", "38.260000000000", "328"),("160589", "2", "0", "583", "1", "35.000000000000", "329"),("218313", "1", "0", "749", "1", "44.440000000000", "330"),("218315", "1", "0", "749", "1", "44.440000000000", "331"),("218317", "1", "0", "749", "1", "44.440000000000", "332"),("168199", "1", "0", "150", "1", "38.260000000000", "333"),("137377", "2", "0", "296", "1", "22.690000000000", "334"),("137385", "2", "0", "296", "1", "22.690000000000", "335"),("137387", "2", "0", "296", "1", "22.690000000000", "336"),("137381", "2", "0", "296", "1", "22.690000000000", "337"),("232463", "1", "0", "122", "1", "81.590000000000", "338"),("169758", "1", "0", "224", "1", "4.110000000000", "339"),("169760", "1", "0", "224", "1", "9.150000000000", "340"),("169761", "1", "0", "224", "1", "9.150000000000", "341"),("188555", "2", "0", "105", "1", "13.600000000000", "342"),("195811", "1", "0", "122", "1", "326.390000000000", "343"),("137357", "2", "0", "296", "1", "22.690000000000", "344"),("137365", "2", "0", "296", "1", "22.690000000000", "345"),("137379", "2", "0", "296", "1", "22.690000000000", "346"),("134855", "1", "0", "605", "1", "180.000000000000", "347"),("5773", "2", "0", "42", "1", "66.300000000000", "348"),("223647", "1", "0", "296", "1", "37.800000000000", "349"),("223649", "1", "0", "296", "1", "37.800000000000", "350"),("223641", "1", "0", "296", "1", "37.800000000000", "351"),("223648", "1", "0", "296", "1", "37.800000000000", "352"),("170840", "1", "0", "18", "1", "95.310000000000", "353"),("159299", "1", "0", "271", "1", "61.900000000000", "354"),("218393", "1", "0", "749", "1", "23.430000000000", "355"),("240258", "1", "0", "54", "1", "161.310000000000", "356"),("240259", "1", "0", "54", "1", "161.310000000000", "357"),("131169", "1", "0", "17", "1", "61.180000000000", "358"),("198121", "1", "0", "119", "1", "61.730000000000", "359"),("87667", "2", "0", "17", "1", "206.000000000000", "360"),("83892", "2", "0", "163", "1", "156.260000000000", "361"),("172934", "2", "0", "795", "1", "176.790000000000", "362"),("173721", "1", "0", "583", "1", "761.330000000000", "363"),("222242", "1", "0", "67", "1", "145.790000000000", "364"),("240308", "1", "0", "54", "1", "172.860000000000", "365"),("143451", "1", "0", "17", "1", "97.000000000000", "366"),("194657", "2", "0", "87", "1", "182.020000000000", "367"),("232396", "1", "0", "122", "1", "95.150000000000", "368"),("196071", "2", "0", "122", "1", "310.590000000000", "369"),("244874", "1", "0", "54", "1", "144.130000000000", "370")

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'