Unknown column 'p.sourcing' in 'field list'
01: SELECT
02: 	    p.id,
03: 	    p.name,
04: 	    p.slug,
05: 	    p.description,
06: 	    p.cas_number,
07: 	    p.cid,
08: 	    p.ec_no,
09: 	    p.product_weight_id,
10: 	    p.appearance_id,
11: 	    p.molecular_formula,
12: 	    p.synonymous,
13: 	    p.molecular_weight,
14: 	    st.name AS storage_temp,
15: 	    p.storage_temp_id,
16: 	    sht.name AS shipping_temp,
17: 	    p.shipping_temp_id,
18: 	    p.group_code,
19: 	    REPLACE(p.usp_description, '#N/D', '') AS usp_description,
20: 	    REPLACE(p.ep_description, '#N/D', '') AS ep_description,
21: 	    p.country_origin,
22: 	    p.origin_country_id,
23: 	    p.smiles,
24: 	    p.iupac_name,
25: 	    p.inchi,
26: 	    p.tariff_code,
27: 	    p.controlled,
28: 	    p.hygroscopy_id,
29: 	    p.sourcing,
30: 	    p.alternative_cas_number,
31: 	    p.un_number,
32: 	    p.un_number_id,
33: 	    p.imo_class_id,
34: 	    p.packing_group_id,
35: 	    p.proper_shipping_name,
36: 	    p.custom_synthesis,
37: 	    p.danger_goods,
38: 	    IF(p.created_at >= DATE_ADD(NOW(), INTERVAL -90 DAY), 1, 0) AS is_new,
39: 	    pw.name AS product_weight,
40: 	    pf.name AS product_format,
41: 	    ap.name AS appearance,
42: 	    st.name AS storage_temp,
43: 	    sht.name AS shipping_temp,
44: 	    h.name AS hygroscopy,
45: 	    o.name AS origin_country,
46: 	    un.name AS un_number,
47: 	    ic.name AS imo_class,
48: 	    pg.name AS packing_group,
49: 	    (
50: 	        SELECT GROUP_CONCAT(DISTINCT CONCAT(pf.id, '|', pf.name) SEPARATOR '||')
51: 	        FROM JSON_TABLE(
52: 	            p.api_family_ids,
53: 	            '$[*]' COLUMNS (family_id INT PATH '$')
54: 	        ) AS jt
55: 	        INNER JOIN productsfamilies AS pf
56: 	            ON jt.family_id = pf.id
57: 	            AND pf.deleted_at IS NULL
58: 	    ) AS product_families,
59: 	    (
60: 	        SELECT GROUP_CONCAT(DISTINCT pt.name)
61: 	        FROM JSON_TABLE(
62: 	            p.product_type_ids,
63: 	            '$[*]' COLUMNS (type_id INT PATH '$')
64: 	        ) AS jt
65: 	        INNER JOIN productstypes AS pt
66: 	            ON jt.type_id = pt.id
67: 	    ) AS product_types
68: 	FROM products AS p
69: 	LEFT JOIN appearances AS ap
70: 	    ON p.appearance_id = ap.id
71: 	LEFT JOIN productsweights AS pw
72: 	    ON p.product_weight_id = pw.id
73: 	LEFT JOIN productsformats AS pf
74: 	    ON p.product_format_id = pf.id
75: 	LEFT JOIN storagetemps AS st
76: 	    ON p.storage_temp_id = st.id
77: 	LEFT JOIN shippingtemps AS sht
78: 	    ON p.shipping_temp_id = sht.id
79: 	LEFT JOIN hygroscopies AS h
80: 	    ON p.hygroscopy_id = h.id
81: 	LEFT JOIN origincountries AS o
82: 	    ON p.origin_country_id = o.id
83: 	LEFT JOIN unnumbers AS un
84: 	    ON p.un_number_id = un.id
85: 	LEFT JOIN imoclasses AS ic
86: 	    ON p.imo_class_id = ic.id
87: 	LEFT JOIN packinggroups AS pg
88: 	    ON p.packing_group_id = pg.id WHERE p.id = '2580'
/var/www/klivon/class/model/_base.php line 29 class mysqli->query
/var/www/klivon/class/model/product.php line 750 class model\_Base->fetchObject
/var/www/klivon/class/controller/_base.php line 136 class model\Product->getBy
/var/www/klivon/class/controller/_base.php line 27 class controller\_Base->getBy
/var/www/klivon/view/product.php line 2 class controller\_Base->_getBy
/var/www/klivon/base/routes/1.public.php line 66
/var/www/klivon/class/util/rotas.php line 119
/var/www/klivon/base/routes/_base.php line 114 class util\Rotas->iniciar
/var/www/klivon/base/config.php line 179
/var/www/klivon/public/index.php line 6