Meaning of tA tC and tP
Posted
by
Greg Wiley
on Stack Overflow
See other posts from Stack Overflow
or by Greg Wiley
Published on 2012-08-31T15:31:38Z
Indexed on
2012/08/31
15:38 UTC
Read the original article
Hit count: 261
If this is a duplicate I appoligize, but looking for two-letter strings is quite hard in any search.
I'm looking for the meaning of tA
tC
and tP
in the context of a mysql query. And in the spirit of "teaching a man how to fish" it would be great if you could point me in the right direction of where to find this info in the future.
Edit: The Query
$wpdb->get_row($wpdb->prepare("SELECT tA.* FROM ".AMYLITE_ADS." tA,
".AMYLITE_ADS_CAMPAIGNS." tC, ".AMYLITE_PACKAGES." tP
WHERE tA.id=tC.ad_id AND tC.campaign_id=tP.campaign_id AND tP.zone_id=%d
AND tP.date_end>CURDATE()
GROUP BY tA.id ORDER BY RAND()", $zone->id));
© Stack Overflow or respective owner