Line Plan
Showing all 3 results
Notice: Undefined index: random</span><span id="code_end" class="sc"> in /home/cp883137/public_html/wp-content/plugins/ads-by-datafeedrcom/inc/dfads.class.php on line 164
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ASC
LIMIT 3' at line 38]
SELECT
p.*,
imp_count.meta_value AS ad_imp_count,
imp_limit.meta_value AS ad_imp_limit,
start_date.meta_value AS ad_start_date,
end_date.meta_value AS ad_end_date
FROM wp_posts p
LEFT JOIN wp_postmeta AS imp_limit
ON p.ID = imp_limit.post_id
AND imp_limit.meta_key = '_dfads_impression_limit'
LEFT JOIN wp_postmeta AS imp_count
ON p.ID = imp_count.post_id
AND imp_count.meta_key = '_dfads_impression_count'
LEFT JOIN wp_postmeta AS start_date
ON p.ID = start_date.post_id
AND start_date.meta_key = '_dfads_start_date'
LEFT JOIN wp_postmeta AS end_date
ON p.ID = end_date.post_id
AND end_date.meta_key = '_dfads_end_date'
WHERE p.post_status = 'publish'
AND p.post_type = 'dfads'
AND (
CAST(imp_limit.meta_value AS UNSIGNED) = 0
OR CAST(imp_count.meta_value AS UNSIGNED) < CAST(imp_limit.meta_value AS UNSIGNED)
OR CAST(imp_count.meta_value AS UNSIGNED) IS NULL
)
AND (
CAST(start_date.meta_value AS UNSIGNED) IS NULL
OR 1686017966 >= CAST(start_date.meta_value AS UNSIGNED)
)
AND (
CAST(end_date.meta_value AS UNSIGNED) IS NULL
OR 1686017966 <= CAST(end_date.meta_value AS UNSIGNED)
)
GROUP BY p.ID
ORDER BY ASC
LIMIT 3
YOU MIGHT ALSO LIKE