SELECT tbl_classifieds.id, accountid, tbl_accounts.name, tbl_classifieds.date, email, tbl_subcategory.categoryid AS categoryid, tbl_subcategory.id AS subcategoryid, tbl_category.name AS categoryname, tbl_subcategory.name AS subcategoryname FROM tbl_classifieds INNER JOIN tbl_subcategory ON tbl_subcategory.id = tbl_classifieds.subcategoryid INNER JOIN tbl_category ON tbl_category.id = tbl_subcategory.categoryid INNER JOIN tbl_accounts ON tbl_accounts.id = tbl_classifieds.accountid WHERE invoicedataid='0' AND free='0' AND reminderemails='0' AND tbl_classifieds.date='2024-04-23';
|