Login to ZARP

TOPIC: Pie_'s Q and A

Pie_'s Q and A 3 years 10 months ago #1306483

I'm really bored in class, feel free to ask anything	Pie_ Offline Legendary Member Lewis Abdul Hajar Posts: 1419 Thanks received: 655 Karma: 37
Teamspeak/Discord Head Administrator SSRP Head Administrator Rat Sandwich Enjoyer Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306485

DO YOUR WORK	Kronen Offline User is blocked Posts: 1825 Thanks received: 530 Karma: -101
Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306487

Kronen wrote: DO YOUR WORK Sorry, active electrolysis is boring	Pie_ Offline Legendary Member Lewis Abdul Hajar Posts: 1419 Thanks received: 655 Karma: 37
Teamspeak/Discord Head Administrator SSRP Head Administrator Rat Sandwich Enjoyer Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306489

Do you undertand this below

SELECT c.conversion_id, ci.conversion_item_id, ci.item_status, FROM_UNIXTIME(c.conversion_time)
FROM inputDB.conversion c
JOIN inputDB.conversion_item ci ON ci.conversion_id = c.conversion_id
WHERE c.campaign_id = '(Number)'
AND c.conversion_time BETWEEN UNIX_TIMESTAMP('2020-02-01') AND UNIX_TIMESTAMP('2020-03-01')-1
AND ci.item_status IN (SELECT conversion_status_id FROM userDB.conversion_status WHERE display_as = 'rejected')

(Number would be a client id but for gdpr i can't give that out)

Joshua
Offline
Former Community Manager
Posts: 1614
Thanks received: 543
Karma: 156

Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306490

Joshua. wrote:

Do you undertand this below

SELECT c.conversion_id, ci.conversion_item_id, ci.item_status, FROM_UNIXTIME(c.conversion_time)
FROM inputDB.conversion c
JOIN inputDB.conversion_item ci ON ci.conversion_id = c.conversion_id
WHERE c.campaign_id = '(Number)'
AND c.conversion_time BETWEEN UNIX_TIMESTAMP('2020-02-01') AND UNIX_TIMESTAMP('2020-03-01')-1
AND ci.item_status IN (SELECT conversion_status_id FROM userDB.conversion_status WHERE display_as = 'rejected')

(Number would be a client id but for gdpr i can't give that out)

Of course i do

Pie_
Offline
Legendary Member
Lewis Abdul Hajar
Posts: 1419
Thanks received: 655
Karma: 37

Teamspeak/Discord Head Administrator

SSRP Head Administrator

Rat Sandwich Enjoyer

Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306492

Ali Aids Pietromj	menameisemil Offline Expert Boarder idk what to put here Posts: 1571 Thanks received: 625 Karma: 13
Former: SSRP Super Admin SSRP Section Mod Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306493

menameisemil wrote: Ali Aids Pietromj O_O	Pie_ Offline Legendary Member Lewis Abdul Hajar Posts: 1419 Thanks received: 655 Karma: 37
Teamspeak/Discord Head Administrator SSRP Head Administrator Rat Sandwich Enjoyer Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306494

Pie_ wrote: menameisemil wrote: Ali Aids Pietromj O_O	menameisemil Offline Expert Boarder idk what to put here Posts: 1571 Thanks received: 625 Karma: 13
Former: SSRP Super Admin SSRP Section Mod Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306495

menameisemil wrote: Pie_ wrote: menameisemil wrote: Ali Aids Pietromj O_O sorry	Pie_ Offline Legendary Member Lewis Abdul Hajar Posts: 1419 Thanks received: 655 Karma: 37
Teamspeak/Discord Head Administrator SSRP Head Administrator Rat Sandwich Enjoyer Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306496

Pie_ wrote: menameisemil wrote: Pie_ wrote: menameisemil wrote: Ali Aids Pietromj O_O sorry meme lewis?	Kronen Offline User is blocked Posts: 1825 Thanks received: 530 Karma: -101
Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306497

Kronen wrote: Pie_ wrote: menameisemil wrote: Pie_ wrote: menameisemil wrote: Ali Aids Pietromj O_O sorry meme lewis? fake	Pie_ Offline Legendary Member Lewis Abdul Hajar Posts: 1419 Thanks received: 655 Karma: 37
Teamspeak/Discord Head Administrator SSRP Head Administrator Rat Sandwich Enjoyer Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306503

Why the name Pie?	Jordz Offline Marvelous Boarder More Scottish than Aidan himself Posts: 10795 Thanks received: 2237 Karma: 129
Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306511

I used to be called Pietromj but nobody new how to pronounce it, (Pietro mj) so people just called me Pie and thats what everyone knew me by so i changed it to that	Pie_ Offline Legendary Member Lewis Abdul Hajar Posts: 1419 Thanks received: 655 Karma: 37
Teamspeak/Discord Head Administrator SSRP Head Administrator Rat Sandwich Enjoyer Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306513

Pie_ wrote: I used to be called Pietromj but nobody new how to pronounce it, (Pietro mj) so people just called me Pie and thats what everyone knew me by so i changed it to that shut up Lewis i called you ali	menameisemil Offline Expert Boarder idk what to put here Posts: 1571 Thanks received: 625 Karma: 13
Former: SSRP Super Admin SSRP Section Mod Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306516

menameisemil wrote: Pie_ wrote: I used to be called Pietromj but nobody new how to pronounce it, (Pietro mj) so people just called me Pie and thats what everyone knew me by so i changed it to that shut up Lewis i called you ali Ew Ali	Pie_ Offline Legendary Member Lewis Abdul Hajar Posts: 1419 Thanks received: 655 Karma: 37
Teamspeak/Discord Head Administrator SSRP Head Administrator Rat Sandwich Enjoyer Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306518

What are your future plans & aspirations?	narexa Offline Divine Boarder Posts: 8287 Thanks received: 4844 Karma: 252
Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306519

favourite walking dead character? (yes there is a correct answer to this)	maddox Offline Gold Boarder Ian foot Posts: 2416 Thanks received: 1294 Karma: -12
sky.lea \| youtube \| steam Discord: edward_adonis Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306525

Would you ever go to Scotland? Are you glad you got sa Why did you join zarp	Jordz Offline Marvelous Boarder More Scottish than Aidan himself Posts: 10795 Thanks received: 2237 Karma: 129
Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306558

Pie_ wrote: menameisemil wrote: Pie_ wrote: I used to be called Pietromj but nobody new how to pronounce it, (Pietro mj) so people just called me Pie and thats what everyone knew me by so i changed it to that shut up Lewis i called you ali Ew Ali	menameisemil Offline Expert Boarder idk what to put here Posts: 1571 Thanks received: 625 Karma: 13
Former: SSRP Super Admin SSRP Section Mod Login or register to post a reply.

Pie_'s Q and A 3 years 10 months ago #1306579

narexa wrote: What are your future plans & aspirations? After GCSE's and A levels are all sorted out im planning to join the royal navy at 18, I'll join as an electrical engineer or something along those lines. After that ill hopefully get a job in British Aerospace developing shit	Pie_ Offline Legendary Member Lewis Abdul Hajar Posts: 1419 Thanks received: 655 Karma: 37
Teamspeak/Discord Head Administrator SSRP Head Administrator Rat Sandwich Enjoyer Login or register to post a reply. The following user(s) said Thank You: narexa