IT

Contenuti

Homepage / Guida / Contenuti
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=15 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<"2021-06-14 00:23:57") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2021-06-14")) 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=15 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<"2021-06-14 00:23:57") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2021-06-14")) 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';