Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '9fac36c16fcf9f61cf65256334'

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 ("9757", "2", "1000", "42", "1", "8.390000000000", "1"),("17946", "2", "1000", "42", "1", "3.510000000000", "2"),("9756", "2", "1009", "42", "1", "8.390000000000", "3"),("17944", "2", "1004", "42", "1", "3.510000000000", "4"),("70173", "2", "1000", "24", "1", "15.280000000000", "5"),("17998", "2", "1000", "42", "1", "37.800000000000", "6"),("17951", "2", "1005", "42", "1", "3.510000000000", "7"),("5745", "2", "1002", "42", "1", "7.550000000000", "8"),("17970", "2", "1000", "42", "1", "5.020000000000", "9"),("17981", "2", "1000", "42", "1", "5.450000000000", "10"),("5753", "2", "1000", "42", "1", "13.430000000000", "11"),("226683", "2", "20", "97", "1", "5.700000000000", "12"),("59456", "2", "9", "97", "1", "5.870000000000", "13"),("63552", "2", "4", "97", "1", "5.450000000000", "14"),("59451", "2", "3", "97", "1", "5.450000000000", "15"),("234597", "1", "1000", "455", "1", "26.130000000000", "16"),("17959", "2", "1005", "42", "1", "3.350000000000", "17"),("172594", "2", "1000", "401", "1", "8.440000000000", "18"),("188795", "2", "1000", "401", "1", "8.310000000000", "19"),("1506", "2", "1006", "42", "1", "6.710000000000", "20"),("127715", "2", "1000", "11", "1", "16.630000000000", "21"),("206085", "1", "1005", "224", "1", "8.310000000000", "22"),("142543", "1", "1000", "48", "1", "23.510000000000", "23"),("142553", "1", "1000", "48", "1", "28.550000000000", "24"),("142573", "1", "1000", "48", "1", "23.510000000000", "25"),("236020", "1", "1003", "224", "1", "10.830000000000", "26"),("235958", "2", "1000", "97", "1", "7.460000000000", "27"),("18000", "2", "1003", "42", "1", "6.710000000000", "28"),("89836", "2", "1000", "423", "1", "8.220000000000", "29"),("89838", "2", "1000", "423", "1", "8.220000000000", "30"),("163830", "2", "9", "13", "1", "5.790000000000", "31"),("163833", "2", "1", "13", "1", "5.790000000000", "32"),("167128", "1", "1000", "193", "1", "10.490000000000", "33"),("89841", "2", "1001", "423", "1", "5.620000000000", "34"),("89842", "2", "1001", "423", "1", "5.620000000000", "35"),("18003", "2", "1000", "42", "1", "13.430000000000", "36"),("131063", "2", "1000", "206", "1", "9.980000000000", "37"),("131065", "2", "1000", "206", "1", "9.980000000000", "38"),("131067", "2", "1000", "206", "1", "9.980000000000", "39"),("131091", "2", "1000", "206", "1", "15.020000000000", "40"),("131093", "2", "1000", "206", "1", "15.020000000000", "41"),("47598", "2", "5", "12", "1", "6.120000000000", "42"),("46076", "2", "2", "12", "1", "15.240000000000", "43"),("70175", "2", "1001", "24", "1", "15.280000000000", "44"),("15589", "2", "1000", "115", "1", "38.550000000000", "45"),("17950", "2", "1000", "42", "1", "3.510000000000", "46"),("17968", "2", "1000", "42", "1", "5.020000000000", "47"),("17980", "2", "1000", "42", "1", "5.020000000000", "48"),("5747", "2", "1000", "42", "1", "8.810000000000", "49"),("5846", "2", "1000", "42", "1", "7.130000000000", "50"),("131075", "2", "1000", "206", "1", "11.670000000000", "51"),("110995", "2", "1000", "279", "1", "106.630000000000", "52"),("227418", "1", "1000", "370", "1", "12.380000000000", "53"),("227425", "1", "1000", "370", "1", "6.880000000000", "54"),("227477", "1", "1000", "370", "1", "6.370000000000", "55"),("70171", "2", "1000", "24", "1", "13.010000000000", "56"),("70174", "2", "1000", "24", "1", "15.280000000000", "57"),("167134", "1", "1001", "193", "1", "10.910000000000", "58"),("17957", "2", "1002", "42", "1", "3.350000000000", "59"),("111007", "2", "1000", "279", "1", "118.390000000000", "60"),("54906", "2", "2", "279", "1", "59.560000000000", "61"),("54909", "2", "1", "279", "1", "59.560000000000", "62"),("145433", "2", "22", "12", "1", "9.190000000000", "63"),("63556", "2", "7", "97", "1", "4.610000000000", "64"),("63558", "2", "6", "97", "1", "4.610000000000", "65"),("63553", "2", "5", "97", "1", "5.020000000000", "66"),("63559", "2", "2", "97", "1", "4.610000000000", "67"),("63557", "2", "2", "97", "1", "4.610000000000", "68"),("38843", "2", "1000", "279", "1", "118.390000000000", "69"),("38844", "2", "1000", "279", "1", "118.390000000000", "70"),("110989", "2", "1000", "279", "1", "118.390000000000", "71"),("110997", "2", "1000", "279", "1", "106.630000000000", "72"),("110999", "2", "1000", "279", "1", "106.630000000000", "73"),("111000", "2", "1000", "279", "1", "106.630000000000", "74"),("159775", "2", "1", "279", "1", "83.100000000000", "75"),("159783", "2", "1", "279", "1", "83.100000000000", "76"),("127713", "2", "1000", "11", "1", "16.200000000000", "77"),("195419", "2", "1000", "388", "1", "17.640000000000", "78"),("227414", "1", "1001", "528", "1", "84.520000000000", "79"),("159779", "2", "1000", "279", "1", "106.630000000000", "80"),("110983", "2", "1000", "279", "1", "118.390000000000", "81"),("110990", "2", "1000", "279", "1", "118.390000000000", "82"),("142541", "1", "1000", "48", "1", "22.600000000000", "83"),("142547", "1", "1000", "48", "1", "27.300000000000", "84"),("142549", "1", "1000", "48", "1", "27.300000000000", "85"),("142557", "1", "1000", "48", "1", "31.830000000000", "86"),("142559", "1", "1000", "48", "1", "31.830000000000", "87"),("142571", "1", "1000", "48", "1", "22.600000000000", "88"),("142577", "1", "1000", "48", "1", "26.880000000000", "89"),("142599", "1", "1000", "48", "1", "33.600000000000", "90"),("185627", "2", "1000", "455", "1", "50.710000000000", "91"),("185629", "2", "1000", "455", "1", "50.710000000000", "92"),("206603", "1", "1000", "517", "1", "17.380000000000", "93"),("206605", "1", "1000", "517", "1", "15.450000000000", "94"),("159777", "2", "1", "279", "1", "83.100000000000", "95"),("165762", "1", "1", "467", "1", "4.780000000000", "96"),("110987", "2", "1", "279", "1", "118.390000000000", "97"),("114837", "2", "1002", "189", "1", "9.150000000000", "98"),("100695", "2", "1000", "177", "1", "18.390000000000", "99"),("100697", "2", "1000", "177", "1", "18.390000000000", "100"),("185621", "2", "1000", "455", "1", "50.710000000000", "101"),("185623", "2", "1000", "455", "1", "50.710000000000", "102"),("185625", "2", "1000", "455", "1", "50.710000000000", "103"),("185631", "2", "1000", "455", "1", "50.710000000000", "104"),("203997", "2", "1000", "455", "1", "50.710000000000", "105"),("245107", "1", "1000", "54", "1", "15.120000000000", "106"),("235959", "2", "1000", "97", "1", "9.150000000000", "107"),("230897", "2", "1000", "85", "1", "41.170000000000", "108"),("238581", "1", "5", "85", "1", "57.970000000000", "109"),("68128", "2", "1", "85", "1", "14.270000000000", "110"),("87254", "2", "1", "469", "1", "14.190000000000", "111"),("113111", "2", "1001", "31", "1", "236.120000000000", "112"),("113086", "2", "1000", "31", "1", "257.970000000000", "113"),("135945", "1", "1000", "193", "1", "10.490000000000", "114"),("219826", "2", "1000", "455", "1", "50.710000000000", "115"),("219827", "2", "1000", "455", "1", "50.710000000000", "116"),("219828", "2", "1000", "455", "1", "50.710000000000", "117"),("241200", "2", "1000", "455", "1", "50.710000000000", "118"),("241201", "2", "1000", "455", "1", "50.710000000000", "119"),("241202", "2", "1000", "455", "1", "50.710000000000", "120"),("92592", "2", "1000", "85", "1", "21.600000000000", "121"),("230898", "2", "1000", "85", "1", "41.170000000000", "122"),("230901", "2", "1000", "85", "1", "41.170000000000", "123"),("234576", "2", "1005", "455", "1", "54.490000000000", "124"),("234580", "2", "1005", "455", "1", "54.490000000000", "125"),("234578", "2", "1000", "455", "1", "54.490000000000", "126"),("146593", "1", "1000", "85", "1", "26.630000000000", "127"),("1505", "2", "1004", "42", "1", "6.710000000000", "128"),("1507", "2", "1002", "42", "1", "6.710000000000", "129"),("1492", "2", "1000", "42", "1", "5.620000000000", "130"),("1493", "2", "1000", "42", "1", "5.620000000000", "131"),("1494", "2", "1000", "42", "1", "5.620000000000", "132"),("1504", "2", "1000", "42", "1", "6.710000000000", "133"),("118475", "2", "1000", "105", "1", "11.670000000000", "134"),("118491", "2", "1000", "105", "1", "11.670000000000", "135"),("231442", "1", "1000", "294", "1", "151.750000000000", "136"),("236879", "1", "1000", "85", "1", "37.800000000000", "137"),("135949", "1", "1000", "193", "1", "10.910000000000", "138"),("231446", "1", "1000", "294", "1", "156.280000000000", "139"),("244395", "-100", "1008", "13", "1", "6.630000000000", "140"),("70426", "2", "1", "185", "1", "31.920000000000", "141"),("246801", "2", "1005", "809", "1", "27.720000000000", "142"),("206127", "1", "1000", "224", "1", "10.830000000000", "143"),("72165", "2", "1000", "189", "1", "14.190000000000", "144"),("131071", "2", "1000", "206", "1", "11.670000000000", "145"),("114836", "2", "1000", "189", "1", "9.980000000000", "146"),("114838", "2", "1000", "189", "1", "9.150000000000", "147"),("224337", "2", "1000", "771", "1", "23.510000000000", "148"),("224338", "2", "1000", "771", "1", "23.510000000000", "149"),("224342", "2", "1000", "771", "1", "23.510000000000", "150"),("224343", "2", "1000", "771", "1", "23.510000000000", "151"),("100397", "2", "1001", "177", "1", "34.360000000000", "152"),("197575", "2", "1", "229", "1", "11.750000000000", "153"),("213319", "1", "1001", "224", "1", "33.510000000000", "154"),("197577", "2", "9", "229", "1", "11.750000000000", "155"),("213317", "1", "1000", "224", "1", "33.510000000000", "156"),("197579", "2", "8", "229", "1", "11.750000000000", "157"),("105860", "1", "1000", "58", "1", "17.550000000000", "158"),("105861", "1", "1000", "58", "1", "18.390000000000", "159"),("105859", "1", "1000", "58", "1", "17.550000000000", "160"),("230056", "2", "1001", "285", "1", "14.400000000000", "161"),("105299", "1", "1000", "58", "1", "10.830000000000", "162"),("105300", "1", "1", "58", "1", "10.830000000000", "163"),("58820", "2", "10", "285", "1", "11.980000000000", "164"),("115081", "2", "1", "12", "1", "15.030000000000", "165"),("175683", "2", "1000", "124", "1", "12.650000000000", "166"),("175684", "2", "1000", "124", "1", "12.650000000000", "167"),("100385", "2", "1000", "177", "1", "34.360000000000", "168"),("100386", "2", "1000", "177", "1", "34.360000000000", "169"),("105078", "2", "1000", "42", "1", "26.880000000000", "170"),("105080", "2", "1000", "42", "1", "26.880000000000", "171"),("98181", "2", "1000", "177", "1", "34.360000000000", "172"),("110543", "2", "1", "12", "1", "8.270000000000", "173"),("142633", "2", "1000", "48", "1", "20.990000000000", "174"),("142635", "2", "1000", "48", "1", "18.470000000000", "175"),("142647", "2", "1000", "48", "1", "18.470000000000", "176"),("171763", "1", "1004", "658", "1", "33.760000000000", "177"),("171761", "1", "1002", "658", "1", "33.760000000000", "178"),("171766", "1", "1002", "658", "1", "33.760000000000", "179"),("171768", "1", "1002", "658", "1", "33.760000000000", "180"),("171762", "1", "2", "658", "1", "33.760000000000", "181"),("171764", "1", "2", "658", "1", "33.760000000000", "182"),("171767", "1", "2", "658", "1", "33.760000000000", "183"),("171769", "1", "1002", "658", "1", "33.760000000000", "184"),("120734", "1", "1002", "85", "1", "13.850000000000", "185"),("138253", "1", "1000", "85", "1", "12.000000000000", "186"),("138255", "1", "1000", "85", "1", "12.000000000000", "187"),("244919", "2", "1000", "122", "1", "22.680000000000", "188"),("244920", "2", "1000", "122", "1", "22.680000000000", "189"),("244921", "2", "1000", "122", "1", "22.680000000000", "190"),("138259", "1", "1001", "85", "1", "12.000000000000", "191"),("138251", "1", "1000", "85", "1", "12.000000000000", "192"),("138257", "1", "1000", "85", "1", "12.000000000000", "193"),("144409", "1", "1000", "85", "1", "12.000000000000", "194"),("138271", "1", "1000", "85", "1", "33.830000000000", "195"),("120736", "1", "1000", "85", "1", "13.850000000000", "196"),("120738", "1", "1000", "85", "1", "13.850000000000", "197"),("187117", "2", "1000", "122", "1", "57.970000000000", "198"),("244916", "2", "1000", "122", "1", "22.680000000000", "199"),("244917", "2", "1000", "122", "1", "22.680000000000", "200"),("244922", "2", "1000", "122", "1", "22.680000000000", "201"),("244923", "2", "1000", "122", "1", "22.680000000000", "202"),("246850", "1", "1000", "745", "1", "15.450000000000", "203"),("246851", "1", "1000", "745", "1", "15.450000000000", "204"),("246853", "1", "1000", "745", "1", "15.450000000000", "205"),("191739", "1", "1000", "54", "1", "29.400000000000", "206"),("120740", "1", "1001", "85", "1", "13.850000000000", "207"),("120732", "1", "1000", "85", "1", "13.850000000000", "208"),("120742", "1", "1000", "85", "1", "13.850000000000", "209"),("224294", "1", "1000", "337", "1", "36.960000000000", "210"),("224295", "1", "1000", "337", "1", "36.960000000000", "211"),("224296", "1", "1000", "337", "1", "36.960000000000", "212"),("224297", "1", "1000", "337", "1", "36.960000000000", "213"),("224299", "1", "1000", "337", "1", "36.960000000000", "214"),("224300", "1", "1000", "337", "1", "36.960000000000", "215"),("224304", "1", "1000", "337", "1", "36.960000000000", "216"),("224305", "1", "1000", "337", "1", "36.960000000000", "217"),("224306", "1", "1000", "337", "1", "36.960000000000", "218"),("224307", "1", "1000", "337", "1", "36.960000000000", "219"),("224308", "1", "1000", "337", "1", "36.960000000000", "220"),("224309", "1", "1000", "337", "1", "36.960000000000", "221"),("224310", "1", "1000", "337", "1", "36.960000000000", "222"),("246848", "1", "1000", "745", "1", "15.450000000000", "223"),("246852", "1", "1000", "745", "1", "15.450000000000", "224"),("246854", "1", "1000", "745", "1", "15.450000000000", "225"),("191727", "1", "1005", "54", "1", "37.800000000000", "226"),("191719", "1", "1003", "54", "1", "37.800000000000", "227"),("191733", "1", "1003", "54", "1", "37.800000000000", "228"),("191731", "1", "1002", "54", "1", "37.800000000000", "229"),("246849", "1", "1000", "745", "1", "15.450000000000", "230"),("246654", "1", "1000", "745", "1", "25.120000000000", "231"),("246656", "1", "1000", "745", "1", "25.120000000000", "232"),("246658", "1", "1000", "745", "1", "25.120000000000", "233"),("167193", "1", "1000", "360", "1", "19.700000000000", "234"),("156505", "1", "5", "360", "1", "19.700000000000", "235"),("98485", "2", "1001", "117", "1", "36.880000000000", "236"),("98487", "2", "1001", "117", "1", "36.880000000000", "237"),("98488", "2", "1000", "117", "1", "39.400000000000", "238"),("229233", "2", "1000", "117", "1", "39.400000000000", "239"),("207803", "2", "1000", "117", "1", "39.400000000000", "240"),("98484", "2", "1000", "117", "1", "36.880000000000", "241"),("246653", "1", "1000", "745", "1", "25.120000000000", "242"),("246655", "1", "1000", "745", "1", "25.120000000000", "243"),("246657", "1", "1000", "745", "1", "25.120000000000", "244"),("246659", "1", "1000", "745", "1", "25.120000000000", "245"),("246660", "1", "1000", "745", "1", "25.120000000000", "246"),("246661", "1", "1000", "745", "1", "25.120000000000", "247"),("246662", "1", "1000", "745", "1", "25.120000000000", "248"),("246663", "1", "1000", "745", "1", "25.120000000000", "249"),("246664", "1", "1000", "745", "1", "25.120000000000", "250"),("246665", "1", "1000", "745", "1", "25.120000000000", "251"),("246666", "1", "1000", "745", "1", "25.120000000000", "252"),("246486", "1", "1000", "122", "1", "20.990000000000", "253"),("246488", "1", "1000", "122", "1", "20.990000000000", "254"),("246491", "1", "1000", "122", "1", "20.990000000000", "255"),("246493", "1", "1000", "122", "1", "20.990000000000", "256"),("246494", "1", "1000", "122", "1", "20.990000000000", "257"),("246497", "1", "1000", "122", "1", "20.990000000000", "258"),("246498", "1", "1000", "122", "1", "20.990000000000", "259"),("165797", "2", "1003", "67", "1", "16.210000000000", "260"),("246496", "1", "1000", "122", "1", "20.990000000000", "261"),("191721", "1", "1005", "54", "1", "37.800000000000", "262"),("191723", "1", "1003", "54", "1", "37.800000000000", "263"),("246487", "1", "1000", "122", "1", "20.990000000000", "264"),("246489", "1", "1000", "122", "1", "20.990000000000", "265"),("246490", "1", "1000", "122", "1", "20.990000000000", "266"),("246495", "1", "1000", "122", "1", "20.990000000000", "267"),("191729", "1", "1005", "54", "1", "37.800000000000", "268"),("191725", "1", "1004", "54", "1", "37.800000000000", "269"),("233884", "2", "1000", "455", "1", "35.590000000000", "270"),("109479", "2", "1000", "85", "1", "23.980000000000", "271"),("146657", "2", "1000", "85", "1", "30.940000000000", "272"),("146661", "2", "1000", "85", "1", "30.940000000000", "273"),("146667", "2", "1000", "85", "1", "30.940000000000", "274"),("128515", "2", "1000", "85", "1", "26.020000000000", "275"),("233883", "2", "1000", "455", "1", "35.590000000000", "276"),("146671", "2", "1000", "85", "1", "38.030000000000", "277"),("146675", "2", "1000", "85", "1", "38.030000000000", "278"),("146665", "2", "1000", "85", "1", "34.180000000000", "279"),("146663", "2", "1000", "85", "1", "30.940000000000", "280"),("163546", "1", "1000", "455", "1", "35.590000000000", "281"),("70170", "2", "0", "24", "1", "8.480000000000", "282"),("164934", "1", "0", "517", "1", "4.940000000000", "283"),("225714", "1", "0", "528", "1", "7.550000000000", "284"),("225715", "1", "0", "528", "1", "7.130000000000", "285"),("8395", "2", "0", "42", "1", "38.000000000000", "286"),("165763", "1", "0", "467", "1", "2.770000000000", "287"),("163825", "2", "0", "13", "1", "2.500000000000", "288"),("17997", "2", "0", "42", "1", "27.000000000000", "289"),("17995", "2", "0", "42", "1", "28.000000000000", "290"),("70172", "2", "0", "24", "1", "9.500000000000", "291"),("131077", "2", "0", "206", "1", "7.000000000000", "292"),("131079", "2", "0", "206", "1", "7.000000000000", "293"),("110996", "2", "0", "279", "1", "82.000000000000", "294"),("110998", "2", "0", "279", "1", "82.000000000000", "295"),("111006", "2", "0", "279", "1", "83.000000000000", "296"),("195383", "1", "0", "388", "1", "29.000000000000", "297"),("38845", "2", "0", "279", "1", "94.000000000000", "298"),("159781", "2", "0", "279", "1", "82.000000000000", "299"),("111001", "2", "0", "279", "1", "82.000000000000", "300"),("159203", "1", "0", "517", "1", "5.930000000000", "301"),("87260", "2", "0", "469", "1", "3.790000000000", "302"),("142551", "1", "0", "48", "1", "17.650000000000", "303"),("142579", "1", "0", "48", "1", "18.490000000000", "304"),("142591", "1", "0", "48", "1", "19.330000000000", "305"),("142597", "1", "0", "48", "1", "21.010000000000", "306"),("227415", "1", "0", "528", "1", "84.520000000000", "307"),("8149", "2", "0", "42", "1", "97.000000000000", "308"),("222574", "1", "0", "528", "1", "5.280000000000", "309"),("222575", "1", "0", "528", "1", "5.280000000000", "310"),("100692", "2", "0", "177", "1", "14.000000000000", "311"),("100694", "2", "0", "177", "1", "14.000000000000", "312"),("230903", "2", "0", "85", "1", "30.840000000000", "313"),("230902", "2", "0", "85", "1", "30.840000000000", "314"),("230900", "2", "0", "85", "1", "30.840000000000", "315"),("230896", "2", "0", "85", "1", "30.840000000000", "316"),("238462", "1", "0", "85", "1", "17.990000000000", "317"),("236986", "1", "0", "85", "1", "25.700000000000", "318"),("230899", "2", "0", "85", "1", "30.840000000000", "319"),("238580", "1", "0", "85", "1", "43.700000000000", "320"),("47583", "2", "0", "42", "1", "129.000000000000", "321"),("234570", "2", "0", "455", "1", "32.480000000000", "322"),("234572", "2", "0", "455", "1", "32.480000000000", "323"),("234574", "2", "0", "455", "1", "32.480000000000", "324"),("97713", "2", "0", "469", "1", "2.100000000000", "325"),("97714", "2", "0", "469", "1", "2.300000000000", "326"),("95648", "2", "0", "85", "1", "17.990000000000", "327"),("231441", "1", "0", "294", "1", "105.499000000000", "328"),("231445", "1", "0", "294", "1", "105.499000000000", "329"),("218447", "1", "0", "749", "1", "120.070000000000", "330"),("121070", "1", "0", "528", "1", "51.020000000000", "331"),("226628", "2", "0", "185", "1", "36.120000000000", "332"),("224336", "2", "0", "771", "1", "23.510000000000", "333"),("224339", "2", "0", "771", "1", "23.510000000000", "334"),("224340", "2", "0", "771", "1", "23.510000000000", "335"),("224341", "2", "0", "771", "1", "23.510000000000", "336"),("100401", "2", "0", "177", "1", "25.000000000000", "337"),("100402", "2", "0", "177", "1", "25.000000000000", "338"),("16228", "2", "0", "42", "1", "25.500000000000", "339"),("239400", "1", "0", "124", "1", "24.420000000000", "340"),("239398", "1", "0", "124", "1", "24.420000000000", "341"),("239397", "1", "0", "124", "1", "24.420000000000", "342"),("239399", "1", "0", "124", "1", "24.420000000000", "343"),("197581", "2", "0", "229", "1", "11.750000000000", "344"),("231500", "1", "0", "294", "1", "64.520000000000", "345"),("231502", "1", "0", "294", "1", "64.520000000000", "346"),("105858", "1", "0", "58", "1", "12.000000000000", "347"),("105862", "1", "0", "58", "1", "13.000000000000", "348"),("244929", "1", "0", "124", "1", "20.800000000000", "349"),("244987", "1", "0", "124", "1", "24.420000000000", "350"),("244984", "1", "0", "124", "1", "24.420000000000", "351"),("175685", "2", "0", "124", "1", "12.070000000000", "352"),("175686", "2", "0", "124", "1", "12.070000000000", "353"),("115648", "2", "0", "124", "1", "12.070000000000", "354"),("105079", "2", "0", "42", "1", "20.000000000000", "355"),("226861", "1", "0", "459", "1", "31.000000000000", "356"),("230284", "2", "0", "42", "1", "20.000000000000", "357"),("147705", "2", "0", "177", "1", "15.000000000000", "358"),("147707", "2", "0", "177", "1", "15.000000000000", "359"),("147711", "2", "0", "177", "1", "15.000000000000", "360"),("147713", "2", "0", "177", "1", "15.000000000000", "361"),("147715", "2", "0", "177", "1", "15.000000000000", "362"),("147717", "2", "0", "177", "1", "11.540000000000", "363"),("110537", "2", "0", "12", "1", "5.310000000000", "364"),("110538", "2", "0", "12", "1", "5.310000000000", "365"),("171765", "1", "0", "658", "1", "24.390000000000", "366"),("147681", "2", "0", "117", "1", "35.000000000000", "367"),("225108", "1", "0", "528", "1", "12.610000000000", "368"),("225109", "1", "0", "528", "1", "12.610000000000", "369"),("225110", "1", "0", "528", "1", "12.610000000000", "370"),("225111", "1", "0", "528", "1", "12.610000000000", "371"),("225112", "1", "0", "528", "1", "12.610000000000", "372"),("225113", "1", "0", "528", "1", "12.610000000000", "373"),("171760", "1", "0", "658", "1", "30.490000000000", "374"),("247116", "2", "0", "117", "1", "43.600000000000", "375"),("138269", "1", "0", "85", "1", "28.460000000000", "376"),("98486", "2", "0", "117", "1", "27.000000000000", "377"),("246359", "1", "0", "122", "1", "14.140000000000", "378"),("246360", "1", "0", "122", "1", "14.140000000000", "379"),("246361", "1", "0", "122", "1", "14.140000000000", "380"),("246362", "1", "0", "122", "1", "14.140000000000", "381"),("246365", "1", "0", "122", "1", "14.140000000000", "382"),("246367", "1", "0", "122", "1", "14.140000000000", "383"),("246368", "1", "0", "122", "1", "14.140000000000", "384"),("246369", "1", "0", "122", "1", "14.140000000000", "385"),("246370", "1", "0", "122", "1", "14.140000000000", "386"),("244857", "1", "0", "122", "1", "38.560000000000", "387"),("246363", "1", "0", "122", "1", "14.140000000000", "388"),("246364", "1", "0", "122", "1", "14.140000000000", "389"),("246366", "1", "0", "122", "1", "14.140000000000", "390"),("145535", "2", "0", "67", "1", "14.800000000000", "391"),("109527", "2", "0", "85", "1", "15.330000000000", "392"),("146659", "2", "0", "85", "1", "24.490000000000", "393")

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'