18/01/2024 09:11:38 am >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 09:11:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '14' , '2024-01-18' , '' , '3213' , '0' , '4669539' , 'VIA MONTICELLI DI SOTTO 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.31' , '58.31' , NOW() , NOW() ) 18/01/2024 09:11:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89989' 18/01/2024 09:11:38 am >> DELETE FROM ps_document_detail WHERE id_document = '89989' 18/01/2024 09:11:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89989' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 18/01/2024 09:11:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89989' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '15' , '11.90' ) 18/01/2024 09:11:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89989' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '15' , '11.90' ) 18/01/2024 09:11:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89989' , '5458' , 'IO SONO CON VOI 2 PARTE' , '12' , '-12' , '4' , '2.80' , '2.8' , '0' , '15' , '28.56' ) 18/01/2024 09:12:37 am >> SELECT document_num FROM ps_document WHERE document_num = '177' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 09:12:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '177' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.38' , '31.38' , NOW() , NOW() ) 18/01/2024 09:12:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89990' 18/01/2024 09:12:37 am >> DELETE FROM ps_document_detail WHERE id_document = '89990' 18/01/2024 09:12:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89990' , '5444' , 'IO SONO CON VOI - CAT.' , '5' , '-5' , '4' , '5.23' , '5.23' , '0' , '0' , '26.15' ) 18/01/2024 09:12:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89990' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.23' , '5.23' , '0' , '0' , '5.23' ) 18/01/2024 09:13:32 am >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 09:13:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '15' , '2024-01-18' , '' , '169' , '0' , '4663860' , 'PIAZZA SANTA CROCE 84086 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '11.90' , '11.90' , NOW() , NOW() ) 18/01/2024 09:13:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89991' 18/01/2024 09:13:32 am >> DELETE FROM ps_document_detail WHERE id_document = '89991' 18/01/2024 09:13:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89991' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '15' , '11.90' ) 18/01/2024 09:14:03 am >> SELECT document_num FROM ps_document WHERE document_num = '178' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 09:14:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '178' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '11.90' , NOW() , NOW() ) 18/01/2024 09:14:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89992' 18/01/2024 09:14:03 am >> DELETE FROM ps_document_detail WHERE id_document = '89992' 18/01/2024 09:14:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89992' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11.9' , '11.9' , '0' , '0' , '11.90' ) 18/01/2024 09:14:27 am >> SELECT document_num FROM ps_document WHERE document_num = '179' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 09:14:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '179' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.20' , '4.20' , NOW() , NOW() ) 18/01/2024 09:14:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89993' 18/01/2024 09:14:27 am >> DELETE FROM ps_document_detail WHERE id_document = '89993' 18/01/2024 09:14:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89993' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.70' , '0.7' , '0' , '0' , '4.20' ) 18/01/2024 09:22:42 am >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '89989' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 09:22:42 am >> UPDATE ps_document SET id_document_type = '21', document_num = '14', document_date = '2024-01-18', document_letter = '', id_customer = '3213', id_supplier = '', id_address = '4669539', address1 = 'VIA MONTICELLI DI SOTTO 84085 MERCATO SAN SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '58.31', price_tax_excluded = '58.31', date_upd = NOW() WHERE id_document = '89989' 18/01/2024 09:22:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89989' 18/01/2024 09:22:42 am >> DELETE FROM ps_document_detail WHERE id_document = '89989' 18/01/2024 09:22:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89989' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 18/01/2024 09:22:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89989' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 18/01/2024 09:22:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89989' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 18/01/2024 09:22:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89989' , '5458' , 'IO SONO CON VOI 2 PARTE' , '12' , '-12' , '4' , '2.8000' , '2.8' , '0' , '15' , '28.56' ) 18/01/2024 09:22:52 am >> DELETE FROM ps_document WHERE id_document = '89991' 18/01/2024 09:22:52 am >> DELETE FROM ps_document_detail WHERE id_document = '89991' 18/01/2024 09:23:08 am >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '89960' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-16') 18/01/2024 09:23:08 am >> UPDATE ps_document SET id_document_type = '21', document_num = '13', document_date = '2024-01-16', document_letter = '', id_customer = '949', id_supplier = '', id_address = '4679102', address1 = 'VIA P. PALMIERI 39 10138 TORINO', address2 = '', note = '', price_shipping = '6.69', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '435.00', price_tax_excluded = '435.00', date_upd = NOW() WHERE id_document = '89960' 18/01/2024 09:23:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89960' 18/01/2024 09:23:09 am >> DELETE FROM ps_document_detail WHERE id_document = '89960' 18/01/2024 09:23:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89960' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 18/01/2024 09:23:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89960' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '0' , '17.9000' , '17.9' , '0' , '15' , '15.21' ) 18/01/2024 09:23:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89960' , '22055' , 'CROCE IN PVC -' , '100' , '-100' , '0' , '1.8000' , '1.8' , '0' , '15' , '153.00' ) 18/01/2024 09:23:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89960' , '15055' , 'CROCE PADRE NOSTRO' , '50' , '-50' , '0' , '3.2000' , '3.2' , '0' , '15' , '136.00' ) 18/01/2024 09:23:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89960' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '3' , '-3' , '0' , '30.0000' , '30' , '0' , '15' , '76.50' ) 18/01/2024 09:24:49 am >> SELECT document_num FROM ps_document WHERE document_num = '178' AND id_document != '89992' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 09:24:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '178', document_date = '2024-01-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.90', price_tax_excluded = '11.90', date_upd = NOW() WHERE id_document = '89992' 18/01/2024 09:24:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89992' 18/01/2024 09:24:49 am >> DELETE FROM ps_document_detail WHERE id_document = '89992' 18/01/2024 09:24:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89992' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '-5' , '4' , '2.38' , '2.38' , '0' , '0' , '11.90' ) 18/01/2024 09:43:13 am >> UPDATE ps_document SET id_document_type = '31', document_num = '34/2024', document_date = '2024-01-12', document_letter = '2024', id_customer = '0', id_supplier = '', id_address = '2618', address1 = 'V.LE ISONZO, 52 20135 MILANO', address2 = '', note = 'CAMBIARE NUMERO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '404.44', price_tax_excluded = '331.51', date_upd = NOW() WHERE id_document = '89963' 18/01/2024 09:43:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89963' 18/01/2024 09:43:13 am >> DELETE FROM ps_document_detail WHERE id_document = '89963' 18/01/2024 09:43:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89963' , '17617' , 'IMMAGINI ISONZO X 100' , '120' , '120' , '1' , '2.3000' , '1.8852459016393' , '22' , '25' , '252.54' ) 18/01/2024 09:43:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89963' , '22054' , 'INNO ALLAMORE' , '100' , '100' , '1' , '0.1100' , '0.09016393442623' , '22' , '25' , '10.07' ) 18/01/2024 09:43:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89963' , '22055' , 'CROCE IN PVC -' , '100' , '100' , '1' , '0.7500' , '0.61475409836066' , '22' , '25' , '68.63' ) 18/01/2024 09:43:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89963' , '15055' , 'CROCE PADRE NOSTRO' , '50' , '50' , '1' , '1.6000' , '1.3114754098361' , '22' , '25' , '73.20' ) 18/01/2024 09:46:22 am >> UPDATE ps_document SET id_document_type = '31', document_num = '34/2024', document_date = '2024-01-12', document_letter = '2024', id_customer = '0', id_supplier = '', id_address = '2618', address1 = 'V.LE ISONZO, 52 20135 MILANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '404.44', price_tax_excluded = '331.51', date_upd = NOW() WHERE id_document = '89963' 18/01/2024 09:46:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89963' 18/01/2024 09:46:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89963' 18/01/2024 09:46:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89963' , '17617' , 'IMMAGINI ISONZO X 100' , '120' , '120' , '1' , '2.3000' , '1.8852459016393' , '22' , '25' , '252.54' ) 18/01/2024 09:46:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89963' , '22054' , 'INNO ALLAMORE' , '100' , '100' , '1' , '0.1100' , '0.09016393442623' , '22' , '25' , '10.07' ) 18/01/2024 09:46:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89963' , '22055' , 'CROCE IN PVC -' , '100' , '100' , '1' , '0.7500' , '0.61475409836066' , '22' , '25' , '68.63' ) 18/01/2024 09:46:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89963' , '15055' , 'CROCE PADRE NOSTRO' , '50' , '50' , '1' , '1.6000' , '1.3114754098361' , '22' , '25' , '73.20' ) 18/01/2024 10:03:24 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10685' 18/01/2024 10:03:24 am >> UPDATE ps_stock_available SET quantity = quantity + '-3' WHERE id_product = '10685' 18/01/2024 10:09:57 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11654' 18/01/2024 10:09:57 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '11654' 18/01/2024 10:42:10 am >> SELECT document_num FROM ps_document WHERE document_num = '180' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 10:42:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '180' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 18/01/2024 10:42:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89994' 18/01/2024 10:42:10 am >> DELETE FROM ps_document_detail WHERE id_document = '89994' 18/01/2024 10:42:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89994' , '19867' , 'CINGOLO NODO BIANCO - F9756' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 18/01/2024 10:54:43 am >> SELECT document_num FROM ps_document WHERE document_num = '181' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 10:54:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '181' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '213.33' , '175.46' , NOW() , NOW() ) 18/01/2024 10:54:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89995' 18/01/2024 10:54:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89995' 18/01/2024 10:54:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89995' , '14401' , 'BALZA CM 19' , '10' , '-10' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '180.00' ) 18/01/2024 10:54:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89995' , '7753' , 'PECCATO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 18/01/2024 10:54:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89995' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 18/01/2024 10:55:47 am >> SELECT document_num FROM ps_document WHERE document_num = '182' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 10:55:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '182' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 18/01/2024 10:55:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89996' 18/01/2024 10:55:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89996' 18/01/2024 10:55:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89996' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 18/01/2024 10:57:28 am >> SELECT document_num FROM ps_document WHERE document_num = '183' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 10:57:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '183' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 18/01/2024 10:57:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89997' 18/01/2024 10:57:28 am >> DELETE FROM ps_document_detail WHERE id_document = '89997' 18/01/2024 10:57:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89997' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '2' , '-2' , '4' , '12.00' , '12' , '0' , '5' , '22.80' ) 18/01/2024 10:57:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89997' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 18/01/2024 10:58:06 am >> SELECT document_num FROM ps_document WHERE document_num = '184' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 10:58:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '184' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.50' , '65.83' , NOW() , NOW() ) 18/01/2024 10:58:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89998' 18/01/2024 10:58:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89998' 18/01/2024 10:58:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89998' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 18/01/2024 10:58:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89998' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 18/01/2024 10:59:03 am >> SELECT document_num FROM ps_document WHERE document_num = '185' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 10:59:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '185' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 18/01/2024 10:59:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89999' 18/01/2024 10:59:03 am >> DELETE FROM ps_document_detail WHERE id_document = '89999' 18/01/2024 10:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89999' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 18/01/2024 11:01:59 am >> SELECT document_num FROM ps_document WHERE document_num = '186' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 11:01:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '186' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '12.70' , NOW() , NOW() ) 18/01/2024 11:01:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90000' 18/01/2024 11:01:59 am >> DELETE FROM ps_document_detail WHERE id_document = '90000' 18/01/2024 11:01:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90000' , '18764' , 'STELLARIO PLEX CM 18/20' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 18/01/2024 11:07:48 am >> SELECT document_num FROM ps_document WHERE document_num = '187' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 11:07:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '187' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '11.89' , NOW() , NOW() ) 18/01/2024 11:07:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90001' 18/01/2024 11:07:48 am >> DELETE FROM ps_document_detail WHERE id_document = '90001' 18/01/2024 11:07:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90001' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '5' , '-5' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '14.50' ) 18/01/2024 11:52:11 am >> SELECT document_num FROM ps_document WHERE document_num = '183' AND id_document != '89997' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 11:52:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '183', document_date = '2024-01-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.50', price_tax_excluded = '28.50', date_upd = NOW() WHERE id_document = '89997' 18/01/2024 11:52:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89997' 18/01/2024 11:52:12 am >> DELETE FROM ps_document_detail WHERE id_document = '89997' 18/01/2024 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89997' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 18/01/2024 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89997' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '5' , '5.70' ) 18/01/2024 11:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89997' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '12' , '12' , '0' , '5' , '11.40' ) 18/01/2024 12:46:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '188' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 12:46:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '188' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.66' , '16.66' , NOW() , NOW() ) 18/01/2024 12:46:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90002' 18/01/2024 12:46:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90002' 18/01/2024 12:46:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90002' , '11192' , 'VENITE CON ME 2 PARTE' , '7' , '-7' , '4' , '2.38' , '2.38' , '0' , '0' , '16.66' ) 18/01/2024 12:59:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '189' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 12:59:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '189' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.10' , '79.58' , NOW() , NOW() ) 18/01/2024 12:59:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90003' 18/01/2024 12:59:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '90003' 18/01/2024 12:59:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90003' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '15' , '12.295081967213' , '22' , '0' , '75.00' ) 18/01/2024 12:59:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90003' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '5' , '18.10' ) 18/01/2024 01:01:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 01:01:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '11/A' , '2024-01-18' , 'A' , '371' , '0' , '4679091' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.50' , '61.89' , NOW() , NOW() ) 18/01/2024 01:01:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90004' 18/01/2024 01:01:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '90004' 18/01/2024 01:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90004' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '35.50' , '29.098360655738' , '22' , '0' , '35.50' ) 18/01/2024 01:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90004' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 18/01/2024 02:12:31 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/01/2024 02:12:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22064' , '1' , '' , 'nuovo-prodotto' ) 18/01/2024 02:12:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22064' , '1' , '1' , '2' , NOW() , NOW() ) 18/01/2024 02:12:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22064' , '0' , '1' , '0' , '0' ) 18/01/2024 02:13:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278980' AND id_product != '22064' AND ean13 != '' 18/01/2024 02:13:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831278980', date_upd = NOW() WHERE id_product = '22064' 18/01/2024 02:13:00 pm >> UPDATE ps_product_lang SET name = 'QUARESIMA 2024', description = '' WHERE id_product = '22064' 18/01/2024 02:13:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.6' WHERE id_product = '22064' 18/01/2024 02:13:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.6', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22064' 18/01/2024 02:13:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '22064' 18/01/2024 02:13:01 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22064' 18/01/2024 02:13:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22065' , '1' , '' , 'nuovo-prodotto' ) 18/01/2024 02:13:01 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22065' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22064' 18/01/2024 02:13:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22065' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22064' 18/01/2024 02:14:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068870' AND id_product != '22065' AND ean13 != '' 18/01/2024 02:14:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788801068870', date_upd = NOW() WHERE id_product = '22065' 18/01/2024 02:14:15 pm >> UPDATE ps_product_lang SET name = 'SALMI NELLA PEDAGOGIA DI DON BOSCO - M. WIRTH', description = '' WHERE id_product = '22065' 18/01/2024 02:14:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '22065' 18/01/2024 02:14:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22065' 18/01/2024 02:14:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '22065' 18/01/2024 02:14:16 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22065' 18/01/2024 02:14:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22066' , '1' , '' , 'nuovo-prodotto' ) 18/01/2024 02:14:16 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22066' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22065' 18/01/2024 02:14:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22066' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22065' 18/01/2024 02:15:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '653512' , '2024-01-17' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.39' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.73' , '84.73' , NOW() , NOW() ) 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90005' 18/01/2024 02:15:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '90005' 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90005' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '12' , '12' , '4' , '2.50' , '2.5' , '0' , '33' , '20.1000' ) 18/01/2024 02:15:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10965' AND id_supplier = '7' 18/01/2024 02:15:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10965' , '7' , '1' ) 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90005' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '100' , '0.0000' ) 18/01/2024 02:15:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10965' AND id_supplier = '7' 18/01/2024 02:15:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10965' , '7' , '1' ) 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90005' , '22064' , 'QUARESIMA 2024' , '5' , '5' , '4' , '3.60' , '3.6' , '0' , '30' , '12.6000' ) 18/01/2024 02:15:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22064' AND id_supplier = '7' 18/01/2024 02:15:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22064' , '7' , '1' ) 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90005' , '22065' , 'SALMI NELLA PEDAGOGIA DI DON BOSCO - M. WIRTH' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '35' , '4.4850' ) 18/01/2024 02:15:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22065' AND id_supplier = '7' 18/01/2024 02:15:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22065' , '7' , '1' ) 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90005' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '3' , '3' , '4' , '6.00' , '6' , '0' , '30' , '12.6000' ) 18/01/2024 02:15:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21751' AND id_supplier = '7' 18/01/2024 02:15:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21751' , '7' , '1' ) 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90005' , '21541' , 'OMELIE SUI SANTI - A. COMASTRI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 18/01/2024 02:15:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21541' AND id_supplier = '7' 18/01/2024 02:15:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21541' , '7' , '1' ) 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90005' , '22001' , 'VERRO A TROVARTI TUTTE LE VOLTE CHE VORRAI - S. ZAMPA' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '33' , '4.6230' ) 18/01/2024 02:15:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22001' AND id_supplier = '7' 18/01/2024 02:15:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22001' , '7' , '1' ) 18/01/2024 02:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90005' , '13256' , 'SINAI: VIAGGIO CON MOSE - GIOCO' , '1' , '1' , '4' , '19.90' , '19.9' , '0' , '30' , '13.9300' ) 18/01/2024 02:15:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13256' AND id_supplier = '7' 18/01/2024 02:15:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13256' , '7' , '1' ) 18/01/2024 02:18:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002165' AND id_product != '21420' AND ean13 != '' 18/01/2024 02:18:37 pm >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '002165', date_upd = NOW() WHERE id_product = '21420' 18/01/2024 02:18:37 pm >> UPDATE ps_product_lang SET name = 'STOLA IN RASO IHS - 7871', description = '' WHERE id_product = '21420' 18/01/2024 02:18:37 pm >> UPDATE ps_product SET wholesale_price = '70.00', on_sale = '0', price = '147.54098360655738' WHERE id_product = '21420' 18/01/2024 02:18:37 pm >> UPDATE ps_product_shop SET wholesale_price = '70.00', price = '147.54098360655738', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21420' 18/01/2024 02:18:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '21420' 18/01/2024 02:19:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '7897' AND id_product != '15408' AND ean13 != '' 18/01/2024 02:19:48 pm >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '7897', date_upd = NOW() WHERE id_product = '15408' 18/01/2024 02:19:48 pm >> UPDATE ps_product_lang SET name = 'STOLA IN RASO CON RICAMO CROCE E SPIGHE - 7897', description = '' WHERE id_product = '15408' 18/01/2024 02:19:48 pm >> UPDATE ps_product SET wholesale_price = '70.00', on_sale = '0', price = '147.54098360655738' WHERE id_product = '15408' 18/01/2024 02:19:48 pm >> UPDATE ps_product_shop SET wholesale_price = '70.00', price = '147.54098360655738', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15408' 18/01/2024 02:19:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '15408' 18/01/2024 02:20:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '7877' AND id_product != '18184' AND ean13 != '' 18/01/2024 02:20:31 pm >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '7877', date_upd = NOW() WHERE id_product = '18184' 18/01/2024 02:20:31 pm >> UPDATE ps_product_lang SET name = 'STOLA RASO CON RICAMO UVA - 7877', description = '' WHERE id_product = '18184' 18/01/2024 02:20:31 pm >> UPDATE ps_product SET wholesale_price = '70.00', on_sale = '0', price = '147.54098360655738' WHERE id_product = '18184' 18/01/2024 02:20:31 pm >> UPDATE ps_product_shop SET wholesale_price = '70.00', price = '147.54098360655738', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18184' 18/01/2024 02:20:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '18184' 18/01/2024 02:20:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2/2024' , '2024-01-16' , '2024' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '427.00' , '350.00' , NOW() , NOW() ) 18/01/2024 02:20:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90006' 18/01/2024 02:20:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90006' 18/01/2024 02:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90006' , '21420' , 'STOLA IN RASO IHS - 7871' , '3' , '3' , '1' , '70' , '57.377049180328' , '22' , '0' , '256.2000' ) 18/01/2024 02:20:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21420' AND id_supplier = '126' 18/01/2024 02:20:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21420' , '126' , '1' ) 18/01/2024 02:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90006' , '15408' , 'STOLA IN RASO CON RICAMO CROCE E SPIGHE - 7897' , '1' , '1' , '1' , '70' , '57.377049180328' , '22' , '0' , '85.4000' ) 18/01/2024 02:20:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15408' AND id_supplier = '126' 18/01/2024 02:20:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15408' , '126' , '1' ) 18/01/2024 02:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90006' , '18184' , 'STOLA RASO CON RICAMO UVA - 7877' , '1' , '1' , '1' , '70' , '57.377049180328' , '22' , '0' , '85.4000' ) 18/01/2024 02:20:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18184' AND id_supplier = '126' 18/01/2024 02:20:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18184' , '126' , '1' ) 18/01/2024 02:32:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001090' AND id_product != '14724' AND ean13 != '' 18/01/2024 02:32:23 pm >> UPDATE ps_product SET id_supplier = '118', reference = '', ean13 = '001090', date_upd = NOW() WHERE id_product = '14724' 18/01/2024 02:32:23 pm >> UPDATE ps_product_lang SET name = 'STOLA MARIANA - ART.1028/342', description = '' WHERE id_product = '14724' 18/01/2024 02:32:23 pm >> UPDATE ps_product SET wholesale_price = '53.35', on_sale = '0', price = '126.22950819672131' WHERE id_product = '14724' 18/01/2024 02:32:23 pm >> UPDATE ps_product_shop SET wholesale_price = '53.35', price = '126.22950819672131', id_tax_rules_group = '1', id_category_default = '432', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14724' 18/01/2024 02:32:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '14724' 18/01/2024 02:34:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '26' , '2024-01-17' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , '' , '13.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '496.62' , '409.50' , NOW() , NOW() ) 18/01/2024 02:34:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90007' 18/01/2024 02:34:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90007' 18/01/2024 02:34:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90007' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '3' , '3' , '1' , '54' , '44.262295081967' , '22' , '0' , '197.6400' ) 18/01/2024 02:34:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118' 18/01/2024 02:34:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' ) 18/01/2024 02:34:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90007' , '20848' , 'CAMICE MONASTICO CON CAPPUCCIO - 21MON' , '1' , '1' , '1' , '93' , '76.229508196721' , '22' , '0' , '113.4600' ) 18/01/2024 02:34:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20848' AND id_supplier = '118' 18/01/2024 02:34:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20848' , '118' , '1' ) 18/01/2024 02:34:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90007' , '14724' , 'STOLA MARIANA - ART.1028/342' , '1' , '1' , '1' , '63' , '51.639344262295' , '22' , '0' , '76.8600' ) 18/01/2024 02:34:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14724' AND id_supplier = '118' 18/01/2024 02:34:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14724' , '118' , '1' ) 18/01/2024 02:34:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90007' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '1' , '1' , '78' , '63.934426229508' , '22' , '0' , '95.1600' ) 18/01/2024 02:34:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14578' AND id_supplier = '118' 18/01/2024 02:34:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14578' , '118' , '1' ) 18/01/2024 04:21:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '190' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 04:21:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '190' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.83' , '7.75' , NOW() , NOW() ) 18/01/2024 04:21:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90008' 18/01/2024 04:21:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90008' 18/01/2024 04:21:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90008' , '19542' , 'LETTERA AGLI SPOSI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 18/01/2024 04:21:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90008' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 18/01/2024 04:21:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90008' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 18/01/2024 04:31:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '191' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 04:31:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '191' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.20' , '9.83' , NOW() , NOW() ) 18/01/2024 04:31:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90009' 18/01/2024 04:31:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '90009' 18/01/2024 04:31:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90009' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '1.2' , '1.2' , '0' , '0' , '3.60' ) 18/01/2024 04:31:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90009' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '7.60' ) 18/01/2024 05:17:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '192' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 05:17:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '192' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.50' , '37.30' , NOW() , NOW() ) 18/01/2024 05:17:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90010' 18/01/2024 05:17:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '90010' 18/01/2024 05:17:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90010' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '7' , '-7' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '45.50' ) 18/01/2024 06:12:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '272/23' , '2023-09-26' , '23' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '36.00' , '36.00' , NOW() , NOW() ) 18/01/2024 06:12:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90011' 18/01/2024 06:12:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90011' 18/01/2024 06:12:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90011' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '60' , '0' , '4' , '0.6' , '0.6' , '0' , '0' , '36.0000' ) 18/01/2024 06:13:14 pm >> DELETE FROM ps_document WHERE id_document = '87460' 18/01/2024 06:13:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '87460' 18/01/2024 06:13:38 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '272/23', document_date = '2023-09-26', document_letter = '23', id_customer = '0', id_supplier = '0', id_address = '4671003', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '36.00', price_tax_excluded = '36.00', date_upd = NOW() WHERE id_document = '90011' 18/01/2024 06:13:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90011' 18/01/2024 06:13:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '90011' 18/01/2024 06:13:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90011' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '60' , '0' , '4' , '0.6000' , '0.6' , '0' , '0' , '36.00' ) 18/01/2024 06:49:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '193' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 18/01/2024 06:49:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '193' , '2024-01-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 18/01/2024 06:49:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90012' 18/01/2024 06:49:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '90012' 18/01/2024 06:49:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90012' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6' , '6' , '0' , '5' , '5.70' ) 18/01/2024 07:27:52 pm >> DELETE FROM ps_document WHERE id_document = '89907' 18/01/2024 07:27:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '89907' 18/01/2024 07:30:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024000000213' , '2024-01-16' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.30' , '124.30' , NOW() , NOW() ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90013' 18/01/2024 07:30:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '90013' 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '22056' , 'E IO VI RISTORERO - M. ZUPPI' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22056' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22056' , '107' , '1' ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '22057' , 'SEQUELA CHRISTI - C.M. MARTINI' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22057' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22057' , '107' , '1' ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '5' , '5' , '4' , '9.0000' , '9' , '0' , '35' , '29.25' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21760' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21760' , '107' , '1' ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '2' , '2' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22042' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22042' , '107' , '1' ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '22058' , 'TEOLOGIA LITURGICA DEI SACRAMENTI - A. MIRALLES' , '1' , '1' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22058' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22058' , '107' , '1' ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '22059' , 'CREARE CASA - SUSSIDIO' , '3' , '3' , '4' , '4.0000' , '4' , '0' , '35' , '7.80' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22059' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22059' , '107' , '1' ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '22060' , 'CREARE CASA - IMMAGINETTE' , '100' , '100' , '4' , '0.1000' , '0.1' , '0' , '35' , '6.50' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22060' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22060' , '107' , '1' ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '22061' , 'FEDE DI ABRAMO E FEDE CRISTIANA - F. MOSETTO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22061' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22061' , '107' , '1' ) 18/01/2024 07:30:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90013' , '22062' , 'SOSTENERE LE RAGIONI DELLA FEDE - S. GUSTAVSSON' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 18/01/2024 07:30:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22062' AND id_supplier = '107' 18/01/2024 07:30:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22062' , '107' , '1' ) 18/01/2024 07:30:49 pm >> DELETE FROM ps_document WHERE id_document = '89981' 18/01/2024 07:30:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89981' 18/01/2024 07:33:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1233' AND id_document != '82784' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-13') 18/01/2024 07:33:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1233', document_date = '2023-04-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '200.05', price_tax_excluded = '167.59', date_upd = NOW() WHERE id_document = '82784' 18/01/2024 07:33:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82784' 18/01/2024 07:33:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82784' 18/01/2024 07:33:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82784' , '20918' , 'TOTUM AMORIS EST' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 18/01/2024 07:33:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82784' , '20417' , 'NON SARA SUBITO LA FINE - G. ZANCHI' , '1' , '-1' , '4' , '11.0500' , '11.05' , '0' , '0' , '11.05' ) 18/01/2024 07:33:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82784' , '21420' , 'STOLA IN RASO IHS - 7871' , '1' , '-1' , '1' , '180.00' , '147.54098360656' , '22' , '0' , '180.00' ) 18/01/2024 07:42:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '231' AND id_document != '70275' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-02') 18/01/2024 07:42:08 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '231', document_date = '2022-11-02', document_letter = '', id_customer = '326', id_supplier = '', id_address = '4671618', address1 = 'VIALE 18 DICEMBRE 04100 LATINA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '499.80', price_tax_excluded = '499.80', date_upd = NOW() WHERE id_document = '70275' 18/01/2024 07:42:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70275' 18/01/2024 07:42:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '70275' 18/01/2024 07:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '4154' , 'FESTA DEL PERDONO' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 18/01/2024 07:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '16199' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 18/01/2024 07:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '4120' , 'FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '5.0000' , '5' , '0' , '15' , '85.00' ) 18/01/2024 07:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.85' , '0.85' , '0' , '0' , '1.70' ) 18/01/2024 07:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '150' , '-150' , '4' , '1.5000' , '1.5' , '0' , '15' , '191.25' ) 18/01/2024 07:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70275' , '5251' , 'INCONTRI EUCARISTICI' , '34' , '-34' , '4' , '3.825' , '3.825' , '0' , '0' , '130.05' )