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=14 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-12-07 20:34:34") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-12-07")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=13)) 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=14 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-12-07 20:34:34") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2024-12-07")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=13) GROUP BY IDst ORDER BY ItemDati ASC LIMIT 0, 20;
MySQL Error: Unknown column 'StDRew' in 'field list';