Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Long SQL
INSERT INTO logtmpsegment6a6427377f16ed5fcf89262b3487e2a2 (idvisit)
SELECT
distinct log_visit.idvisit as idvisit
FROM
log_visit AS log_visit LEFT JOIN log_link_visit_action AS log_link_visit_action ON log_link_visit_action.idvisit = log_visit.idvisit
WHERE
( log_visit.visit_last_action_time >= '2021-11-13 08:00:00'
AND log_visit.visit_last_action_time <= '2021-11-14 07:59:59'
AND log_visit.idsite IN ('1') )
AND
( ( log_link_visit_action.idaction_url IN (SELECT idaction FROM log_action WHERE ( name LIKE CONCAT('%', 'src=11', '%') AND type = 1 )) ) AND log_visit.visitor_returning = '0' )
ORDER BY
log_visit.idvisit ASC
*****************************
Sending data INSERT INTO logtmpsegment4d0ca64e8782f83463b3817aa458186b (idvisit)
SELECT
distinct log_visit.idvisit as idvisit
FROM
log_visit AS log_visit LEFT JOIN log_link_visit_action AS log_link_visit_action ON log_link_visit_action.idvisit = log_visit.idvisit
WHERE
( log_visit.visit_last_action_time >= '2021-11-12 08:00:00'
AND log_visit.visit_last_action_time <= '2021-11-13 07:59:59'
AND log_visit.idsite IN ('1') )
AND
( log_visit.visitor_returning = '0' AND ( log_link_visit_action.idaction_url IN (SELECT idaction FROM log_action WHERE ( name LIKE CONCAT('%', 'src=11', '%') AND type = 1 )) ) )
ORDER BY
log_visit.idvisit ASC
***********************
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment