Le caratteristiche di NTool per l'Area Marketing

Error SQL!
Non riesco ad eseguire la query.
myDBcount();
Query: SELECT COUNT(*) FROM (SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE (IDdgroup=10 OR DgroupMaster LIKE "0,4,6,10" OR DgroupMaster LIKE "0,4,6,10,%") AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14)) AS C;;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBload();
Query: SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE (IDdgroup=10 OR DgroupMaster LIKE "0,4,6,10" OR DgroupMaster LIKE "0,4,6,10,%") AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14) GROUP BY IDst ORDER BY ItemDati DESC LIMIT 0, 30;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBcount();
Query: SELECT COUNT(*) FROM (SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=9 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14)) AS C;;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBload();
Query: SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=9 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14) GROUP BY IDst ORDER BY ItemDati DESC LIMIT 0, 30;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBcount();
Query: SELECT COUNT(*) FROM (SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=12 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14)) AS C;;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBload();
Query: SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=12 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14) GROUP BY IDst ORDER BY ItemDati DESC LIMIT 0, 30;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBcount();
Query: SELECT COUNT(*) FROM (SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=13 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14)) AS C;;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBload();
Query: SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=13 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14) GROUP BY IDst ORDER BY ItemDati DESC LIMIT 0, 20;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBcount();
Query: SELECT COUNT(*) FROM (SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=11 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14)) AS C;;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBload();
Query: SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=11 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2024-04-19 21:30:07") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-04-19")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14) GROUP BY IDst ORDER BY ItemDati DESC LIMIT 0, 20;
MySQL Error: Unknown column 'StDRew' in 'field list';