Name: Novelty
Brand: Sweetkiss
SKU: 1
Rating: 4.9 (349 reviews)

Catched error 40642S02: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lcyigxqc_new_sweetkis.day_event' doesn't exist
in /home/lcyigxqc/public_html/protected/classes/DataBase.php on line 73.
Query: 'SELECT 
		        tb.id,
		        tb.url,
		        tb_lang.weight,
		        tb.brend_id,
		        tb.photo,
		        tb_lang.name,
		        price.id as price_id,
		        price.price,
		        price.basePrice,
		        price.discount,
		        price.stock,
		        price.unit
		        ,
		        
			  GROUP_CONCAT(DISTINCT pss.status_id SEPARATOR '|') AS statuses,
			  GROUP_CONCAT(DISTINCT pr_p.photo SEPARATOR '|') AS dopPhoto,
        lang_brend.name AS brend,
        price.price * providers.currency_rate AS price_sort,
        tb_lang.body_m,
        pss.status_id,
        lang_ps.name AS status,
        providers.currency_id,
        favorites.product_id AS fav_id,
        bascket.product_id AS basket_id,        
        de.time_start AS  sale_time_start,
        de.time_end AS  sale_time_end,
        de.sale AS sale_prod,
        catalog.id AS catalog_id,
        providers.currency_rate FROM `product` `tb` LEFT JOIN `en_product` tb_lang ON tb.id=tb_lang.product_id 
        LEFT JOIN product_catalog p_cat ON p_cat.product_id=tb.id   
        LEFT JOIN catalog ON p_cat.catalog_id=catalog.id
        LEFT JOIN day_event de ON de.catalog_id=catalog.id AND de.day_id = (WEEKDAY(CURDATE()) + 1)  
		LEFT JOIN params_product pp ON pp.product_id = tb.id
		LEFT JOIN product_status_set pss ON pss.product_id = tb.id
        LEFT JOIN product_photo pr_p ON pr_p.product_id=tb.id
        LEFT JOIN en_product_status lang_ps ON pss.status_id = lang_ps.product_status_id
        LEFT JOIN en_brend lang_brend ON lang_brend.brend_id = tb.brend_id
        LEFT JOIN price price ON price.product_id = tb.id AND price.price_type_id = '1'
        LEFT JOIN providers ON tb.provider_id = providers.id
        LEFT JOIN favorites ON favorites.product_id = tb.id AND favorites.session_id = '1aacb119467ffb8d0e47f82c9f1f7e40'
        LEFT JOIN bascket ON bascket.product_id = tb.id AND bascket.session_id = '1aacb119467ffb8d0e47f82c9f1f7e40'
         WHERE tb.id!='0'   AND tb.id IN(SELECT product_id FROM product_status_set WHERE status_id="1") AND tb.active = "1" GROUP BY tb.id HAVING id != 0 ORDER BY tb.sort ASC, tb.id DESC '

Catched error 40642S02: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lcyigxqc_new_sweetkis.day_event' doesn't exist
in /home/lcyigxqc/public_html/protected/classes/DataBase.php on line 74.
Query: 'SELECT 
		        tb.id,
		        tb.url,
		        tb_lang.weight,
		        tb.brend_id,
		        tb.photo,
		        tb_lang.name,
		        price.id as price_id,
		        price.price,
		        price.basePrice,
		        price.discount,
		        price.stock,
		        price.unit
		        ,
		        
			  GROUP_CONCAT(DISTINCT pss.status_id SEPARATOR '|') AS statuses,
			  GROUP_CONCAT(DISTINCT pr_p.photo SEPARATOR '|') AS dopPhoto,
        lang_brend.name AS brend,
        price.price * providers.currency_rate AS price_sort,
        tb_lang.body_m,
        pss.status_id,
        lang_ps.name AS status,
        providers.currency_id,
        favorites.product_id AS fav_id,
        bascket.product_id AS basket_id,        
        de.time_start AS  sale_time_start,
        de.time_end AS  sale_time_end,
        de.sale AS sale_prod,
        catalog.id AS catalog_id,
        providers.currency_rate FROM `product` `tb` LEFT JOIN `en_product` tb_lang ON tb.id=tb_lang.product_id 
        LEFT JOIN product_catalog p_cat ON p_cat.product_id=tb.id   
        LEFT JOIN catalog ON p_cat.catalog_id=catalog.id
        LEFT JOIN day_event de ON de.catalog_id=catalog.id AND de.day_id = (WEEKDAY(CURDATE()) + 1)  
		LEFT JOIN params_product pp ON pp.product_id = tb.id
		LEFT JOIN product_status_set pss ON pss.product_id = tb.id
        LEFT JOIN product_photo pr_p ON pr_p.product_id=tb.id
        LEFT JOIN en_product_status lang_ps ON pss.status_id = lang_ps.product_status_id
        LEFT JOIN en_brend lang_brend ON lang_brend.brend_id = tb.brend_id
        LEFT JOIN price price ON price.product_id = tb.id AND price.price_type_id = '1'
        LEFT JOIN providers ON tb.provider_id = providers.id
        LEFT JOIN favorites ON favorites.product_id = tb.id AND favorites.session_id = '1aacb119467ffb8d0e47f82c9f1f7e40'
        LEFT JOIN bascket ON bascket.product_id = tb.id AND bascket.session_id = '1aacb119467ffb8d0e47f82c9f1f7e40'
         WHERE tb.id!='0'   AND tb.id IN(SELECT product_id FROM product_status_set WHERE status_id="1") AND tb.active = "1" GROUP BY tb.id HAVING id != 0 ORDER BY tb.sort ASC, tb.id DESC LIMIT 0,24'

Catched error 40642S02: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lcyigxqc_new_sweetkis.day_event' doesn't exist
in /home/lcyigxqc/public_html/protected/classes/DataBase.php on line 74.
Query: 'SELECT 
		        tb.id,
		        tb.url,
		        tb_lang.weight,
		        tb.brend_id,
		        tb.photo,
		        tb_lang.name,
		        price.id as price_id,
		        price.price,
		        price.basePrice,
		        price.discount,
		        price.stock,
		        price.unit
		        ,
		        
			  GROUP_CONCAT(DISTINCT pss.status_id SEPARATOR '|') AS statuses,
			  GROUP_CONCAT(DISTINCT pr_p.photo SEPARATOR '|') AS dopPhoto,
        lang_brend.name AS brend,
        price.price * providers.currency_rate AS price_sort,
        tb_lang.body_m,
        pss.status_id,
        lang_ps.name AS status,
        providers.currency_id,
        favorites.product_id AS fav_id,
        bascket.product_id AS basket_id,        
        de.time_start AS  sale_time_start,
        de.time_end AS  sale_time_end,
        de.sale AS sale_prod,
        catalog.id AS catalog_id,
        providers.currency_rate FROM `product` `tb` LEFT JOIN `en_product` tb_lang ON tb.id=tb_lang.product_id 
        LEFT JOIN product_catalog p_cat ON p_cat.product_id=tb.id   
        LEFT JOIN catalog ON p_cat.catalog_id=catalog.id
        LEFT JOIN day_event de ON de.catalog_id=catalog.id AND de.day_id = (WEEKDAY(CURDATE()) + 1)  
		LEFT JOIN params_product pp ON pp.product_id = tb.id
		LEFT JOIN product_status_set pss ON pss.product_id = tb.id
        LEFT JOIN product_photo pr_p ON pr_p.product_id=tb.id
        LEFT JOIN en_product_status lang_ps ON pss.status_id = lang_ps.product_status_id
        LEFT JOIN en_brend lang_brend ON lang_brend.brend_id = tb.brend_id
        LEFT JOIN price price ON price.product_id = tb.id AND price.price_type_id = '1'
        LEFT JOIN providers ON tb.provider_id = providers.id
        LEFT JOIN favorites ON favorites.product_id = tb.id AND favorites.session_id = '1aacb119467ffb8d0e47f82c9f1f7e40'
        LEFT JOIN bascket ON bascket.product_id = tb.id AND bascket.session_id = '1aacb119467ffb8d0e47f82c9f1f7e40'
         WHERE tb.id!='0'  AND tb.id IN(SELECT product_id FROM product_status_set WHERE status_id="1")  GROUP BY tb.id  ORDER BY tb.`sort` ASC,tb.id DESC '

Catched error 40642000: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY tb.id' at line 2
in /home/lcyigxqc/public_html/protected/classes/DataBase.php on line 74.
Query: 'SELECT *, COUNT(product.id) as product_count FROM `params` `tb` LEFT JOIN `en_params` tb_lang ON tb.id=tb_lang.params_id LEFT JOIN params_product ON tb.id = params_product.params_id
                           LEFT JOIN product ON params_product.product_id = product.id WHERE tb.active = "1" AND tb.sub IS NOT NULL AND params_product.product_id IN () GROUP BY tb.id   '