24/02/2023 09:15:12 am >> SELECT document_num FROM ps_document
WHERE document_num = '35' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 09:15:12 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' ,
'35' ,
'2023-02-24' ,
'' ,
'4007' ,
'0' ,
'4678838' ,
'Via Fenati Dionigi , 3 48022 Santa Maria in Fabriago ' ,
'' ,
'' ,
'5.00' ,
'0' ,
'0' ,
'0' ,
'0' ,
'' ,
'6' ,
'0' ,
'19.30' ,
'19.30' ,
NOW() ,
NOW() )
24/02/2023 09:15:12 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 = '81996'
24/02/2023 09:15:12 am >> DELETE FROM ps_document_detail WHERE id_document = '81996'
24/02/2023 09:15: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
( '81996' , '4154' , 'FESTA DEL PERDONO' , '4' , '-4' , '4' ,
'3.0000' , '3' , '0' , '5' , '11.40' )
24/02/2023 09:15: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
( '81996' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' ,
'2.90' , '2.90' , '' , '0' , '2.90' )
24/02/2023 09:15:28 am >> UPDATE ps_orders SET
current_state = '4',
delivery_date = '2023-02-24'
WHERE id_order = '417'
24/02/2023 09:15:28 am >> DELETE FROM ps_document WHERE document_num = '417' AND id_document_type = '28'
24/02/2023 09:22:36 am >> SELECT document_num FROM ps_document
WHERE document_num = '35' AND id_document != '81996' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 09:22:36 am >> UPDATE ps_document SET
id_document_type = '21',
document_num = '35',
document_date = '2023-02-24',
document_letter = '',
id_customer = '4007',
id_supplier = '',
id_address = '4678838',
address1 = 'Via Fenati Dionigi , 3 48022 Santa Maria in Fabriago ',
address2 = '',
note = '',
price_shipping = '5.00',
id_tax_shipping_rules = '0',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '9',
id_causal = '0',
price_tax_included = '19.30',
price_tax_excluded = '19.30',
date_upd = NOW()
WHERE id_document = '81996'
24/02/2023 09:22: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 = '81996'
24/02/2023 09:22:36 am >> DELETE FROM ps_document_detail WHERE id_document = '81996'
24/02/2023 09:22: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
( '81996' , '4154' , 'FESTA DEL PERDONO' , '4' , '-4' , '4' ,
'3.0000' , '3' , '0' , '5' , '11.40' )
24/02/2023 09:22: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
( '81996' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' ,
'2.9' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 10:25:05 am >> SELECT document_num FROM ps_document
WHERE document_num = '613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 10:25:05 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' ,
'613' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'206.97' ,
'206.97' ,
NOW() ,
NOW() )
24/02/2023 10:25:05 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 = '81997'
24/02/2023 10:25:05 am >> DELETE FROM ps_document_detail WHERE id_document = '81997'
24/02/2023 10:25:05 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
( '81997' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '31' , '-31' , '4' ,
'5.00' , '5' , '0' , '5' , '147.25' )
24/02/2023 10:25:05 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
( '81997' , '20528' , 'AMEN - MAR 23' , '6' , '-6' , '4' ,
'3.90' , '3.9' , '0' , '5' , '22.26' )
24/02/2023 10:25:05 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
( '81997' , '20527' , 'AMEN - APR 23' , '6' , '-6' , '4' ,
'3.90' , '3.9' , '0' , '5' , '22.26' )
24/02/2023 10:25:05 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
( '81997' , '20632' , 'MESSA MEDITAZIONE - MAR/APR 2023' , '2' , '-2' , '4' ,
'8.00' , '8' , '0' , '5' , '15.20' )
24/02/2023 11:22:39 am >> SELECT document_num FROM ps_document
WHERE document_num = '614' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 11:22:39 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' ,
'614' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'26.50' ,
'26.37' ,
NOW() ,
NOW() )
24/02/2023 11:22:39 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 = '81998'
24/02/2023 11:22:39 am >> DELETE FROM ps_document_detail WHERE id_document = '81998'
24/02/2023 11:22:39 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
( '81998' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '3.50' )
24/02/2023 11:22:39 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
( '81998' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'23' , '23' , '0' , '0' , '23.00' )
24/02/2023 11:23:31 am >> SELECT document_num FROM ps_document
WHERE document_num = '615' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 11:23:31 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' ,
'615' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'60.00' ,
'55.67' ,
NOW() ,
NOW() )
24/02/2023 11:23:31 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 = '81999'
24/02/2023 11:23:31 am >> DELETE FROM ps_document_detail WHERE id_document = '81999'
24/02/2023 11:23:31 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
( '81999' , '19320' , 'QUADRO PIASTRELLA 20X20 SACRA FAMIGLIA - 2189/I0102' , '1' , '-1' , '1' ,
'24.00' , '19.672131147541' , '22' , '0' , '24.00' )
24/02/2023 11:23:31 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
( '81999' , '20773' , 'VIA CRUCIS CON BENEDETTO XVI' , '2' , '-2' , '4' ,
'2.00' , '2' , '0' , '0' , '4.00' )
24/02/2023 11:23:31 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
( '81999' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '1' , '-1' , '4' ,
'1.6' , '1.6' , '0' , '0' , '1.60' )
24/02/2023 11:23:31 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
( '81999' , '20532' , 'HO VISTO E UDITO - ILDEGARDA DI BINGEN' , '1' , '-1' , '4' ,
'32.00' , '32' , '0' , '5' , '30.40' )
24/02/2023 11:26:02 am >> SELECT document_num FROM ps_document
WHERE document_num = '111/A' AND id_document != '76151' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-07')
24/02/2023 11:26:02 am >> UPDATE ps_document SET
id_document_type = '24',
document_num = '111/A',
document_date = '2022-12-07',
document_letter = 'A',
id_customer = '3865',
id_supplier = '',
id_address = '4673708',
address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO',
address2 = '',
note = 'acconto € 100,00 3/2/22 - 24/02/2023 € 100,00',
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 = '1000.00',
price_tax_excluded = '819.67',
date_upd = NOW()
WHERE id_document = '76151'
24/02/2023 11:26:02 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 = '76151'
24/02/2023 11:26:02 am >> DELETE FROM ps_document_detail WHERE id_document = '76151'
24/02/2023 11:26:02 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
( '76151' , '19853' , 'CASULA GOTICA L/S LAME\' - 8257' , '1' , '-1' , '1' ,
'1000.0000' , '819.67213114754' , '22' , '0' , '1000.00' )
24/02/2023 12:03:24 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
24/02/2023 12:03:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20776' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 12:03:24 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20776' , '1' , '1' , '2' , NOW() , NOW()
)
24/02/2023 12:03:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20776' , '0' , '1' , '0' , '0' )
24/02/2023 12:04:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879624091' AND id_product != '20776' AND ean13 != ''
24/02/2023 12:04:53 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '6/3',
ean13 = '9788879624091',
date_upd = NOW()
WHERE id_product = '20776'
24/02/2023 12:04:53 pm >> UPDATE ps_product_lang SET
name = 'PREGARE I SALMI CON FRANCESCO D\'ASSISI - L. BERGAMASCHI',
description = ''
WHERE id_product = '20776'
24/02/2023 12:04:53 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '14'
WHERE id_product = '20776'
24/02/2023 12:04:53 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '14',
id_tax_rules_group = '4',
id_category_default = '110',
id_argoment_default = '23',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20776'
24/02/2023 12:04:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '20776'
24/02/2023 12:04:54 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 = '20776'
24/02/2023 12:04:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20777' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 12:04:54 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 '20777' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20776'
24/02/2023 12:04:54 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '20777' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20776'
24/02/2023 12:05: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 (
'33' ,
'2023000001162' ,
'2023-02-23' ,
'' ,
'0' ,
'107' ,
'4669100' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'6' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'67.10' ,
'67.10' ,
NOW() ,
NOW() )
24/02/2023 12:05: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 = '82000'
24/02/2023 12:05:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '82000'
24/02/2023 12:05: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
( '82000' , '20776' , 'PREGARE I SALMI CON FRANCESCO DASSISI - L. BERGAMASCHI' , '1' , '1' , '4' ,
'14.00' , '14' , '0' , '35' , '9.1000' )
24/02/2023 12:05:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20776' AND id_supplier = '107'
24/02/2023 12:05:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20776' , '107' , '1' )
24/02/2023 12:05: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
( '82000' , '20396' , 'MINISTERO DI GESù NEL VANGELO SECONDO MATTEO - N. DI BIANCO' , '5' , '5' , '4' ,
'16.00' , '16' , '0' , '35' , '52.0000' )
24/02/2023 12:05:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20396' AND id_supplier = '107'
24/02/2023 12:05:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20396' , '107' , '1' )
24/02/2023 12:33:33 pm >> SELECT document_num FROM ps_document
WHERE document_num = '616' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 12:33:33 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' ,
'616' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'57.00' ,
'57.00' ,
NOW() ,
NOW() )
24/02/2023 12:33:33 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 = '82001'
24/02/2023 12:33:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '82001'
24/02/2023 12:33:33 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
( '82001' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '3' , '-3' , '4' ,
'2.00' , '2' , '0' , '5' , '5.70' )
24/02/2023 12:33:33 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
( '82001' , '17626' , 'ADORIAMO IL SS SACRAMENTO - QUARESIMA - 8202' , '2' , '-2' , '4' ,
'3.00' , '3' , '0' , '5' , '5.70' )
24/02/2023 12:33:33 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
( '82001' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '3' , '-3' , '4' ,
'10.00' , '10' , '0' , '5' , '28.50' )
24/02/2023 12:33:33 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
( '82001' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '5' , '11.40' )
24/02/2023 12:33:33 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
( '82001' , '20710' , 'VIA CRUCIS DELLA PACE' , '3' , '-3' , '4' ,
'2.00' , '2' , '0' , '5' , '5.70' )
24/02/2023 12:33:54 pm >> SELECT document_num FROM ps_document
WHERE document_num = '617' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 12:33:54 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' ,
'617' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'18.50' ,
'18.50' ,
NOW() ,
NOW() )
24/02/2023 12:33:54 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 = '82002'
24/02/2023 12:33:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '82002'
24/02/2023 12:33:54 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
( '82002' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' ,
'18.50' , '18.5' , '0' , '0' , '18.50' )
24/02/2023 12:35:12 pm >> SELECT document_num FROM ps_document
WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 12:35:12 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 (
'21' ,
'36' ,
'2023-02-24' ,
'' ,
'27' ,
'0' ,
'4677541' ,
'P.ZZA PIRONTI 83025 PIANO DI MONTORO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'57.29' ,
'57.29' ,
NOW() ,
NOW() )
24/02/2023 12:35:12 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 = '82003'
24/02/2023 12:35:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '82003'
24/02/2023 12:35:12 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
( '82003' , '20719' , 'CORONA DELL’ADDOLORATA' , '4' , '-4' , '4' ,
'1.80' , '1.8' , '0' , '15' , '6.12' )
24/02/2023 12:35:12 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
( '82003' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '12' , '-12' , '4' ,
'0.85' , '0.85' , '0' , '15' , '8.67' )
24/02/2023 12:35:12 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
( '82003' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '50' , '-50' , '4' ,
'1.00' , '1' , '0' , '15' , '42.50' )
24/02/2023 12:36:21 pm >> SELECT document_num FROM ps_document
WHERE document_num = '618' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 12:36:21 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' ,
'618' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'1.00' ,
'1.00' ,
NOW() ,
NOW() )
24/02/2023 12:36:21 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 = '82004'
24/02/2023 12:36:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82004'
24/02/2023 12:36:21 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
( '82004' , '20774' , 'MESSAGGIO PER LA QUARESIMA 2023' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
24/02/2023 12:57:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821598531' AND id_product != '1114' AND ean13 != ''
24/02/2023 12:57:36 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '11/3',
ean13 = '9788821598531',
date_upd = NOW()
WHERE id_product = '1114'
24/02/2023 12:57:37 pm >> UPDATE ps_product_lang SET
name = 'BIBBIA DEGLI SPOSI',
description = ''
WHERE id_product = '1114'
24/02/2023 12:57:37 pm >> UPDATE ps_product SET
wholesale_price = '12.40',
on_sale = '0',
price = '25'
WHERE id_product = '1114'
24/02/2023 12:57:37 pm >> UPDATE ps_product_shop SET
wholesale_price = '12.40',
price = '25',
id_tax_rules_group = '4',
id_category_default = '30',
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 = '1114'
24/02/2023 12:57:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '1114'
24/02/2023 12:58:07 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' ,
'623991' ,
'2023-02-23' ,
'' ,
'0' ,
'7' ,
'2602' ,
'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
'' ,
'' ,
'2.5' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'71.18' ,
'71.18' ,
NOW() ,
NOW() )
24/02/2023 12:58:07 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 = '82005'
24/02/2023 12:58:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '82005'
24/02/2023 12:58:07 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
( '82005' , '1114' , 'BIBBIA DEGLI SPOSI' , '5' , '5' , '4' ,
'25.00' , '25' , '0' , '33+18' , '68.6750' )
24/02/2023 12:58:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1114' AND id_supplier = '7'
24/02/2023 12:58:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1114' , '7' , '1' )
24/02/2023 12:59:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240865' AND id_product != '20777' AND ean13 != ''
24/02/2023 12:59:39 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '7/5',
ean13 = '9788892240865',
date_upd = NOW()
WHERE id_product = '20777'
24/02/2023 12:59:39 pm >> UPDATE ps_product_lang SET
name = 'NELLA TEMPESTA DIO - AAVV',
description = ''
WHERE id_product = '20777'
24/02/2023 12:59:39 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '22'
WHERE id_product = '20777'
24/02/2023 12:59:39 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '22',
id_tax_rules_group = '4',
id_category_default = '30',
id_argoment_default = '10',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20777'
24/02/2023 12:59:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '20777'
24/02/2023 12:59:41 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 = '20777'
24/02/2023 12:59:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20778' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 12:59:41 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 '20778' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20777'
24/02/2023 12:59:41 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '20778' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20777'
24/02/2023 01:00:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801064230' AND id_product != '20778' AND ean13 != ''
24/02/2023 01:00:13 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788801064230',
date_upd = NOW()
WHERE id_product = '20778'
24/02/2023 01:00:13 pm >> UPDATE ps_product_lang SET
name = 'PASSIO N.E.',
description = ''
WHERE id_product = '20778'
24/02/2023 01:00:13 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '6'
WHERE id_product = '20778'
24/02/2023 01:00:14 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '6',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '170',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20778'
24/02/2023 01:00:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '20778'
24/02/2023 01:00:15 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 = '20778'
24/02/2023 01:00:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20779' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 01:00:15 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 '20779' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20778'
24/02/2023 01:00:15 pm >> INSERT INTO `ps_stock_available` (
id_product , id_product_attribute , id_shop , id_shop_group , quantity
) SELECT '20779' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20778'
24/02/2023 01:00:49 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' ,
'623992' ,
'2023-02-23' ,
'' ,
'0' ,
'7' ,
'2602' ,
'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
'' ,
'' ,
'3.2' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'69.29' ,
'69.29' ,
NOW() ,
NOW() )
24/02/2023 01:00:49 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 = '82006'
24/02/2023 01:00:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '82006'
24/02/2023 01:00:49 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
( '82006' , '13882' , 'GAUDETE ET EXSULTATE' , '1' , '1' , '4' ,
'2.00' , '2' , '0' , '35' , '1.3000' )
24/02/2023 01:00:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13882' AND id_supplier = '7'
24/02/2023 01:00:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13882' , '7' , '1' )
24/02/2023 01:00:49 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
( '82006' , '3528' , 'DIO VIVO E VERO - L. F. LADARIA' , '1' , '1' , '4' ,
'59.00' , '59' , '0' , '35' , '38.3500' )
24/02/2023 01:00:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3528' AND id_supplier = '7'
24/02/2023 01:00:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3528' , '7' , '1' )
24/02/2023 01:00:49 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
( '82006' , '20777' , 'NELLA TEMPESTA DIO - AAVV' , '1' , '1' , '4' ,
'22.00' , '22' , '0' , '33' , '14.7400' )
24/02/2023 01:00:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20777' AND id_supplier = '7'
24/02/2023 01:00:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20777' , '7' , '1' )
24/02/2023 01:00:49 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
( '82006' , '20778' , 'PASSIO N.E.' , '3' , '3' , '4' ,
'6.00' , '6' , '0' , '35' , '11.7000' )
24/02/2023 01:00:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20778' AND id_supplier = '7'
24/02/2023 01:00:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20778' , '7' , '1' )
24/02/2023 03:15:46 pm >> SELECT document_num FROM ps_document
WHERE document_num = '619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 03:15:46 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' ,
'619' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'35.50' ,
'35.50' ,
NOW() ,
NOW() )
24/02/2023 03:15:46 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 = '82007'
24/02/2023 03:15:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82007'
24/02/2023 03:15:46 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
( '82007' , '1102' , 'BIBBIA BROSSURA OLANDESE' , '1' , '-1' , '4' ,
'26' , '26' , '0' , '0' , '26.00' )
24/02/2023 03:15:46 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
( '82007' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '5' , '9.50' )
24/02/2023 03:16:58 pm >> SELECT document_num FROM ps_document
WHERE document_num = '380' AND id_document != '81179' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-02')
24/02/2023 03:16:58 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '380',
document_date = '2023-02-02',
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 = '12.70',
price_tax_excluded = '12.70',
date_upd = NOW()
WHERE id_document = '81179'
24/02/2023 03:16: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 = '81179'
24/02/2023 03:16:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '81179'
24/02/2023 03:16: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
( '81179' , '9394' , 'SAN BIAGIO - G.PESENTI' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '5' , '3.80' )
24/02/2023 03:16: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
( '81179' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' ,
'4.45' , '4.45' , '0' , '0' , '8.90' )
24/02/2023 04:01:48 pm >> SELECT document_num FROM ps_document
WHERE document_num = '388' AND id_document != '81189' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-02')
24/02/2023 04:01:48 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '388',
document_date = '2023-02-02',
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 = '71.00',
price_tax_excluded = '58.20',
date_upd = NOW()
WHERE id_document = '81189'
24/02/2023 04:01:48 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 = '81189'
24/02/2023 04:01:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '81189'
24/02/2023 04:01:48 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
( '81189' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' ,
'27.5000' , '22.540983606557' , '22' , '0' , '55.00' )
24/02/2023 04:01:48 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
( '81189' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' ,
'10.00' , '8.1967213114754' , '22' , '0' , '10.00' )
24/02/2023 04:01:48 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
( '81189' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '10' , '-10' , '1' ,
'0.6' , '0.49180327868852' , '22' , '0' , '6.00' )
24/02/2023 04:08:16 pm >> SELECT document_num FROM ps_document
WHERE document_num = '13' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 04:08:16 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' ,
'13' ,
'2023-02-24' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'EDIZIONI' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'5320.00' ,
'5320.00' ,
NOW() ,
NOW() )
24/02/2023 04:08:16 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 = '82008'
24/02/2023 04:08:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82008'
24/02/2023 04:08:16 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
( '82008' , '20721' , 'AVE MARIA - L. CALABRETTA' , '360' , '-360' , '4' ,
'4.50' , '4.5' , '0' , '0' , '1620.00' )
24/02/2023 04:08:16 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
( '82008' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '360' , '-360' , '4' ,
'4.50' , '4.5' , '0' , '0' , '1620.00' )
24/02/2023 04:08:16 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
( '82008' , '20722' , 'SEMINATORI DI GIOIA' , '400' , '-400' , '4' ,
'2.50' , '2.5' , '0' , '0' , '1000.00' )
24/02/2023 04:08:16 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
( '82008' , '20719' , 'CORONA DELL’ADDOLORATA' , '600' , '-600' , '4' ,
'1.80' , '1.8' , '0' , '0' , '1080.00' )
24/02/2023 04:09:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688740' AND id_product != '17' AND ean13 != ''
24/02/2023 04:09:46 pm >> UPDATE ps_product SET
id_supplier = '53',
reference = '',
ean13 = '9788887688740',
date_upd = NOW()
WHERE id_product = '17'
24/02/2023 04:09:46 pm >> UPDATE ps_product_lang SET
name = 'LA FEDE NELLO ZAINETTO',
description = '
\r\n\r\n
Un piccolo compendio\r\nche presenta in maniera chiara, sintetica e affascinante le verità fondamentali del cristianesimo contenute nella Bibbia e insegnate dalla Chiesa. Oggi viviamo in una società multiculturale ed è fondamentale\r\nper il ragazzo essere ben preparato, cioè avere una coscienza chiara di quella che è la propria cultura che è stata plasmata, lungo venti secoli, dallo spirito cristiano. II libretto\r\nriassume i fatti principali della\"storia della salvezza\" e gli\r\ninsegnamenti fondamentali che ne derivano, dando\r\nal ragazzo la possibilità di un confronto con i propri\r\ncompagni. Le verità fondamentali del\r\ncristianesimo, contenute nella Bibbia e insegnate dalla Chiesa,\r\nspiegate in maniera breve e chiara.
'
WHERE id_product = '17'
24/02/2023 04:09:46 pm >> UPDATE ps_product SET
wholesale_price = '1.02',
on_sale = '0',
price = '6'
WHERE id_product = '17'
24/02/2023 04:09:46 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.02',
price = '6',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '17'
24/02/2023 04:09:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '17'
24/02/2023 04:09:46 pm >> INSERT INTO ps_specific_price
( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
VALUES
( '0' , '0' , '17' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
24/02/2023 04:11:10 pm >> SELECT document_num FROM ps_document
WHERE document_num = '5' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 04:11:10 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' ,
'5' ,
'2023-02-24' ,
'' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4160.00' ,
'4160.00' ,
NOW() ,
NOW() )
24/02/2023 04:11:10 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 = '10795'
24/02/2023 04:11:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '10795'
24/02/2023 04:11:10 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
( '10795' , '17' , 'LA FEDE NELLO ZAINETTO' , '400' , '-400' , '4' ,
'6.00' , '6' , '0' , '0' , '2400.00' )
24/02/2023 04:11:10 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
( '10795' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '700' , '-700' , '4' ,
'1.80' , '1.8' , '0' , '0' , '1260.00' )
24/02/2023 04:11:10 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
( '10795' , '92' , 'LA PREGHIERA DEL ROSARIO' , '100' , '-100' , '4' ,
'2.50' , '2.5' , '0' , '0' , '250.00' )
24/02/2023 04:11:10 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
( '10795' , '104' , 'TEMPO DI QUARESIMA' , '100' , '-100' , '4' ,
'2.50' , '2.5' , '0' , '0' , '250.00' )
24/02/2023 04:58:13 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '5659'
24/02/2023 04:58:13 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '5659'
24/02/2023 04:58:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801046212' AND id_product != '5659' AND ean13 != ''
24/02/2023 04:58:27 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '5/2',
ean13 = '9788801046212',
date_upd = NOW()
WHERE id_product = '5659'
24/02/2023 04:58:27 pm >> UPDATE ps_product_lang SET
name = 'LEGGO E GIOCO CON LA BIBBIA',
description = ''
WHERE id_product = '5659'
24/02/2023 04:58:28 pm >> UPDATE ps_product SET
wholesale_price = '6.25',
on_sale = '0',
price = '12.5000'
WHERE id_product = '5659'
24/02/2023 04:58:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '6.25',
price = '12.5000',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '25',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '5659'
24/02/2023 04:58:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '5659'
24/02/2023 05:11:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801052275' AND id_product != '20779' AND ean13 != ''
24/02/2023 05:11:05 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788801052275',
date_upd = NOW()
WHERE id_product = '20779'
24/02/2023 05:11:05 pm >> UPDATE ps_product_lang SET
name = 'PREGHIERE DI OGNI GIORNO',
description = ''
WHERE id_product = '20779'
24/02/2023 05:11:05 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '18'
WHERE id_product = '20779'
24/02/2023 05:11:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '18',
id_tax_rules_group = '4',
id_category_default = '19',
id_argoment_default = '170',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20779'
24/02/2023 05:11:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '20779'
24/02/2023 05:29:35 pm >> SELECT document_num FROM ps_document
WHERE document_num = '14' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 05:29:35 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' ,
'14' ,
'2023-02-24' ,
'' ,
'0' ,
'7' ,
'2602' ,
'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
'' ,
'RESA' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'9' ,
'608.40' ,
'606.24' ,
NOW() ,
NOW() )
24/02/2023 05:29:35 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 = '82009'
24/02/2023 05:29:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '82009'
24/02/2023 05:29:35 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
( '82009' , '6597' , 'MI CONFESSO ANCHIO - T. LASCONI' , '1' , '-1' , '4' ,
'11.00' , '11' , '0' , '0' , '11.00' )
24/02/2023 05:29:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6597' AND id_supplier = '7'
24/02/2023 05:29:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6597' , '7' , '1' )
24/02/2023 05:29:35 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
( '82009' , '19025' , 'ORA ANDIAMO!' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '0' , '8.00' )
24/02/2023 05:29:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19025' AND id_supplier = '7'
24/02/2023 05:29:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19025' , '7' , '1' )
24/02/2023 05:29:35 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
( '82009' , '7851' , 'PER VIVERE DA CRISTIANI - L. DELLA TORRE' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '0' , '5.00' )
24/02/2023 05:29:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7851' AND id_supplier = '7'
24/02/2023 05:29:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7851' , '7' , '1' )
24/02/2023 05:29:35 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
( '82009' , '16938' , 'SILENZIO SI FA PREGHIERA' , '1' , '-1' , '4' ,
'14.00' , '14' , '0' , '0' , '14.00' )
24/02/2023 05:29:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16938' AND id_supplier = '7'
24/02/2023 05:29:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16938' , '7' , '1' )
24/02/2023 05:29:35 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
( '82009' , '12057' , 'BACI NON DATI - RONCHI' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '0' , '8.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12057' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12057' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '17450' , 'ALLE SORGENTI - A. DE MELLO' , '1' , '-1' , '4' ,
'14.00' , '14' , '0' , '0' , '14.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17450' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17450' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '15620' , 'CHIAMATI ALLAMORE - A. DE MELLO' , '1' , '-1' , '4' ,
'13.00' , '13' , '0' , '0' , '13.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15620' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15620' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '2864' , 'CREDO SPIEGATO AI BAMBINI' , '4' , '-4' , '4' ,
'3.50' , '3.5' , '0' , '0' , '14.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2864' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2864' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '14162' , 'DIECI COMANDAMENTI' , '8' , '-8' , '1' ,
'1.50' , '1.2295081967213' , '22' , '0' , '12.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14162' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14162' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '19525' , 'OGGI VOGLIO PORTARVI TUTTI IN PARADISO' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '0' , '8.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19525' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19525' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '2847' , 'CREDO' , '2' , '-2' , '4' ,
'1.50' , '1.5' , '0' , '0' , '3.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2847' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2847' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '9366' , 'SALMI PER I PICCOLI' , '3' , '-3' , '4' ,
'2.90' , '2.9' , '0' , '0' , '8.70' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9366' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9366' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '13266' , 'MESSAGGERI DI DIO' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '0' , '16.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13266' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13266' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '19022' , 'COSI SEI NATO - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'14.90' , '14.9' , '0' , '0' , '14.90' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19022' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19022' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '95' , '99 PREGHIERE PER I BAMBINI' , '1' , '-1' , '4' ,
'14.90' , '14.9' , '0' , '0' , '14.90' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '95' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '95' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '18305' , 'MOSTRA ITINERANTE BEATO CARLO ACUTIS' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18305' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18305' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '5420' , 'IO COLORO IL VANGELO 1' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5420' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5420' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '8344' , 'PREGHIERE DEI BAMBINI E DEI RAGAZZI' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '0' , '12.00' )
24/02/2023 05:29:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8344' AND id_supplier = '7'
24/02/2023 05:29:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8344' , '7' , '1' )
24/02/2023 05:29:36 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
( '82009' , '14452' , 'COLORI STAGIONI E ANIMALI' , '1' , '-1' , '4' ,
'3.90' , '3.9' , '0' , '0' , '3.90' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14452' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14452' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '16521' , 'COME E FATTO IL MIO CORPO ' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '0' , '12.00' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16521' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16521' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '3489' , 'DIO ESISTE - C. DELHEZ' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '0' , '18.00' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3489' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3489' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '1171' , 'BIBBIA LE PIÙ BELLE STORIE' , '1' , '-1' , '4' ,
'22.00' , '22' , '0' , '0' , '22.00' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1171' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1171' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '17536' , 'CERCA E TROVA NELLE STORIE DELLA BIBBIA' , '1' , '-1' , '4' ,
'11.90' , '11.9' , '0' , '0' , '11.90' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17536' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17536' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '16821' , 'LEGGIAMO IL VANGELO IN FAMIGLIA' , '1' , '-1' , '4' ,
'4.90' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16821' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16821' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '763' , 'ARTINGIOCO - M.R. BONOMI VOLONGHI' , '1' , '-1' , '4' ,
'13.90' , '13.9' , '0' , '0' , '13.90' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '763' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '763' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '16160' , 'MIE PRIME PAROLE CON LA BIBBIA' , '1' , '-1' , '4' ,
'12.90' , '12.9' , '0' , '0' , '12.90' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16160' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16160' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '17247' , 'NUOVO TESTAMENTO UNA PROMESSA ....' , '1' , '-1' , '4' ,
'6.50' , '6.5' , '0' , '0' , '6.50' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17247' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17247' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '10622' , 'TESTIMONI DELLA MISERICORDIA' , '1' , '-1' , '4' ,
'4.90' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10622' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10622' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '17632' , 'FUORI DAL CORO - P. PELLEGRINO' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '0' , '4.00' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17632' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17632' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '17633' , 'RIDI E VAI A CANESTRO - P. PELLEGRINO' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '0' , '4.00' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17633' AND id_supplier = '7'
24/02/2023 05:29:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17633' , '7' , '1' )
24/02/2023 05:29:37 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
( '82009' , '20779' , 'PREGHIERE DI OGNI GIORNO' , '1' , '-1' , '4' ,
'18.00' , '18' , '0' , '0' , '18.00' )
24/02/2023 05:29:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20779' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20779' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '17309' , 'CHE BELLA IDEA - P. PELLEGRINO ' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '0' , '4.00' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17309' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17309' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '15609' , 'DOVE VA LA BARCA DEL MONDO? - P. PELLEGRINO' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '0' , '9.00' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15609' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15609' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '17766' , 'DICO GRAZIE A... ' , '1' , '-1' , '4' ,
'6.90' , '6.9' , '0' , '0' , '6.90' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17766' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17766' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '17762' , 'AMARE ' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17762' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17762' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '20202' , 'GIUDA LA VERA STORIA - S. PANZARELLA' , '2' , '-2' , '4' ,
'17.00' , '17' , '0' , '0' , '34.00' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20202' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20202' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '14667' , 'BUONE FESTE' , '5' , '-5' , '4' ,
'1.80' , '1.8' , '0' , '0' , '9.00' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14667' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14667' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19929' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19929' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '20036' , 'PAROLA E PREGHIERA - DIC 2022' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20036' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20036' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '19925' , 'AMEN - NOV. 2022' , '2' , '-2' , '4' ,
'3.90' , '3.9' , '0' , '0' , '7.80' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '20441' , 'AMEN - GEN. 23' , '3' , '-3' , '4' ,
'3.90' , '3.9' , '0' , '0' , '11.70' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '7'
24/02/2023 05:29:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '7' , '1' )
24/02/2023 05:29: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
( '82009' , '20260' , 'GESU CRISTO SI E FATTO POVERO' , '5' , '-5' , '4' ,
'2.90' , '2.9' , '0' , '0' , '14.50' )
24/02/2023 05:29:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20260' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20260' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '12803' , 'PER NOI UOMINI E PER LA NOSTRA SALVEZZA - R. COVI' , '1' , '-1' , '4' ,
'20.00' , '20' , '0' , '0' , '20.00' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12803' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12803' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '4261' , 'FRA TERRA E CIELO - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '0' , '9.00' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4261' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4261' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '15064' , 'SANTAGOSTINO - DIZIONARIO DELLE OPERE' , '1' , '-1' , '4' ,
'25.00' , '25' , '0' , '0' , '25.00' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15064' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15064' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '17550' , 'ANGELO DELLA SPERANZA - G. CAPURSO' , '1' , '-1' , '4' ,
'4.50' , '4.5' , '0' , '0' , '4.50' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17550' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17550' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20534' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20534' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '16663' , 'QUANDO ARDE IL CUORE - A. PITTA' , '1' , '-1' , '4' ,
'14.00' , '14' , '0' , '0' , '14.00' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16663' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16663' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '3775' , 'EDITH STEIN - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'9.30' , '9.3' , '0' , '0' , '9.30' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3775' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3775' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '16848' , 'SUOR MARIA GIOVANNA DELLA CROCE - P. PIETRA' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16848' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16848' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '15238' , 'VERONICA GIULIANI - A. CLEMENTI' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15238' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15238' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '19479' , 'VOLA CON NOI - ESTATE 2022' , '2' , '-2' , '4' ,
'12.90' , '12.9' , '0' , '0' , '25.80' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19479' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19479' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '20496' , 'KYRIE BAMBINO' , '4' , '-4' , '4' ,
'2.70' , '2.7' , '0' , '0' , '10.80' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20496' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20496' , '7' , '1' )
24/02/2023 05:29:39 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
( '82009' , '20032' , 'ALLA SCOPERTA DEL TESORO' , '10' , '-10' , '4' ,
'2.50' , '2.5' , '0' , '0' , '25.00' )
24/02/2023 05:29:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20032' AND id_supplier = '7'
24/02/2023 05:29:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20032' , '7' , '1' )
24/02/2023 05:30:05 pm >> SELECT document_num FROM ps_document
WHERE document_num = '620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 05:30:05 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' ,
'620' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'28.50' ,
'23.99' ,
NOW() ,
NOW() )
24/02/2023 05:30:05 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 = '82010'
24/02/2023 05:30:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82010'
24/02/2023 05:30:05 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
( '82010' , '5651' , 'LEGGIO IN LEGNO ' , '1' , '-1' , '1' ,
'25.00' , '20.491803278689' , '22' , '0' , '25.00' )
24/02/2023 05:30:05 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
( '82010' , '19265' , 'GIOIA DI ESSERE TESTIMONI' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 05:35:46 pm >> SELECT document_num FROM ps_document
WHERE document_num = '621' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 05:35:46 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' ,
'621' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'52.50' ,
'45.93' ,
NOW() ,
NOW() )
24/02/2023 05:35:46 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 = '82011'
24/02/2023 05:35:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82011'
24/02/2023 05:35:46 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
( '82011' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'16.90' , '16.9' , '0' , '5' , '16.06' )
24/02/2023 05:35:46 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
( '82011' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' ,
'36.44' , '29.868852459016' , '22' , '0' , '36.44' )
24/02/2023 05:45:20 pm >> SELECT document_num FROM ps_document
WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23')
24/02/2023 05:45:20 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '54/A',
document_date = '2022-07-23',
document_letter = 'A',
id_customer = '230',
id_supplier = '',
id_address = '4668969',
address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO',
address2 = '',
note = 'ACCONTO € 50,00+100 2/2/23 + 50,00 24/02',
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 = '590.00',
price_tax_excluded = '590.00',
date_upd = NOW()
WHERE id_document = '59768'
24/02/2023 05:45:20 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 = '59768'
24/02/2023 05:45:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '59768'
24/02/2023 05:45:20 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
( '59768' , '0' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' ,
'485.0000' , '485' , '0' , '0' , '485.00' )
24/02/2023 05:45:20 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
( '59768' , '0' , 'GIGLIO DORATO DA SCONTARE IN C/ VISIONE' , '1' , '-1' , '0' ,
'105.0000' , '105' , '0' , '0' , '105.00' )
24/02/2023 05:54:01 pm >> SELECT document_num FROM ps_document
WHERE document_num = '37' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 05:54:01 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 (
'21' ,
'37' ,
'2023-02-24' ,
'' ,
'230' ,
'0' ,
'4668969' ,
'VIA G. NICOTERA, 66 84080 PELLEZZANO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'51.00' ,
'51.00' ,
NOW() ,
NOW() )
24/02/2023 05:54:01 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 = '82012'
24/02/2023 05:54:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '82012'
24/02/2023 05:54:01 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
( '82012' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '30' , '-30' , '4' ,
'2.00' , '2' , '0' , '15' , '51.00' )
24/02/2023 05:54:54 pm >> SELECT document_num FROM ps_document
WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 05:54:54 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 (
'21' ,
'9' ,
'2023-02-24' ,
'' ,
'230' ,
'0' ,
'4668969' ,
'VIA G. NICOTERA, 66 84080 PELLEZZANO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'17.00' ,
'17.00' ,
NOW() ,
NOW() )
24/02/2023 05:54:54 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 = '10796'
24/02/2023 05:54:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '10796'
24/02/2023 05:54:54 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
( '10796' , '104' , 'TEMPO DI QUARESIMA' , '20' , '-20' , '4' ,
'1' , '1' , '0' , '15' , '17.00' )
24/02/2023 05:55:54 pm >> SELECT document_num FROM ps_document
WHERE document_num = '622' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 05:55:54 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' ,
'622' ,
'2023-02-24' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.50' ,
'3.69' ,
NOW() ,
NOW() )
24/02/2023 05:55:54 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 = '82013'
24/02/2023 05:55:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '82013'
24/02/2023 05:55:54 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
( '82013' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '1' , '-1' , '1' ,
'4.50' , '3.6885245901639' , '22' , '0' , '4.50' )
24/02/2023 06:21:33 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
24/02/2023 06:21:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20780' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 06:21:33 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20780' , '1' , '1' , '2' , NOW() , NOW()
)
24/02/2023 06:21:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20780' , '0' , '1' , '0' , '0' )
24/02/2023 06:22:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831525947' AND id_product != '20780' AND ean13 != ''
24/02/2023 06:22:05 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788831525947',
date_upd = NOW()
WHERE id_product = '20780'
24/02/2023 06:22:05 pm >> UPDATE ps_product_lang SET
name = 'grande gesù',
description = ''
WHERE id_product = '20780'
24/02/2023 06:22:05 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '6.147540983606557'
WHERE id_product = '20780'
24/02/2023 06:22:05 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '6.147540983606557',
id_tax_rules_group = '1',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20780'
24/02/2023 06:22:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '20780'
24/02/2023 06:22:43 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
24/02/2023 06:22:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20781' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 06:22:43 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20781' , '1' , '1' , '2' , NOW() , NOW()
)
24/02/2023 06:22:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20781' , '0' , '1' , '0' , '0' )
24/02/2023 06:22:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831525961' AND id_product != '20781' AND ean13 != ''
24/02/2023 06:22:56 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788831525961',
date_upd = NOW()
WHERE id_product = '20781'
24/02/2023 06:22:56 pm >> UPDATE ps_product_lang SET
name = 'grande gesù',
description = ''
WHERE id_product = '20781'
24/02/2023 06:22:56 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.0000'
WHERE id_product = '20781'
24/02/2023 06:22:56 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.0000',
id_tax_rules_group = '1',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20781'
24/02/2023 06:22:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '20781'
24/02/2023 06:23:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831525961' AND id_product != '20781' AND ean13 != ''
24/02/2023 06:23:13 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788831525961',
date_upd = NOW()
WHERE id_product = '20781'
24/02/2023 06:23:13 pm >> UPDATE ps_product_lang SET
name = 'grande gesù',
description = ''
WHERE id_product = '20781'
24/02/2023 06:23:14 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.5'
WHERE id_product = '20781'
24/02/2023 06:23:14 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.5',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20781'
24/02/2023 06:23:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '20781'
24/02/2023 06:23:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831525947' AND id_product != '20780' AND ean13 != ''
24/02/2023 06:23:28 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788831525947',
date_upd = NOW()
WHERE id_product = '20780'
24/02/2023 06:23:28 pm >> UPDATE ps_product_lang SET
name = 'grande gesù',
description = ''
WHERE id_product = '20780'
24/02/2023 06:23:28 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '7.5'
WHERE id_product = '20780'
24/02/2023 06:23:28 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '7.5',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20780'
24/02/2023 06:23:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20780'
24/02/2023 06:23:45 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
24/02/2023 06:23:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20782' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 06:23:45 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20782' , '1' , '1' , '2' , NOW() , NOW()
)
24/02/2023 06:23:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20782' , '0' , '1' , '0' , '0' )
24/02/2023 06:24:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831525954' AND id_product != '20782' AND ean13 != ''
24/02/2023 06:24:01 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788831525954',
date_upd = NOW()
WHERE id_product = '20782'
24/02/2023 06:24:01 pm >> UPDATE ps_product_lang SET
name = 'grande gesù',
description = ''
WHERE id_product = '20782'
24/02/2023 06:24:01 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.5'
WHERE id_product = '20782'
24/02/2023 06:24:01 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.5',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20782'
24/02/2023 06:24:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '20782'
24/02/2023 06:25:15 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
24/02/2023 06:25:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20783' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 06:25:15 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20783' , '1' , '1' , '2' , NOW() , NOW()
)
24/02/2023 06:25:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20783' , '0' , '1' , '0' , '0' )
24/02/2023 06:25:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801104998' AND id_product != '20783' AND ean13 != ''
24/02/2023 06:25:41 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788801104998',
date_upd = NOW()
WHERE id_product = '20783'
24/02/2023 06:25:41 pm >> UPDATE ps_product_lang SET
name = 'GESU\' DI NAZARET MANDA - TESTO',
description = ''
WHERE id_product = '20783'
24/02/2023 06:25:41 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '6'
WHERE id_product = '20783'
24/02/2023 06:25:41 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '6',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20783'
24/02/2023 06:25:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '20783'
24/02/2023 06:26:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831525954' AND id_product != '20782' AND ean13 != ''
24/02/2023 06:26:11 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '9788831525954',
date_upd = NOW()
WHERE id_product = '20782'
24/02/2023 06:26:11 pm >> UPDATE ps_product_lang SET
name = 'grande gesù',
description = ''
WHERE id_product = '20782'
24/02/2023 06:26:11 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '3.5'
WHERE id_product = '20782'
24/02/2023 06:26:11 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '3.5',
id_tax_rules_group = '4',
id_category_default = '2',
id_argoment_default = '',
id_internal_category = '',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20782'
24/02/2023 06:26:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '20782'
24/02/2023 06:26:14 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
24/02/2023 06:26:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20784' , '1' , '' , 'nuovo-prodotto' )
24/02/2023 06:26:14 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'20784' , '1' , '1' , '2' , NOW() , NOW()
)
24/02/2023 06:26:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20784' , '0' , '1' , '0' , '0' )
24/02/2023 06:45:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '14' AND id_document != '82009' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 06:45:14 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '14',
document_date = '2023-02-24',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '2602',
address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA',
address2 = '',
note = 'RESA',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '9',
price_tax_included = '1158.70',
price_tax_excluded = '1152.05',
date_upd = NOW()
WHERE id_document = '82009'
24/02/2023 06:45:14 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 = '82009'
24/02/2023 06:45:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82009'
24/02/2023 06:45:14 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
( '82009' , '6597' , 'MI CONFESSO ANCHIO - T. LASCONI' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
24/02/2023 06:45:14 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
( '82009' , '19025' , 'ORA ANDIAMO!' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 06:45:14 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
( '82009' , '7851' , 'PER VIVERE DA CRISTIANI - L. DELLA TORRE' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
24/02/2023 06:45:14 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
( '82009' , '16938' , 'SILENZIO SI FA PREGHIERA' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 06:45:14 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
( '82009' , '12057' , 'BACI NON DATI - RONCHI' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 06:45:14 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
( '82009' , '17450' , 'ALLE SORGENTI - A. DE MELLO' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 06:45:14 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
( '82009' , '15620' , 'CHIAMATI ALLAMORE - A. DE MELLO' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
24/02/2023 06:45:14 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
( '82009' , '2864' , 'CREDO SPIEGATO AI BAMBINI' , '4' , '-4' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '14.00' )
24/02/2023 06:45:14 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
( '82009' , '14162' , 'DIECI COMANDAMENTI' , '8' , '-8' , '1' ,
'1.5000' , '1.2295081967213' , '22' , '0' , '12.00' )
24/02/2023 06:45:14 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
( '82009' , '19525' , 'OGGI VOGLIO PORTARVI TUTTI IN PARADISO' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 06:45:14 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
( '82009' , '2847' , 'CREDO' , '2' , '-2' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '3.00' )
24/02/2023 06:45:14 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
( '82009' , '9366' , 'SALMI PER I PICCOLI' , '3' , '-3' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '8.70' )
24/02/2023 06:45:14 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
( '82009' , '13266' , 'MESSAGGERI DI DIO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
24/02/2023 06:45:14 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
( '82009' , '19022' , 'COSI SEI NATO - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'14.9000' , '14.9' , '0' , '0' , '14.90' )
24/02/2023 06:45:14 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
( '82009' , '95' , '99 PREGHIERE PER I BAMBINI' , '1' , '-1' , '4' ,
'14.9000' , '14.9' , '0' , '0' , '14.90' )
24/02/2023 06:45:14 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
( '82009' , '18305' , 'MOSTRA ITINERANTE BEATO CARLO ACUTIS' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 06:45:14 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
( '82009' , '5420' , 'IO COLORO IL VANGELO 1' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '2.50' )
24/02/2023 06:45:14 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
( '82009' , '8344' , 'PREGHIERE DEI BAMBINI E DEI RAGAZZI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
24/02/2023 06:45:14 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
( '82009' , '14452' , 'COLORI STAGIONI E ANIMALI' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '3.90' )
24/02/2023 06:45:14 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
( '82009' , '16521' , 'COME E FATTO IL MIO CORPO ' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
24/02/2023 06:45:14 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
( '82009' , '3489' , 'DIO ESISTE - C. DELHEZ' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
24/02/2023 06:45:14 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
( '82009' , '1171' , 'BIBBIA LE PIÙ BELLE STORIE' , '1' , '-1' , '4' ,
'22.0000' , '22' , '0' , '0' , '22.00' )
24/02/2023 06:45:14 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
( '82009' , '17536' , 'CERCA E TROVA NELLE STORIE DELLA BIBBIA' , '1' , '-1' , '4' ,
'11.9000' , '11.9' , '0' , '0' , '11.90' )
24/02/2023 06:45:15 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
( '82009' , '16821' , 'LEGGIAMO IL VANGELO IN FAMIGLIA' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 06:45:15 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
( '82009' , '763' , 'ARTINGIOCO - M.R. BONOMI VOLONGHI' , '1' , '-1' , '4' ,
'13.9000' , '13.9' , '0' , '0' , '13.90' )
24/02/2023 06:45:15 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
( '82009' , '16160' , 'MIE PRIME PAROLE CON LA BIBBIA' , '1' , '-1' , '4' ,
'12.9000' , '12.9' , '0' , '0' , '12.90' )
24/02/2023 06:45:15 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
( '82009' , '17247' , 'NUOVO TESTAMENTO UNA PROMESSA ....' , '1' , '-1' , '4' ,
'6.5000' , '6.5' , '0' , '0' , '6.50' )
24/02/2023 06:45:15 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
( '82009' , '10622' , 'TESTIMONI DELLA MISERICORDIA' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 06:45:15 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
( '82009' , '17632' , 'FUORI DAL CORO - P. PELLEGRINO' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 06:45:15 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
( '82009' , '17633' , 'RIDI E VAI A CANESTRO - P. PELLEGRINO' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 06:45:15 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
( '82009' , '20779' , 'PREGHIERE DI OGNI GIORNO' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
24/02/2023 06:45:15 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
( '82009' , '17309' , 'CHE BELLA IDEA - P. PELLEGRINO ' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 06:45:15 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
( '82009' , '15609' , 'DOVE VA LA BARCA DEL MONDO? - P. PELLEGRINO' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
24/02/2023 06:45:15 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
( '82009' , '17766' , 'DICO GRAZIE A... ' , '1' , '-1' , '4' ,
'6.9000' , '6.9' , '0' , '0' , '6.90' )
24/02/2023 06:45:15 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
( '82009' , '17762' , 'AMARE ' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 06:45:15 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
( '82009' , '20202' , 'GIUDA LA VERA STORIA - S. PANZARELLA' , '2' , '-2' , '4' ,
'17.0000' , '17' , '0' , '0' , '34.00' )
24/02/2023 06:45:15 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
( '82009' , '14667' , 'BUONE FESTE' , '5' , '-5' , '4' ,
'1.8000' , '1.8' , '0' , '0' , '9.00' )
24/02/2023 06:45:15 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
( '82009' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 06:45:15 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
( '82009' , '20036' , 'PAROLA E PREGHIERA - DIC 2022' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 06:45:15 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
( '82009' , '19925' , 'AMEN - NOV. 2022' , '2' , '-2' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '7.80' )
24/02/2023 06:45:15 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
( '82009' , '20441' , 'AMEN - GEN. 23' , '3' , '-3' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '11.70' )
24/02/2023 06:45:15 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
( '82009' , '20260' , 'GESU CRISTO SI E FATTO POVERO' , '5' , '-5' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '14.50' )
24/02/2023 06:45:15 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
( '82009' , '12803' , 'PER NOI UOMINI E PER LA NOSTRA SALVEZZA - R. COVI' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
24/02/2023 06:45:15 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
( '82009' , '4261' , 'FRA TERRA E CIELO - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
24/02/2023 06:45:15 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
( '82009' , '15064' , 'SANTAGOSTINO - DIZIONARIO DELLE OPERE' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
24/02/2023 06:45:15 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
( '82009' , '17550' , 'ANGELO DELLA SPERANZA - G. CAPURSO' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
24/02/2023 06:45:15 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
( '82009' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 06:45:15 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
( '82009' , '16663' , 'QUANDO ARDE IL CUORE - A. PITTA' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 06:45:15 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
( '82009' , '3775' , 'EDITH STEIN - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'9.3000' , '9.3' , '0' , '0' , '9.30' )
24/02/2023 06:45:15 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
( '82009' , '16848' , 'SUOR MARIA GIOVANNA DELLA CROCE - P. PIETRA' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 06:45:15 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
( '82009' , '15238' , 'VERONICA GIULIANI - A. CLEMENTI' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 06:45:15 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
( '82009' , '19479' , 'VOLA CON NOI - ESTATE 2022' , '2' , '-2' , '4' ,
'12.9000' , '12.9' , '0' , '0' , '25.80' )
24/02/2023 06:45:15 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
( '82009' , '20496' , 'KYRIE BAMBINO' , '4' , '-4' , '4' ,
'2.7000' , '2.7' , '0' , '0' , '10.80' )
24/02/2023 06:45:15 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
( '82009' , '20032' , 'ALLA SCOPERTA DEL TESORO' , '10' , '-10' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '25.00' )
24/02/2023 06:45:15 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
( '82009' , '4727' , 'GRANDE GESU - SCHEDE GENITORI - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 06:45:15 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
( '82009' , '20780' , 'grande gesù' , '1' , '-1' , '4' ,
'7.50' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 06:45:16 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
( '82009' , '20781' , 'grande gesù' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 06:45:16 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
( '82009' , '20782' , 'grande gesù' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 06:45:16 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
( '82009' , '20783' , 'GESU DI NAZARET MANDA - TESTO' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '0' , '6.00' )
24/02/2023 06:45:16 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
( '82009' , '6779' , 'MISTAGOGIA' , '1' , '-1' , '4' ,
'13.00' , '13' , '0' , '0' , '13.00' )
24/02/2023 06:45:16 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
( '82009' , '982' , 'BEATI GLI INVITATI ALLA MENSA DEL SIGNORE' , '2' , '-2' , '4' ,
'5.50' , '5.5' , '0' , '0' , '11.00' )
24/02/2023 06:45:16 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
( '82009' , '8722' , 'QUARESIMA DELLELEZIONE...' , '1' , '-1' , '4' ,
'11.00' , '11' , '0' , '0' , '11.00' )
24/02/2023 06:45:16 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
( '82009' , '9989' , 'SIGNORE È BUONO: GRANDE È IL SUO AMORE' , '2' , '-2' , '4' ,
'6.50' , '6.5' , '0' , '0' , '13.00' )
24/02/2023 06:45:16 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
( '82009' , '11243' , 'VERSO I SACRAMENTI - FASE ESISTENZIALE' , '1' , '-1' , '4' ,
'11.00' , '11' , '0' , '0' , '11.00' )
24/02/2023 06:45:16 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
( '82009' , '1879' , 'CELEBRATE IL SIGNORE PERCHÉ È BUONO' , '2' , '-2' , '4' ,
'10.00' , '10' , '0' , '0' , '20.00' )
24/02/2023 06:45:16 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
( '82009' , '11244' , 'VERSO I SACRAMENTI - FASE LITURGICA' , '1' , '-1' , '4' ,
'13.50' , '13.5' , '0' , '0' , '13.50' )
24/02/2023 06:45:16 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
( '82009' , '4740' , 'GRANDI COSE HA FATTO IL SIGNORE PER NOI' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
24/02/2023 06:45:16 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
( '82009' , '11242' , 'VERSO I SACRAMENTI - FASE BIBLICA' , '1' , '-1' , '4' ,
'13.00' , '13' , '0' , '0' , '13.00' )
24/02/2023 06:45:16 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
( '82009' , '8492' , 'PRIMA EVANGELIZZAZIONE - GUIDA' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '0' , '12.00' )
24/02/2023 06:45:16 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
( '82009' , '4740' , 'GRANDI COSE HA FATTO IL SIGNORE PER NOI' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
24/02/2023 06:45:16 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
( '82009' , '4395' , 'GESÙ CI CHIAMA E CI PARLA' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
24/02/2023 06:45:16 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
( '82009' , '686' , 'ANTIOCHIA: METTERSI IN GIOCO' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
24/02/2023 06:45:16 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
( '82009' , '3821' , 'EMMAUS: LE PIETRE VIVE' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
24/02/2023 06:45:16 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
( '82009' , '3822' , 'EMMAUS: LE PIETRE VIVE - GUIDA' , '1' , '-1' , '4' ,
'7.50' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 06:45:16 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
( '82009' , '4363' , 'GERUSALEMME: LA STORIA CHE SALVA' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
24/02/2023 06:45:16 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
( '82009' , '4364' , 'GERUSALEMME: LA STORIA CHE SALVA - GUIDA' , '1' , '-1' , '4' ,
'7.50' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 06:45:16 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
( '82009' , '1444' , 'CAFARNAO: IL PADRE' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
24/02/2023 06:45:16 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
( '82009' , '1445' , 'CAFARNAO: IL PADRE - GUIDA' , '1' , '-1' , '4' ,
'7.50' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 06:45:16 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
( '82009' , '6934' , 'NAZARET LA SCOPERTA DI GESÙ' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '0' , '3.00' )
24/02/2023 06:45:16 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
( '82009' , '6935' , 'NAZARET LA SCOPERTA DI GESÙ - GUIDA' , '1' , '-1' , '4' ,
'7.50' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 06:45:16 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
( '82009' , '1087' , 'BETLEMME TI RACCONTIAMO GESÙ - GUIDA PER I GENITORI' , '1' , '-1' , '4' ,
'7.50' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 06:45:16 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
( '82009' , '2001' , 'CHIAMATI ALLA FEDE - 2' , '1' , '-1' , '4' ,
'8.50' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 06:45:16 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
( '82009' , '2000' , 'CHIAMATI ALLA FEDE - 1' , '1' , '-1' , '4' ,
'7.00' , '7' , '0' , '0' , '7.00' )
24/02/2023 06:45:16 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
( '82009' , '2806' , 'COSA SAPPIAMO DELLA BIBBIA? - 1' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:16 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
( '82009' , '2808' , 'COSA SAPPIAMO DELLA BIBBIA? - 2' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:16 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
( '82009' , '2809' , 'COSA SAPPIAMO DELLA BIBBIA? - 3' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:16 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
( '82009' , '2810' , 'COSA SAPPIAMO DELLA BIBBIA? - 4' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:16 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
( '82009' , '2811' , 'COSA SAPPIAMO DELLA BIBBIA? - 5' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:17 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
( '82009' , '2812' , 'COSA SAPPIAMO DELLA BIBBIA? - 6' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:17 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
( '82009' , '2813' , 'COSA SAPPIAMO DELLA BIBBIA? - 7' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:17 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
( '82009' , '2814' , 'COSA SAPPIAMO DELLA BIBBIA? - 8' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:17 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
( '82009' , '2815' , 'COSA SAPPIAMO DELLA BIBBIA? - 9' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:17 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
( '82009' , '2807' , 'COSA SAPPIAMO DELLA BIBBIA? - 10' , '1' , '-1' , '4' ,
'5.68' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 06:45:17 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
( '82009' , '2002' , 'CHIAMATI ALLA FEDE - 3' , '1' , '-1' , '4' ,
'8.50' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 06:45:17 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
( '82009' , '13881' , 'SALMI PER BIBLE JOURNALING' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
24/02/2023 06:45:17 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
( '82009' , '13900' , 'VOCE SALE A TE SIGNORE! - GUGLIELMONI/NEGRI' , '1' , '-1' , '4' ,
'7.00' , '7' , '0' , '0' , '7.00' )
24/02/2023 06:45:17 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
( '82009' , '15161' , 'QUANTO AMO LA TUA LEGGE - G. PAPOLA' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '0' , '9.00' )
24/02/2023 06:45:17 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
( '82009' , '17643' , 'PRENDI E LEGGI - G. RONZONI' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '0' , '2.50' )
24/02/2023 06:45:17 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
( '82009' , '15634' , 'GESU E MIO AMICO - 2-5 ANNI' , '1' , '-1' , '4' ,
'2.20' , '2.2' , '0' , '0' , '2.20' )
24/02/2023 06:45:17 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
( '82009' , '19569' , 'FRATELLI TUTTI - O. VIZZOLI' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
24/02/2023 06:45:17 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
( '82009' , '19041' , 'HA VINTO IL TUO AMORE - AGG. SPARTITO' , '1' , '-1' , '3' ,
'5.50' , '5.2884615384615' , '4' , '0' , '5.50' )
24/02/2023 06:45:17 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
( '82009' , '17441' , 'PADRE NOSTRO . W. KASPER' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
24/02/2023 06:45:17 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
( '82009' , '16971' , 'PREGHIERA NELLA BIBBIA - C. DI SANTE' , '1' , '-1' , '4' ,
'9.50' , '9.5' , '0' , '0' , '9.50' )
24/02/2023 06:45:17 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
( '82009' , '14466' , 'PER-DONARE - F. LAMBIASI' , '1' , '-1' , '4' ,
'8.50' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 06:45:17 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
( '82009' , '17539' , 'SINFONIA DEI MINISTERI - F. FABENE' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
24/02/2023 06:45:17 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
( '82009' , '7745' , 'PAURE - V. M. FERNANDEZ' , '1' , '-1' , '4' ,
'4.90' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 06:45:17 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
( '82009' , '19065' , 'SANTUARIO PORTA APERTA...' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '0' , '16.00' )
24/02/2023 06:45:17 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
( '82009' , '16386' , 'SACERDOTE MISSIONARIO DELLA MISERICORDIA ' , '1' , '-1' , '4' ,
'16.00' , '16' , '0' , '0' , '16.00' )
24/02/2023 06:45:17 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
( '82009' , '16391' , 'GIOIA DEL DONO - L.M. GILARDI' , '1' , '-1' , '4' ,
'30.00' , '30' , '0' , '0' , '30.00' )
24/02/2023 06:45:17 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
( '82009' , '19169' , 'OGGI SI E COMPIUTA QUESTA SCRITTURA - A. GRAPPONE' , '4' , '-4' , '4' ,
'10.00' , '10' , '0' , '0' , '40.00' )
24/02/2023 06:45:17 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
( '82009' , '19989' , 'CALENDARIO 2023' , '3' , '-3' , '1' ,
'3.50' , '2.8688524590164' , '22' , '0' , '10.50' )
24/02/2023 06:45:17 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
( '82009' , '19988' , 'AGENDINA 2023' , '11' , '-11' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '13.20' )
24/02/2023 06:45:17 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
( '82009' , '19811' , 'AGENDINA 2023' , '23' , '-23' , '4' ,
'0.90' , '0.9' , '0' , '0' , '20.70' )
24/02/2023 06:46:42 pm >> SELECT document_num FROM ps_document
WHERE document_num = '491' AND id_document != '81327' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-11')
24/02/2023 06:46:42 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '491',
document_date = '2023-02-11',
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 = '34.91',
price_tax_excluded = '32.80',
date_upd = NOW()
WHERE id_document = '81327'
24/02/2023 06:46: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 = '81327'
24/02/2023 06:46:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '81327'
24/02/2023 06:46: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
( '81327' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' ,
'7.0000' , '5.7377049180328' , '22' , '0' , '7.00' )
24/02/2023 06:46: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
( '81327' , '17941' , 'LOURDES - ISONZO 119 bis' , '1' , '-1' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '3.50' )
24/02/2023 06:46: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
( '81327' , '20446' , 'PREFAZI E PREGHIERE EUCARISTICHE' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '1.50' )
24/02/2023 06:46: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
( '81327' , '11151' , 'LIBRI' , '1' , '-1' , '4' ,
'4.6' , '4.6' , '0' , '0' , '4.60' )
24/02/2023 06:46: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
( '81327' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '5' , '13.30' )
24/02/2023 06:46: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
( '81327' , '15601' , 'RITO DEL BATTESIMO' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '5' , '2.38' )
24/02/2023 06:46: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
( '81327' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' ,
'1.5000' , '1.5' , '0' , '5' , '1.43' )
24/02/2023 06:46: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
( '81327' , '19988' , 'AGENDINA 2023' , '1' , '-1' , '1' ,
'1.20' , '0.98360655737705' , '22' , '0' , '1.20' )
24/02/2023 06:56:15 pm >> UPDATE ps_product_shop SET
minimal_quantity = '1',
multiple_quantity = '1',
available_date = '',
date_upd = NOW()
WHERE id_product = '1893'
24/02/2023 06:56:15 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '1893'
24/02/2023 07:14:13 pm >> SELECT document_num FROM ps_document
WHERE document_num = '14' AND id_document != '82009' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 07:14:13 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '14',
document_date = '2023-02-24',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '2602',
address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA',
address2 = '',
note = 'RESA',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '9',
price_tax_included = '1275.10',
price_tax_excluded = '1268.45',
date_upd = NOW()
WHERE id_document = '82009'
24/02/2023 07:14: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 = '82009'
24/02/2023 07:14:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82009'
24/02/2023 07:14: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
( '82009' , '6597' , 'MI CONFESSO ANCHIO - T. LASCONI' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
24/02/2023 07:14: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
( '82009' , '19025' , 'ORA ANDIAMO!' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 07:14: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
( '82009' , '7851' , 'PER VIVERE DA CRISTIANI - L. DELLA TORRE' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
24/02/2023 07:14: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
( '82009' , '16938' , 'SILENZIO SI FA PREGHIERA' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 07:14: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
( '82009' , '12057' , 'BACI NON DATI - RONCHI' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 07:14: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
( '82009' , '17450' , 'ALLE SORGENTI - A. DE MELLO' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 07:14: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
( '82009' , '15620' , 'CHIAMATI ALLAMORE - A. DE MELLO' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
24/02/2023 07:14: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
( '82009' , '2864' , 'CREDO SPIEGATO AI BAMBINI' , '4' , '-4' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '14.00' )
24/02/2023 07:14: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
( '82009' , '14162' , 'DIECI COMANDAMENTI' , '8' , '-8' , '1' ,
'1.5000' , '1.2295081967213' , '22' , '0' , '12.00' )
24/02/2023 07:14: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
( '82009' , '19525' , 'OGGI VOGLIO PORTARVI TUTTI IN PARADISO' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 07:14:14 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
( '82009' , '2847' , 'CREDO' , '2' , '-2' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '3.00' )
24/02/2023 07:14:14 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
( '82009' , '9366' , 'SALMI PER I PICCOLI' , '3' , '-3' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '8.70' )
24/02/2023 07:14:14 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
( '82009' , '13266' , 'MESSAGGERI DI DIO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
24/02/2023 07:14:14 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
( '82009' , '19022' , 'COSI SEI NATO - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'14.9000' , '14.9' , '0' , '0' , '14.90' )
24/02/2023 07:14:14 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
( '82009' , '95' , '99 PREGHIERE PER I BAMBINI' , '1' , '-1' , '4' ,
'14.9000' , '14.9' , '0' , '0' , '14.90' )
24/02/2023 07:14:14 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
( '82009' , '18305' , 'MOSTRA ITINERANTE BEATO CARLO ACUTIS' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 07:14:14 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
( '82009' , '5420' , 'IO COLORO IL VANGELO 1' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '2.50' )
24/02/2023 07:14:14 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
( '82009' , '8344' , 'PREGHIERE DEI BAMBINI E DEI RAGAZZI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
24/02/2023 07:14:14 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
( '82009' , '14452' , 'COLORI STAGIONI E ANIMALI' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '3.90' )
24/02/2023 07:14:14 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
( '82009' , '16521' , 'COME E FATTO IL MIO CORPO ' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
24/02/2023 07:14:14 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
( '82009' , '3489' , 'DIO ESISTE - C. DELHEZ' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
24/02/2023 07:14:14 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
( '82009' , '1171' , 'BIBBIA LE PIÙ BELLE STORIE' , '1' , '-1' , '4' ,
'22.0000' , '22' , '0' , '0' , '22.00' )
24/02/2023 07:14:14 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
( '82009' , '17536' , 'CERCA E TROVA NELLE STORIE DELLA BIBBIA' , '1' , '-1' , '4' ,
'11.9000' , '11.9' , '0' , '0' , '11.90' )
24/02/2023 07:14:14 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
( '82009' , '16821' , 'LEGGIAMO IL VANGELO IN FAMIGLIA' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 07:14:14 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
( '82009' , '763' , 'ARTINGIOCO - M.R. BONOMI VOLONGHI' , '1' , '-1' , '4' ,
'13.9000' , '13.9' , '0' , '0' , '13.90' )
24/02/2023 07:14:14 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
( '82009' , '16160' , 'MIE PRIME PAROLE CON LA BIBBIA' , '1' , '-1' , '4' ,
'12.9000' , '12.9' , '0' , '0' , '12.90' )
24/02/2023 07:14:14 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
( '82009' , '17247' , 'NUOVO TESTAMENTO UNA PROMESSA ....' , '1' , '-1' , '4' ,
'6.5000' , '6.5' , '0' , '0' , '6.50' )
24/02/2023 07:14:14 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
( '82009' , '10622' , 'TESTIMONI DELLA MISERICORDIA' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 07:14:14 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
( '82009' , '17632' , 'FUORI DAL CORO - P. PELLEGRINO' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 07:14:14 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
( '82009' , '17633' , 'RIDI E VAI A CANESTRO - P. PELLEGRINO' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 07:14:14 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
( '82009' , '20779' , 'PREGHIERE DI OGNI GIORNO' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
24/02/2023 07:14:14 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
( '82009' , '17309' , 'CHE BELLA IDEA - P. PELLEGRINO ' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 07:14:14 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
( '82009' , '15609' , 'DOVE VA LA BARCA DEL MONDO? - P. PELLEGRINO' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
24/02/2023 07:14:14 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
( '82009' , '17766' , 'DICO GRAZIE A... ' , '1' , '-1' , '4' ,
'6.9000' , '6.9' , '0' , '0' , '6.90' )
24/02/2023 07:14:14 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
( '82009' , '17762' , 'AMARE ' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:14:14 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
( '82009' , '20202' , 'GIUDA LA VERA STORIA - S. PANZARELLA' , '2' , '-2' , '4' ,
'17.0000' , '17' , '0' , '0' , '34.00' )
24/02/2023 07:14:14 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
( '82009' , '14667' , 'BUONE FESTE' , '5' , '-5' , '4' ,
'1.8000' , '1.8' , '0' , '0' , '9.00' )
24/02/2023 07:14:14 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
( '82009' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 07:14:15 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
( '82009' , '20036' , 'PAROLA E PREGHIERA - DIC 2022' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 07:14:15 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
( '82009' , '19925' , 'AMEN - NOV. 2022' , '2' , '-2' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '7.80' )
24/02/2023 07:14:15 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
( '82009' , '20441' , 'AMEN - GEN. 23' , '3' , '-3' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '11.70' )
24/02/2023 07:14:15 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
( '82009' , '20260' , 'GESU CRISTO SI E FATTO POVERO' , '5' , '-5' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '14.50' )
24/02/2023 07:14:15 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
( '82009' , '12803' , 'PER NOI UOMINI E PER LA NOSTRA SALVEZZA - R. COVI' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
24/02/2023 07:14:15 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
( '82009' , '4261' , 'FRA TERRA E CIELO - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
24/02/2023 07:14:15 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
( '82009' , '15064' , 'SANTAGOSTINO - DIZIONARIO DELLE OPERE' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
24/02/2023 07:14:15 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
( '82009' , '17550' , 'ANGELO DELLA SPERANZA - G. CAPURSO' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
24/02/2023 07:14:15 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
( '82009' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 07:14:15 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
( '82009' , '16663' , 'QUANDO ARDE IL CUORE - A. PITTA' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 07:14:15 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
( '82009' , '3775' , 'EDITH STEIN - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'9.3000' , '9.3' , '0' , '0' , '9.30' )
24/02/2023 07:14:15 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
( '82009' , '16848' , 'SUOR MARIA GIOVANNA DELLA CROCE - P. PIETRA' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 07:14:15 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
( '82009' , '15238' , 'VERONICA GIULIANI - A. CLEMENTI' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 07:14:15 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
( '82009' , '19479' , 'VOLA CON NOI - ESTATE 2022' , '2' , '-2' , '4' ,
'12.9000' , '12.9' , '0' , '0' , '25.80' )
24/02/2023 07:14:15 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
( '82009' , '20496' , 'KYRIE BAMBINO' , '4' , '-4' , '4' ,
'2.7000' , '2.7' , '0' , '0' , '10.80' )
24/02/2023 07:14:15 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
( '82009' , '20032' , 'ALLA SCOPERTA DEL TESORO' , '10' , '-10' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '25.00' )
24/02/2023 07:14:15 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
( '82009' , '4727' , 'GRANDE GESU - SCHEDE GENITORI - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 07:14:15 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
( '82009' , '20780' , 'grande gesù' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:14:15 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
( '82009' , '20781' , 'grande gesù' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 07:14:15 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
( '82009' , '20782' , 'grande gesù' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 07:14:15 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
( '82009' , '20783' , 'GESU DI NAZARET MANDA - TESTO' , '1' , '-1' , '4' ,
'6.0000' , '6' , '0' , '0' , '6.00' )
24/02/2023 07:14:15 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
( '82009' , '6779' , 'MISTAGOGIA' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
24/02/2023 07:14:15 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
( '82009' , '982' , 'BEATI GLI INVITATI ALLA MENSA DEL SIGNORE' , '2' , '-2' , '4' ,
'5.5000' , '5.5' , '0' , '0' , '11.00' )
24/02/2023 07:14:15 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
( '82009' , '8722' , 'QUARESIMA DELLELEZIONE...' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
24/02/2023 07:14:15 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
( '82009' , '9989' , 'SIGNORE È BUONO: GRANDE È IL SUO AMORE' , '2' , '-2' , '4' ,
'6.5000' , '6.5' , '0' , '0' , '13.00' )
24/02/2023 07:14:15 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
( '82009' , '11243' , 'VERSO I SACRAMENTI - FASE ESISTENZIALE' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
24/02/2023 07:14:15 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
( '82009' , '1879' , 'CELEBRATE IL SIGNORE PERCHÉ È BUONO' , '2' , '-2' , '4' ,
'10.0000' , '10' , '0' , '0' , '20.00' )
24/02/2023 07:14:15 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
( '82009' , '11244' , 'VERSO I SACRAMENTI - FASE LITURGICA' , '1' , '-1' , '4' ,
'13.5000' , '13.5' , '0' , '0' , '13.50' )
24/02/2023 07:14:15 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
( '82009' , '4740' , 'GRANDI COSE HA FATTO IL SIGNORE PER NOI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:14:16 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
( '82009' , '11242' , 'VERSO I SACRAMENTI - FASE BIBLICA' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
24/02/2023 07:14:16 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
( '82009' , '8492' , 'PRIMA EVANGELIZZAZIONE - GUIDA' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
24/02/2023 07:14:16 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
( '82009' , '4740' , 'GRANDI COSE HA FATTO IL SIGNORE PER NOI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:14:16 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
( '82009' , '4395' , 'GESÙ CI CHIAMA E CI PARLA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:14:16 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
( '82009' , '686' , 'ANTIOCHIA: METTERSI IN GIOCO' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:14:16 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
( '82009' , '3821' , 'EMMAUS: LE PIETRE VIVE' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:14:16 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
( '82009' , '3822' , 'EMMAUS: LE PIETRE VIVE - GUIDA' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:14:16 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
( '82009' , '4363' , 'GERUSALEMME: LA STORIA CHE SALVA' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:14:16 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
( '82009' , '4364' , 'GERUSALEMME: LA STORIA CHE SALVA - GUIDA' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:14:16 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
( '82009' , '1444' , 'CAFARNAO: IL PADRE' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:14:16 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
( '82009' , '1445' , 'CAFARNAO: IL PADRE - GUIDA' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:14:16 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
( '82009' , '6934' , 'NAZARET LA SCOPERTA DI GESÙ' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:14:16 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
( '82009' , '6935' , 'NAZARET LA SCOPERTA DI GESÙ - GUIDA' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:14:16 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
( '82009' , '1087' , 'BETLEMME TI RACCONTIAMO GESÙ - GUIDA PER I GENITORI' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:14:16 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
( '82009' , '2001' , 'CHIAMATI ALLA FEDE - 2' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 07:14:16 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
( '82009' , '2000' , 'CHIAMATI ALLA FEDE - 1' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
24/02/2023 07:14:16 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
( '82009' , '2806' , 'COSA SAPPIAMO DELLA BIBBIA? - 1' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:16 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
( '82009' , '2808' , 'COSA SAPPIAMO DELLA BIBBIA? - 2' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:16 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
( '82009' , '2809' , 'COSA SAPPIAMO DELLA BIBBIA? - 3' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:16 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
( '82009' , '2810' , 'COSA SAPPIAMO DELLA BIBBIA? - 4' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:16 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
( '82009' , '2811' , 'COSA SAPPIAMO DELLA BIBBIA? - 5' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:16 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
( '82009' , '2812' , 'COSA SAPPIAMO DELLA BIBBIA? - 6' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:17 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
( '82009' , '2813' , 'COSA SAPPIAMO DELLA BIBBIA? - 7' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:17 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
( '82009' , '2814' , 'COSA SAPPIAMO DELLA BIBBIA? - 8' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:17 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
( '82009' , '2815' , 'COSA SAPPIAMO DELLA BIBBIA? - 9' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:17 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
( '82009' , '2807' , 'COSA SAPPIAMO DELLA BIBBIA? - 10' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:14:17 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
( '82009' , '2002' , 'CHIAMATI ALLA FEDE - 3' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 07:14:17 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
( '82009' , '13881' , 'SALMI PER BIBLE JOURNALING' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 07:14:17 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
( '82009' , '13900' , 'VOCE SALE A TE SIGNORE! - GUGLIELMONI/NEGRI' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
24/02/2023 07:14:17 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
( '82009' , '15161' , 'QUANTO AMO LA TUA LEGGE - G. PAPOLA' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
24/02/2023 07:14:17 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
( '82009' , '17643' , 'PRENDI E LEGGI - G. RONZONI' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '2.50' )
24/02/2023 07:14:17 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
( '82009' , '15634' , 'GESU E MIO AMICO - 2-5 ANNI' , '1' , '-1' , '4' ,
'2.2000' , '2.2' , '0' , '0' , '2.20' )
24/02/2023 07:14:17 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
( '82009' , '19569' , 'FRATELLI TUTTI - O. VIZZOLI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:14:17 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
( '82009' , '19041' , 'HA VINTO IL TUO AMORE - AGG. SPARTITO' , '1' , '-1' , '3' ,
'5.5000' , '5.2884615384615' , '4' , '0' , '5.50' )
24/02/2023 07:14:17 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
( '82009' , '17441' , 'PADRE NOSTRO . W. KASPER' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 07:14:17 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
( '82009' , '16971' , 'PREGHIERA NELLA BIBBIA - C. DI SANTE' , '1' , '-1' , '4' ,
'9.5000' , '9.5' , '0' , '0' , '9.50' )
24/02/2023 07:14:17 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
( '82009' , '14466' , 'PER-DONARE - F. LAMBIASI' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 07:14:17 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
( '82009' , '17539' , 'SINFONIA DEI MINISTERI - F. FABENE' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:14:17 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
( '82009' , '7745' , 'PAURE - V. M. FERNANDEZ' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 07:14:17 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
( '82009' , '19065' , 'SANTUARIO PORTA APERTA...' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
24/02/2023 07:14:17 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
( '82009' , '16386' , 'SACERDOTE MISSIONARIO DELLA MISERICORDIA ' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
24/02/2023 07:14:17 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
( '82009' , '16391' , 'GIOIA DEL DONO - L.M. GILARDI' , '1' , '-1' , '4' ,
'30.0000' , '30' , '0' , '0' , '30.00' )
24/02/2023 07:14:17 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
( '82009' , '19169' , 'OGGI SI E COMPIUTA QUESTA SCRITTURA - A. GRAPPONE' , '4' , '-4' , '4' ,
'10.0000' , '10' , '0' , '0' , '40.00' )
24/02/2023 07:14:17 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
( '82009' , '19989' , 'CALENDARIO 2023' , '3' , '-3' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '10.50' )
24/02/2023 07:14:17 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
( '82009' , '19988' , 'AGENDINA 2023' , '11' , '-11' , '1' ,
'1.2000' , '0.98360655737705' , '22' , '0' , '13.20' )
24/02/2023 07:14:17 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
( '82009' , '19811' , 'AGENDINA 2023' , '23' , '-23' , '4' ,
'0.9000' , '0.9' , '0' , '0' , '20.70' )
24/02/2023 07:14:17 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
( '82009' , '15197' , 'PER VIVERE CON TE ' , '1' , '-1' , '4' ,
'5.50' , '5.5' , '0' , '0' , '5.50' )
24/02/2023 07:14:17 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
( '82009' , '6540' , 'MESSA UNA FESTA' , '4' , '-4' , '4' ,
'3.50' , '3.5' , '0' , '0' , '14.00' )
24/02/2023 07:14:17 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
( '82009' , '9937' , 'SETTE SACRAMENTI DELLA CHIESA CATTOLICA' , '2' , '-2' , '4' ,
'3.50' , '3.5' , '0' , '0' , '7.00' )
24/02/2023 07:14:18 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
( '82009' , '2863' , 'CREDO RACCONTATO AI BAMBINI - BRUNO FERRERO' , '4' , '-4' , '4' ,
'5.00' , '5' , '0' , '0' , '20.00' )
24/02/2023 07:14:18 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
( '82009' , '2043' , 'CHIESA RACCONTATA AI BAMBINI - FERRERO/PEIRETTI' , '3' , '-3' , '4' ,
'4.00' , '4' , '0' , '0' , '12.00' )
24/02/2023 07:14:18 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
( '82009' , '11205' , 'VENITE, FACCIAMO FESTA - PER CONFESSIONE' , '3' , '-3' , '4' ,
'2.80' , '2.8' , '0' , '0' , '8.40' )
24/02/2023 07:14:18 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
( '82009' , '2443' , 'COLORO LA MESSA' , '1' , '-1' , '4' ,
'4.50' , '4.5' , '0' , '0' , '4.50' )
24/02/2023 07:14:18 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
( '82009' , '8315' , 'PREGHIERA RACCONTATA AI BAMBINI' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '0' , '5.00' )
24/02/2023 07:14:18 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
( '82009' , '1970' , 'CHE COSA SÌ... CHE COSA NO - L. FERRARESSO' , '3' , '-3' , '4' ,
'10.00' , '10' , '0' , '0' , '30.00' )
24/02/2023 07:14:18 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
( '82009' , '5249' , 'INCONTRI DI GIOIA - GUIDA' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:16:45 pm >> SELECT document_num FROM ps_document
WHERE document_num = '38' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 07:16:45 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 (
'21' ,
'38' ,
'2023-02-24' ,
'' ,
'3945' ,
'0' ,
'4676041' ,
'PIAZZA M. BARILARI 1 89822 SERRA SAN BRUNO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
24/02/2023 07:16:45 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 = '82014'
24/02/2023 07:16:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '82014'
24/02/2023 07:16:45 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
( '82014' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '50' , '-50' , '4' ,
'4.50' , '4.5' , '0' , '100' , '0.00' )
24/02/2023 07:16:46 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
( '82014' , '20721' , 'AVE MARIA - L. CALABRETTA' , '50' , '-50' , '4' ,
'4.50' , '4.5' , '0' , '100' , '0.00' )
24/02/2023 07:53:37 pm >> SELECT document_num FROM ps_document
WHERE document_num = '14' AND id_document != '82009' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 07:53:37 pm >> UPDATE ps_document SET
id_document_type = '24',
document_num = '14',
document_date = '2023-02-24',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '2602',
address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA',
address2 = '',
note = 'RESA',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '9',
price_tax_included = '1262.10',
price_tax_excluded = '1255.45',
date_upd = NOW()
WHERE id_document = '82009'
24/02/2023 07:53: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 = '82009'
24/02/2023 07:53:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '82009'
24/02/2023 07:53: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
( '82009' , '6597' , 'MI CONFESSO ANCHIO - T. LASCONI' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
24/02/2023 07:53: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
( '82009' , '19025' , 'ORA ANDIAMO!' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 07:53: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
( '82009' , '7851' , 'PER VIVERE DA CRISTIANI - L. DELLA TORRE' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
24/02/2023 07:53: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
( '82009' , '16938' , 'SILENZIO SI FA PREGHIERA' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 07:53: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
( '82009' , '12057' , 'BACI NON DATI - RONCHI' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 07:53: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
( '82009' , '17450' , 'ALLE SORGENTI - A. DE MELLO' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 07:53: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
( '82009' , '15620' , 'CHIAMATI ALLAMORE - A. DE MELLO' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
24/02/2023 07:53: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
( '82009' , '2864' , 'CREDO SPIEGATO AI BAMBINI' , '4' , '-4' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '14.00' )
24/02/2023 07:53: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
( '82009' , '14162' , 'DIECI COMANDAMENTI' , '8' , '-8' , '1' ,
'1.5000' , '1.2295081967213' , '22' , '0' , '12.00' )
24/02/2023 07:53: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
( '82009' , '19525' , 'OGGI VOGLIO PORTARVI TUTTI IN PARADISO' , '1' , '-1' , '4' ,
'8.0000' , '8' , '0' , '0' , '8.00' )
24/02/2023 07:53: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
( '82009' , '2847' , 'CREDO' , '2' , '-2' , '4' ,
'1.5000' , '1.5' , '0' , '0' , '3.00' )
24/02/2023 07:53: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
( '82009' , '9366' , 'SALMI PER I PICCOLI' , '3' , '-3' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '8.70' )
24/02/2023 07:53: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
( '82009' , '13266' , 'MESSAGGERI DI DIO' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
24/02/2023 07:53: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
( '82009' , '19022' , 'COSI SEI NATO - PAPA FRANCESCO' , '1' , '-1' , '4' ,
'14.9000' , '14.9' , '0' , '0' , '14.90' )
24/02/2023 07:53: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
( '82009' , '95' , '99 PREGHIERE PER I BAMBINI' , '1' , '-1' , '4' ,
'14.9000' , '14.9' , '0' , '0' , '14.90' )
24/02/2023 07:53: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
( '82009' , '18305' , 'MOSTRA ITINERANTE BEATO CARLO ACUTIS' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 07:53: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
( '82009' , '5420' , 'IO COLORO IL VANGELO 1' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '2.50' )
24/02/2023 07:53: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
( '82009' , '8344' , 'PREGHIERE DEI BAMBINI E DEI RAGAZZI' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
24/02/2023 07:53: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
( '82009' , '14452' , 'COLORI STAGIONI E ANIMALI' , '1' , '-1' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '3.90' )
24/02/2023 07:53: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
( '82009' , '16521' , 'COME E FATTO IL MIO CORPO ' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
24/02/2023 07:53: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
( '82009' , '3489' , 'DIO ESISTE - C. DELHEZ' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
24/02/2023 07:53: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
( '82009' , '1171' , 'BIBBIA LE PIÙ BELLE STORIE' , '1' , '-1' , '4' ,
'22.0000' , '22' , '0' , '0' , '22.00' )
24/02/2023 07:53: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
( '82009' , '17536' , 'CERCA E TROVA NELLE STORIE DELLA BIBBIA' , '1' , '-1' , '4' ,
'11.9000' , '11.9' , '0' , '0' , '11.90' )
24/02/2023 07:53: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
( '82009' , '16821' , 'LEGGIAMO IL VANGELO IN FAMIGLIA' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 07:53: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
( '82009' , '763' , 'ARTINGIOCO - M.R. BONOMI VOLONGHI' , '1' , '-1' , '4' ,
'13.9000' , '13.9' , '0' , '0' , '13.90' )
24/02/2023 07:53: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
( '82009' , '16160' , 'MIE PRIME PAROLE CON LA BIBBIA' , '1' , '-1' , '4' ,
'12.9000' , '12.9' , '0' , '0' , '12.90' )
24/02/2023 07:53: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
( '82009' , '17247' , 'NUOVO TESTAMENTO UNA PROMESSA ....' , '1' , '-1' , '4' ,
'6.5000' , '6.5' , '0' , '0' , '6.50' )
24/02/2023 07:53: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
( '82009' , '10622' , 'TESTIMONI DELLA MISERICORDIA' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 07:53: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
( '82009' , '17632' , 'FUORI DAL CORO - P. PELLEGRINO' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 07:53: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
( '82009' , '17633' , 'RIDI E VAI A CANESTRO - P. PELLEGRINO' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 07:53: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
( '82009' , '20779' , 'PREGHIERE DI OGNI GIORNO' , '1' , '-1' , '4' ,
'18.0000' , '18' , '0' , '0' , '18.00' )
24/02/2023 07:53: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
( '82009' , '17309' , 'CHE BELLA IDEA - P. PELLEGRINO ' , '1' , '-1' , '4' ,
'4.0000' , '4' , '0' , '0' , '4.00' )
24/02/2023 07:53: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
( '82009' , '15609' , 'DOVE VA LA BARCA DEL MONDO? - P. PELLEGRINO' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
24/02/2023 07:53:39 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
( '82009' , '17766' , 'DICO GRAZIE A... ' , '1' , '-1' , '4' ,
'6.9000' , '6.9' , '0' , '0' , '6.90' )
24/02/2023 07:53:39 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
( '82009' , '17762' , 'AMARE ' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:53:39 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
( '82009' , '20202' , 'GIUDA LA VERA STORIA - S. PANZARELLA' , '2' , '-2' , '4' ,
'17.0000' , '17' , '0' , '0' , '34.00' )
24/02/2023 07:53:39 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
( '82009' , '14667' , 'BUONE FESTE' , '5' , '-5' , '4' ,
'1.8000' , '1.8' , '0' , '0' , '9.00' )
24/02/2023 07:53:39 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
( '82009' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 07:53:39 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
( '82009' , '20036' , 'PAROLA E PREGHIERA - DIC 2022' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 07:53:39 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
( '82009' , '19925' , 'AMEN - NOV. 2022' , '2' , '-2' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '7.80' )
24/02/2023 07:53:39 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
( '82009' , '20441' , 'AMEN - GEN. 23' , '3' , '-3' , '4' ,
'3.9000' , '3.9' , '0' , '0' , '11.70' )
24/02/2023 07:53:39 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
( '82009' , '20260' , 'GESU CRISTO SI E FATTO POVERO' , '5' , '-5' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '14.50' )
24/02/2023 07:53:39 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
( '82009' , '12803' , 'PER NOI UOMINI E PER LA NOSTRA SALVEZZA - R. COVI' , '1' , '-1' , '4' ,
'20.0000' , '20' , '0' , '0' , '20.00' )
24/02/2023 07:53:39 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
( '82009' , '4261' , 'FRA TERRA E CIELO - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
24/02/2023 07:53:39 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
( '82009' , '15064' , 'SANTAGOSTINO - DIZIONARIO DELLE OPERE' , '1' , '-1' , '4' ,
'25.0000' , '25' , '0' , '0' , '25.00' )
24/02/2023 07:53:39 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
( '82009' , '17550' , 'ANGELO DELLA SPERANZA - G. CAPURSO' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
24/02/2023 07:53:39 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
( '82009' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' ,
'2.9000' , '2.9' , '0' , '0' , '2.90' )
24/02/2023 07:53:39 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
( '82009' , '16663' , 'QUANDO ARDE IL CUORE - A. PITTA' , '1' , '-1' , '4' ,
'14.0000' , '14' , '0' , '0' , '14.00' )
24/02/2023 07:53:39 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
( '82009' , '3775' , 'EDITH STEIN - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'9.3000' , '9.3' , '0' , '0' , '9.30' )
24/02/2023 07:53:39 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
( '82009' , '16848' , 'SUOR MARIA GIOVANNA DELLA CROCE - P. PIETRA' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 07:53:39 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
( '82009' , '15238' , 'VERONICA GIULIANI - A. CLEMENTI' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 07:53:39 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
( '82009' , '19479' , 'VOLA CON NOI - ESTATE 2022' , '2' , '-2' , '4' ,
'12.9000' , '12.9' , '0' , '0' , '25.80' )
24/02/2023 07:53:39 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
( '82009' , '20496' , 'KYRIE BAMBINO' , '4' , '-4' , '4' ,
'2.7000' , '2.7' , '0' , '0' , '10.80' )
24/02/2023 07:53:39 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
( '82009' , '20032' , 'ALLA SCOPERTA DEL TESORO' , '10' , '-10' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '25.00' )
24/02/2023 07:53:39 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
( '82009' , '4727' , 'GRANDE GESU - SCHEDE GENITORI - CONTO DEPOSITO' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 07:53:39 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
( '82009' , '20780' , 'grande gesù' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:53:39 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
( '82009' , '20781' , 'grande gesù' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 07:53:39 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
( '82009' , '20782' , 'grande gesù' , '1' , '-1' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '3.50' )
24/02/2023 07:53:39 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
( '82009' , '20783' , 'GESU DI NAZARET MANDA - TESTO' , '1' , '-1' , '4' ,
'6.0000' , '6' , '0' , '0' , '6.00' )
24/02/2023 07:53:39 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
( '82009' , '982' , 'BEATI GLI INVITATI ALLA MENSA DEL SIGNORE' , '2' , '-2' , '4' ,
'5.5000' , '5.5' , '0' , '0' , '11.00' )
24/02/2023 07:53:39 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
( '82009' , '8722' , 'QUARESIMA DELLELEZIONE...' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
24/02/2023 07:53:39 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
( '82009' , '9989' , 'SIGNORE È BUONO: GRANDE È IL SUO AMORE' , '2' , '-2' , '4' ,
'6.5000' , '6.5' , '0' , '0' , '13.00' )
24/02/2023 07:53:39 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
( '82009' , '11243' , 'VERSO I SACRAMENTI - FASE ESISTENZIALE' , '1' , '-1' , '4' ,
'11.0000' , '11' , '0' , '0' , '11.00' )
24/02/2023 07:53:39 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
( '82009' , '1879' , 'CELEBRATE IL SIGNORE PERCHÉ È BUONO' , '2' , '-2' , '4' ,
'10.0000' , '10' , '0' , '0' , '20.00' )
24/02/2023 07:53:39 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
( '82009' , '11244' , 'VERSO I SACRAMENTI - FASE LITURGICA' , '1' , '-1' , '4' ,
'13.5000' , '13.5' , '0' , '0' , '13.50' )
24/02/2023 07:53:39 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
( '82009' , '4740' , 'GRANDI COSE HA FATTO IL SIGNORE PER NOI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:53:40 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
( '82009' , '11242' , 'VERSO I SACRAMENTI - FASE BIBLICA' , '1' , '-1' , '4' ,
'13.0000' , '13' , '0' , '0' , '13.00' )
24/02/2023 07:53:40 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
( '82009' , '8492' , 'PRIMA EVANGELIZZAZIONE - GUIDA' , '1' , '-1' , '4' ,
'12.0000' , '12' , '0' , '0' , '12.00' )
24/02/2023 07:53:40 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
( '82009' , '4740' , 'GRANDI COSE HA FATTO IL SIGNORE PER NOI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:53:40 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
( '82009' , '4395' , 'GESÙ CI CHIAMA E CI PARLA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:53:40 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
( '82009' , '686' , 'ANTIOCHIA: METTERSI IN GIOCO' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:53:40 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
( '82009' , '3821' , 'EMMAUS: LE PIETRE VIVE' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:53:40 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
( '82009' , '3822' , 'EMMAUS: LE PIETRE VIVE - GUIDA' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:53:40 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
( '82009' , '4363' , 'GERUSALEMME: LA STORIA CHE SALVA' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:53:40 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
( '82009' , '4364' , 'GERUSALEMME: LA STORIA CHE SALVA - GUIDA' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:53:40 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
( '82009' , '1444' , 'CAFARNAO: IL PADRE' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:53:40 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
( '82009' , '1445' , 'CAFARNAO: IL PADRE - GUIDA' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:53:40 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
( '82009' , '6934' , 'NAZARET LA SCOPERTA DI GESÙ' , '1' , '-1' , '4' ,
'3.0000' , '3' , '0' , '0' , '3.00' )
24/02/2023 07:53:40 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
( '82009' , '6935' , 'NAZARET LA SCOPERTA DI GESÙ - GUIDA' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:53:40 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
( '82009' , '1087' , 'BETLEMME TI RACCONTIAMO GESÙ - GUIDA PER I GENITORI' , '1' , '-1' , '4' ,
'7.5000' , '7.5' , '0' , '0' , '7.50' )
24/02/2023 07:53:40 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
( '82009' , '2001' , 'CHIAMATI ALLA FEDE - 2' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 07:53:40 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
( '82009' , '2000' , 'CHIAMATI ALLA FEDE - 1' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
24/02/2023 07:53:40 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
( '82009' , '2806' , 'COSA SAPPIAMO DELLA BIBBIA? - 1' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2808' , 'COSA SAPPIAMO DELLA BIBBIA? - 2' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2809' , 'COSA SAPPIAMO DELLA BIBBIA? - 3' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2810' , 'COSA SAPPIAMO DELLA BIBBIA? - 4' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2811' , 'COSA SAPPIAMO DELLA BIBBIA? - 5' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2812' , 'COSA SAPPIAMO DELLA BIBBIA? - 6' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2813' , 'COSA SAPPIAMO DELLA BIBBIA? - 7' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2814' , 'COSA SAPPIAMO DELLA BIBBIA? - 8' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2815' , 'COSA SAPPIAMO DELLA BIBBIA? - 9' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2807' , 'COSA SAPPIAMO DELLA BIBBIA? - 10' , '1' , '-1' , '4' ,
'5.6800' , '5.68' , '0' , '0' , '5.68' )
24/02/2023 07:53:40 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
( '82009' , '2002' , 'CHIAMATI ALLA FEDE - 3' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 07:53:40 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
( '82009' , '13881' , 'SALMI PER BIBLE JOURNALING' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 07:53:40 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
( '82009' , '13900' , 'VOCE SALE A TE SIGNORE! - GUGLIELMONI/NEGRI' , '1' , '-1' , '4' ,
'7.0000' , '7' , '0' , '0' , '7.00' )
24/02/2023 07:53:40 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
( '82009' , '15161' , 'QUANTO AMO LA TUA LEGGE - G. PAPOLA' , '1' , '-1' , '4' ,
'9.0000' , '9' , '0' , '0' , '9.00' )
24/02/2023 07:53:40 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
( '82009' , '17643' , 'PRENDI E LEGGI - G. RONZONI' , '1' , '-1' , '4' ,
'2.5000' , '2.5' , '0' , '0' , '2.50' )
24/02/2023 07:53:40 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
( '82009' , '15634' , 'GESU E MIO AMICO - 2-5 ANNI' , '1' , '-1' , '4' ,
'2.2000' , '2.2' , '0' , '0' , '2.20' )
24/02/2023 07:53:40 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
( '82009' , '19569' , 'FRATELLI TUTTI - O. VIZZOLI' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:53:40 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
( '82009' , '19041' , 'HA VINTO IL TUO AMORE - AGG. SPARTITO' , '1' , '-1' , '3' ,
'5.5000' , '5.2884615384615' , '4' , '0' , '5.50' )
24/02/2023 07:53:40 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
( '82009' , '17441' , 'PADRE NOSTRO . W. KASPER' , '1' , '-1' , '4' ,
'15.0000' , '15' , '0' , '0' , '15.00' )
24/02/2023 07:53: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
( '82009' , '16971' , 'PREGHIERA NELLA BIBBIA - C. DI SANTE' , '1' , '-1' , '4' ,
'9.5000' , '9.5' , '0' , '0' , '9.50' )
24/02/2023 07:53: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
( '82009' , '14466' , 'PER-DONARE - F. LAMBIASI' , '1' , '-1' , '4' ,
'8.5000' , '8.5' , '0' , '0' , '8.50' )
24/02/2023 07:53: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
( '82009' , '17539' , 'SINFONIA DEI MINISTERI - F. FABENE' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 07:53: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
( '82009' , '7745' , 'PAURE - V. M. FERNANDEZ' , '1' , '-1' , '4' ,
'4.9000' , '4.9' , '0' , '0' , '4.90' )
24/02/2023 07:53: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
( '82009' , '19065' , 'SANTUARIO PORTA APERTA...' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
24/02/2023 07:53: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
( '82009' , '16386' , 'SACERDOTE MISSIONARIO DELLA MISERICORDIA ' , '1' , '-1' , '4' ,
'16.0000' , '16' , '0' , '0' , '16.00' )
24/02/2023 07:53: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
( '82009' , '16391' , 'GIOIA DEL DONO - L.M. GILARDI' , '1' , '-1' , '4' ,
'30.0000' , '30' , '0' , '0' , '30.00' )
24/02/2023 07:53: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
( '82009' , '19169' , 'OGGI SI E COMPIUTA QUESTA SCRITTURA - A. GRAPPONE' , '4' , '-4' , '4' ,
'10.0000' , '10' , '0' , '0' , '40.00' )
24/02/2023 07:53: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
( '82009' , '19989' , 'CALENDARIO 2023' , '3' , '-3' , '1' ,
'3.5000' , '2.8688524590164' , '22' , '0' , '10.50' )
24/02/2023 07:53: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
( '82009' , '19988' , 'AGENDINA 2023' , '11' , '-11' , '1' ,
'1.2000' , '0.98360655737705' , '22' , '0' , '13.20' )
24/02/2023 07:53: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
( '82009' , '19811' , 'AGENDINA 2023' , '23' , '-23' , '4' ,
'0.9000' , '0.9' , '0' , '0' , '20.70' )
24/02/2023 07:53: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
( '82009' , '15197' , 'PER VIVERE CON TE ' , '1' , '-1' , '4' ,
'5.5000' , '5.5' , '0' , '0' , '5.50' )
24/02/2023 07:53: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
( '82009' , '6540' , 'MESSA UNA FESTA' , '4' , '-4' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '14.00' )
24/02/2023 07:53: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
( '82009' , '9937' , 'SETTE SACRAMENTI DELLA CHIESA CATTOLICA' , '2' , '-2' , '4' ,
'3.5000' , '3.5' , '0' , '0' , '7.00' )
24/02/2023 07:53: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
( '82009' , '2863' , 'CREDO RACCONTATO AI BAMBINI - BRUNO FERRERO' , '4' , '-4' , '4' ,
'5.0000' , '5' , '0' , '0' , '20.00' )
24/02/2023 07:53: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
( '82009' , '2043' , 'CHIESA RACCONTATA AI BAMBINI - FERRERO/PEIRETTI' , '3' , '-3' , '4' ,
'4.0000' , '4' , '0' , '0' , '12.00' )
24/02/2023 07:53: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
( '82009' , '11205' , 'VENITE, FACCIAMO FESTA - PER CONFESSIONE' , '3' , '-3' , '4' ,
'2.8000' , '2.8' , '0' , '0' , '8.40' )
24/02/2023 07:53: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
( '82009' , '2443' , 'COLORO LA MESSA' , '1' , '-1' , '4' ,
'4.5000' , '4.5' , '0' , '0' , '4.50' )
24/02/2023 07:53: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
( '82009' , '8315' , 'PREGHIERA RACCONTATA AI BAMBINI' , '1' , '-1' , '4' ,
'5.0000' , '5' , '0' , '0' , '5.00' )
24/02/2023 07:53: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
( '82009' , '1970' , 'CHE COSA SÌ... CHE COSA NO - L. FERRARESSO' , '3' , '-3' , '4' ,
'10.0000' , '10' , '0' , '0' , '30.00' )
24/02/2023 07:53: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
( '82009' , '5249' , 'INCONTRI DI GIOIA - GUIDA' , '1' , '-1' , '4' ,
'10.0000' , '10' , '0' , '0' , '10.00' )
24/02/2023 08:02:47 pm >> SELECT document_num FROM ps_document
WHERE document_num = '9' AND id_document != '10796' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-24')
24/02/2023 08:02:47 pm >> UPDATE ps_document SET
id_document_type = '21',
document_num = '9',
document_date = '2023-02-24',
document_letter = '',
id_customer = '230',
id_supplier = '',
id_address = '4668969',
address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO',
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 = '17.00',
price_tax_excluded = '17.00',
date_upd = NOW()
WHERE id_document = '10796'
24/02/2023 08:02: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 = '10796'
24/02/2023 08:02:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '10796'
24/02/2023 08:02: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
( '10796' , '104' , 'TEMPO DI QUARESIMA' , '20' , '-20' , '4' ,
'1.0000' , '1' , '0' , '15' , '17.00' )