Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '57c6baa9b867125c3a5dda6a71'

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 ("170099", "2", "1001", "192", "1", "427.730000000000", "1"),("170122", "2", "1001", "192", "1", "492.440000000000", "2"),("170125", "2", "1001", "192", "1", "587.390000000000", "3"),("170128", "2", "1001", "192", "1", "613.450000000000", "4"),("170129", "2", "1001", "192", "1", "646.220000000000", "5"),("170126", "2", "1001", "192", "1", "578.990000000000", "6"),("170131", "2", "1001", "192", "1", "663.030000000000", "7"),("170123", "2", "1001", "192", "1", "553.780000000000", "8"),("170124", "2", "1001", "192", "1", "563.030000000000", "9"),("170127", "2", "1001", "192", "1", "587.390000000000", "10"),("107046", "2", "1000", "192", "1", "377.310000000000", "11"),("107060", "2", "1000", "192", "1", "380.670000000000", "12"),("107214", "2", "1000", "192", "1", "1215.970000000000", "13"),("107215", "2", "1000", "192", "1", "1280.670000000000", "14"),("129051", "1", "1000", "192", "1", "1015.130000000000", "15"),("129053", "1", "1000", "192", "1", "1102.520000000000", "16"),("129055", "1", "1000", "192", "1", "974.790000000000", "17"),("129057", "1", "1000", "192", "1", "1102.520000000000", "18"),("129059", "1", "1000", "192", "1", "1189.920000000000", "19"),("129065", "1", "1000", "192", "1", "1149.580000000000", "20"),("129069", "1", "1000", "192", "1", "1216.810000000000", "21"),("129071", "1", "1000", "192", "1", "1236.970000000000", "22"),("129073", "1", "1000", "192", "1", "1284.030000000000", "23"),("170087", "2", "1000", "192", "1", "3605.040000000000", "24"),("170088", "2", "1000", "192", "1", "3605.040000000000", "25"),("170113", "2", "1000", "192", "1", "461.340000000000", "26"),("131303", "1", "1001", "192", "1", "826.050000000000", "27"),("154953", "2", "1001", "192", "1", "831.930000000000", "28"),("154955", "2", "1001", "192", "1", "857.140000000000", "29"),("154957", "2", "1001", "192", "1", "857.140000000000", "30"),("154959", "2", "1001", "192", "1", "882.350000000000", "31"),("202677", "1", "1001", "192", "1", "587.390000000000", "32"),("202679", "1", "1001", "192", "1", "612.610000000000", "33"),("202683", "1", "1001", "192", "1", "612.610000000000", "34"),("202687", "1", "1001", "192", "1", "672.270000000000", "35"),("202689", "1", "1001", "192", "1", "713.450000000000", "36"),("202691", "1", "1001", "192", "1", "739.500000000000", "37"),("154961", "2", "1001", "192", "1", "907.560000000000", "38"),("202673", "1", "1001", "192", "1", "504.200000000000", "39"),("54583", "2", "1000", "192", "1", "1220.170000000000", "40"),("107102", "2", "1000", "192", "1", "627.730000000000", "41"),("107104", "2", "1000", "192", "1", "752.940000000000", "42"),("107488", "2", "1000", "192", "1", "1966.390000000000", "43"),("129321", "1", "1000", "192", "1", "382.350000000000", "44"),("129093", "1", "1000", "192", "1", "1047.900000000000", "45"),("129097", "1", "1000", "192", "1", "1122.690000000000", "46"),("129101", "1", "1000", "192", "1", "1163.030000000000", "47"),("129103", "1", "1000", "192", "1", "1189.920000000000", "48"),("129109", "1", "1000", "192", "1", "1257.140000000000", "49"),("154283", "2", "1000", "192", "1", "477.310000000000", "50"),("154935", "2", "1000", "192", "1", "731.090000000000", "51"),("131301", "1", "1000", "192", "1", "763.030000000000", "52"),("154933", "2", "1000", "192", "1", "705.880000000000", "53"),("202681", "1", "2", "192", "1", "647.060000000000", "54"),("54579", "2", "1", "192", "1", "1099.160000000000", "55"),("131299", "1", "1", "192", "1", "773.110000000000", "56"),("154951", "2", "1", "192", "1", "822.690000000000", "57"),("202685", "1", "1", "192", "1", "654.620000000000", "58"),("154945", "2", "1", "192", "1", "764.710000000000", "59"),("208883", "1", "1002", "192", "1", "1469.750000000000", "60"),("170055", "2", "1001", "192", "1", "578.990000000000", "61"),("170058", "2", "1001", "192", "1", "613.450000000000", "62"),("170063", "2", "1001", "192", "1", "857.140000000000", "63"),("170064", "2", "1001", "192", "1", "805.880000000000", "64"),("170065", "2", "1001", "192", "1", "823.530000000000", "65"),("170070", "2", "1001", "192", "1", "542.020000000000", "66"),("208887", "1", "1001", "192", "1", "1528.570000000000", "67"),("170132", "2", "1001", "192", "1", "629.410000000000", "68"),("107017", "2", "1000", "192", "1", "390.760000000000", "69"),("107219", "2", "1000", "192", "1", "900.840000000000", "70"),("107220", "2", "1000", "192", "1", "952.100000000000", "71"),("107237", "2", "1000", "192", "1", "926.050000000000", "72"),("107239", "2", "1000", "192", "1", "926.050000000000", "73"),("107509", "2", "1000", "192", "1", "1613.450000000000", "74"),("107513", "2", "1000", "192", "1", "1739.500000000000", "75"),("110889", "2", "1000", "192", "1", "1226.890000000000", "76"),("128957", "1", "1000", "192", "1", "840.340000000000", "77"),("128961", "1", "1000", "192", "1", "880.670000000000", "78"),("128967", "1", "1000", "192", "1", "906.720000000000", "79"),("128869", "1", "1000", "192", "1", "651.260000000000", "80"),("128871", "1", "1000", "192", "1", "578.150000000000", "81"),("128877", "1", "1000", "192", "1", "671.430000000000", "82"),("128883", "1", "1000", "192", "1", "739.500000000000", "83"),("128885", "1", "1000", "192", "1", "705.880000000000", "84"),("128889", "1", "1000", "192", "1", "773.110000000000", "85"),("170059", "2", "1000", "192", "1", "663.030000000000", "86"),("170133", "2", "1000", "192", "1", "646.220000000000", "87"),("170134", "2", "1000", "192", "1", "671.430000000000", "88"),("154937", "2", "1000", "192", "1", "772.270000000000", "89"),("154939", "2", "1000", "192", "1", "781.510000000000", "90"),("154941", "2", "1000", "192", "1", "923.530000000000", "91"),("154943", "2", "1000", "192", "1", "873.110000000000", "92"),("202693", "1", "1000", "192", "1", "453.780000000000", "93"),("202699", "1", "1000", "192", "1", "672.270000000000", "94"),("202703", "1", "1000", "192", "1", "504.200000000000", "95"),("202695", "1", "1000", "192", "1", "478.990000000000", "96"),("208881", "1", "1000", "192", "1", "1378.150000000000", "97"),("202697", "1", "1000", "192", "1", "612.610000000000", "98"),("208885", "1", "1000", "192", "1", "1503.360000000000", "99"),("87678", "2", "1", "192", "1", "428.490000000000", "100"),("170071", "2", "1", "192", "1", "570.590000000000", "101"),("129043", "1", "1000", "192", "1", "1001.680000000000", "102"),("129045", "1", "1000", "192", "1", "1062.180000000000", "103"),("129047", "1", "1000", "192", "1", "1149.580000000000", "104"),("128851", "1", "1000", "192", "1", "658.820000000000", "105"),("154905", "2", "1000", "192", "1", "671.430000000000", "106"),("154907", "2", "1000", "192", "1", "679.830000000000", "107"),("154909", "2", "1000", "192", "1", "780.670000000000", "108"),("154911", "2", "1000", "192", "1", "898.320000000000", "109"),("154913", "2", "1000", "192", "1", "671.430000000000", "110"),("154929", "2", "1000", "192", "1", "805.880000000000", "111"),("154297", "2", "1000", "192", "1", "617.650000000000", "112"),("154975", "2", "1000", "192", "1", "798.320000000000", "113"),("154977", "2", "1000", "192", "1", "823.530000000000", "114"),("154987", "2", "1000", "192", "1", "747.060000000000", "115"),("154989", "2", "1000", "192", "1", "781.510000000000", "116"),("154991", "2", "1000", "192", "1", "844.540000000000", "117"),("154993", "2", "1000", "192", "1", "881.510000000000", "118"),("155001", "2", "1000", "192", "1", "881.510000000000", "119"),("155003", "2", "1000", "192", "1", "898.320000000000", "120"),("155005", "2", "1000", "192", "1", "923.530000000000", "121"),("155007", "2", "1000", "192", "1", "948.740000000000", "122"),("155011", "2", "1000", "192", "1", "3268.910000000000", "123"),("202363", "1", "1000", "192", "1", "1731.090000000000", "124"),("202365", "1", "1000", "192", "1", "1773.110000000000", "125"),("202367", "1", "1000", "192", "1", "1847.900000000000", "126"),("202369", "1", "1000", "192", "1", "1865.550000000000", "127"),("202425", "1", "1000", "192", "1", "578.990000000000", "128"),("202429", "1", "1000", "192", "1", "663.870000000000", "129"),("202433", "1", "1000", "192", "1", "638.660000000000", "130"),("202491", "1", "1000", "192", "1", "747.060000000000", "131"),("202499", "1", "1000", "192", "1", "705.040000000000", "132"),("154967", "2", "1000", "192", "1", "713.450000000000", "133"),("154969", "2", "1000", "192", "1", "730.250000000000", "134"),("154971", "2", "1000", "192", "1", "738.660000000000", "135"),("202361", "1", "1000", "192", "1", "1655.460000000000", "136"),("202371", "1", "1000", "192", "1", "1889.920000000000", "137"),("202427", "1", "1000", "192", "1", "638.660000000000", "138"),("202431", "1", "1000", "192", "1", "705.040000000000", "139"),("202489", "1", "1000", "192", "1", "705.040000000000", "140"),("202495", "1", "1000", "192", "1", "747.060000000000", "141"),("202701", "1", "1000", "192", "1", "621.850000000000", "142"),("154963", "2", "1", "192", "1", "663.870000000000", "143"),("205983", "1", "1001", "192", "1", "785.710000000000", "144"),("205993", "1", "1001", "192", "1", "923.530000000000", "145"),("24770", "2", "1000", "192", "1", "1023.530000000000", "146"),("107502", "2", "1000", "192", "1", "1481.510000000000", "147"),("128983", "1", "1000", "192", "1", "887.390000000000", "148"),("128985", "1", "1000", "192", "1", "852.940000000000", "149"),("129077", "1", "1000", "192", "1", "940.340000000000", "150"),("128845", "1", "1000", "192", "1", "638.660000000000", "151"),("128853", "1", "1000", "192", "1", "711.760000000000", "152"),("205985", "1", "1000", "192", "1", "822.690000000000", "153"),("205987", "1", "1000", "192", "1", "857.140000000000", "154"),("205991", "1", "1000", "192", "1", "882.350000000000", "155"),("205995", "1", "1000", "192", "1", "957.140000000000", "156"),("154915", "2", "1000", "192", "1", "679.830000000000", "157"),("202373", "1", "1000", "192", "1", "1504.200000000000", "158"),("202511", "1", "1000", "192", "1", "638.660000000000", "159"),("202519", "1", "1000", "192", "1", "805.880000000000", "160"),("202523", "1", "1000", "192", "1", "764.710000000000", "161"),("202543", "1", "1000", "192", "1", "587.390000000000", "162"),("240712", "1", "1000", "192", "1", "780.670000000000", "163"),("240713", "1", "1000", "192", "1", "814.290000000000", "164"),("240714", "1", "1000", "192", "1", "857.140000000000", "165"),("240715", "1", "1000", "192", "1", "906.720000000000", "166"),("240716", "1", "1000", "192", "1", "906.720000000000", "167"),("240717", "1", "1000", "192", "1", "948.740000000000", "168"),("240718", "1", "1000", "192", "1", "831.090000000000", "169"),("240719", "1", "1000", "192", "1", "839.500000000000", "170"),("240720", "1", "1000", "192", "1", "865.550000000000", "171"),("240721", "1", "1000", "192", "1", "948.740000000000", "172"),("240722", "1", "1000", "192", "1", "932.770000000000", "173"),("240724", "1", "1000", "192", "1", "957.140000000000", "174"),("240725", "1", "1000", "192", "1", "973.950000000000", "175"),("240726", "1", "1000", "192", "1", "999.160000000000", "176"),("240727", "1", "1000", "192", "1", "1024.370000000000", "177"),("240728", "1", "1000", "192", "1", "1058.820000000000", "178"),("240729", "1", "1000", "192", "1", "1074.790000000000", "179"),("240779", "1", "1000", "192", "1", "1116.810000000000", "180"),("240790", "1", "1000", "192", "1", "1200.840000000000", "181"),("240792", "1", "1000", "192", "1", "1268.910000000000", "182"),("240794", "1", "1000", "192", "1", "1327.730000000000", "183"),("240797", "1", "1000", "192", "1", "1327.730000000000", "184"),("240799", "1", "1000", "192", "1", "1369.750000000000", "185"),("240812", "1", "1000", "192", "1", "1605.040000000000", "186"),("240813", "1", "1000", "192", "1", "1756.300000000000", "187"),("240814", "1", "1000", "192", "1", "1839.500000000000", "188"),("240817", "1", "1000", "192", "1", "1899.160000000000", "189"),("240819", "1", "1000", "192", "1", "1966.390000000000", "190"),("240820", "1", "1000", "192", "1", "1990.760000000000", "191"),("240833", "1", "1000", "192", "1", "3444.540000000000", "192"),("240835", "1", "1000", "192", "1", "3537.820000000000", "193"),("240836", "1", "1000", "192", "1", "3554.620000000000", "194"),("240837", "1", "1000", "192", "1", "3663.870000000000", "195"),("240839", "1", "1000", "192", "1", "3714.290000000000", "196"),("240840", "1", "1000", "192", "1", "3739.500000000000", "197"),("240841", "1", "1000", "192", "1", "3773.110000000000", "198"),("205989", "1", "2", "192", "1", "882.350000000000", "199"),("107505", "2", "1000", "192", "1", "1481.510000000000", "200"),("107506", "2", "1000", "192", "1", "1537.820000000000", "201"),("107326", "2", "1000", "192", "1", "1714.290000000000", "202"),("154289", "2", "1000", "192", "1", "621.010000000000", "203"),("154295", "2", "1000", "192", "1", "679.830000000000", "204"),("202375", "1", "1000", "192", "1", "1457.980000000000", "205"),("202377", "1", "1000", "192", "1", "1679.830000000000", "206"),("240738", "1", "1000", "192", "1", "1200.840000000000", "207"),("240739", "1", "1000", "192", "1", "1302.520000000000", "208"),("240740", "1", "1000", "192", "1", "1369.750000000000", "209"),("240741", "1", "1000", "192", "1", "1218.490000000000", "210"),("240742", "1", "1000", "192", "1", "1444.540000000000", "211"),("240743", "1", "1000", "192", "1", "1452.940000000000", "212"),("240744", "1", "1000", "192", "1", "1487.390000000000", "213"),("240800", "1", "1000", "192", "1", "1385.710000000000", "214"),("240802", "1", "1000", "192", "1", "1445.380000000000", "215"),("240822", "1", "1000", "192", "1", "1578.990000000000", "216"),("240823", "1", "1000", "192", "1", "1722.690000000000", "217"),("107014", "2", "1000", "192", "1", "396.550000000000", "218"),("107015", "2", "1000", "192", "1", "403.360000000000", "219"),("208859", "1", "1000", "192", "1", "1318.490000000000", "220"),("208861", "1", "1000", "192", "1", "1436.970000000000", "221"),("128827", "1", "1000", "192", "1", "617.650000000000", "222"),("220013", "1", "1006", "13", "1", "112.520000000000", "223"),("220011", "1", "1004", "13", "1", "97.390000000000", "224"),("220012", "1", "1004", "13", "1", "104.120000000000", "225"),("220004", "1", "1005", "13", "1", "131.010000000000", "226"),("219998", "1", "1004", "13", "1", "120.080000000000", "227"),("219994", "1", "1004", "13", "1", "112.520000000000", "228"),("107062", "2", "0", "192", "1", "425.210000000000", "229"),("107063", "2", "0", "192", "1", "433.610000000000", "230"),("107213", "2", "0", "192", "1", "1196.640000000000", "231"),("170085", "2", "0", "192", "1", "2785.000000000000", "232"),("170086", "2", "0", "192", "1", "2912.000000000000", "233"),("170091", "2", "0", "192", "1", "3178.000000000000", "234"),("170130", "2", "0", "192", "1", "484.000000000000", "235"),("107216", "2", "0", "192", "1", "1309.000000000000", "236"),("170084", "2", "0", "192", "1", "2741.000000000000", "237"),("154947", "2", "0", "192", "1", "636.000000000000", "238"),("154949", "2", "0", "192", "1", "626.000000000000", "239"),("154279", "2", "0", "192", "1", "417.000000000000", "240"),("154285", "2", "0", "192", "1", "474.000000000000", "241"),("129085", "1", "0", "192", "1", "999.000000000000", "242"),("129095", "1", "0", "192", "1", "1048.000000000000", "243"),("202671", "1", "0", "192", "1", "369.000000000000", "244"),("154277", "2", "0", "192", "1", "398.000000000000", "245"),("202675", "1", "0", "192", "1", "419.000000000000", "246"),("87679", "2", "0", "192", "1", "602.520000000000", "247"),("170072", "2", "0", "192", "1", "466.000000000000", "248"),("170074", "2", "0", "192", "1", "556.000000000000", "249"),("24697", "2", "0", "192", "1", "600.800000000000", "250"),("128875", "1", "0", "192", "1", "625.000000000000", "251"),("128879", "1", "0", "192", "1", "663.000000000000", "252"),("107018", "2", "0", "192", "1", "415.000000000000", "253"),("208879", "1", "0", "192", "1", "1065.000000000000", "254"),("208891", "1", "0", "192", "1", "949.000000000000", "255"),("107238", "2", "0", "192", "1", "1001.680000000000", "256"),("154917", "2", "0", "192", "1", "521.000000000000", "257"),("154919", "2", "0", "192", "1", "531.000000000000", "258"),("154927", "2", "0", "192", "1", "599.000000000000", "259"),("202497", "1", "0", "192", "1", "599.000000000000", "260"),("202423", "1", "0", "192", "1", "469.000000000000", "261"),("154995", "2", "0", "192", "1", "734.000000000000", "262"),("154997", "2", "0", "192", "1", "651.000000000000", "263"),("154999", "2", "0", "192", "1", "680.000000000000", "264"),("202359", "1", "0", "192", "1", "1278.000000000000", "265"),("202487", "1", "0", "192", "1", "519.000000000000", "266"),("154305", "2", "0", "192", "1", "536.000000000000", "267"),("202529", "1", "0", "192", "1", "439.000000000000", "268"),("129117", "1", "0", "192", "1", "1326.000000000000", "269"),("129083", "1", "0", "192", "1", "961.000000000000", "270"),("107029", "2", "0", "192", "1", "603.000000000000", "271"),("202525", "1", "0", "192", "1", "649.000000000000", "272"),("202545", "1", "0", "192", "1", "489.000000000000", "273"),("240789", "1", "0", "192", "1", "1142.020000000000", "274"),("240796", "1", "0", "192", "1", "1277.310000000000", "275"),("240834", "1", "0", "192", "1", "3511.760000000000", "276"),("240816", "1", "0", "192", "1", "1873.950000000000", "277"),("154293", "2", "0", "192", "1", "501.000000000000", "278"),("208865", "1", "0", "192", "1", "1071.000000000000", "279"),("208867", "1", "0", "192", "1", "1185.000000000000", "280"),("208863", "1", "0", "192", "1", "968.000000000000", "281"),("240824", "1", "0", "192", "1", "1873.950000000000", "282"),("240825", "1", "0", "192", "1", "2049.580000000000", "283"),("128847", "1", "0", "192", "1", "664.000000000000", "284"),("208857", "1", "0", "192", "1", "948.000000000000", "285"),("235147", "1", "0", "11", "1", "767.940000000000", "286")

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 *
FROM oc_url_alias
WHERE `query` = 'product_id=129055'

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