05/11/2024 10:18:10 am >> SELECT document_num FROM ps_document
WHERE document_num = '3324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 10:18:10 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3324' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.00' ,
'7.38' ,
NOW() ,
NOW() )
05/11/2024 10:18:10 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94041'
05/11/2024 10:18:10 am >> DELETE FROM ps_document_detail WHERE id_document = '94041'
05/11/2024 10:18:10 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94041' , '14062' , 'STELLARIO PLEX CM 8' , '1' , '-1' , '1' ,
'9.00' , '7.3770491803279' , '22' , '0' , '9.00' )
05/11/2024 11:04:13 am >> SELECT document_num FROM ps_document
WHERE document_num = '207' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 11:04:13 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' ,
'207' ,
'2024-11-05' ,
'' ,
'1083' ,
'0' ,
'4674059' ,
'VIA CREMONA, 1 83020 S. MICHELE DI SERINO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'1' ,
'0' ,
'203.45' ,
'203.45' ,
NOW() ,
NOW() )
05/11/2024 11:04:13 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94042'
05/11/2024 11:04:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94042'
05/11/2024 11:04:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94042' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '21' , '-21' , '4' ,
'3.40' , '3.4' , '0' , '15' , '60.69' )
05/11/2024 11:04:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94042' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '15' , '4.25' )
05/11/2024 11:04:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94042' , '11191' , 'VENITE CON ME 1 PARTE' , '22' , '-22' , '4' ,
'2.80' , '2.8' , '0' , '15' , '52.36' )
05/11/2024 11:04:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94042' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' ,
'8.00' , '8' , '0' , '15' , '13.60' )
05/11/2024 11:04:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94042' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '25' , '-25' , '4' ,
'3.00' , '3' , '0' , '15' , '63.75' )
05/11/2024 11:04:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94042' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '15' , '6.80' )
05/11/2024 11:04:13 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94042' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
05/11/2024 11:04:47 am >> SELECT document_num FROM ps_document
WHERE document_num = '3325' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 11:04:47 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3325' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'14.00' ,
'14.00' ,
NOW() ,
NOW() )
05/11/2024 11:04:47 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94043'
05/11/2024 11:04:47 am >> DELETE FROM ps_document_detail WHERE id_document = '94043'
05/11/2024 11:04:47 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94043' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '20' , '-20' , '4' ,
'0.70' , '0.7' , '0' , '0' , '14.00' )
05/11/2024 11:05:20 am >> SELECT document_num FROM ps_document
WHERE document_num = '3326' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 11:05:20 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3326' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'33.26' ,
'33.26' ,
NOW() ,
NOW() )
05/11/2024 11:05:20 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94044'
05/11/2024 11:05:20 am >> DELETE FROM ps_document_detail WHERE id_document = '94044'
05/11/2024 11:05:20 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94044' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '-1' , '4' ,
'22.00' , '22' , '0' , '5' , '20.90' )
05/11/2024 11:05:20 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94044' , '23106' , 'DILEXIT NOS' , '2' , '-2' , '4' ,
'3.50' , '3.5' , '0' , '5' , '6.66' )
05/11/2024 11:05:20 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94044' , '22972' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )
05/11/2024 11:08:12 am >> SELECT document_num FROM ps_document
WHERE document_num = '3327' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 11:08: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 (
'11' ,
'3327' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'7.65' ,
'6.45' ,
NOW() ,
NOW() )
05/11/2024 11:08: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 = '94045'
05/11/2024 11:08:12 am >> DELETE FROM ps_document_detail WHERE id_document = '94045'
05/11/2024 11:08: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
( '94045' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '1' , '-1' , '4' ,
'1.00' , '1' , '0' , '0' , '1.00' )
05/11/2024 11:08: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
( '94045' , '22908' , 'AGENDINA SETTIMANALE VERDE 2025 - 40824' , '1' , '-1' , '1' ,
'7.00' , '5.7377049180328' , '22' , '5' , '6.65' )
05/11/2024 11:08:48 am >> SELECT document_num FROM ps_document
WHERE document_num = '3328' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 11:08:49 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3328' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'99.11' ,
'98.16' ,
NOW() ,
NOW() )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94046'
05/11/2024 11:08:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94046'
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '5' , '14.25' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '8855' , 'REGISTRO DEL CATECHISTA' , '7' , '-7' , '1' ,
'0.75' , '0.61475409836066' , '22' , '0' , '5.25' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '19953' , 'FELIZ CITTA\' - GIOCO CARLO ACUTIS' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '0' , '15.00' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '20137' , 'FOLLOWERS 2.0 - QUADERNO' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '5' , '7.60' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '20043' , 'FOLLOWERS 2.0 - GUIDA' , '1' , '-1' , '4' ,
'14.00' , '14' , '0' , '5' , '13.30' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' ,
'6.00' , '6' , '0' , '5' , '5.70' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' , '-1' , '4' ,
'15.00' , '15' , '0' , '5' , '14.25' )
05/11/2024 11:08:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94046' , '23112' , 'CONOSCI TE STESSO - C. AMIRANTE' , '1' , '-1' , '4' ,
'12.90' , '12.9' , '0' , '5' , '12.26' )
05/11/2024 11:10:31 am >> SELECT document_num FROM ps_document
WHERE document_num = '3329' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 11:10: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' ,
'3329' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'152.50' ,
'132.89' ,
NOW() ,
NOW() )
05/11/2024 11:10: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 = '94047'
05/11/2024 11:10:31 am >> DELETE FROM ps_document_detail WHERE id_document = '94047'
05/11/2024 11:10: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
( '94047' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' ,
'6.90' , '5.655737704918' , '22' , '0' , '6.90' )
05/11/2024 11:10: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
( '94047' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' ,
'4.30' , '4.1346153846154' , '4' , '0' , '8.60' )
05/11/2024 11:10:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94047' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '10.00' )
05/11/2024 11:10:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94047' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '17.50' )
05/11/2024 11:10:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94047' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' ,
'3.50' , '3.3653846153846' , '4' , '0' , '17.50' )
05/11/2024 11:10:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94047' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' ,
'2.00' , '1.9230769230769' , '4' , '0' , '2.00' )
05/11/2024 11:10:32 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94047' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' ,
'3' , '2.4590163934426' , '22' , '0' , '90.00' )
05/11/2024 11:19:27 am >> SELECT document_num FROM ps_document
WHERE document_num = '208' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 11:19:27 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'21' ,
'208' ,
'2024-11-05' ,
'' ,
'3215' ,
'0' ,
'4669544' ,
'VIA CASA PAPA 83029 SOLOFRA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'15' ,
'0' ,
'116.52' ,
'116.52' ,
NOW() ,
NOW() )
05/11/2024 11:19:27 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94048'
05/11/2024 11:19:27 am >> DELETE FROM ps_document_detail WHERE id_document = '94048'
05/11/2024 11:19:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94048' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' ,
'2.80' , '2.8' , '0' , '15' , '2.38' )
05/11/2024 11:19:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94048' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' ,
'3.40' , '3.4' , '0' , '15' , '2.89' )
05/11/2024 11:19:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94048' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '14' , '-14' , '4' ,
'3.80' , '3.8' , '0' , '15' , '45.22' )
05/11/2024 11:19:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94048' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '19' , '-19' , '4' ,
'3.80' , '3.8' , '0' , '15' , '61.37' )
05/11/2024 11:19:27 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94048' , '21568' , 'CARO GESU AL CATECHISMO ...' , '1' , '-1' , '4' ,
'4.90' , '4.9' , '0' , '5' , '4.66' )
05/11/2024 11:22:49 am >> SELECT document_num FROM ps_document
WHERE document_num = '3330' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 11:22:49 am >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'11' ,
'3330' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'3.50' ,
'3.50' ,
NOW() ,
NOW() )
05/11/2024 11:22:49 am >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94049'
05/11/2024 11:22:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94049'
05/11/2024 11:22:49 am >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94049' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '0' , '3.50' )
05/11/2024 11:41:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736383' AND id_product != '20951' AND ean13 != ''
05/11/2024 11:41:11 am >> UPDATE ps_product SET
id_supplier = '159',
reference = '6/7',
ean13 = '9791280736383',
date_upd = NOW()
WHERE id_product = '20951'
05/11/2024 11:41:11 am >> UPDATE ps_product_lang SET
name = 'STORIE DEL NOSTRO TEMPO - F. CERRI',
description = 'Nel nostro tempo sono tanti gli avvenimenti che si accavallano, che è quasi impossibile ricordarli tutti, con la conseguenza che, appena venuti a conoscenza tramite i media, si dimenticano facilmente, mentre avrebbero bisogno di momenti di riflessione. In questo libro sono raccolte alcune storie e modi particolari di vivere del nostro tempo, sia nella società civile che nella comunità ecclesiale, con l\'invito al lettore di leggere, riflettere e sorridere… nonostante tutto!
Prete della diocesi di Lucca. Ha ricoperto numerosi incarichi: parroco in diverse parrocchie, cappellano del carcere di Lucca, direttore della Caritas diocesana, delegato regionale della Caritas per la Toscana, componente del Consiglio della Caritas Italiana. È stato per alcuni anni missionario in Rwanda. Attualmente è Rettore della chiesa di S. Giusto a Lucca e responsabile del Centro diocesano del Catecumenato. Giornalista pubblicista, già coordinatore delle pagine di Lucca del settimanale Toscana Oggi.
'
WHERE id_product = '20951'
05/11/2024 11:41:11 am >> UPDATE ps_product SET
wholesale_price = '2.80',
on_sale = '0',
price = '15.0000'
WHERE id_product = '20951'
05/11/2024 11:41:11 am >> UPDATE ps_product_shop SET
wholesale_price = '2.80',
price = '15.0000',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '10',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '20951'
05/11/2024 11:41:11 am >> DELETE FROM ps_specific_price WHERE id_product = '20951'
05/11/2024 11:41:11 am >> 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' , '20951' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
05/11/2024 11:55:32 am >> DELETE FROM ps_document WHERE id_document = '94021'
05/11/2024 11:55:32 am >> DELETE FROM ps_document_detail WHERE id_document = '94021'
05/11/2024 12:09:06 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3216' AND id_document != '93882' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28')
05/11/2024 12:09:06 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3216',
document_date = '2024-10-28',
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 = '24.70',
price_tax_excluded = '21.61',
date_upd = NOW()
WHERE id_document = '93882'
05/11/2024 12:09:06 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93882'
05/11/2024 12:09:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93882'
05/11/2024 12:09:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '93882' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' ,
'1.4' , '1.1475409836066' , '22' , '0' , '1.40' )
05/11/2024 12:09:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '93882' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' ,
'3.5000' , '3.3653846153846' , '4' , '0' , '3.50' )
05/11/2024 12:09:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '93882' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '1' , '-1' , '4' ,
'2.0000' , '2' , '0' , '0' , '2.00' )
05/11/2024 12:09:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '93882' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '1' , '-1' , '4' ,
'2.8000' , '2.8' , '0' , '0' , '2.80' )
05/11/2024 12:09: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
( '93882' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' ,
'0.2000' , '0.16393442622951' , '22' , '0' , '0.20' )
05/11/2024 12:09: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
( '93882' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' ,
'2.2000' , '1.8032786885246' , '22' , '0' , '2.20' )
05/11/2024 12:09: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
( '93882' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '12' , '-12' , '1' ,
'0.2500' , '0.20491803278689' , '22' , '0' , '3.00' )
05/11/2024 12:09: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
( '93882' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '12' , '-12' , '1' ,
'0.2500' , '0.20491803278689' , '22' , '0' , '3.00' )
05/11/2024 12:09: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
( '93882' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '12' , '-12' , '1' ,
'0.2500' , '0.20491803278689' , '22' , '0' , '3.00' )
05/11/2024 12:09: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
( '93882' , '3175' , 'CROCETTA S. BENEDETTO METALLO OX CM 3,5X2 - PG350-N' , '2' , '-2' , '1' ,
'0.7000' , '0.57377049180328' , '22' , '0' , '1.40' )
05/11/2024 12:09: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
( '93882' , '15105' , 'ROSARIO BOTTIGLIA - 187' , '1' , '-1' , '1' ,
'2.20' , '1.8032786885246' , '22' , '0' , '2.20' )
05/11/2024 12:09:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3091' AND id_document != '93696' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-18')
05/11/2024 12:09:55 pm >> UPDATE ps_document SET
id_document_type = '11',
document_num = '3091',
document_date = '2024-10-18',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '0',
address1 = '',
address2 = '',
note = '',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '0',
id_causal = '0',
price_tax_included = '2.00',
price_tax_excluded = '2.00',
date_upd = NOW()
WHERE id_document = '93696'
05/11/2024 12:09:56 pm >> INSERT INTO ps_document_detail_backup
( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93696'
05/11/2024 12:09:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '93696'
05/11/2024 12:09:56 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '93696' , '6663' , 'MIE PREGHIERE - 8783' , '1' , '-1' , '4' ,
'2.00' , '2' , '0' , '0' , '2.00' )
05/11/2024 12:16:00 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3331' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 12:16:00 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' ,
'3331' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'17.15' ,
'17.15' ,
NOW() ,
NOW() )
05/11/2024 12:16:00 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 = '94050'
05/11/2024 12:16:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94050'
05/11/2024 12:16:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94050' , '23134' , 'AVVENTO E NATALE 2024/25' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '0' , '2.90' )
05/11/2024 12:16:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94050' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '3' , '-3' , '4' ,
'5.00' , '5' , '0' , '5' , '14.25' )
05/11/2024 12:24:16 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 12:24: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 (
'11' ,
'3332' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'19.78' ,
'18.70' ,
NOW() ,
NOW() )
05/11/2024 12:24: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 = '94051'
05/11/2024 12:24:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94051'
05/11/2024 12:24: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
( '94051' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '5' , '3.33' )
05/11/2024 12:24: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
( '94051' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' ,
'8.00' , '8' , '0' , '5' , '7.60' )
05/11/2024 12:24: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
( '94051' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
05/11/2024 12:24: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
( '94051' , '5573' , 'LAVABO ' , '2' , '-2' , '1' ,
'3.00' , '2.4590163934426' , '22' , '0' , '6.00' )
05/11/2024 12:38:30 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() )
05/11/2024 12:38:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23162' , '1' , '' , 'nuovo-prodotto' )
05/11/2024 12:38:30 pm >> INSERT INTO ps_product_shop (
id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
) VALUES (
'23162' , '1' , '1' , '2' , NOW() , NOW()
)
05/11/2024 12:38:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23162' , '0' , '1' , '0' , '0' )
05/11/2024 12:39:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002316' AND id_product != '23162' AND ean13 != ''
05/11/2024 12:39:17 pm >> UPDATE ps_product SET
id_supplier = '',
reference = '',
ean13 = '002316',
date_upd = NOW()
WHERE id_product = '23162'
05/11/2024 12:39:18 pm >> UPDATE ps_product_lang SET
name = 'SERVIZIO MESSA - 5837',
description = ''
WHERE id_product = '23162'
05/11/2024 12:39:18 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '0.0000'
WHERE id_product = '23162'
05/11/2024 12:39:18 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '0.0000',
id_tax_rules_group = '1',
id_category_default = '448',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23162'
05/11/2024 12:39:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '23162'
05/11/2024 12:39:34 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' ,
'179/2024' ,
'2024-10-30' ,
'2024' ,
'0' ,
'126' ,
'4669995' ,
'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'0.00' ,
'0.00' ,
NOW() ,
NOW() )
05/11/2024 12:39:34 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 = '94052'
05/11/2024 12:39:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94052'
05/11/2024 12:39:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '21424' , 'STOLA ROMANA S. MOIRE\' - 7248S' , '1' , '1' , '1' ,
'0' , '0' , '22' , '0' , '0.0000' )
05/11/2024 12:39:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21424' AND id_supplier = '126'
05/11/2024 12:39:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21424' , '126' , '1' )
05/11/2024 12:39:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '16040' , 'STOLA ROMANA S/MOIRE\' - 7336S' , '1' , '1' , '1' ,
'0' , '0' , '22' , '0' , '0.0000' )
05/11/2024 12:39:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16040' AND id_supplier = '126'
05/11/2024 12:39:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16040' , '126' , '1' )
05/11/2024 12:39:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '19190' , 'STOLA MARIANA - 7335' , '1' , '1' , '1' ,
'0' , '0' , '22' , '0' , '0.0000' )
05/11/2024 12:39:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19190' AND id_supplier = '126'
05/11/2024 12:39:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19190' , '126' , '1' )
05/11/2024 12:39:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '1' , '1' ,
'0' , '0' , '22' , '0' , '0.0000' )
05/11/2024 12:39:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18237' AND id_supplier = '126'
05/11/2024 12:39:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18237' , '126' , '1' )
05/11/2024 12:39:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '1' , '1' ,
'0' , '0' , '22' , '0' , '0.0000' )
05/11/2024 12:39:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '126'
05/11/2024 12:39:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '126' , '1' )
05/11/2024 12:39:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '1' , '1' ,
'0' , '0' , '22' , '0' , '0.0000' )
05/11/2024 12:39:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18238' AND id_supplier = '126'
05/11/2024 12:39:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18238' , '126' , '1' )
05/11/2024 12:39:34 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '23162' , 'SERVIZIO MESSA - 5837' , '1' , '1' , '1' ,
'0.00' , '0' , '22' , '0' , '0.00' )
05/11/2024 12:39:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23162' AND id_supplier = '126'
05/11/2024 12:39:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23162' , '126' , '1' )
05/11/2024 12:43:36 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'32' ,
'145/2024' ,
'2024-10-30' ,
'2024' ,
'0' ,
'126' ,
'4669995' ,
'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' ,
'' ,
'' ,
'13' ,
'1' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'955.26' ,
'783.00' ,
NOW() ,
NOW() )
05/11/2024 12:43:36 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 = '94053'
05/11/2024 12:43:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '94053'
05/11/2024 12:43: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
( '94053' , '16955' , 'STOLA MARIANA - 8005' , '1' , '0' , '1' ,
'65' , '53.27868852459' , '22' , '0' , '79.3000' )
05/11/2024 12:43:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16955' AND id_supplier = '126'
05/11/2024 12:43:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16955' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '21420' , 'STOLA IN RASO IHS - 7871' , '1' , '0' , '1' ,
'75' , '61.475409836066' , '22' , '0' , '91.5000' )
05/11/2024 12:43:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21420' AND id_supplier = '126'
05/11/2024 12:43:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21420' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '2' , '0' , '1' ,
'20' , '16.393442622951' , '22' , '0' , '48.8000' )
05/11/2024 12:43:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '0' , '1' ,
'20' , '16.393442622951' , '22' , '0' , '24.4000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19351' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19351' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '16961' , 'SERVIZIO MESSA - 5838/4' , '1' , '0' , '1' ,
'50' , '40.983606557377' , '22' , '0' , '61.0000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16961' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16961' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '21424' , 'STOLA ROMANA S. MOIRE\' - 7248S' , '1' , '0' , '1' ,
'165' , '135.24590163934' , '22' , '0' , '201.3000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21424' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21424' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '16040' , 'STOLA ROMANA S/MOIRE\' - 7336S' , '1' , '0' , '1' ,
'175' , '143.44262295082' , '22' , '0' , '213.5000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16040' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16040' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '19190' , 'STOLA MARIANA - 7335' , '1' , '0' , '1' ,
'75' , '61.475409836066' , '22' , '0' , '91.5000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19190' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19190' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '2' , '0' , '1' ,
'20' , '16.393442622951' , '22' , '0' , '48.8000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18237' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18237' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '0' , '1' ,
'25' , '20.491803278689' , '22' , '0' , '30.5000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '0' , '1' ,
'20' , '16.393442622951' , '22' , '0' , '24.4000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18238' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18238' , '126' , '1' )
05/11/2024 12:43: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
( '94053' , '23162' , 'SERVIZIO MESSA - 5837' , '1' , '0' , '1' ,
'20' , '16.393442622951' , '22' , '0' , '24.4000' )
05/11/2024 12:43:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23162' AND id_supplier = '126'
05/11/2024 12:43:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23162' , '126' , '1' )
05/11/2024 12:44:00 pm >> UPDATE ps_document SET
id_document_type = '33',
document_num = '179/2024',
document_date = '2024-10-30',
document_letter = '2024',
id_customer = '0',
id_supplier = '',
id_address = '4669995',
address1 = 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA',
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 = '0.00',
price_tax_excluded = '0.00',
date_upd = NOW()
WHERE id_document = '94052'
05/11/2024 12:44:00 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 = '94052'
05/11/2024 12:44:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94052'
05/11/2024 12:44:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '21424' , 'STOLA ROMANA S. MOIRE\' - 7248S' , '1' , '1' , '1' ,
'0.0000' , '0' , '22' , '0' , '0.00' )
05/11/2024 12:44:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '16040' , 'STOLA ROMANA S/MOIRE\' - 7336S' , '1' , '1' , '1' ,
'0.0000' , '0' , '22' , '0' , '0.00' )
05/11/2024 12:44:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '19190' , 'STOLA MARIANA - 7335' , '1' , '1' , '1' ,
'0.0000' , '0' , '22' , '0' , '0.00' )
05/11/2024 12:44:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '2' , '2' , '1' ,
'0.0000' , '0' , '22' , '0' , '0.0000' )
05/11/2024 12:44:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '1' , '1' ,
'0.0000' , '0' , '22' , '0' , '0.00' )
05/11/2024 12:44:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '1' , '1' ,
'0.0000' , '0' , '22' , '0' , '0.00' )
05/11/2024 12:44:00 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94052' , '23162' , 'SERVIZIO MESSA - 5837' , '1' , '1' , '1' ,
'0.0000' , '0' , '22' , '0' , '0.00' )
05/11/2024 12:47:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248625' AND id_product != '17247' AND ean13 != ''
05/11/2024 12:47:43 pm >> UPDATE ps_product SET
id_supplier = '7',
reference = '2/3',
ean13 = '9788861248625',
date_upd = NOW()
WHERE id_product = '17247'
05/11/2024 12:47:43 pm >> UPDATE ps_product_lang SET
name = 'NUOVO TESTAMENTO UNA PROMESSA ....',
description = ''
WHERE id_product = '17247'
05/11/2024 12:47:43 pm >> UPDATE ps_product SET
wholesale_price = '4.55',
on_sale = '0',
price = '6.5000'
WHERE id_product = '17247'
05/11/2024 12:47:43 pm >> UPDATE ps_product_shop SET
wholesale_price = '4.55',
price = '6.5000',
id_tax_rules_group = '4',
id_category_default = '26',
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 = '17247'
05/11/2024 12:47:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '17247'
05/11/2024 12:49:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788871354729' AND id_product != '9563' AND ean13 != ''
05/11/2024 12:49:08 pm >> UPDATE ps_product SET
id_supplier = '17',
reference = '6/4',
ean13 = '9788871354729',
date_upd = NOW()
WHERE id_product = '9563'
05/11/2024 12:49:08 pm >> UPDATE ps_product_lang SET
name = 'SANTA GEMMA GALGANI - G.DI LUCA',
description = ''
WHERE id_product = '9563'
05/11/2024 12:49:09 pm >> UPDATE ps_product SET
wholesale_price = '1.75',
on_sale = '0',
price = '3.5000'
WHERE id_product = '9563'
05/11/2024 12:49:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.75',
price = '3.5000',
id_tax_rules_group = '4',
id_category_default = '501',
id_argoment_default = '53',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '9563'
05/11/2024 12:49:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '9563'
05/11/2024 12:54:51 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3333' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 12:54:51 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' ,
'3333' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'8.60' ,
'8.27' ,
NOW() ,
NOW() )
05/11/2024 12:54:51 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 = '94054'
05/11/2024 12:54:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '94054'
05/11/2024 12:54:51 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94054' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' ,
'4.30' , '4.1346153846154' , '4' , '0' , '8.60' )
05/11/2024 02:16:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002169' AND id_product != '21424' AND ean13 != ''
05/11/2024 02:16:23 pm >> UPDATE ps_product SET
id_supplier = '126',
reference = '',
ean13 = '002169',
date_upd = NOW()
WHERE id_product = '21424'
05/11/2024 02:16:23 pm >> UPDATE ps_product_lang SET
name = 'STOLA ROMANA S. MOIRE\' - 7248S',
description = ''
WHERE id_product = '21424'
05/11/2024 02:16:23 pm >> UPDATE ps_product SET
wholesale_price = '160.00',
on_sale = '0',
price = '323.7704918032787'
WHERE id_product = '21424'
05/11/2024 02:16:23 pm >> UPDATE ps_product_shop SET
wholesale_price = '160.00',
price = '323.7704918032787',
id_tax_rules_group = '1',
id_category_default = '448',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '21424'
05/11/2024 02:16:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '21424'
05/11/2024 02:18:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001779' AND id_product != '16040' AND ean13 != ''
05/11/2024 02:18:33 pm >> UPDATE ps_product SET
id_supplier = '126',
reference = '',
ean13 = '001779',
date_upd = NOW()
WHERE id_product = '16040'
05/11/2024 02:18:33 pm >> UPDATE ps_product_lang SET
name = 'STOLA ROMANA S/MOIRE\' - 7336S',
description = ''
WHERE id_product = '16040'
05/11/2024 02:18:33 pm >> UPDATE ps_product SET
wholesale_price = '170.00',
on_sale = '0',
price = '336.0655737704918'
WHERE id_product = '16040'
05/11/2024 02:18:33 pm >> UPDATE ps_product_shop SET
wholesale_price = '170.00',
price = '336.0655737704918',
id_tax_rules_group = '1',
id_category_default = '448',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '16040'
05/11/2024 02:18:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '16040'
05/11/2024 02:20:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002316' AND id_product != '23162' AND ean13 != ''
05/11/2024 02:20:09 pm >> UPDATE ps_product SET
id_supplier = '126',
reference = '',
ean13 = '002316',
date_upd = NOW()
WHERE id_product = '23162'
05/11/2024 02:20:09 pm >> UPDATE ps_product_lang SET
name = 'SERVIZIO MESSA - 5837',
description = ''
WHERE id_product = '23162'
05/11/2024 02:20:09 pm >> UPDATE ps_product SET
wholesale_price = '0.00',
on_sale = '0',
price = '40.90163934426229'
WHERE id_product = '23162'
05/11/2024 02:20:09 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.00',
price = '40.90163934426229',
id_tax_rules_group = '1',
id_category_default = '448',
id_argoment_default = '42',
id_internal_category = '3',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23162'
05/11/2024 02:20:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '23162'
05/11/2024 03:48:40 pm >> SELECT document_num FROM ps_document
WHERE document_num = '209' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 03:48:40 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' ,
'209' ,
'2024-11-05' ,
'' ,
'3999' ,
'0' ,
'4678275' ,
'Via Duomo vicolo Florio 18 84087 Sarno' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'9' ,
'0' ,
'117.80' ,
'117.80' ,
NOW() ,
NOW() )
05/11/2024 03:48:40 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 = '94055'
05/11/2024 03:48:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '94055'
05/11/2024 03:48: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
( '94055' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '5' , '9.50' )
05/11/2024 03:48: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
( '94055' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' ,
'3.80' , '3.8' , '0' , '5' , '108.30' )
05/11/2024 04:27:05 pm >> SELECT document_num FROM ps_document
WHERE document_num = '23/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 04:27: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 (
'22' ,
'23/S' ,
'2024-11-05' ,
'S' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'VENDUTO OTTOBRE 2024' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'14' ,
'0' ,
'1569.80' ,
'1569.80' ,
NOW() ,
NOW() )
05/11/2024 04:27: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 = '14764'
05/11/2024 04:27:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '14764'
05/11/2024 04:27: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
( '14764' , '17' , 'LA FEDE NELLO ZAINETTO' , '79' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '237.00' )
05/11/2024 04:27: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
( '14764' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '11' , '0' , '4' ,
'1.80' , '1.8' , '0' , '50' , '9.90' )
05/11/2024 04:27: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
( '14764' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '47' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '35.25' )
05/11/2024 04:27: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
( '14764' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '31' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '38.75' )
05/11/2024 04:27: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
( '14764' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '3' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 04:27: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
( '14764' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '2' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '3.00' )
05/11/2024 04:27: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
( '14764' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '4' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '5.00' )
05/11/2024 04:27: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
( '14764' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '10' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '12.50' )
05/11/2024 04:27: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
( '14764' , '125' , 'MIE PREGHIERINE - N. E.' , '2' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '1.50' )
05/11/2024 04:27: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
( '14764' , '33' , '100 GIORNI CON LO SPIRITO' , '2' , '0' , '4' ,
'7.50' , '7.5' , '0' , '50' , '7.50' )
05/11/2024 04:27: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
( '14764' , '40' , 'A TAVOLA CON GESU' , '13' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '16.25' )
05/11/2024 04:27: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
( '14764' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '4' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '6.00' )
05/11/2024 04:27: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
( '14764' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' ,
'9.90' , '9.9' , '0' , '50' , '4.95' )
05/11/2024 04:27: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
( '14764' , '50' , 'PERDONAMI SIGNORE' , '2' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '2.50' )
05/11/2024 04:27: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
( '14764' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '124' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '124.00' )
05/11/2024 04:27: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
( '14764' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '29' , '0' , '4' ,
'30.00' , '30' , '0' , '50' , '435.00' )
05/11/2024 04:27: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
( '14764' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '1.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '75' , 'IL SEGNO DELLA CROCE' , '2' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '1.50' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '76' , 'LA BIBBIA: NUOVO TESTAMENTO' , '3' , '0' , '4' ,
'7.90' , '7.9' , '0' , '50' , '11.85' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '88' , 'GESÙ È RISORTO' , '2' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '2.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '0' , '4' ,
'1.80' , '1.8' , '0' , '50' , '2.70' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '92' , 'LA PREGHIERA DEL ROSARIO' , '73' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '91.25' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '95' , 'LA PICCOLA MATITA' , '10' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '7.50' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '4' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '4.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '0.75' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '102' , 'LE BEATITUDINI N.EDIZ.' , '9' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '9.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '104' , 'TEMPO DI QUARESIMA' , '11' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '13.75' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '111' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '138.75' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '110' , 'SE MI AMI NON PIANGERE' , '4' , '0' , '4' ,
'1.80' , '1.8' , '0' , '50' , '3.60' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '111' , 'I NONNI SONO UN TESORO' , '2' , '0' , '4' ,
'1.80' , '1.8' , '0' , '50' , '1.80' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '27' , '0' , '4' ,
'4.00' , '4' , '0' , '50' , '54.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '117' , 'La preghiera delle cinque dita n.e.' , '14' , '0' , '4' ,
'1.80' , '1.8' , '0' , '50' , '12.60' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '8' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '10.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '84' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '105.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '20' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '30.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '138' , 'LA NASCITA DI GESU' , '15' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '18.75' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '139' , 'E NATO - n.e.' , '16' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '16.00' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '136' , 'ANGELO DI DIO N.E.' , '16' , '0' , '4' ,
'1.80' , '1.8' , '0' , '50' , '14.40' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '137' , 'AVVENTO' , '27' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '33.75' )
05/11/2024 04:27:06 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '14764' , '126' , 'SACRAMENTO DEL PERDONO' , '43' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '43.00' )
05/11/2024 04:34:07 pm >> SELECT document_num FROM ps_document
WHERE document_num = '24/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 04:34: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 (
'25' ,
'24/S' ,
'2024-11-05' ,
'S' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'RESA OTTOBRE 2024' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'101.75' ,
'101.75' ,
NOW() ,
NOW() )
05/11/2024 04:34: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 = '14765'
05/11/2024 04:34:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '14765'
05/11/2024 04:34: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
( '14765' , '13' , 'BUSSATE E VI SARÀ APERTO' , '5' , '5' , '4' ,
'1.50' , '1.5' , '0' , '50' , '3.75' )
05/11/2024 04:34: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
( '14765' , '17' , 'LA FEDE NELLO ZAINETTO' , '13' , '13' , '4' ,
'6.00' , '6' , '0' , '50' , '39.00' )
05/11/2024 04:34: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
( '14765' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '4' , '4' , '4' ,
'1.80' , '1.8' , '0' , '50' , '3.60' )
05/11/2024 04:34: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
( '14765' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '2' , '2' , '4' ,
'2.50' , '2.5' , '0' , '50' , '2.50' )
05/11/2024 04:34: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
( '14765' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '3' , '3' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 04:34: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
( '14765' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '2' , '2' , '4' ,
'2.50' , '2.5' , '0' , '50' , '2.50' )
05/11/2024 04:34: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
( '14765' , '125' , 'MIE PREGHIERINE - N. E.' , '1' , '1' , '4' ,
'1.50' , '1.5' , '0' , '50' , '0.75' )
05/11/2024 04:34: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
( '14765' , '33' , '100 GIORNI CON LO SPIRITO' , '3' , '3' , '4' ,
'7.50' , '7.5' , '0' , '50' , '11.25' )
05/11/2024 04:34: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
( '14765' , '50' , 'PERDONAMI SIGNORE' , '1' , '1' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
05/11/2024 04:34: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
( '14765' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '7' , '7' , '4' ,
'2.00' , '2' , '0' , '50' , '7.00' )
05/11/2024 04:34: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
( '14765' , '75' , 'IL SEGNO DELLA CROCE' , '2' , '2' , '4' ,
'1.50' , '1.5' , '0' , '50' , '1.50' )
05/11/2024 04:34: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
( '14765' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '4' , '4' , '4' ,
'1.80' , '1.8' , '0' , '50' , '3.60' )
05/11/2024 04:34: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
( '14765' , '92' , 'LA PREGHIERA DEL ROSARIO' , '3' , '3' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 04:34: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
( '14765' , '104' , 'TEMPO DI QUARESIMA' , '1' , '1' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
05/11/2024 04:34: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
( '14765' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '5' , '5' , '4' ,
'2.50' , '2.5' , '0' , '50' , '6.25' )
05/11/2024 04:34: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
( '14765' , '110' , 'SE MI AMI NON PIANGERE' , '2' , '2' , '4' ,
'1.80' , '1.8' , '0' , '50' , '1.80' )
05/11/2024 04:34: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
( '14765' , '138' , 'LA NASCITA DI GESU' , '5' , '5' , '4' ,
'2.50' , '2.5' , '0' , '50' , '6.25' )
05/11/2024 04:34: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
( '14765' , '126' , 'SACRAMENTO DEL PERDONO' , '2' , '2' , '4' ,
'2.00' , '2' , '0' , '50' , '2.00' )
05/11/2024 04:36:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801044416' AND id_product != '9563' AND ean13 != ''
05/11/2024 04:36:25 pm >> UPDATE ps_product SET
id_supplier = '17',
reference = '6/4',
ean13 = '9788801044416',
date_upd = NOW()
WHERE id_product = '9563'
05/11/2024 04:36:25 pm >> UPDATE ps_product_lang SET
name = 'SANTA GEMMA GALGANI - G.DI LUCA',
description = ''
WHERE id_product = '9563'
05/11/2024 04:36:25 pm >> UPDATE ps_product SET
wholesale_price = '1.75',
on_sale = '0',
price = '3.5000'
WHERE id_product = '9563'
05/11/2024 04:36:25 pm >> UPDATE ps_product_shop SET
wholesale_price = '1.75',
price = '3.5000',
id_tax_rules_group = '4',
id_category_default = '501',
id_argoment_default = '53',
id_internal_category = '7',
on_sale = '0',
on_showcase = '0',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '9563'
05/11/2024 04:36:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '9563'
05/11/2024 04:39:15 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 (
'31' ,
'284/24' ,
'2024-10-29' ,
'24' ,
'0' ,
'145' ,
'4670978' ,
'VIA TORQUATO TASSO 10 24020 GORLE' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'58.50' ,
'58.50' ,
NOW() ,
NOW() )
05/11/2024 04:39:15 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 = '94056'
05/11/2024 04:39:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94056'
05/11/2024 04:39: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
( '94056' , '23159' , 'EDITH STEIN - V. SALVOLDI' , '1' , '1' , '4' ,
'5.50' , '5.5' , '0' , '50' , '2.7500' )
05/11/2024 04:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23159' AND id_supplier = '145'
05/11/2024 04:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23159' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '9563' , 'SANTA GEMMA GALGANI - G.DI LUCA' , '1' , '1' , '4' ,
'3.50' , '3.5' , '0' , '50' , '1.7500' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9563' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9563' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '9573' , 'SANTA LUCIA' , '1' , '1' , '4' ,
'5.00' , '5' , '0' , '50' , '2.5000' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9573' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9573' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '9553' , 'SANTA CHIARA DI ASSISI - G.POLIDORO' , '1' , '1' , '4' ,
'5.50' , '5.5' , '0' , '50' , '2.7500' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9553' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9553' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '9438' , 'SAN GENNARO VESCOVO' , '1' , '1' , '4' ,
'4.00' , '4' , '0' , '50' , '2.0000' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9438' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9438' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '23158' , 'SAN GIUSTINO M. RUSSOLILLO - S. MEUCCI' , '1' , '1' , '4' ,
'6.00' , '6' , '0' , '50' , '3.0000' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23158' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23158' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '9613' , 'SANTA TERESA DI LISIEUX' , '1' , '1' , '4' ,
'5.00' , '5' , '0' , '50' , '2.5000' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9613' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9613' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '3' , '3' , '4' ,
'5.50' , '5.5' , '0' , '50' , '8.2500' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '21031' , 'MADONNA DEL ROSARIO - A. CAMPAGNA' , '2' , '2' , '4' ,
'5.00' , '5' , '0' , '50' , '5.0000' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21031' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21031' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '6242' , 'MARIA IMMACOLATA - S. CECCHIN' , '3' , '3' , '4' ,
'5.00' , '5' , '0' , '50' , '7.5000' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6242' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6242' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' ,
'5.00' , '5' , '0' , '50' , '2.5000' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19667' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19667' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '23157' , 'ASPETTIAMO CON GIOIA IL NATALE' , '3' , '3' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.7500' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23157' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23157' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '23156' , 'ACCOGLIAMO GESU' , '3' , '3' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.7500' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23156' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23156' , '145' , '1' )
05/11/2024 04:39: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
( '94056' , '23155' , 'VITA CRISTIANA 2025' , '3' , '3' , '4' ,
'7.00' , '7' , '0' , '50' , '10.5000' )
05/11/2024 04:39:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23155' AND id_supplier = '145'
05/11/2024 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23155' , '145' , '1' )
05/11/2024 05:05:11 pm >> SELECT document_num FROM ps_document
WHERE document_num = '52/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 05:05:11 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 (
'22' ,
'52/E' ,
'2024-11-05' ,
'E' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'14' ,
'0' ,
'24434.10' ,
'24393.62' ,
NOW() ,
NOW() )
05/11/2024 05:05:11 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 = '94057'
05/11/2024 05:05:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '94057'
05/11/2024 05:05:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94057' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '786' , '0' , '4' ,
'2.40' , '2.4' , '0' , '50' , '943.20' )
05/11/2024 05:05:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94057' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '166' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '207.50' )
05/11/2024 05:05:11 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94057' , '5446' , 'IO SONO CON VOI - GUIDA' , '16' , '0' , '4' ,
'8.00' , '8' , '0' , '50' , '64.00' )
05/11/2024 05:05: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
( '94057' , '11183' , 'VENITE CON ME - GUIDA' , '33' , '0' , '4' ,
'8.00' , '8' , '0' , '50' , '132.00' )
05/11/2024 05:05: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
( '94057' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '1.00' )
05/11/2024 05:05: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
( '94057' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '1.00' )
05/11/2024 05:05: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
( '94057' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '23' , '0' , '4' ,
'6.20' , '6.2' , '0' , '50' , '71.30' )
05/11/2024 05:05: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
( '94057' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '1.75' )
05/11/2024 05:05: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
( '94057' , '9675' , 'SARETE MIEI TESTIMONI' , '314' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '549.50' )
05/11/2024 05:05: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
( '94057' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2679' , '0' , '4' ,
'2.80' , '2.8' , '0' , '50' , '3750.60' )
05/11/2024 05:05: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
( '94057' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1947' , '0' , '4' ,
'2.80' , '2.8' , '0' , '50' , '2725.80' )
05/11/2024 05:05: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
( '94057' , '11191' , 'VENITE CON ME 1 PARTE' , '1987' , '0' , '4' ,
'2.80' , '2.8' , '0' , '50' , '2781.80' )
05/11/2024 05:05: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
( '94057' , '11192' , 'VENITE CON ME 2 PARTE' , '1362' , '0' , '4' ,
'2.80' , '2.8' , '0' , '50' , '1906.80' )
05/11/2024 05:05: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
( '94057' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '8' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '14.00' )
05/11/2024 05:05: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
( '94057' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '0' , '4' ,
'8.00' , '8' , '0' , '50' , '4.00' )
05/11/2024 05:05: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
( '94057' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '0' , '4' ,
'3.40' , '3.4' , '0' , '50' , '1.70' )
05/11/2024 05:05: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
( '94057' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '364' , '0' , '4' ,
'3.40' , '3.4' , '0' , '50' , '618.80' )
05/11/2024 05:05: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
( '94057' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '36' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '90.00' )
05/11/2024 05:05: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
( '94057' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '5.00' )
05/11/2024 05:05: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
( '94057' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '14' , '0' , '4' ,
'8.00' , '8' , '0' , '50' , '56.00' )
05/11/2024 05:05: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
( '94057' , '6629' , 'MIA PREGHIERA' , '1' , '0' , '4' ,
'0.90' , '0.9' , '0' , '50' , '0.45' )
05/11/2024 05:05: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
( '94057' , '8408' , 'PRENDETE E MANGIATE' , '824' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '1236.00' )
05/11/2024 05:05: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
( '94057' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '33' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '82.50' )
05/11/2024 05:05: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
( '94057' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '23' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '57.50' )
05/11/2024 05:05: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
( '94057' , '4154' , 'FESTA DEL PERDONO' , '831' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '1246.50' )
05/11/2024 05:05: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
( '94057' , '2679' , 'CONOSCERE GESU' , '556' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '973.00' )
05/11/2024 05:05: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
( '94057' , '2680' , 'CONOSCERE GESU - GUIDA' , '14' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '42.00' )
05/11/2024 05:05: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
( '94057' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '4' , '0' , '4' ,
'5.00' , '5' , '0' , '50' , '10.00' )
05/11/2024 05:05: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
( '94057' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' ,
'1.60' , '1.6' , '0' , '50' , '0.80' )
05/11/2024 05:05: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
( '94057' , '7543' , 'PARABOLE DI GESÙ' , '58' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '87.00' )
05/11/2024 05:05: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
( '94057' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '320' , '0' , '4' ,
'3.80' , '3.8' , '0' , '50' , '608.00' )
05/11/2024 05:05: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
( '94057' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '235' , '0' , '4' ,
'3.80' , '3.8' , '0' , '50' , '446.50' )
05/11/2024 05:05: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
( '94057' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '13' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '65.00' )
05/11/2024 05:05: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
( '94057' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '281' , '0' , '4' ,
'3.80' , '3.8' , '0' , '50' , '533.90' )
05/11/2024 05:05: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
( '94057' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '12' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '60.00' )
05/11/2024 05:05: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
( '94057' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '14' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '70.00' )
05/11/2024 05:05: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
( '94057' , '12819' , 'REGISTRO DEL CATECHISTA ' , '449' , '0' , '1' ,
'1.00' , '0.81967213114754' , '22' , '50' , '224.50' )
05/11/2024 05:05: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
( '94057' , '12813' , 'MARIA MADRE NOSTRA' , '14' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '21.00' )
05/11/2024 05:05: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
( '94057' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '12' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '21.00' )
05/11/2024 05:05: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
( '94057' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '45' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '135.00' )
05/11/2024 05:05: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
( '94057' , '13397' , 'MIO GESU' , '92' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '161.00' )
05/11/2024 05:05: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
( '94057' , '13956' , 'MIRACOLI DI GESU' , '4' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '6.00' )
05/11/2024 05:05: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
( '94057' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '3' , '0' , '4' ,
'9.00' , '9' , '0' , '50' , '13.50' )
05/11/2024 05:05: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
( '94057' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '628' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '314.00' )
05/11/2024 05:05: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
( '94057' , '15019' , 'PREGHIAMO CON MARIA' , '11' , '0' , '4' ,
'0.80' , '0.8' , '0' , '50' , '4.40' )
05/11/2024 05:05: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
( '94057' , '15020' , 'PREGARE OGNI GIORNO' , '4' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '2.00' )
05/11/2024 05:05: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
( '94057' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '3' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '5.25' )
05/11/2024 05:05: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
( '94057' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '15' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '45.00' )
05/11/2024 05:05: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
( '94057' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '41' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '20.50' )
05/11/2024 05:05: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
( '94057' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '11' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '11.00' )
05/11/2024 05:05: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
( '94057' , '16667' , 'VIA CRUCIS' , '9' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '13.50' )
05/11/2024 05:05: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
( '94057' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '3' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 05:05: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
( '94057' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '2' , '0' , '4' ,
'15.00' , '15' , '0' , '50' , '15.00' )
05/11/2024 05:05: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
( '94057' , '17257' , 'IO TI BATTEZZO ' , '72' , '0' , '4' ,
'1.80' , '1.8' , '0' , '50' , '64.80' )
05/11/2024 05:05: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
( '94057' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' ,
'3.80' , '3.8' , '0' , '50' , '1.90' )
05/11/2024 05:05: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
( '94057' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '2' , '0' , '4' ,
'4.80' , '4.8' , '0' , '50' , '4.80' )
05/11/2024 05:05: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
( '94057' , '18176' , 'ANTIQUUM MINISTERIUM ' , '16' , '0' , '4' ,
'1.00' , '1' , '0' , '50' , '8.00' )
05/11/2024 05:05: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
( '94057' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '104' , '0' , '4' ,
'1.90' , '1.9' , '0' , '50' , '98.80' )
05/11/2024 05:05: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
( '94057' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '7' , '0' , '4' ,
'1.50' , '1.5' , '0' , '50' , '5.25' )
05/11/2024 05:05: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
( '94057' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '4' , '0' , '4' ,
'16.00' , '16' , '0' , '50' , '32.00' )
05/11/2024 05:05: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
( '94057' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '6' , '0' , '4' ,
'7.00' , '7' , '0' , '50' , '21.00' )
05/11/2024 05:05: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
( '94057' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '8' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '8.00' )
05/11/2024 05:05: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
( '94057' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '0' , '4' ,
'9.00' , '9' , '0' , '50' , '9.00' )
05/11/2024 05:05: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
( '94057' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '12' , '0' , '4' ,
'9.00' , '9' , '0' , '50' , '54.00' )
05/11/2024 05:05: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
( '94057' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' ,
'9.00' , '9' , '0' , '50' , '9.00' )
05/11/2024 05:05: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
( '94057' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '5' , '0' , '4' ,
'12.00' , '12' , '0' , '50' , '30.00' )
05/11/2024 05:05: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
( '94057' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '3' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 05:05: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
( '94057' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '8' , '0' , '4' ,
'4.50' , '4.5' , '0' , '50' , '18.00' )
05/11/2024 05:05: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
( '94057' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '5' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '6.25' )
05/11/2024 05:05: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
( '94057' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '5.00' )
05/11/2024 05:05: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
( '94057' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '11' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '13.75' )
05/11/2024 05:05: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
( '94057' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '6' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '6.00' )
05/11/2024 05:05: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
( '94057' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '0' , '4' ,
'4.50' , '4.5' , '0' , '50' , '2.25' )
05/11/2024 05:05: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
( '94057' , '20722' , 'SEMINATORI DI GIOIA' , '28' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '35.00' )
05/11/2024 05:05: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
( '94057' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '2' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '2.50' )
05/11/2024 05:05: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
( '94057' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '5.00' )
05/11/2024 05:05: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
( '94057' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '3' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 05:05: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
( '94057' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '698' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '1047.00' )
05/11/2024 05:05: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
( '94057' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '22' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '27.50' )
05/11/2024 05:05: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
( '94057' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '29' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '29.00' )
05/11/2024 05:05: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
( '94057' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '27' , '0' , '4' ,
'2.00' , '2' , '0' , '50' , '27.00' )
05/11/2024 05:05: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
( '94057' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '22' , '0' , '4' ,
'8.00' , '8' , '0' , '50' , '88.00' )
05/11/2024 05:05: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
( '94057' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '9' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '45.00' )
05/11/2024 05:05: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
( '94057' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '3' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 05:05: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
( '94057' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '11' , '0' , '4' ,
'8.00' , '8' , '0' , '50' , '44.00' )
05/11/2024 05:05: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
( '94057' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '14' , '0' , '4' ,
'2.80' , '2.8' , '0' , '50' , '19.60' )
05/11/2024 05:05: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
( '94057' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '47' , '0' , '4' ,
'2.80' , '2.8' , '0' , '50' , '65.80' )
05/11/2024 05:05: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
( '94057' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '27' , '0' , '4' ,
'2.50' , '2.5' , '0' , '50' , '33.75' )
05/11/2024 05:05: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
( '94057' , '22151' , 'MA DIO LO HA RISUSCITATO' , '7' , '0' , '4' ,
'10.00' , '10' , '0' , '50' , '35.00' )
05/11/2024 05:05: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
( '94057' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '3' , '0' , '4' ,
'6.00' , '6' , '0' , '50' , '9.00' )
05/11/2024 05:05: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
( '94057' , '22152' , 'A TE RICORRIAMO' , '73' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '109.50' )
05/11/2024 05:05: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
( '94057' , '23092' , 'SPERANZA CHE E IN NOI' , '218' , '0' , '4' ,
'3.50' , '3.5' , '0' , '50' , '381.50' )
05/11/2024 05:05: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
( '94057' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '116' , '0' , '4' ,
'8.00' , '8' , '0' , '50' , '464.00' )
05/11/2024 05:05: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
( '94057' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '358' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '537.00' )
05/11/2024 05:05: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
( '94057' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '399' , '0' , '4' ,
'2.80' , '2.8' , '0' , '50' , '558.60' )
05/11/2024 05:06:15 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 05:06:15 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' ,
'3334' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
05/11/2024 05:06:15 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 = '94058'
05/11/2024 05:06:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94058'
05/11/2024 05:06: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
( '94058' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '2' , '-2' , '4' ,
'5.00' , '5' , '0' , '5' , '9.50' )
05/11/2024 05:11:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736444' AND id_product != '23092' AND ean13 != ''
05/11/2024 05:11:03 pm >> UPDATE ps_product SET
id_supplier = '145',
reference = 'GONDOLA 2',
ean13 = '9791280736444',
date_upd = NOW()
WHERE id_product = '23092'
05/11/2024 05:11:03 pm >> UPDATE ps_product_lang SET
name = 'SPERANZA CHE E\' IN NOI',
description = 'Sussidio in preparazione al Giubileo 2025: «Pellegrini di speranza». Il 2024 è l’anno dedicato alla preghiera per preparare i pellegrini a vivere il Giubileo 2025. Questo libretto vuole rafforzare la speranza dei cristiani, fondata su Gesù Cristo, per testimoniare, con gioia e senza paura, il Vangelo che si traduce nell\'amore verso Dio e verso il prossimo, impegnandoci a cambiare in meglio il mondo.
'
WHERE id_product = '23092'
05/11/2024 05:11:03 pm >> UPDATE ps_product SET
wholesale_price = '0.90',
on_sale = '0',
price = '3'
WHERE id_product = '23092'
05/11/2024 05:11:03 pm >> UPDATE ps_product_shop SET
wholesale_price = '0.90',
price = '3',
id_tax_rules_group = '4',
id_category_default = '395',
id_argoment_default = '23',
id_internal_category = '4',
on_sale = '0',
on_showcase = '1',
on_offer = '00',
on_most = '00',
date_upd = NOW()
WHERE id_product = '23092'
05/11/2024 05:11:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '23092'
05/11/2024 05:12:14 pm >> SELECT document_num FROM ps_document
WHERE document_num = '52/E' AND id_document != '94057' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 05:12:14 pm >> UPDATE ps_document SET
id_document_type = '22',
document_num = '52/E',
document_date = '2024-11-05',
document_letter = 'E',
id_customer = '3000',
id_supplier = '',
id_address = '4669629',
address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
address2 = '',
note = 'VENDUTO OTTOBRE 2024',
price_shipping = '0.00',
id_tax_shipping_rules = '4',
colli = '0',
peso = '0',
porto_e_imballo = '0',
mezzo_consegna = '',
id_payment = '14',
id_causal = '0',
price_tax_included = '24379.60',
price_tax_excluded = '24339.12',
date_upd = NOW()
WHERE id_document = '94057'
05/11/2024 05:12: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 = '94057'
05/11/2024 05:12:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94057'
05/11/2024 05:12: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
( '94057' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '786' , '0' , '4' ,
'2.4000' , '2.4' , '0' , '50' , '943.20' )
05/11/2024 05:12: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
( '94057' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '166' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '207.50' )
05/11/2024 05:12: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
( '94057' , '5446' , 'IO SONO CON VOI - GUIDA' , '16' , '0' , '4' ,
'8.0000' , '8' , '0' , '50' , '64.00' )
05/11/2024 05:12: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
( '94057' , '11183' , 'VENITE CON ME - GUIDA' , '33' , '0' , '4' ,
'8.0000' , '8' , '0' , '50' , '132.00' )
05/11/2024 05:12: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
( '94057' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '0' , '4' ,
'2.0000' , '2' , '0' , '50' , '1.00' )
05/11/2024 05:12: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
( '94057' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '0' , '4' ,
'2.0000' , '2' , '0' , '50' , '1.00' )
05/11/2024 05:12: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
( '94057' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '23' , '0' , '4' ,
'6.2000' , '6.2' , '0' , '50' , '71.30' )
05/11/2024 05:12: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
( '94057' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '0' , '4' ,
'3.5000' , '3.5' , '0' , '50' , '1.75' )
05/11/2024 05:12: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
( '94057' , '9675' , 'SARETE MIEI TESTIMONI' , '314' , '0' , '4' ,
'3.5000' , '3.5' , '0' , '50' , '549.50' )
05/11/2024 05:12: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
( '94057' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2679' , '0' , '4' ,
'2.8000' , '2.8' , '0' , '50' , '3750.60' )
05/11/2024 05:12: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
( '94057' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1947' , '0' , '4' ,
'2.8000' , '2.8' , '0' , '50' , '2725.80' )
05/11/2024 05:12: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
( '94057' , '11191' , 'VENITE CON ME 1 PARTE' , '1987' , '0' , '4' ,
'2.8000' , '2.8' , '0' , '50' , '2781.80' )
05/11/2024 05:12: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
( '94057' , '11192' , 'VENITE CON ME 2 PARTE' , '1362' , '0' , '4' ,
'2.8000' , '2.8' , '0' , '50' , '1906.80' )
05/11/2024 05:12: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
( '94057' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '8' , '0' , '4' ,
'3.5000' , '3.5' , '0' , '50' , '14.00' )
05/11/2024 05:12: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
( '94057' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '0' , '4' ,
'8.0000' , '8' , '0' , '50' , '4.00' )
05/11/2024 05:12: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
( '94057' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '0' , '4' ,
'3.4000' , '3.4' , '0' , '50' , '1.70' )
05/11/2024 05:12: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
( '94057' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '364' , '0' , '4' ,
'3.4000' , '3.4' , '0' , '50' , '618.80' )
05/11/2024 05:12: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
( '94057' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '36' , '0' , '4' ,
'5.0000' , '5' , '0' , '50' , '90.00' )
05/11/2024 05:12: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
( '94057' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '50' , '5.00' )
05/11/2024 05:12: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
( '94057' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '14' , '0' , '4' ,
'8.0000' , '8' , '0' , '50' , '56.00' )
05/11/2024 05:12: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
( '94057' , '6629' , 'MIA PREGHIERA' , '1' , '0' , '4' ,
'0.9000' , '0.9' , '0' , '50' , '0.45' )
05/11/2024 05:12: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
( '94057' , '8408' , 'PRENDETE E MANGIATE' , '824' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '1236.00' )
05/11/2024 05:12: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
( '94057' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '33' , '0' , '4' ,
'5.0000' , '5' , '0' , '50' , '82.50' )
05/11/2024 05:12: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
( '94057' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '23' , '0' , '4' ,
'5.0000' , '5' , '0' , '50' , '57.50' )
05/11/2024 05:12: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
( '94057' , '4154' , 'FESTA DEL PERDONO' , '831' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '1246.50' )
05/11/2024 05:12: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
( '94057' , '2679' , 'CONOSCERE GESU' , '556' , '0' , '4' ,
'3.5000' , '3.5' , '0' , '50' , '973.00' )
05/11/2024 05:12: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
( '94057' , '2680' , 'CONOSCERE GESU - GUIDA' , '14' , '0' , '4' ,
'6.0000' , '6' , '0' , '50' , '42.00' )
05/11/2024 05:12: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
( '94057' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '4' , '0' , '4' ,
'5.0000' , '5' , '0' , '50' , '10.00' )
05/11/2024 05:12: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
( '94057' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' ,
'1.6000' , '1.6' , '0' , '50' , '0.80' )
05/11/2024 05:12: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
( '94057' , '7543' , 'PARABOLE DI GESÙ' , '58' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '87.00' )
05/11/2024 05:12: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
( '94057' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '320' , '0' , '4' ,
'3.8000' , '3.8' , '0' , '50' , '608.00' )
05/11/2024 05:12: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
( '94057' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '235' , '0' , '4' ,
'3.8000' , '3.8' , '0' , '50' , '446.50' )
05/11/2024 05:12: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
( '94057' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '13' , '0' , '4' ,
'10.0000' , '10' , '0' , '50' , '65.00' )
05/11/2024 05:12: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
( '94057' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '281' , '0' , '4' ,
'3.8000' , '3.8' , '0' , '50' , '533.90' )
05/11/2024 05:12: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
( '94057' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '12' , '0' , '4' ,
'10.0000' , '10' , '0' , '50' , '60.00' )
05/11/2024 05:12: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
( '94057' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '14' , '0' , '4' ,
'10.0000' , '10' , '0' , '50' , '70.00' )
05/11/2024 05:12: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
( '94057' , '12819' , 'REGISTRO DEL CATECHISTA ' , '449' , '0' , '1' ,
'1.0000' , '0.81967213114754' , '22' , '50' , '224.50' )
05/11/2024 05:12: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
( '94057' , '12813' , 'MARIA MADRE NOSTRA' , '14' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '21.00' )
05/11/2024 05:12: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
( '94057' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '12' , '0' , '4' ,
'3.5000' , '3.5' , '0' , '50' , '21.00' )
05/11/2024 05:12: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
( '94057' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '45' , '0' , '4' ,
'6.0000' , '6' , '0' , '50' , '135.00' )
05/11/2024 05:12: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
( '94057' , '13397' , 'MIO GESU' , '92' , '0' , '4' ,
'3.5000' , '3.5' , '0' , '50' , '161.00' )
05/11/2024 05:12: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
( '94057' , '13956' , 'MIRACOLI DI GESU' , '4' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '6.00' )
05/11/2024 05:12: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
( '94057' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '3' , '0' , '4' ,
'9.0000' , '9' , '0' , '50' , '13.50' )
05/11/2024 05:12: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
( '94057' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '628' , '0' , '4' ,
'1.0000' , '1' , '0' , '50' , '314.00' )
05/11/2024 05:12: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
( '94057' , '15019' , 'PREGHIAMO CON MARIA' , '11' , '0' , '4' ,
'0.8000' , '0.8' , '0' , '50' , '4.40' )
05/11/2024 05:12: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
( '94057' , '15020' , 'PREGARE OGNI GIORNO' , '4' , '0' , '4' ,
'1.0000' , '1' , '0' , '50' , '2.00' )
05/11/2024 05:12: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
( '94057' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '3' , '0' , '4' ,
'3.5000' , '3.5' , '0' , '50' , '5.25' )
05/11/2024 05:12: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
( '94057' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '15' , '0' , '4' ,
'6.0000' , '6' , '0' , '50' , '45.00' )
05/11/2024 05:12: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
( '94057' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '41' , '0' , '4' ,
'1.0000' , '1' , '0' , '50' , '20.50' )
05/11/2024 05:12: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
( '94057' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '11' , '0' , '4' ,
'2.0000' , '2' , '0' , '50' , '11.00' )
05/11/2024 05:12: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
( '94057' , '16667' , 'VIA CRUCIS' , '9' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '13.50' )
05/11/2024 05:12: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
( '94057' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '3' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 05:12: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
( '94057' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '2' , '0' , '4' ,
'15.0000' , '15' , '0' , '50' , '15.00' )
05/11/2024 05:12: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
( '94057' , '17257' , 'IO TI BATTEZZO ' , '72' , '0' , '4' ,
'1.8000' , '1.8' , '0' , '50' , '64.80' )
05/11/2024 05:12: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
( '94057' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' ,
'3.8000' , '3.8' , '0' , '50' , '1.90' )
05/11/2024 05:12: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
( '94057' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '2' , '0' , '4' ,
'4.8000' , '4.8' , '0' , '50' , '4.80' )
05/11/2024 05:12: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
( '94057' , '18176' , 'ANTIQUUM MINISTERIUM ' , '16' , '0' , '4' ,
'1.0000' , '1' , '0' , '50' , '8.00' )
05/11/2024 05:12: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
( '94057' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '104' , '0' , '4' ,
'1.9000' , '1.9' , '0' , '50' , '98.80' )
05/11/2024 05:12: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
( '94057' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '7' , '0' , '4' ,
'1.5000' , '1.5' , '0' , '50' , '5.25' )
05/11/2024 05:12: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
( '94057' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '4' , '0' , '4' ,
'16.0000' , '16' , '0' , '50' , '32.00' )
05/11/2024 05:12: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
( '94057' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '6' , '0' , '4' ,
'7.0000' , '7' , '0' , '50' , '21.00' )
05/11/2024 05:12: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
( '94057' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '8' , '0' , '4' ,
'2.0000' , '2' , '0' , '50' , '8.00' )
05/11/2024 05:12: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
( '94057' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '0' , '4' ,
'9.0000' , '9' , '0' , '50' , '9.00' )
05/11/2024 05:12: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
( '94057' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '12' , '0' , '4' ,
'9.0000' , '9' , '0' , '50' , '54.00' )
05/11/2024 05:12: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
( '94057' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' ,
'9.0000' , '9' , '0' , '50' , '9.00' )
05/11/2024 05:12: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
( '94057' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '5' , '0' , '4' ,
'12.0000' , '12' , '0' , '50' , '30.00' )
05/11/2024 05:12: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
( '94057' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '3' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 05:12: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
( '94057' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '8' , '0' , '4' ,
'4.5000' , '4.5' , '0' , '50' , '18.00' )
05/11/2024 05:12: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
( '94057' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '5' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '6.25' )
05/11/2024 05:12: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
( '94057' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '50' , '5.00' )
05/11/2024 05:12: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
( '94057' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '11' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '13.75' )
05/11/2024 05:12: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
( '94057' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '6' , '0' , '4' ,
'2.0000' , '2' , '0' , '50' , '6.00' )
05/11/2024 05:12: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
( '94057' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '0' , '4' ,
'4.5000' , '4.5' , '0' , '50' , '2.25' )
05/11/2024 05:12: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
( '94057' , '20722' , 'SEMINATORI DI GIOIA' , '28' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '35.00' )
05/11/2024 05:12: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
( '94057' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '2' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '2.50' )
05/11/2024 05:12: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
( '94057' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '0' , '4' ,
'10.0000' , '10' , '0' , '50' , '5.00' )
05/11/2024 05:12: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
( '94057' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '3' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 05:12: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
( '94057' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '698' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '1047.00' )
05/11/2024 05:12: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
( '94057' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '22' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '27.50' )
05/11/2024 05:12: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
( '94057' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '29' , '0' , '4' ,
'2.0000' , '2' , '0' , '50' , '29.00' )
05/11/2024 05:12: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
( '94057' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '27' , '0' , '4' ,
'2.0000' , '2' , '0' , '50' , '27.00' )
05/11/2024 05:12: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
( '94057' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '22' , '0' , '4' ,
'8.0000' , '8' , '0' , '50' , '88.00' )
05/11/2024 05:12: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
( '94057' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '9' , '0' , '4' ,
'10.0000' , '10' , '0' , '50' , '45.00' )
05/11/2024 05:12: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
( '94057' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '3' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '3.75' )
05/11/2024 05:12: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
( '94057' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '11' , '0' , '4' ,
'8.0000' , '8' , '0' , '50' , '44.00' )
05/11/2024 05:12: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
( '94057' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '14' , '0' , '4' ,
'2.8000' , '2.8' , '0' , '50' , '19.60' )
05/11/2024 05:12: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
( '94057' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '47' , '0' , '4' ,
'2.8000' , '2.8' , '0' , '50' , '65.80' )
05/11/2024 05:12: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
( '94057' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '27' , '0' , '4' ,
'2.5000' , '2.5' , '0' , '50' , '33.75' )
05/11/2024 05:12: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
( '94057' , '22151' , 'MA DIO LO HA RISUSCITATO' , '7' , '0' , '4' ,
'10.0000' , '10' , '0' , '50' , '35.00' )
05/11/2024 05:12: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
( '94057' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '3' , '0' , '4' ,
'6.0000' , '6' , '0' , '50' , '9.00' )
05/11/2024 05:12: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
( '94057' , '22152' , 'A TE RICORRIAMO' , '73' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '109.50' )
05/11/2024 05:12: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
( '94057' , '23092' , 'SPERANZA CHE E IN NOI' , '218' , '0' , '4' ,
'3.00' , '3' , '0' , '50' , '327.00' )
05/11/2024 05:12: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
( '94057' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '116' , '0' , '4' ,
'8.0000' , '8' , '0' , '50' , '464.00' )
05/11/2024 05:12: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
( '94057' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '358' , '0' , '4' ,
'3.0000' , '3' , '0' , '50' , '537.00' )
05/11/2024 05:12: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
( '94057' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '399' , '0' , '4' ,
'2.8000' , '2.8' , '0' , '50' , '558.60' )
05/11/2024 05:23:43 pm >> SELECT document_num FROM ps_document
WHERE document_num = '53/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 05:23:43 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 (
'25' ,
'53/E' ,
'2024-11-05' ,
'E' ,
'3000' ,
'0' ,
'4669629' ,
'VIA DEI CASTANI, 116 00172 ROMA' ,
'' ,
'RESA OTTOBRE 2024' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'765.60' ,
'761.63' ,
NOW() ,
NOW() )
05/11/2024 05:23:43 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 = '94059'
05/11/2024 05:23:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94059'
05/11/2024 05:23:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '1' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
05/11/2024 05:23:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '9675' , 'SARETE MIEI TESTIMONI' , '8' , '8' , '4' ,
'3.50' , '3.5' , '0' , '50' , '14.00' )
05/11/2024 05:23:43 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '5457' , 'IO SONO CON VOI 1 PARTE' , '152' , '152' , '4' ,
'2.80' , '2.8' , '0' , '50' , '212.80' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '5458' , 'IO SONO CON VOI 2 PARTE' , '29' , '29' , '4' ,
'2.80' , '2.8' , '0' , '50' , '40.60' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '11191' , 'VENITE CON ME 1 PARTE' , '17' , '17' , '4' ,
'2.80' , '2.8' , '0' , '50' , '23.80' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '11192' , 'VENITE CON ME 2 PARTE' , '22' , '22' , '4' ,
'2.80' , '2.8' , '0' , '50' , '30.80' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '1' , '4' ,
'8.00' , '8' , '0' , '50' , '4.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '5' , '5' , '4' ,
'3.40' , '3.4' , '0' , '50' , '8.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '6629' , 'MIA PREGHIERA' , '1' , '1' , '4' ,
'0.90' , '0.9' , '0' , '50' , '0.45' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '8408' , 'PRENDETE E MANGIATE' , '12' , '12' , '4' ,
'3.00' , '3' , '0' , '50' , '18.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '2' , '4' ,
'5.00' , '5' , '0' , '50' , '5.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '1' , '4' ,
'5.00' , '5' , '0' , '50' , '2.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '4154' , 'FESTA DEL PERDONO' , '12' , '12' , '4' ,
'3.00' , '3' , '0' , '50' , '18.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '2679' , 'CONOSCERE GESU' , '58' , '58' , '4' ,
'3.50' , '3.5' , '0' , '50' , '101.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '7543' , 'PARABOLE DI GESÙ' , '9' , '9' , '4' ,
'3.00' , '3' , '0' , '50' , '13.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '12819' , 'REGISTRO DEL CATECHISTA ' , '44' , '44' , '1' ,
'1.00' , '0.81967213114754' , '22' , '50' , '22.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '13956' , 'MIRACOLI DI GESU' , '8' , '8' , '4' ,
'3.00' , '3' , '0' , '50' , '12.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '14032' , 'AVE MARIA' , '1' , '1' , '4' ,
'3.00' , '3' , '0' , '50' , '1.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '14029' , 'ANGELO DI DIO' , '1' , '1' , '4' ,
'3.00' , '3' , '0' , '50' , '1.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '1' , '4' ,
'0.80' , '0.8' , '0' , '50' , '0.40' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '5' , '5' , '4' ,
'2.00' , '2' , '0' , '50' , '5.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '16667' , 'VIA CRUCIS' , '4' , '4' , '4' ,
'3.00' , '3' , '0' , '50' , '6.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '2' , '2' , '4' ,
'2.50' , '2.5' , '0' , '50' , '2.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '1' , '4' ,
'15.00' , '15' , '0' , '50' , '7.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '5' , '5' , '4' ,
'3.80' , '3.8' , '0' , '50' , '9.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '1' , '4' ,
'12.00' , '12' , '0' , '50' , '6.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '6' , '6' , '4' ,
'2.00' , '2' , '0' , '50' , '6.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '1' , '4' ,
'1.90' , '1.9' , '0' , '50' , '0.95' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '5' , '5' , '4' ,
'2.00' , '2' , '0' , '50' , '5.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '2' , '2' , '4' ,
'7.00' , '7' , '0' , '50' , '7.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '1' , '4' ,
'10.00' , '10' , '0' , '50' , '5.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '5' , '5' , '4' ,
'2.50' , '2.5' , '0' , '50' , '6.25' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '2' , '2' , '4' ,
'4.50' , '4.5' , '0' , '50' , '4.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '5' , '5' , '4' ,
'2.50' , '2.5' , '0' , '50' , '6.25' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '1' , '1' , '4' ,
'2.50' , '2.5' , '0' , '50' , '1.25' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '6' , '6' , '4' ,
'2.00' , '2' , '0' , '50' , '6.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '20721' , 'AVE MARIA - L. CALABRETTA' , '2' , '2' , '4' ,
'4.50' , '4.5' , '0' , '50' , '4.50' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '5' , '5' , '4' ,
'4.50' , '4.5' , '0' , '50' , '11.25' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '4' , '4' , '4' ,
'2.50' , '2.5' , '0' , '50' , '5.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '1' , '4' ,
'20.00' , '20' , '0' , '50' , '10.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '8' , '8' , '4' ,
'2.50' , '2.5' , '0' , '50' , '10.00' )
05/11/2024 05:23:44 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94059' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '1' , '4' ,
'3.00' , '3' , '0' , '50' , '1.50' )
05/11/2024 05:23: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
( '94059' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '4' , '4' , '4' ,
'2.50' , '2.5' , '0' , '50' , '5.00' )
05/11/2024 05:23: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
( '94059' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '2' , '2' , '4' ,
'2.00' , '2' , '0' , '50' , '2.00' )
05/11/2024 05:23: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
( '94059' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '2' , '2' , '4' ,
'2.00' , '2' , '0' , '50' , '2.00' )
05/11/2024 05:23: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
( '94059' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '2' , '2' , '4' ,
'8.00' , '8' , '0' , '50' , '8.00' )
05/11/2024 05:23: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
( '94059' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '2' , '2' , '4' ,
'10.00' , '10' , '0' , '50' , '10.00' )
05/11/2024 05:23: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
( '94059' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '5' , '5' , '4' ,
'2.50' , '2.5' , '0' , '50' , '6.25' )
05/11/2024 05:23: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
( '94059' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '4' , '4' , '4' ,
'8.00' , '8' , '0' , '50' , '16.00' )
05/11/2024 05:23: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
( '94059' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '1' , '4' ,
'2.80' , '2.8' , '0' , '50' , '1.40' )
05/11/2024 05:23: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
( '94059' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '6' , '6' , '4' ,
'2.80' , '2.8' , '0' , '50' , '8.40' )
05/11/2024 05:23: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
( '94059' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '12' , '12' , '4' ,
'2.50' , '2.5' , '0' , '50' , '15.00' )
05/11/2024 05:23: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
( '94059' , '22151' , 'MA DIO LO HA RISUSCITATO' , '2' , '2' , '4' ,
'10.00' , '10' , '0' , '50' , '10.00' )
05/11/2024 05:23: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
( '94059' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '1' , '1' , '4' ,
'6.00' , '6' , '0' , '50' , '3.00' )
05/11/2024 05:23: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
( '94059' , '22152' , 'A TE RICORRIAMO' , '13' , '13' , '4' ,
'3.00' , '3' , '0' , '50' , '19.50' )
05/11/2024 06:03:01 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3335' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 06:03: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 (
'11' ,
'3335' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'9.50' ,
'9.50' ,
NOW() ,
NOW() )
05/11/2024 06:03: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 = '94060'
05/11/2024 06:03:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94060'
05/11/2024 06:03: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
( '94060' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
05/11/2024 06:03: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
( '94060' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' ,
'5.00' , '5' , '0' , '5' , '4.75' )
05/11/2024 06:16:23 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3336' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 06:16:23 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' ,
'3336' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'190.00' ,
'179.78' ,
NOW() ,
NOW() )
05/11/2024 06:16:23 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 = '94061'
05/11/2024 06:16:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '94061'
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' ,
'11.68' , '9.5737704918033' , '22' , '0' , '11.68' )
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '21137' , 'MOCCOLO 70X200' , '6' , '-6' , '1' ,
'7.50' , '6.1475409836066' , '22' , '0' , '45.00' )
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '-1' , '4' ,
'19.50' , '19.5' , '0' , '5' , '18.53' )
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '23134' , 'AVVENTO E NATALE 2024/25' , '1' , '-1' , '4' ,
'2.90' , '2.9' , '0' , '5' , '2.76' )
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '23157' , 'ASPETTIAMO CON GIOIA IL NATALE' , '1' , '-1' , '4' ,
'2.50' , '2.5' , '0' , '5' , '2.38' )
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '23143' , 'CATECHISTI DI SPERANZA - F. VANNOTTI' , '1' , '-1' , '4' ,
'7.90' , '7.9' , '0' , '5' , '7.51' )
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '22276' , 'VITA IN DIO - M. ZANOTTI' , '1' , '-1' , '4' ,
'15.50' , '15.5' , '0' , '5' , '14.73' )
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '23106' , 'DILEXIT NOS' , '2' , '-2' , '4' ,
'3.50' , '3.5' , '0' , '5' , '6.66' )
05/11/2024 06:16:23 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94061' , '7164' , 'NUOVO DIZIONARIO DI MISTICA' , '1' , '-1' , '4' ,
'85.00' , '85' , '0' , '5' , '80.75' )
05/11/2024 06:23:55 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 06:23:55 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' ,
'3337' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'4.30' ,
'4.13' ,
NOW() ,
NOW() )
05/11/2024 06:23:55 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 = '94062'
05/11/2024 06:23:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '94062'
05/11/2024 06:23:55 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94062' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' ,
'4.30' , '4.1346153846154' , '4' , '0' , '4.30' )
05/11/2024 06:30: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 (
'32' ,
'2321' ,
'2024-10-31' ,
'' ,
'0' ,
'47' ,
'2642' ,
'V.LE BACCHIGLIONE, 20 20139 MILANO' ,
'' ,
'' ,
'5.63' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'132.26' ,
'132.26' ,
NOW() ,
NOW() )
05/11/2024 06:30: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 = '94063'
05/11/2024 06:30:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '94063'
05/11/2024 06:30: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
( '94063' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '3' , '0' , '4' ,
'16.0000' , '16' , '0' , '30' , '33.60' )
05/11/2024 06:30:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22956' AND id_supplier = '47'
05/11/2024 06:30:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22956' , '47' , '1' )
05/11/2024 06:30: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
( '94063' , '7221' , 'OLTRE IL RELATIVISMO - F. CORALLUZZO' , '2' , '0' , '4' ,
'20.0000' , '20' , '0' , '30' , '28.00' )
05/11/2024 06:30:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7221' AND id_supplier = '47'
05/11/2024 06:30:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7221' , '47' , '1' )
05/11/2024 06:30: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
( '94063' , '23112' , 'CONOSCI TE STESSO - C. AMIRANTE' , '2' , '0' , '4' ,
'12.9000' , '12.9' , '0' , '27' , '18.83' )
05/11/2024 06:30:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23112' AND id_supplier = '47'
05/11/2024 06:30:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23112' , '47' , '1' )
05/11/2024 06:30: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
( '94063' , '22762' , 'SAN CHARBEL IL MISTERO DEL CORPO INTATTO - P. CATTANEO' , '1' , '0' , '4' ,
'15.0000' , '15' , '0' , '30' , '10.50' )
05/11/2024 06:30:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22762' AND id_supplier = '47'
05/11/2024 06:30:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22762' , '47' , '1' )
05/11/2024 06:30: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
( '94063' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '3' , '0' , '4' ,
'17.0000' , '17' , '0' , '30' , '35.70' )
05/11/2024 06:30:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23005' AND id_supplier = '47'
05/11/2024 06:30:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23005' , '47' , '1' )
05/11/2024 06:46:39 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'32' ,
'6024237790' ,
'2024-10-31' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'100.89' ,
'100.89' ,
NOW() ,
NOW() )
05/11/2024 06:46:39 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 = '94064'
05/11/2024 06:46:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '94064'
05/11/2024 06:46: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
( '94064' , '22861' , 'E LA TUA PARTE 3 - 12/14 ANNI' , '1' , '0' , '4' ,
'12.7' , '12.7' , '0' , '0' , '12.7000' )
05/11/2024 06:46:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22861' AND id_supplier = '109'
05/11/2024 06:46:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22861' , '109' , '1' )
05/11/2024 06:46: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
( '94064' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' ,
'14.18' , '14.18' , '0' , '0' , '14.1800' )
05/11/2024 06:46:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109'
05/11/2024 06:46:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' )
05/11/2024 06:46: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
( '94064' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' ,
'14.18' , '14.18' , '0' , '0' , '14.1800' )
05/11/2024 06:46:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109'
05/11/2024 06:46:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' )
05/11/2024 06:46: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
( '94064' , '23044' , 'NUOVA STORIA DELLA PEDAGOGIA - F. DE GIORGI' , '1' , '0' , '4' ,
'21.94' , '21.94' , '0' , '0' , '21.9400' )
05/11/2024 06:46:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23044' AND id_supplier = '109'
05/11/2024 06:46:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23044' , '109' , '1' )
05/11/2024 06:46: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
( '94064' , '22985' , 'CHE PESCI PIGLIARE ' , '1' , '0' , '4' ,
'9.085' , '9.085' , '0' , '0' , '9.0850' )
05/11/2024 06:46:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22985' AND id_supplier = '109'
05/11/2024 06:46:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22985' , '109' , '1' )
05/11/2024 06:46: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
( '94064' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '0' , '4' ,
'10.08' , '10.08' , '0' , '0' , '10.0800' )
05/11/2024 06:46:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109'
05/11/2024 06:46:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' )
05/11/2024 06:46: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
( '94064' , '22187' , 'SETTE SACRAMENTI CREATIVI - A. QUEIROLO' , '1' , '0' , '4' ,
'8.64' , '8.64' , '0' , '0' , '8.6400' )
05/11/2024 06:46:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22187' AND id_supplier = '109'
05/11/2024 06:46:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22187' , '109' , '1' )
05/11/2024 06:46: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
( '94064' , '21554' , 'CATECHESI CREATIVA 2 - A. QUEIROLO' , '1' , '0' , '4' ,
'10.08' , '10.08' , '0' , '0' , '10.0800' )
05/11/2024 06:46:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21554' AND id_supplier = '109'
05/11/2024 06:46:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21554' , '109' , '1' )
05/11/2024 06:49:21 pm >> SELECT document_num FROM ps_document
WHERE document_num = '210' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 06:49: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 (
'21' ,
'210' ,
'2024-11-05' ,
'' ,
'3541' ,
'0' ,
'4677359' ,
'CORSO DELLA REPUBBLICA 29 00060 CANALE MONTERANO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'3' ,
'0' ,
'333.03' ,
'333.03' ,
NOW() ,
NOW() )
05/11/2024 06:49: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 = '94065'
05/11/2024 06:49:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '94065'
05/11/2024 06:49: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
( '94065' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' ,
'3.80' , '3.8' , '0' , '15' , '64.60' )
05/11/2024 06:49: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
( '94065' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' ,
'10.00' , '10' , '0' , '15' , '17.00' )
05/11/2024 06:49: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
( '94065' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' ,
'3.80' , '3.8' , '0' , '15' , '64.60' )
05/11/2024 06:49: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
( '94065' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '4' , '-4' , '4' ,
'10.00' , '10' , '0' , '15' , '34.00' )
05/11/2024 06:49: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
( '94065' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '21' , '-21' , '4' ,
'3.80' , '3.8' , '0' , '15' , '67.83' )
05/11/2024 06:49: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
( '94065' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' ,
'10.00' , '10' , '0' , '15' , '25.50' )
05/11/2024 06:49: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
( '94065' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '25' , '-25' , '4' ,
'2.80' , '2.8' , '0' , '15' , '59.50' )
05/11/2024 06:56:13 pm >> UPDATE ps_document SET
id_document_type = '32',
document_num = '6024237790',
document_date = '2024-10-31',
document_letter = '',
id_customer = '0',
id_supplier = '',
id_address = '4669106',
address1 = 'VIA G. VERDI, 8 20090 ASSAGO',
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 = '145.17',
price_tax_excluded = '145.17',
date_upd = NOW()
WHERE id_document = '94064'
05/11/2024 06:56: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 = '94064'
05/11/2024 06:56:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '94064'
05/11/2024 06:56: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
( '94064' , '22861' , 'E LA TUA PARTE 3 - 12/14 ANNI' , '1' , '0' , '4' ,
'12.7000' , '12.7' , '0' , '0' , '12.70' )
05/11/2024 06:56: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
( '94064' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' ,
'14.1800' , '14.18' , '0' , '0' , '14.18' )
05/11/2024 06:56: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
( '94064' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' ,
'14.1800' , '14.18' , '0' , '0' , '14.18' )
05/11/2024 06:56: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
( '94064' , '23044' , 'NUOVA STORIA DELLA PEDAGOGIA - F. DE GIORGI' , '1' , '0' , '4' ,
'21.9400' , '21.94' , '0' , '0' , '21.94' )
05/11/2024 06:56: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
( '94064' , '22985' , 'CHE PESCI PIGLIARE ' , '2' , '0' , '4' ,
'8.855' , '8.855' , '0' , '0' , '17.7100' )
05/11/2024 06:56: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
( '94064' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '0' , '4' ,
'10.0800' , '10.08' , '0' , '0' , '10.08' )
05/11/2024 06:56: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
( '94064' , '22187' , 'SETTE SACRAMENTI CREATIVI - A. QUEIROLO' , '1' , '0' , '4' ,
'8.6400' , '8.64' , '0' , '0' , '8.64' )
05/11/2024 06:56: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
( '94064' , '21554' , 'CATECHESI CREATIVA 2 - A. QUEIROLO' , '1' , '0' , '4' ,
'10.0800' , '10.08' , '0' , '0' , '10.08' )
05/11/2024 06:56: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
( '94064' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' ,
'14.18' , '14.18' , '0' , '0' , '14.1800' )
05/11/2024 06:56: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
( '94064' , '23114' , 'SII TENERO SII CORAGGIOSO - PAPA FRANCESCO' , '1' , '0' , '4' ,
'7.3' , '7.3' , '0' , '0' , '7.3000' )
05/11/2024 06:56: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
( '94064' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' ,
'14.18' , '14.18' , '0' , '0' , '14.1800' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document (
id_document_type ,
document_num ,
document_date ,
document_letter ,
id_customer ,
id_supplier ,
id_address ,
address1 ,
address2 ,
note ,
price_shipping ,
id_tax_shipping_rules ,
colli ,
peso ,
porto_e_imballo ,
mezzo_consegna ,
id_payment ,
id_causal ,
price_tax_included ,
price_tax_excluded ,
date_add ,
date_upd
) VALUES (
'32' ,
'6024237791' ,
'2024-10-31' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'124.35' ,
'124.35' ,
NOW() ,
NOW() )
05/11/2024 07:01:25 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 = '94066'
05/11/2024 07:01:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '94066'
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '0' , '4' ,
'13.7' , '13.7' , '0' , '0' , '13.7000' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16205' AND id_supplier = '109'
05/11/2024 07:01:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16205' , '109' , '1' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '0' , '4' ,
'13.7' , '13.7' , '0' , '0' , '13.7000' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16204' AND id_supplier = '109'
05/11/2024 07:01:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16204' , '109' , '1' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '0' , '4' ,
'14.05' , '14.05' , '0' , '0' , '14.0500' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17413' AND id_supplier = '109'
05/11/2024 07:01:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17413' , '109' , '1' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '0' , '4' ,
'14.05' , '14.05' , '0' , '0' , '14.0500' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17413' AND id_supplier = '109'
05/11/2024 07:01:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17413' , '109' , '1' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '0' , '4' ,
'13.7' , '13.7' , '0' , '0' , '13.7000' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16204' AND id_supplier = '109'
05/11/2024 07:01:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16204' , '109' , '1' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '0' , '4' ,
'13.7' , '13.7' , '0' , '0' , '13.7000' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16205' AND id_supplier = '109'
05/11/2024 07:01:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16205' , '109' , '1' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '0' , '4' ,
'13.7' , '13.7' , '0' , '0' , '13.7000' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16204' AND id_supplier = '109'
05/11/2024 07:01:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16204' , '109' , '1' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '0' , '4' ,
'13.7' , '13.7' , '0' , '0' , '13.7000' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16205' AND id_supplier = '109'
05/11/2024 07:01:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16205' , '109' , '1' )
05/11/2024 07:01:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94066' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '0' , '4' ,
'14.05' , '14.05' , '0' , '0' , '14.0500' )
05/11/2024 07:01:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17413' AND id_supplier = '109'
05/11/2024 07:01:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17413' , '109' , '1' )
05/11/2024 07:08: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 (
'32' ,
'6024237792' ,
'2024-10-31' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'149.39' ,
'149.39' ,
NOW() ,
NOW() )
05/11/2024 07:08: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 = '94067'
05/11/2024 07:08:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94067'
05/11/2024 07:08: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
( '94067' , '23073' , 'COME MUORE UN REGIME' , '1' , '0' , '4' ,
'15.76' , '15.76' , '0' , '0' , '15.7600' )
05/11/2024 07:08:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23073' AND id_supplier = '109'
05/11/2024 07:08:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23073' , '109' , '1' )
05/11/2024 07:08: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
( '94067' , '23077' , 'ANDREOTTI' , '1' , '0' , '4' ,
'17.65' , '17.65' , '0' , '0' , '17.6500' )
05/11/2024 07:08:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23077' AND id_supplier = '109'
05/11/2024 07:08:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23077' , '109' , '1' )
05/11/2024 07:08: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
( '94067' , '23076' , 'DALLA DEMOCRAZIA INCOMPIUTA' , '1' , '0' , '4' ,
'23.96' , '23.96' , '0' , '0' , '23.9600' )
05/11/2024 07:08:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23076' AND id_supplier = '109'
05/11/2024 07:08:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23076' , '109' , '1' )
05/11/2024 07:08: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
( '94067' , '23078' , 'DELITTO MATTEOTTI' , '1' , '0' , '4' ,
'16.39' , '16.39' , '0' , '0' , '16.3900' )
05/11/2024 07:08:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23078' AND id_supplier = '109'
05/11/2024 07:08:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23078' , '109' , '1' )
05/11/2024 07:08: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
( '94067' , '23074' , '1968 UN ANNO' , '1' , '0' , '4' ,
'13.86' , '13.86' , '0' , '0' , '13.8600' )
05/11/2024 07:08:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23074' AND id_supplier = '109'
05/11/2024 07:08:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23074' , '109' , '1' )
05/11/2024 07:08: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
( '94067' , '23075' , 'ITALIA DELLA SVOLTA' , '1' , '0' , '4' ,
'11.97' , '11.97' , '0' , '0' , '11.9700' )
05/11/2024 07:08:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23075' AND id_supplier = '109'
05/11/2024 07:08:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23075' , '109' , '1' )
05/11/2024 07:08: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
( '94067' , '23080' , 'ALDO MORO' , '1' , '0' , '4' ,
'10.09' , '10.09' , '0' , '0' , '10.0900' )
05/11/2024 07:08:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23080' AND id_supplier = '109'
05/11/2024 07:08:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23080' , '109' , '1' )
05/11/2024 07:08:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94067' , '23078' , 'DELITTO MATTEOTTI' , '1' , '0' , '4' ,
'16.39' , '16.39' , '0' , '0' , '16.3900' )
05/11/2024 07:08:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23078' AND id_supplier = '109'
05/11/2024 07:08:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23078' , '109' , '1' )
05/11/2024 07:08:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94067' , '23115' , 'ALDO MORO' , '1' , '0' , '4' ,
'11.35' , '11.35' , '0' , '0' , '11.3500' )
05/11/2024 07:08:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23115' AND id_supplier = '109'
05/11/2024 07:08:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23115' , '109' , '1' )
05/11/2024 07:08:08 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94067' , '21403' , 'DE GASPERI' , '1' , '0' , '4' ,
'11.97' , '11.97' , '0' , '0' , '11.9700' )
05/11/2024 07:08:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21403' AND id_supplier = '109'
05/11/2024 07:08:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21403' , '109' , '1' )
05/11/2024 07:18: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 (
'32' ,
'6024237789' ,
'2024-10-31' ,
'' ,
'0' ,
'109' ,
'4669106' ,
'VIA G. VERDI, 8 20090 ASSAGO' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'51.89' ,
'49.95' ,
NOW() ,
NOW() )
05/11/2024 07:18: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 = '94068'
05/11/2024 07:18:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '94068'
05/11/2024 07:18: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
( '94068' , '23042' , 'PADRE NOSTRO - J. ZUMSTEIN' , '1' , '0' , '4' ,
'6.36' , '6.36' , '0' , '0' , '6.3600' )
05/11/2024 07:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23042' AND id_supplier = '109'
05/11/2024 07:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23042' , '109' , '1' )
05/11/2024 07:18: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
( '94068' , '23043' , 'PREGHIAMO CON MARIA' , '3' , '0' , '4' ,
'8.01' , '8.01' , '0' , '0' , '24.0300' )
05/11/2024 07:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23043' AND id_supplier = '109'
05/11/2024 07:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23043' , '109' , '1' )
05/11/2024 07:18: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
( '94068' , '23079' , 'JOHN HENRY NEWMAN' , '1' , '0' , '4' ,
'10.72' , '10.72' , '0' , '0' , '10.7200' )
05/11/2024 07:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23079' AND id_supplier = '109'
05/11/2024 07:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23079' , '109' , '1' )
05/11/2024 07:18: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
( '94068' , '23116' , 'CALENDARIO LE VALLI VALDESI 2025' , '1' , '0' , '1' ,
'8.84' , '7.2459016393443' , '22' , '0' , '10.7848' )
05/11/2024 07:18:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23116' AND id_supplier = '109'
05/11/2024 07:18:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23116' , '109' , '1' )
05/11/2024 07:30:25 pm >> SELECT document_num FROM ps_document
WHERE document_num = '3338' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-05')
05/11/2024 07:30:25 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' ,
'3338' ,
'2024-11-05' ,
'' ,
'0' ,
'0' ,
'0' ,
'' ,
'' ,
'' ,
'0' ,
'4' ,
'0' ,
'0' ,
'0' ,
'' ,
'0' ,
'0' ,
'140.75' ,
'139.22' ,
NOW() ,
NOW() )
05/11/2024 07:30:25 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 = '94069'
05/11/2024 07:30:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '94069'
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '22875' , 'AMEN - DIC 24' , '3' , '-3' , '4' ,
'3.90' , '3.9' , '0' , '5' , '11.13' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' ,
'3.90' , '3.9' , '0' , '5' , '3.71' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '5' , '3.33' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' ,
'3.40' , '3.4' , '0' , '5' , '3.23' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' ,
'3.40' , '3.4' , '0' , '5' , '3.23' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' ,
'3.50' , '3.5' , '0' , '5' , '3.33' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '5659' , 'LEGGO E GIOCO CON LA BIBBIA' , '1' , '-1' , '4' ,
'12.50' , '12.5' , '0' , '5' , '11.88' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '-1' , '4' ,
'10.00' , '10' , '0' , '5' , '9.50' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '1738' , 'CARTINE CATECHISTICHE' , '1' , '-1' , '1' ,
'8.90' , '7.2950819672131' , '22' , '5' , '8.46' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '5' , '8.55' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '5' , '8.55' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' ,
'9.00' , '9' , '0' , '5' , '8.55' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '22230' , 'GIOCHIAMO CON LA BIBBIA' , '1' , '-1' , '4' ,
'12.90' , '12.9' , '0' , '5' , '12.26' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '15722' , 'BIBBIA DEI PICCOLI' , '1' , '-1' , '4' ,
'12.00' , '12' , '0' , '5' , '11.40' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '12720' , 'VANGELO PER TUTTO LANNO' , '1' , '-1' , '4' ,
'8.50' , '8.5' , '0' , '5' , '8.08' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '12718' , 'VITA DI GESU ' , '1' , '-1' , '4' ,
'8.90' , '8.9' , '0' , '5' , '8.46' )
05/11/2024 07:30:25 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '4534' , 'GIOCA E COLORA - IO SONO I' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '5' , '3.80' )
05/11/2024 07:30:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '4536' , 'GIOCA E COLORA - VENITE I' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '5' , '3.80' )
05/11/2024 07:30:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '4537' , 'GIOCA E COLORA - VENITE II' , '1' , '-1' , '4' ,
'4.00' , '4' , '0' , '5' , '3.80' )
05/11/2024 07:30:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )
05/11/2024 07:30:26 pm >> INSERT INTO ps_document_detail
( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
price_tax_included , price_tax_excluded , tax , discount , price_total )
VALUES
( '94069' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '1' , '-1' , '4' ,
'3.00' , '3' , '0' , '5' , '2.85' )