Căutare

SELECT data
FROM `oc_session`
WHERE session_id = '810a0bf919ccd97ae960d42340'

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 ("94689", "2", "1000", "20", "1", "24.120000000000", "1"),("94685", "2", "0", "20", "1", "17.210000000000", "2"),("94688", "2", "0", "20", "1", "17.210000000000", "3"),("239566", "1", "1003", "13", "1", "64.620000000000", "4"),("239567", "2", "1003", "13", "1", "75.550000000000", "5"),("80981", "10", "1000", "222", "1", "363.780000000000", "6"),("8786", "2", "1000", "42", "1", "355.460000000000", "7"),("210745", "10", "1002", "751", "1", "149.800000000000", "8"),("210747", "10", "1", "751", "1", "149.800000000000", "9"),("144637", "2", "1001", "163", "1", "3.390000000000", "10"),("60092", "2", "1000", "187", "1", "12.610000000000", "11"),("218487", "1", "1000", "749", "1", "84.030000000000", "12"),("144649", "2", "1000", "163", "1", "4.560000000000", "13"),("144651", "2", "1000", "163", "1", "4.560000000000", "14"),("100562", "1", "1000", "271", "1", "404.000000000000", "15"),("144641", "2", "1000", "163", "1", "3.500000000000", "16"),("144639", "2", "1000", "163", "1", "3.390000000000", "17"),("144635", "2", "1000", "163", "1", "3.390000000000", "18"),("144645", "2", "1000", "163", "1", "4.560000000000", "19"),("144647", "2", "1000", "163", "1", "4.560000000000", "20"),("144643", "2", "1000", "163", "1", "3.500000000000", "21"),("240618", "4", "6", "231", "1", "83.950000000000", "22"),("21982", "2", "1006", "73", "1", "19.420000000000", "23"),("70205", "2", "1001", "187", "1", "11.760000000000", "24"),("60059", "2", "1001", "187", "1", "5.460000000000", "25"),("60053", "2", "1001", "187", "1", "5.460000000000", "26"),("60089", "2", "1000", "187", "1", "12.610000000000", "27"),("60090", "2", "1000", "187", "1", "12.610000000000", "28"),("60095", "2", "1000", "187", "1", "12.610000000000", "29"),("70207", "2", "1000", "187", "1", "11.760000000000", "30"),("70208", "2", "1000", "187", "1", "11.760000000000", "31"),("79496", "2", "1000", "42", "1", "29.410000000000", "32"),("62948", "2", "1000", "187", "1", "5.460000000000", "33"),("62949", "2", "1000", "187", "1", "5.460000000000", "34"),("171048", "2", "1000", "224", "1", "4.200000000000", "35"),("9261", "2", "1000", "109", "1", "4.710000000000", "36"),("166996", "2", "1000", "73", "1", "16.760000000000", "37"),("48817", "2", "5", "160", "1", "13.260000000000", "38"),("17656", "2", "1003", "42", "1", "23.530000000000", "39"),("22589", "4", "1001", "165", "1", "192.350000000000", "40"),("170853", "1", "1001", "224", "1", "3.360000000000", "41"),("171050", "1", "1001", "224", "1", "3.360000000000", "42"),("24367", "10", "1000", "82", "1", "280.930000000000", "43"),("22588", "10", "1000", "165", "1", "232.610000000000", "44"),("114826", "2", "1000", "187", "1", "5.040000000000", "45"),("130683", "1", "1000", "285", "1", "16.720000000000", "46"),("114827", "2", "1000", "187", "1", "5.880000000000", "47"),("170854", "1", "1000", "224", "1", "3.360000000000", "48"),("151277", "2", "6", "121", "1", "14.290000000000", "49"),("151271", "2", "1", "121", "1", "13.450000000000", "50"),("22309", "2", "1003", "163", "1", "3.820000000000", "51"),("113454", "2", "1001", "187", "1", "6.720000000000", "52"),("114828", "2", "1001", "187", "1", "5.460000000000", "53"),("13033", "2", "1000", "115", "1", "34.450000000000", "54"),("17717", "2", "1000", "42", "1", "37.820000000000", "55"),("22308", "2", "1000", "163", "1", "3.930000000000", "56"),("48709", "2", "1000", "54", "1", "26.890000000000", "57"),("48728", "2", "1000", "54", "1", "26.890000000000", "58"),("48708", "2", "1000", "54", "1", "20.680000000000", "59"),("22316", "2", "1000", "163", "1", "3.580000000000", "60"),("22314", "2", "1000", "163", "1", "3.270000000000", "61"),("49789", "2", "1000", "54", "1", "30.210000000000", "62"),("22307", "2", "1000", "163", "1", "5.900000000000", "63"),("22310", "2", "1000", "163", "1", "3.270000000000", "64"),("22313", "2", "1000", "163", "1", "3.270000000000", "65"),("22590", "2", "1000", "165", "1", "297.480000000000", "66"),("22317", "2", "1000", "163", "1", "3.900000000000", "67"),("161955", "1", "1000", "540", "1", "9.660000000000", "68"),("22315", "2", "1000", "163", "1", "3.580000000000", "69"),("22306", "2", "11", "163", "1", "5.370000000000", "70"),("181225", "4", "1019", "13", "1", "10.840000000000", "71"),("181223", "4", "1016", "13", "1", "10.840000000000", "72"),("136998", "2", "1016", "423", "1", "5.130000000000", "73"),("181299", "4", "1015", "13", "1", "15.040000000000", "74"),("136996", "2", "1015", "423", "1", "4.960000000000", "75"),("181221", "4", "1011", "13", "1", "10.840000000000", "76"),("131749", "1", "1008", "559", "1", "8.320000000000", "77"),("131765", "1", "1007", "559", "1", "7.480000000000", "78"),("235647", "2", "1007", "370", "1", "13.120000000000", "79"),("112136", "1", "1006", "559", "1", "8.240000000000", "80"),("188545", "2", "1006", "54", "1", "27.730000000000", "81"),("131751", "1", "1005", "559", "1", "8.320000000000", "82"),("166360", "1", "1005", "559", "1", "10.080000000000", "83"),("131767", "1", "1004", "559", "1", "7.480000000000", "84"),("131747", "1", "1004", "559", "1", "8.320000000000", "85"),("165740", "2", "1004", "56", "1", "27.730000000000", "86"),("112135", "1", "1004", "559", "1", "8.240000000000", "87"),("662", "2", "1003", "15", "1", "9.990000000000", "88"),("165737", "2", "1003", "56", "1", "21.850000000000", "89"),("17685", "2", "1002", "42", "1", "26.050000000000", "90"),("165738", "2", "1002", "56", "1", "23.530000000000", "91"),("165739", "2", "1002", "56", "1", "26.050000000000", "92"),("229982", "2", "1001", "368", "1", "491.560000000000", "93"),("458", "2", "1001", "15", "1", "6.110000000000", "94"),("645", "2", "1000", "15", "1", "9.160000000000", "95"),("15072", "2", "1000", "115", "1", "73.110000000000", "96"),("48117", "2", "1000", "105", "1", "16.810000000000", "97"),("52906", "2", "1000", "115", "1", "50.420000000000", "98"),("52908", "2", "1000", "115", "1", "50.420000000000", "99"),("52909", "2", "1000", "115", "1", "50.420000000000", "100"),("69309", "2", "1000", "187", "1", "8.820000000000", "101"),("106689", "2", "1000", "49", "1", "12.610000000000", "102"),("106690", "2", "1000", "49", "1", "12.610000000000", "103"),("106692", "2", "1000", "49", "1", "12.610000000000", "104"),("106693", "2", "1000", "49", "1", "12.610000000000", "105"),("79948", "2", "1000", "42", "1", "478.990000000000", "106"),("181977", "1", "1000", "500", "1", "16.710000000000", "107"),("181987", "1", "1000", "500", "1", "15.960000000000", "108"),("181989", "1", "1000", "500", "1", "15.960000000000", "109"),("181995", "1", "1000", "500", "1", "15.960000000000", "110"),("181997", "1", "1000", "500", "1", "15.960000000000", "111"),("181999", "1", "1000", "500", "1", "15.960000000000", "112"),("145069", "2", "1000", "19", "1", "9.950000000000", "113"),("145071", "2", "1000", "19", "1", "9.950000000000", "114"),("148063", "2", "1000", "19", "1", "9.950000000000", "115"),("96089", "2", "1000", "187", "1", "8.820000000000", "116"),("106688", "2", "1000", "49", "1", "12.610000000000", "117"),("200381", "1", "15", "28", "1", "25.830400000000", "118"),("200379", "1", "14", "28", "1", "25.830400000000", "119"),("200375", "1", "12", "28", "1", "25.830400000000", "120"),("200377", "1", "11", "28", "1", "25.830400000000", "121"),("167145", "1", "5", "345", "1", "29.330000000000", "122"),("106694", "2", "1", "49", "1", "12.610000000000", "123"),("107380", "1", "1023", "58", "1", "4.200000000000", "124"),("181297", "4", "1019", "13", "1", "15.040000000000", "125"),("166359", "1", "1012", "559", "1", "9.660000000000", "126"),("107379", "1", "1010", "58", "1", "4.200000000000", "127"),("103578", "1", "1010", "401", "1", "16.810000000000", "128"),("112143", "1", "1006", "559", "1", "6.640000000000", "129"),("110633", "2", "1006", "73", "1", "21.440000000000", "130"),("415", "2", "1005", "15", "1", "6.640000000000", "131"),("112141", "1", "1005", "559", "1", "6.640000000000", "132"),("149383", "2", "1005", "423", "1", "6.050000000000", "133"),("107359", "1", "1004", "58", "1", "7.560000000000", "134"),("112142", "1", "1004", "559", "1", "6.640000000000", "135"),("166491", "2", "1004", "228", "1", "12.520000000000", "136"),("107381", "1", "1004", "58", "1", "4.200000000000", "137"),("107376", "1", "1004", "58", "1", "5.040000000000", "138"),("165253", "1", "1003", "611", "1", "22.610000000000", "139"),("107377", "1", "1003", "58", "1", "4.200000000000", "140"),("70193", "2", "1002", "187", "1", "8.400000000000", "141"),("58067", "2", "1002", "15", "1", "6.110000000000", "142"),("149385", "2", "1002", "423", "1", "6.050000000000", "143"),("107378", "1", "1002", "58", "1", "4.200000000000", "144"),("16792", "2", "1001", "42", "1", "21.010000000000", "145"),("49555", "2", "1001", "364", "1", "158.820000000000", "146"),("96095", "2", "1001", "187", "1", "8.400000000000", "147"),("57901", "2", "1001", "15", "1", "8.740000000000", "148"),("175794", "1", "1001", "124", "1", "77.440000000000", "149"),("107375", "1", "1001", "58", "1", "6.720000000000", "150"),("15073", "2", "1000", "115", "1", "73.110000000000", "151"),("52907", "2", "1000", "115", "1", "50.420000000000", "152"),("52910", "2", "1000", "115", "1", "50.420000000000", "153"),("52921", "2", "1000", "115", "1", "73.110000000000", "154"),("52904", "2", "1000", "115", "1", "50.420000000000", "155"),("52905", "2", "1000", "115", "1", "50.420000000000", "156"),("117500", "2", "1000", "19", "1", "9.760000000000", "157"),("118696", "2", "1000", "105", "1", "12.610000000000", "158"),("96094", "2", "1000", "187", "1", "8.400000000000", "159"),("128105", "2", "1000", "15", "1", "8.610000000000", "160"),("128107", "2", "1000", "15", "1", "8.610000000000", "161"),("181973", "1", "1000", "500", "1", "15.960000000000", "162"),("181975", "1", "1000", "500", "1", "15.960000000000", "163"),("181979", "1", "1000", "500", "1", "15.960000000000", "164"),("181981", "1", "1000", "500", "1", "15.960000000000", "165"),("181983", "1", "1000", "500", "1", "15.960000000000", "166"),("181985", "1", "1000", "500", "1", "15.960000000000", "167"),("181991", "1", "1000", "500", "1", "15.960000000000", "168"),("181993", "1", "1000", "500", "1", "15.960000000000", "169"),("144455", "2", "1000", "163", "1", "14.170000000000", "170"),("117503", "2", "1000", "19", "1", "9.760000000000", "171"),("96097", "2", "1000", "187", "1", "8.400000000000", "172"),("96096", "2", "1000", "187", "1", "8.400000000000", "173"),("17317", "2", "1000", "42", "1", "21.010000000000", "174"),("143847", "1", "1000", "611", "1", "22.610000000000", "175"),("165242", "1", "1000", "611", "1", "22.610000000000", "176"),("112140", "1", "1000", "559", "1", "8.240000000000", "177"),("70191", "2", "1000", "187", "1", "8.400000000000", "178"),("114825", "2", "1000", "187", "1", "8.400000000000", "179"),("94823", "10", "1000", "82", "1", "225.870000000000", "180"),("35341", "2", "1000", "289", "1", "8.400000000000", "181"),("96098", "2", "1000", "187", "1", "8.400000000000", "182"),("238451", "1", "1000", "353", "1", "12.580000000000", "183"),("96099", "2", "999", "187", "1", "8.400000000000", "184"),("4585", "2", "5", "95", "1", "85.710000000000", "185"),("166765", "2", "4", "228", "1", "22.500000000000", "186"),("16773", "10", "3", "42", "1", "27.730000000000", "187"),("166761", "2", "2", "228", "1", "12.520000000000", "188"),("189449", "1", "2", "345", "1", "25.130000000000", "189"),("96000", "2", "2", "410", "1", "16.810000000000", "190"),("96001", "2", "2", "410", "1", "16.810000000000", "191"),("400", "2", "1", "15", "1", "5.230000000000", "192"),("165254", "1", "1", "611", "1", "22.610000000000", "193"),("112118", "1", "1010", "559", "1", "7.560000000000", "194"),("112106", "1", "1007", "559", "1", "4.960000000000", "195"),("112112", "1", "1007", "559", "1", "5.800000000000", "196"),("112113", "1", "1007", "559", "1", "5.800000000000", "197"),("12555", "2", "1007", "56", "1", "22.270000000000", "198"),("165359", "2", "1007", "73", "1", "17.480000000000", "199"),("533", "2", "1006", "15", "1", "8.320000000000", "200"),("112099", "1", "1006", "559", "1", "7.560000000000", "201"),("112131", "1", "1006", "559", "1", "9.240000000000", "202"),("112119", "1", "1006", "559", "1", "4.960000000000", "203"),("204905", "1", "1006", "44", "1", "141.180000000000", "204"),("112086", "1", "1005", "559", "1", "4.960000000000", "205"),("68529", "2", "1005", "24", "1", "28.570000000000", "206"),("12553", "2", "1005", "56", "1", "21.850000000000", "207"),("12556", "2", "1005", "56", "1", "23.530000000000", "208"),("200973", "1", "1005", "224", "1", "14.290000000000", "209"),("112085", "1", "1004", "559", "1", "4.960000000000", "210"),("112114", "1", "1004", "559", "1", "4.960000000000", "211"),("95170", "2", "1004", "56", "1", "26.050000000000", "212"),("112111", "1", "1004", "559", "1", "5.800000000000", "213"),("143073", "1", "1004", "611", "1", "24.290000000000", "214"),("78768", "2", "1004", "325", "1", "18.490000000000", "215"),("70213", "2", "1003", "187", "1", "8.400000000000", "216"),("228355", "2", "1003", "20", "1", "13.450000000000", "217"),("12554", "2", "1003", "56", "1", "23.530000000000", "218"),("692", "2", "1002", "15", "1", "10.820000000000", "219"),("22335", "2", "1002", "12", "1", "123.030000000000", "220"),("112107", "1", "1002", "559", "1", "4.960000000000", "221"),("228353", "2", "1002", "20", "1", "13.450000000000", "222"),("471", "2", "1002", "15", "1", "10.820000000000", "223"),("524", "2", "1001", "15", "1", "6.500000000000", "224"),("112104", "1", "1001", "559", "1", "4.960000000000", "225"),("112084", "1", "1001", "559", "1", "6.720000000000", "226"),("228354", "2", "1001", "20", "1", "13.450000000000", "227"),("112100", "1", "1001", "559", "1", "7.560000000000", "228"),("107954", "2", "1000", "124", "1", "283.710000000000", "229"),("106118", "2", "1000", "49", "1", "453.780000000000", "230"),("106119", "2", "1000", "49", "1", "494.960000000000", "231"),("112117", "1", "1000", "559", "1", "7.560000000000", "232"),("112132", "1", "1000", "559", "1", "9.240000000000", "233"),("118739", "2", "1000", "105", "1", "19.330000000000", "234"),("119092", "2", "1000", "105", "1", "21.010000000000", "235"),("91610", "2", "1000", "371", "1", "40.380000000000", "236"),("91691", "2", "1000", "371", "1", "40.380000000000", "237"),("91692", "2", "1000", "371", "1", "40.380000000000", "238"),("91693", "2", "1000", "371", "1", "40.380000000000", "239"),("91694", "2", "1000", "371", "1", "40.380000000000", "240"),("91695", "2", "1000", "371", "1", "40.380000000000", "241"),("124675", "2", "1000", "289", "1", "6.720000000000", "242"),("228340", "2", "1000", "20", "1", "13.450000000000", "243"),("228341", "2", "1000", "20", "1", "13.450000000000", "244"),("228342", "2", "1000", "20", "1", "13.450000000000", "245"),("228343", "2", "1000", "20", "1", "13.450000000000", "246"),("228344", "2", "1000", "20", "1", "13.450000000000", "247"),("222033", "2", "1000", "459", "1", "9.240000000000", "248"),("175849", "10", "1000", "238", "1", "132.750000000000", "249"),("229429", "1", "1000", "540", "1", "273.110000000000", "250"),("112130", "1", "1000", "559", "1", "9.240000000000", "251"),("112116", "1", "1000", "559", "1", "7.560000000000", "252"),("112083", "1", "1000", "559", "1", "6.720000000000", "253"),("200975", "1", "1000", "224", "1", "14.290000000000", "254"),("78765", "2", "1000", "325", "1", "16.130000000000", "255"),("78766", "2", "1000", "325", "1", "17.900000000000", "256"),("78767", "2", "1000", "325", "1", "15.040000000000", "257"),("235760", "2", "1000", "54", "1", "31.090000000000", "258"),("235761", "2", "1000", "54", "1", "31.090000000000", "259"),("235764", "2", "1000", "54", "1", "31.090000000000", "260"),("235765", "2", "1000", "54", "1", "31.090000000000", "261"),("228445", "2", "1000", "73", "1", "116.720000000000", "262"),("112115", "1", "1000", "559", "1", "7.560000000000", "263"),("241125", "2", "1000", "168", "1", "181.480000000000", "264"),("112105", "1", "1000", "559", "1", "6.720000000000", "265"),("112110", "1", "1000", "559", "1", "7.560000000000", "266"),("680", "2", "30", "15", "1", "7.000000000000", "267"),("148623", "2", "7", "289", "1", "8.400000000000", "268"),("165299", "1", "6", "611", "1", "22.610000000000", "269"),("92684", "2", "3", "410", "1", "16.810000000000", "270"),("4586", "2", "2", "95", "1", "85.710000000000", "271"),("33508", "2", "1", "286", "1", "2.860000000000", "272"),("33510", "2", "1", "286", "1", "2.860000000000", "273"),("91715", "2", "1", "480", "1", "27.680000000000", "274"),("239517", "2", "1010", "289", "1", "8.400000000000", "275"),("179001", "4", "1008", "423", "1", "2.520000000000", "276"),("143075", "1", "1006", "611", "1", "24.290000000000", "277"),("202917", "1", "1006", "44", "1", "145.380000000000", "278"),("69688", "2", "1005", "27", "1", "10.080000000000", "279"),("107670", "1", "1005", "58", "1", "5.040000000000", "280"),("115031", "1", "1005", "73", "1", "17.480000000000", "281"),("536", "2", "1003", "15", "1", "10.820000000000", "282"),("69687", "2", "1003", "27", "1", "10.080000000000", "283"),("70196", "2", "1003", "187", "1", "10.080000000000", "284"),("40362", "2", "1003", "326", "1", "10.840000000000", "285"),("100326", "1", "1003", "160", "1", "13.260000000000", "286"),("143077", "1", "1003", "611", "1", "24.290000000000", "287"),("69689", "2", "1002", "27", "1", "10.080000000000", "288"),("40361", "2", "1002", "326", "1", "10.840000000000", "289"),("107671", "1", "1002", "58", "1", "5.040000000000", "290"),("107672", "1", "1002", "58", "1", "5.040000000000", "291"),("114818", "2", "1001", "187", "1", "15.130000000000", "292"),("119144", "2", "1001", "105", "1", "6.640000000000", "293"),("103635", "2", "1001", "492", "1", "43.390000000000", "294"),("69686", "2", "1001", "27", "1", "10.080000000000", "295"),("10749", "2", "1001", "187", "1", "11.760000000000", "296"),("485", "2", "1000", "15", "1", "9.440000000000", "297"),("8895", "2", "1000", "42", "1", "167.230000000000", "298"),("37097", "2", "1000", "163", "1", "14.170000000000", "299"),("114819", "2", "1000", "187", "1", "17.650000000000", "300"),("114820", "2", "1000", "187", "1", "12.610000000000", "301"),("114822", "2", "1000", "187", "1", "9.240000000000", "302"),("118736", "2", "1000", "105", "1", "19.330000000000", "303"),("118737", "2", "1000", "105", "1", "19.330000000000", "304"),("118740", "2", "1000", "105", "1", "19.330000000000", "305"),("119139", "2", "1000", "105", "1", "6.640000000000", "306"),("119084", "2", "1000", "105", "1", "21.010000000000", "307"),("119093", "2", "1000", "105", "1", "21.010000000000", "308"),("119094", "2", "1000", "105", "1", "21.010000000000", "309"),("119095", "2", "1000", "105", "1", "21.010000000000", "310"),("119096", "2", "1000", "105", "1", "21.010000000000", "311"),("119097", "2", "1000", "105", "1", "21.010000000000", "312"),("119098", "2", "1000", "105", "1", "21.010000000000", "313"),("119619", "4", "1000", "58", "1", "147.060000000000", "314"),("124815", "2", "1000", "289", "1", "5.880000000000", "315"),("183243", "1", "1000", "20", "1", "18.130000000000", "316"),("183247", "1", "1000", "20", "1", "18.130000000000", "317"),("183253", "1", "1000", "20", "1", "18.130000000000", "318"),("183263", "1", "1000", "20", "1", "18.130000000000", "319"),("229082", "2", "1000", "20", "1", "43.970000000000", "320"),("229084", "2", "1000", "20", "1", "43.970000000000", "321"),("228348", "2", "1000", "20", "1", "13.450000000000", "322"),("228350", "2", "1000", "20", "1", "13.450000000000", "323"),("145443", "1", "1000", "163", "1", "26.450000000000", "324"),("228349", "2", "1000", "20", "1", "13.450000000000", "325"),("238600", "1", "1000", "85", "1", "25.210000000000", "326"),("235758", "2", "1000", "54", "1", "31.090000000000", "327"),("35335", "2", "1000", "289", "1", "8.400000000000", "328"),("225374", "2", "5", "289", "1", "8.400000000000", "329"),("171209", "1", "5", "648", "1", "7.560000000000", "330"),("171210", "1", "5", "648", "1", "7.560000000000", "331"),("171212", "1", "5", "648", "1", "7.560000000000", "332"),("142827", "1", "4", "611", "1", "22.690000000000", "333"),("142835", "1", "4", "611", "1", "16.720000000000", "334"),("171222", "1", "3", "648", "1", "7.560000000000", "335"),("35347", "2", "3", "289", "1", "6.720000000000", "336"),("142831", "1", "3", "611", "1", "22.690000000000", "337"),("143079", "1", "2", "611", "1", "24.290000000000", "338"),("143841", "1", "2", "611", "1", "15.880000000000", "339"),("9526", "2", "2", "19", "1", "11.360000000000", "340"),("238681", "2", "1", "611", "1", "22.690000000000", "341"),("107661", "1", "1011", "58", "1", "6.720000000000", "342"),("183293", "1", "1007", "20", "1", "18.130000000000", "343"),("142811", "1", "1006", "611", "1", "22.690000000000", "344"),("107662", "1", "1006", "58", "1", "5.880000000000", "345"),("107664", "1", "1005", "58", "1", "5.880000000000", "346"),("107665", "1", "1005", "58", "1", "5.880000000000", "347"),("183297", "1", "1004", "20", "1", "18.130000000000", "348"),("107663", "1", "1004", "58", "1", "5.880000000000", "349"),("609", "2", "1003", "15", "1", "8.870000000000", "350"),("69691", "2", "1003", "27", "1", "10.080000000000", "351"),("187563", "2", "1003", "356", "1", "13.450000000000", "352"),("69690", "2", "1003", "27", "1", "10.080000000000", "353"),("107666", "1", "1003", "58", "1", "5.880000000000", "354"),("187559", "2", "1002", "356", "1", "13.450000000000", "355"),("107386", "1", "1002", "58", "1", "6.720000000000", "356"),("107660", "1", "1002", "58", "1", "6.720000000000", "357"),("187561", "2", "1002", "356", "1", "13.450000000000", "358"),("107385", "1", "1002", "58", "1", "6.720000000000", "359"),("107387", "1", "1002", "58", "1", "6.720000000000", "360"),("107667", "1", "1002", "58", "1", "5.880000000000", "361"),("107669", "1", "1002", "58", "1", "5.880000000000", "362"),("107389", "1", "1002", "58", "1", "8.400000000000", "363"),("107388", "1", "1001", "58", "1", "6.720000000000", "364"),("107668", "1", "1001", "58", "1", "5.880000000000", "365"),("125421", "2", "1001", "289", "1", "5.880000000000", "366"),("125423", "2", "1001", "289", "1", "5.880000000000", "367"),("130431", "2", "1001", "289", "1", "6.720000000000", "368"),("146971", "2", "1001", "113", "1", "289.920000000000", "369"),("107384", "1", "1001", "58", "1", "7.560000000000", "370"),("57706", "2", "1001", "15", "1", "9.600000000000", "371"),("129691", "10", "1001", "75", "1", "23.488000000000", "372"),("45689", "2", "1001", "289", "1", "8.400000000000", "373"),("170663", "1", "1001", "122", "1", "113.450000000000", "374"),("10745", "2", "1000", "187", "1", "13.450000000000", "375"),("37093", "2", "1000", "163", "1", "14.170000000000", "376"),("107390", "1", "1000", "58", "1", "8.400000000000", "377"),("113460", "2", "1000", "187", "1", "8.400000000000", "378"),("118600", "2", "1000", "105", "1", "12.610000000000", "379"),("118604", "2", "1000", "105", "1", "12.610000000000", "380"),("118605", "2", "1000", "105", "1", "12.610000000000", "381"),("119134", "2", "1000", "105", "1", "6.640000000000", "382"),("119078", "2", "1000", "105", "1", "21.010000000000", "383"),("119091", "2", "1000", "105", "1", "21.010000000000", "384"),("95344", "2", "1000", "371", "1", "40.380000000000", "385"),("95420", "2", "1000", "163", "1", "15.580000000000", "386"),("105055", "2", "1000", "58", "1", "11.760000000000", "387"),("125409", "2", "1000", "289", "1", "5.880000000000", "388"),("125413", "2", "1000", "289", "1", "5.880000000000", "389"),("183245", "1", "1000", "20", "1", "18.130000000000", "390"),("183255", "1", "1000", "20", "1", "18.130000000000", "391"),("183281", "1", "1000", "20", "1", "18.130000000000", "392"),("183285", "1", "1000", "20", "1", "18.130000000000", "393"),("183289", "1", "1000", "20", "1", "18.130000000000", "394"),("183299", "1", "1000", "20", "1", "18.130000000000", "395"),("183305", "1", "1000", "20", "1", "18.130000000000", "396"),("221949", "1", "1000", "459", "1", "55.460000000000", "397"),("221950", "1", "1000", "459", "1", "55.460000000000", "398"),("221951", "1", "1000", "459", "1", "55.460000000000", "399"),("188693", "2", "1000", "20", "1", "18.130000000000", "400"),("188695", "2", "1000", "20", "1", "18.130000000000", "401"),("125003", "2", "1000", "289", "1", "5.880000000000", "402"),("237468", "2", "1000", "11", "1", "59.270000000000", "403"),("235607", "2", "1000", "54", "1", "31.090000000000", "404"),("235608", "2", "1000", "54", "1", "31.090000000000", "405"),("235612", "2", "1000", "54", "1", "31.090000000000", "406"),("235744", "2", "1000", "54", "1", "31.090000000000", "407"),("235745", "2", "1000", "54", "1", "31.090000000000", "408"),("235749", "2", "1000", "54", "1", "31.090000000000", "409"),("235759", "2", "1000", "54", "1", "31.090000000000", "410"),("235762", "2", "1000", "54", "1", "31.090000000000", "411"),("235763", "2", "1000", "54", "1", "31.090000000000", "412"),("235804", "2", "1000", "54", "1", "31.090000000000", "413"),("235805", "2", "1000", "54", "1", "31.090000000000", "414"),("235808", "2", "1000", "54", "1", "31.090000000000", "415"),("235809", "2", "1000", "54", "1", "31.090000000000", "416"),("95419", "2", "1000", "163", "1", "13.220000000000", "417"),("58351", "2", "10", "285", "1", "31.449600000000", "418"),("58354", "2", "9", "285", "1", "31.449600000000", "419"),("58352", "2", "9", "285", "1", "31.449600000000", "420"),("58355", "2", "7", "285", "1", "31.449600000000", "421"),("125411", "2", "4", "289", "1", "5.880000000000", "422"),("97173", "2", "3", "95", "1", "85.710000000000", "423"),("58356", "2", "2", "285", "1", "31.449600000000", "424"),("37090", "2", "1", "163", "1", "14.170000000000", "425"),("239508", "2", "1", "289", "1", "8.400000000000", "426"),("66115", "2", "1020", "289", "1", "8.400000000000", "427"),("166373", "1", "1011", "559", "1", "8.320000000000", "428"),("166369", "1", "1011", "559", "1", "8.320000000000", "429"),("166372", "1", "1010", "559", "1", "8.320000000000", "430"),("66174", "2", "1009", "289", "1", "8.400000000000", "431"),("166371", "1", "1009", "559", "1", "8.320000000000", "432"),("166370", "1", "1007", "559", "1", "8.320000000000", "433"),("183307", "1", "1005", "20", "1", "18.130000000000", "434"),("168825", "1", "1002", "54", "1", "121.010000000000", "435"),("146969", "2", "1001", "113", "1", "294.120000000000", "436"),("64156", "2", "1000", "15", "1", "12.500000000000", "437"),("118601", "2", "1000", "105", "1", "12.610000000000", "438"),("118602", "2", "1000", "105", "1", "12.610000000000", "439"),("118603", "2", "1000", "105", "1", "12.610000000000", "440"),("124979", "2", "1000", "289", "1", "6.720000000000", "441"),("124981", "2", "1000", "289", "1", "6.720000000000", "442"),("183249", "1", "1000", "20", "1", "18.130000000000", "443"),("183251", "1", "1000", "20", "1", "18.130000000000", "444"),("183283", "1", "1000", "20", "1", "18.130000000000", "445"),("183291", "1", "1000", "20", "1", "18.130000000000", "446"),("183295", "1", "1000", "20", "1", "18.130000000000", "447"),("221952", "1", "1000", "459", "1", "55.460000000000", "448"),("221953", "1", "1000", "459", "1", "55.460000000000", "449"),("188691", "2", "1000", "20", "1", "18.130000000000", "450"),("188697", "2", "1000", "20", "1", "18.130000000000", "451"),("237477", "2", "1000", "11", "1", "59.270000000000", "452"),("235605", "2", "1000", "54", "1", "31.090000000000", "453"),("235606", "2", "1000", "54", "1", "31.090000000000", "454"),("235611", "2", "1000", "54", "1", "31.090000000000", "455"),("235742", "2", "1000", "54", "1", "31.090000000000", "456"),("235748", "2", "1000", "54", "1", "31.090000000000", "457"),("235802", "2", "1000", "54", "1", "31.090000000000", "458"),("241072", "2", "1000", "168", "1", "226.860000000000", "459"),("220381", "2", "1000", "435", "1", "503.360000000000", "460"),("222262", "1", "1", "769", "1", "46.028800000000", "461"),("48459", "2", "1", "100", "1", "41.100800000000", "462"),("11985", "2", "1014", "24", "1", "2.520000000000", "463"),("11987", "4", "1010", "24", "1", "2.520000000000", "464"),("200763", "1", "1010", "20", "1", "13.210000000000", "465"),("200769", "1", "1010", "20", "1", "13.210000000000", "466"),("66024", "2", "1010", "289", "1", "8.400000000000", "467"),("197035", "1", "1008", "607", "1", "31.090000000000", "468"),("197037", "1", "1007", "607", "1", "31.090000000000", "469"),("7550", "2", "1006", "15", "1", "8.750000000000", "470"),("170223", "1", "1006", "559", "1", "10.080000000000", "471"),("64223", "2", "1006", "15", "1", "9.300000000000", "472"),("197055", "1", "1006", "607", "1", "31.090000000000", "473"),("64221", "2", "1005", "15", "1", "9.300000000000", "474"),("170224", "1", "1005", "559", "1", "10.080000000000", "475"),("197057", "1", "1005", "607", "1", "31.090000000000", "476"),("64222", "2", "1004", "15", "1", "9.300000000000", "477"),("202567", "1", "1003", "20", "1", "13.210000000000", "478"),("169647", "2", "1003", "559", "1", "9.240000000000", "479"),("66178", "2", "1002", "289", "1", "6.720000000000", "480"),("170219", "1", "1002", "559", "1", "10.080000000000", "481"),("24883", "2", "1001", "75", "1", "23.488000000000", "482"),("24896", "2", "1001", "75", "1", "23.488000000000", "483"),("24892", "2", "1001", "75", "1", "23.488000000000", "484"),("11986", "2", "1001", "24", "1", "2.520000000000", "485"),("129505", "2", "1001", "27", "1", "23.488000000000", "486"),("416", "2", "1000", "15", "1", "9.440000000000", "487"),("24891", "2", "1000", "75", "1", "23.488000000000", "488"),("47550", "2", "1000", "42", "1", "31.930000000000", "489"),("91360", "2", "1000", "42", "1", "166.390000000000", "490"),("170221", "1", "1000", "559", "1", "10.080000000000", "491"),("169658", "2", "1000", "559", "1", "9.240000000000", "492"),("169659", "2", "1000", "559", "1", "9.240000000000", "493"),("183257", "1", "1000", "20", "1", "18.130000000000", "494"),("183287", "1", "1000", "20", "1", "18.130000000000", "495"),("183301", "1", "1000", "20", "1", "18.130000000000", "496"),("183303", "1", "1000", "20", "1", "18.130000000000", "497"),("207245", "2", "1000", "606", "1", "19.330000000000", "498"),("207255", "2", "1000", "606", "1", "19.330000000000", "499"),("221954", "1", "1000", "459", "1", "55.460000000000", "500"),("169646", "2", "1000", "559", "1", "9.240000000000", "501"),("235609", "2", "1000", "54", "1", "31.090000000000", "502"),("235610", "2", "1000", "54", "1", "31.090000000000", "503"),("235743", "2", "1000", "54", "1", "31.090000000000", "504"),("235746", "2", "1000", "54", "1", "31.090000000000", "505"),("235747", "2", "1000", "54", "1", "31.090000000000", "506"),("235803", "2", "1000", "54", "1", "31.090000000000", "507"),("235806", "2", "1000", "54", "1", "31.090000000000", "508"),("235807", "2", "1000", "54", "1", "31.090000000000", "509"),("47542", "2", "1000", "42", "1", "23.530000000000", "510"),("243775", "2", "1000", "73", "1", "18.870000000000", "511"),("243782", "1", "1000", "73", "1", "18.870000000000", "512"),("243863", "1", "1000", "73", "1", "18.870000000000", "513"),("200765", "1", "1000", "20", "1", "13.210000000000", "514"),("200767", "1", "9", "20", "1", "13.210000000000", "515"),("171955", "2", "4", "648", "1", "13.450000000000", "516"),("222274", "1", "3", "769", "1", "46.028800000000", "517"),("222305", "1", "3", "769", "1", "46.028800000000", "518"),("222304", "1", "3", "769", "1", "46.028800000000", "519"),("191003", "2", "2", "95", "1", "125.210000000000", "520"),("171957", "2", "2", "648", "1", "13.450000000000", "521"),("91348", "2", "1", "42", "1", "112.610000000000", "522"),("191001", "2", "1", "95", "1", "95.800000000000", "523"),("107676", "1", "1024", "58", "1", "10.080000000000", "524"),("107677", "1", "1022", "58", "1", "9.240000000000", "525"),("197031", "1", "1011", "607", "1", "31.090000000000", "526"),("234761", "2", "1006", "122", "1", "30.250000000000", "527"),("107674", "1", "1006", "58", "1", "15.130000000000", "528"),("107673", "1", "1006", "58", "1", "17.650000000000", "529"),("107675", "1", "1005", "58", "1", "12.610000000000", "530"),("107679", "1", "1003", "58", "1", "9.240000000000", "531"),("107680", "1", "1003", "58", "1", "9.240000000000", "532"),("24871", "2", "1002", "75", "1", "14.092800000000", "533"),("106238", "1", "1002", "75", "1", "23.488000000000", "534"),("107678", "1", "1002", "58", "1", "9.240000000000", "535"),("24875", "2", "1001", "75", "1", "14.092800000000", "536"),("105728", "1", "1001", "58", "1", "88.240000000000", "537"),("112129", "1", "1001", "559", "1", "9.240000000000", "538"),("24861", "2", "1001", "75", "1", "14.092800000000", "539"),("24874", "2", "1001", "75", "1", "14.092800000000", "540"),("134463", "2", "1001", "606", "1", "24.790000000000", "541"),("105292", "1", "1001", "58", "1", "41.180000000000", "542"),("24868", "2", "1000", "75", "1", "14.092800000000", "543"),("134467", "2", "1000", "606", "1", "24.790000000000", "544"),("183279", "1", "1000", "20", "1", "18.130000000000", "545"),("207249", "2", "1000", "606", "1", "19.330000000000", "546"),("199991", "1", "1000", "224", "1", "14.290000000000", "547"),("235801", "2", "1000", "224", "1", "90.760000000000", "548"),("102279", "2", "1000", "204", "1", "21.010000000000", "549"),("102280", "2", "1000", "204", "1", "14.710000000000", "550"),("241022", "1", "1000", "119", "1", "12.440000000000", "551"),("241023", "1", "1000", "119", "1", "12.440000000000", "552"),("241024", "1", "1000", "119", "1", "12.440000000000", "553"),("241025", "1", "1000", "119", "1", "12.440000000000", "554"),("243773", "1", "1000", "73", "1", "18.870000000000", "555"),("222497", "-100", "4", "769", "1", "109.094400000000", "556"),("171963", "2", "4", "648", "1", "13.450000000000", "557"),("222275", "1", "1", "769", "1", "46.028800000000", "558"),("222276", "1", "1", "769", "1", "46.028800000000", "559"),("197033", "1", "1009", "607", "1", "31.090000000000", "560"),("35208", "2", "1007", "15", "1", "14.200000000000", "561"),("192493", "1", "1007", "587", "1", "15.500000000000", "562"),("35209", "2", "1006", "15", "1", "19.660000000000", "563"),("192495", "1", "1006", "587", "1", "16.140000000000", "564"),("197041", "1", "1006", "607", "1", "31.090000000000", "565"),("197039", "1", "1004", "607", "1", "31.090000000000", "566"),("35207", "2", "1003", "15", "1", "14.200000000000", "567"),("192497", "1", "1003", "587", "1", "16.790000000000", "568"),("197059", "1", "1003", "607", "1", "31.090000000000", "569"),("55998", "2", "1003", "15", "1", "23.650000000000", "570"),("24857", "2", "1000", "75", "1", "14.092800000000", "571"),("55999", "2", "1000", "15", "1", "19.660000000000", "572"),("241026", "1", "1000", "119", "1", "12.440000000000", "573"),("241027", "1", "1000", "119", "1", "12.440000000000", "574"),("241028", "1", "1000", "119", "1", "12.440000000000", "575"),("241029", "1", "1000", "119", "1", "12.440000000000", "576"),("222345", "-100", "4", "769", "1", "87.603200000000", "577"),("222339", "2", "2", "769", "1", "87.603200000000", "578"),("163810", "2", "1018", "13", "1", "8.320000000000", "579"),("165458", "1", "1007", "324", "1", "8.820000000000", "580"),("165459", "1", "1005", "324", "1", "8.820000000000", "581"),("163812", "2", "1001", "13", "1", "7.480000000000", "582"),("145445", "1", "1000", "163", "1", "29.280000000000", "583"),("165460", "1", "1000", "324", "1", "8.820000000000", "584"),("158647", "1", "1000", "206", "1", "12.610000000000", "585"),("227392", "2", "3", "280", "1", "125.660000000000", "586"),("222346", "2", "3", "769", "1", "87.603200000000", "587"),("56024", "2", "1007", "15", "1", "10.000000000000", "588"),("56022", "2", "1005", "15", "1", "11.130000000000", "589"),("56023", "2", "1004", "15", "1", "8.320000000000", "590"),("399", "2", "1002", "15", "1", "8.610000000000", "591"),("56021", "2", "1001", "15", "1", "8.320000000000", "592"),("398", "2", "1000", "15", "1", "8.610000000000", "593"),("164648", "2", "1012", "42", "1", "10.920000000000", "594"),("164647", "2", "1009", "42", "1", "10.920000000000", "595"),("633", "2", "1000", "15", "1", "8.610000000000", "596"),("47790", "-100", "18", "26", "1", "6.640000000000", "597"),("704", "2", "1000", "15", "1", "10.820000000000", "598"),("430", "2", "1009", "15", "1", "9.990000000000", "599"),("376", "2", "1009", "15", "1", "9.990000000000", "600"),("205773", "1", "1008", "13", "1", "88.990000000000", "601"),("231695", "1", "1000", "517", "1", "33.450000000000", "602"),("243565", "2", "1000", "75", "1", "4.620000000000", "603"),("243566", "2", "1000", "75", "1", "4.620000000000", "604"),("243567", "2", "1000", "75", "1", "4.620000000000", "605"),("93011", "10", "0", "222", "1", "300.130000000000", "606"),("234274", "2", "0", "59", "1", "16.800000000000", "607"),("15074", "2", "0", "115", "1", "57.000000000000", "608"),("15075", "2", "0", "115", "1", "57.000000000000", "609"),("40272", "10", "0", "326", "1", "4.320000000000", "610"),("40274", "10", "0", "326", "1", "4.320000000000", "611"),("111305", "2", "0", "49", "1", "12.000000000000", "612"),("106691", "2", "0", "49", "1", "10.000000000000", "613"),("104523", "1", "0", "469", "1", "205.670000000000", "614"),("165255", "1", "0", "611", "1", "15.450000000000", "615"),("96003", "2", "0", "410", "1", "12.000000000000", "616"),("97594", "2", "0", "340", "1", "16.810000000000", "617"),("52920", "2", "0", "115", "1", "57.000000000000", "618"),("166498", "2", "0", "228", "1", "11.830000000000", "619"),("117502", "2", "0", "19", "1", "7.280000000000", "620"),("115552", "1", "0", "124", "1", "176.350000000000", "621"),("195429", "2", "0", "204", "1", "730.000000000000", "622"),("96002", "2", "0", "410", "1", "12.000000000000", "623"),("143845", "1", "0", "611", "1", "15.450000000000", "624"),("131027", "2", "0", "206", "1", "5.000000000000", "625"),("240617", "10", "0", "231", "1", "546.130000000000", "626"),("91696", "2", "0", "371", "1", "31.060000000000", "627"),("91684", "2", "0", "371", "1", "34.000000000000", "628"),("92685", "2", "0", "410", "1", "12.000000000000", "629"),("80052", "2", "0", "42", "1", "71.000000000000", "630"),("161429", "2", "0", "289", "1", "3.970000000000", "631"),("115659", "2", "0", "483", "1", "19.920000000000", "632"),("17319", "2", "0", "42", "1", "16.500000000000", "633"),("234811", "1", "0", "59", "1", "16.760000000000", "634"),("234812", "2", "0", "59", "1", "13.820000000000", "635"),("234813", "2", "0", "59", "1", "11.720000000000", "636"),("234814", "2", "0", "59", "1", "10.880000000000", "637"),("117532", "2", "0", "168", "1", "60.500000000000", "638"),("91336", "2", "0", "42", "1", "62.000000000000", "639"),("143843", "1", "0", "611", "1", "15.450000000000", "640"),("235236", "2", "0", "59", "1", "92.006400000000", "641"),("48636", "2", "0", "19", "1", "7.830000000000", "642"),("115661", "2", "0", "483", "1", "22.860000000000", "643"),("225372", "2", "0", "289", "1", "8.400000000000", "644"),("119624", "4", "0", "58", "1", "135.000000000000", "645"),("221948", "1", "0", "459", "1", "42.000000000000", "646"),("46220", "2", "0", "289", "1", "4.960000000000", "647"),("18014", "2", "0", "42", "1", "13.000000000000", "648"),("116648", "2", "0", "280", "1", "39.270000000000", "649"),("105245", "2", "0", "42", "1", "68.000000000000", "650"),("125415", "2", "0", "289", "1", "3.470000000000", "651"),("125417", "2", "0", "289", "1", "5.880000000000", "652"),("152177", "1", "0", "469", "1", "83.950000000000", "653"),("116644", "2", "0", "280", "1", "36.400000000000", "654"),("102082", "2", "0", "204", "1", "77.000000000000", "655"),("91357", "2", "0", "42", "1", "108.000000000000", "656"),("134465", "2", "0", "606", "1", "18.530000000000", "657"),("221955", "1", "0", "459", "1", "42.000000000000", "658"),("134447", "2", "0", "606", "1", "18.540000000000", "659"),("24884", "2", "0", "75", "1", "18.944000000000", "660"),("134445", "2", "0", "606", "1", "18.530000000000", "661"),("190999", "2", "0", "95", "1", "60.000000000000", "662"),("134449", "2", "0", "606", "1", "18.530000000000", "663"),("207247", "2", "0", "606", "1", "19.330000000000", "664"),("171964", "2", "0", "648", "1", "8.000000000000", "665"),("243791", "1", "0", "73", "1", "13.440000000000", "666"),("134461", "2", "0", "606", "1", "24.790000000000", "667"),("66123", "2", "0", "289", "1", "4.960000000000", "668"),("93264", "2", "0", "192", "1", "413.000000000000", "669"),("107374", "2", "0", "192", "1", "291.000000000000", "670"),("207243", "2", "0", "606", "1", "19.330000000000", "671"),("96740", "2", "0", "192", "1", "199.000000000000", "672"),("207251", "2", "0", "606", "1", "19.330000000000", "673"),("207253", "2", "0", "606", "1", "19.330000000000", "674"),("222338", "2", "0", "769", "1", "54.720000000000", "675"),("185255", "1", "0", "469", "1", "5.040000000000", "676"),("185273", "1", "0", "469", "1", "6.000000000000", "677")

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 = '94688' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

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 = '94688' 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 = '94688' AND a.attribute_group_id = '13' 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 = '94688'
ORDER BY sort_order ASC

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

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'

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'