06/08/2024 09:44:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2423' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 09:44:51 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' , '2423' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.79' , '89.06' , NOW() , NOW() ) 06/08/2024 09:44:51 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 = '92819' 06/08/2024 09:44:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92819' 06/08/2024 09:44:51 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 ( '92819' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 06/08/2024 09:44:51 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 ( '92819' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 06/08/2024 09:44:51 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 ( '92819' , '7202' , 'ARTICOLI RELIGIOSI' , '10' , '-10' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '35.00' ) 06/08/2024 09:44:51 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 ( '92819' , '21660' , 'PREGHIERA SEMINA GIOIA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/08/2024 09:44:51 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 ( '92819' , '22476' , 'AMEN - AGO 24' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 06/08/2024 09:44:51 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 ( '92819' , '22713' , 'AMEN - SET 24' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 06/08/2024 10:12:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2424' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:12:49 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' , '2424' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 06/08/2024 10:12: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 = '92820' 06/08/2024 10:12:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92820' 06/08/2024 10:12: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 ( '92820' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 06/08/2024 10:22:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2425' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:22:51 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' , '2425' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.80' , '66.69' , NOW() , NOW() ) 06/08/2024 10:22:51 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 = '92821' 06/08/2024 10:22:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92821' 06/08/2024 10:22:51 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 ( '92821' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 06/08/2024 10:22:51 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 ( '92821' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 06/08/2024 10:22:51 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 ( '92821' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 06/08/2024 10:22:51 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 ( '92821' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 06/08/2024 10:22:51 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 ( '92821' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 06/08/2024 10:22:51 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 ( '92821' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 06/08/2024 10:22:51 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 ( '92821' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/08/2024 10:23:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2425' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:23:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2425' AND id_document != '92821' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:23:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2425', document_date = '2024-08-06', 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 = '76.80', price_tax_excluded = '66.69', date_upd = NOW() WHERE id_document = '92821' 06/08/2024 10:23: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 = '92821' 06/08/2024 10:23:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92821' 06/08/2024 10:23: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 ( '92821' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 06/08/2024 10:23: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 ( '92821' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '3.5000' , '3.5' , '0' , '0' , '10.50' ) 06/08/2024 10:23: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 ( '92821' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 06/08/2024 10:23: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 ( '92821' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.5000' , '8.1730769230769' , '4' , '0' , '8.50' ) 06/08/2024 10:23: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 ( '92821' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 06/08/2024 10:23: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 ( '92821' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '1' , '-1' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '1.40' ) 06/08/2024 10:23: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 ( '92821' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/08/2024 10:34:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2426' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:34:20 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' , '2426' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '7.86' , NOW() , NOW() ) 06/08/2024 10:34:20 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 = '92822' 06/08/2024 10:34:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92822' 06/08/2024 10:34:20 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 ( '92822' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/08/2024 10:34:20 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 ( '92822' , '9726' , 'SCATOLINA OVALE GRANDE IN METALLO - 299/K25 - OGGETTI' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 06/08/2024 10:36:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2427' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:36:56 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' , '2427' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 06/08/2024 10:36:56 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 = '92823' 06/08/2024 10:36:56 am >> DELETE FROM ps_document_detail WHERE id_document = '92823' 06/08/2024 10:36:56 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 ( '92823' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/08/2024 10:36:56 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 ( '92823' , '2640' , 'CONFESSIONI - S. AGOSTINO ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 06/08/2024 10:47:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2428' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:47: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' , '2428' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 06/08/2024 10:47: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 = '92824' 06/08/2024 10:47:28 am >> DELETE FROM ps_document_detail WHERE id_document = '92824' 06/08/2024 10:47: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 ( '92824' , '15666' , 'STATUA MIRACOLOSA CM 60 - PA602' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 06/08/2024 10:47:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2429' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:47:56 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' , '2429' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 06/08/2024 10:47:56 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 = '92825' 06/08/2024 10:47:56 am >> DELETE FROM ps_document_detail WHERE id_document = '92825' 06/08/2024 10:47:56 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 ( '92825' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA - 8382' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/08/2024 10:47:56 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 ( '92825' , '6323' , 'MEDAGLIA MIRACOLOSA E CATERINA LABOURĂˆ - 8814' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 06/08/2024 10:54:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2430' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:54:52 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' , '2430' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 06/08/2024 10:54:52 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 = '92826' 06/08/2024 10:54:52 am >> DELETE FROM ps_document_detail WHERE id_document = '92826' 06/08/2024 10:54:52 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 ( '92826' , '22652' , 'CROCE SEMPLICE VARI COLORI' , '500' , '-500' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '150.00' ) 06/08/2024 10:57:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2431' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:57:18 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' , '2431' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 06/08/2024 10:57:18 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 = '92827' 06/08/2024 10:57:18 am >> DELETE FROM ps_document_detail WHERE id_document = '92827' 06/08/2024 10:57:18 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 ( '92827' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 06/08/2024 10:58:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2432' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 10:58:26 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' , '2432' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.90' , '15.49' , NOW() , NOW() ) 06/08/2024 10:58:26 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 = '92828' 06/08/2024 10:58:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92828' 06/08/2024 10:58:26 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 ( '92828' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '6' , '-6' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '8.40' ) 06/08/2024 10:58:26 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 ( '92828' , '15093' , 'BRACCIALE PAX - GOMMA' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 06/08/2024 11:01:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2433' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 11:01:56 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' , '2433' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '295.00' , '241.80' , NOW() , NOW() ) 06/08/2024 11:01:56 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 = '92829' 06/08/2024 11:01:56 am >> DELETE FROM ps_document_detail WHERE id_document = '92829' 06/08/2024 11:01:56 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 ( '92829' , '21785' , 'SACRO CUORE CM 30 - 616' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 06/08/2024 11:01:56 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 ( '92829' , '6057' , 'MADONNA DEL CARMINE - CM 60' , '1' , '-1' , '1' , '240' , '196.72131147541' , '22' , '0' , '240.00' ) 06/08/2024 11:01:56 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 ( '92829' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 06/08/2024 11:06:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2434' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 11:06:19 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' , '2434' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '2.40' , NOW() , NOW() ) 06/08/2024 11:06:19 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 = '92830' 06/08/2024 11:06:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92830' 06/08/2024 11:06:20 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 ( '92830' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.40' , '2.4' , '0' , '0' , '2.40' ) 06/08/2024 11:37:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2435' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 11:37:30 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' , '2435' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 06/08/2024 11:37:30 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 = '92831' 06/08/2024 11:37:30 am >> DELETE FROM ps_document_detail WHERE id_document = '92831' 06/08/2024 11:37:30 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 ( '92831' , '22476' , 'AMEN - AGO 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 06/08/2024 11:38:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001249' AND id_product != '15869' AND ean13 != '' 06/08/2024 11:38:37 am >> UPDATE ps_product SET id_supplier = '25', reference = '', ean13 = '001249', date_upd = NOW() WHERE id_product = '15869' 06/08/2024 11:38:37 am >> UPDATE ps_product_lang SET name = 'CASULA SATIN RAYE\' CON RICAMO ', description = '' WHERE id_product = '15869' 06/08/2024 11:38:37 am >> UPDATE ps_product SET wholesale_price = '140.00', on_sale = '0', price = '254.0983606557377' WHERE id_product = '15869' 06/08/2024 11:38:37 am >> UPDATE ps_product_shop SET wholesale_price = '140.00', price = '254.0983606557377', id_tax_rules_group = '1', id_category_default = '139', 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 = '15869' 06/08/2024 11:38:37 am >> DELETE FROM ps_specific_price WHERE id_product = '15869' 06/08/2024 11:40:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2436' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 11:40:25 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' , '2436' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '360.00' , '297.20' , NOW() , NOW() ) 06/08/2024 11:40:25 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 = '92832' 06/08/2024 11:40:25 am >> DELETE FROM ps_document_detail WHERE id_document = '92832' 06/08/2024 11:40:25 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 ( '92832' , '15869' , 'CASULA SATIN RAYE CON RICAMO ' , '1' , '-1' , '1' , '310.00' , '254.09836065574' , '22' , '0' , '310.00' ) 06/08/2024 11:40:25 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 ( '92832' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 06/08/2024 11:40:25 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 ( '92832' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 06/08/2024 11:40:25 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 ( '92832' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.1' , '28.770491803279' , '22' , '0' , '35.10' ) 06/08/2024 11:51:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2309' AND id_document != '92674' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-19') 06/08/2024 11:51:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2309', document_date = '2024-07-19', 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.30', price_tax_excluded = '9.26', date_upd = NOW() WHERE id_document = '92674' 06/08/2024 11:51:36 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 = '92674' 06/08/2024 11:51:36 am >> DELETE FROM ps_document_detail WHERE id_document = '92674' 06/08/2024 11:51:36 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 ( '92674' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 06/08/2024 11:51:36 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 ( '92674' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 06/08/2024 11:51:36 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 ( '92674' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 06/08/2024 11:52:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2275' AND id_document != '92633' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-16') 06/08/2024 11:52:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2275', document_date = '2024-07-16', 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 = '14.60', price_tax_excluded = '11.97', date_upd = NOW() WHERE id_document = '92633' 06/08/2024 11:52:20 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 = '92633' 06/08/2024 11:52:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92633' 06/08/2024 11:52:20 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 ( '92633' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '2' , '-2' , '1' , '4.8000' , '3.9344262295082' , '22' , '0' , '9.60' ) 06/08/2024 11:52:20 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 ( '92633' , '20182' , 'COPPIA TESTE DI ANGELO CM7 - AR06' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 06/08/2024 11:54:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1720' AND id_document != '91959' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-23') 06/08/2024 11:54:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1720', document_date = '2024-05-23', 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 = '14.60', price_tax_excluded = '12.29', date_upd = NOW() WHERE id_document = '91959' 06/08/2024 11:54:21 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 = '91959' 06/08/2024 11:54:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91959' 06/08/2024 11:54:21 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 ( '91959' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 06/08/2024 11:54:21 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 ( '91959' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.8000' , '3.9344262295082' , '22' , '0' , '4.80' ) 06/08/2024 11:54:21 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 ( '91959' , '15387' , 'VESTINA BATTESIMALE ' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 06/08/2024 11:54:21 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 ( '91959' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 06/08/2024 11:54:21 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 ( '91959' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 06/08/2024 12:11:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2437' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 06/08/2024 12:11: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' , '2437' , '2024-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.75' , '33.44' , NOW() , NOW() ) 06/08/2024 12:11: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 = '92833' 06/08/2024 12:11:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92833' 06/08/2024 12:11: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 ( '92833' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '25' , '-25' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '35.00' ) 06/08/2024 12:11: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 ( '92833' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )