IstheCITY is all about connecting you to businesses, organizations, business professionals, and influencers with out all the clutter.
Browse, Interact, Network, and Promote what you do. Get started now by Signing Up or Login to your account.
SELECT media.image as media_featured, media.ext, media.video_site, media.video_id,
profile.username, products.* FROM products
LEFT JOIN media ON products.media_featured_id=media.id
LEFT JOIN profile ON products.uuid=profile.uuid
WHERE products.publish='1' AND products.delete_me=0 AND
products.date_created >='2022-07-04 00:00:00' AND
products.date_created <'2022-07-05 00:00:00'