| 0.0003 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT nama_website FROM identitas ORDER BY id_identitas DESC LIMIT 1
|
| 0.0003 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT meta_deskripsi FROM identitas ORDER BY id_identitas DESC LIMIT 1
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT meta_deskripsi FROM identitas ORDER BY id_identitas DESC LIMIT 1
|
| 0.0001 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT meta_keyword FROM identitas ORDER BY id_identitas DESC LIMIT 1
|
| 0.0008 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT tc.*, (SELECT concat(kanal_name, '|', surel) FROM t_kanal tk WHERE tk.id = tc.id_kanal LIMIT 1) AS kanal, (SELECT concat(site_name, '|', url) FROM t_site ts WHERE ts.id_site = tc.site_id LIMIT 1) AS main_site, pub.fullname AS publisher FROM `t_content` `tc` LEFT JOIN `t_users` `pub` ON `pub`.`username` = `tc`.`publisher` WHERE `tc`.`publish` = 'Y' AND `tc`.`hapus` = 'N' AND `tc`.`id` = 5916 AND `tc`.`url_seo` = 'ini__cara_cepat_menghilangkan_bau_mulut_saat_puasa' AND tc.publish_date <= NOW() ORDER BY `tc`.`publish_date` DESC LIMIT 1
|
| 0.0012 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT tc.*, CONCAT(tk.kanal_name, '|', tk.surel) AS kanal, CONCAT(ts.site_name, '|', ts.url) AS main_site FROM `t_content` `tc` LEFT JOIN `t_kanal` `tk` ON `tk`.`id` = `tc`.`id_kanal` LEFT JOIN `t_site` `ts` ON `ts`.`id_site` = `tc`.`site_id` WHERE `tc`.`publish` = 'Y' AND `tc`.`headline` = 'Y' AND `tc`.`hapus` = 'N' AND `tc`.`site_id` = 1 AND `tc`.`publish_date` <= '2026-06-06 01:16:20' ORDER BY `tc`.`publish_date` DESC LIMIT 5
|
| 0.0007 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT tc.*, CONCAT(tk.kanal_name, '|', tk.surel) AS kanal, CONCAT(ts.site_name, '|', ts.url) AS main_site FROM `t_content` `tc` LEFT JOIN `t_kanal` `tk` ON `tk`.`id` = `tc`.`id_kanal` LEFT JOIN `t_site` `ts` ON `ts`.`id_site` = `tc`.`site_id` WHERE tc.publish_date <= NOW() AND `tc`.`publish` = 'Y' AND `tc`.`hapus` = 'N' ORDER BY `tc`.`publish_date` DESC LIMIT 6
|
| 0.0010 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT tc.*, CONCAT(tk.kanal_name, '|', tk.surel) AS kanal, CONCAT(ts.site_name, '|', ts.url) AS main_site, (tc.m + tc.d) AS total_popular FROM `t_content` `tc` LEFT JOIN `t_kanal` `tk` ON `tk`.`id` = `tc`.`id_kanal` LEFT JOIN `t_site` `ts` ON `ts`.`id_site` = `tc`.`site_id` WHERE `tc`.`publish` = 'Y' AND `tc`.`hapus` = 'N' AND tc.publish_date >= DATE_SUB(NOW(), INTERVAL 2 DAY) ORDER BY `total_popular` DESC LIMIT 5
|
| 0.0007 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.id_kanal = 68
AND tc.site_id = 1
ORDER BY tc.publish_date DESC
LIMIT 0, 1
|
| 0.0005 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.id_kanal = 90
AND tc.site_id = 1
ORDER BY tc.publish_date DESC
LIMIT 0, 1
|
| 0.0005 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.id_kanal = 88
AND tc.site_id = 1
ORDER BY tc.publish_date DESC
LIMIT 0, 1
|
| 0.0006 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.id_kanal = 64
AND tc.site_id = 1
ORDER BY tc.publish_date DESC
LIMIT 0, 6
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT * FROM video ORDER BY id_video DESC LIMIT 0, 1
|
| 0.0006 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.id_kanal = 65
AND tc.site_id = 1
ORDER BY tc.publish_date DESC
LIMIT 0, 5
|
| 0.0010 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT tc.*, CONCAT(tk.kanal_name, '|', tk.surel) AS kanal, CONCAT(ts.site_name, '|', ts.url) AS main_site FROM `t_content` `tc` LEFT JOIN `t_kanal` `tk` ON `tk`.`id` = `tc`.`id_kanal` LEFT JOIN `t_site` `ts` ON `ts`.`id_site` = `tc`.`site_id` WHERE `tc`.`publish` = 'Y' AND `tc`.`hapus` = 'N' AND `tc`.`site_id` = 1 AND `tc`.`id` <> 5916 AND `tc`.`id_kanal` = 65 AND tc.publish_date <= NOW() AND LOWER(tc.tag) LIKE '%lifestyle%' ESCAPE '!' ORDER BY `tc`.`publish_date` DESC LIMIT 4
|
| 0.0060 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT tc.*, CONCAT(tk.kanal_name, '|', tk.surel) AS kanal, CONCAT(ts.site_name, '|', ts.url) AS main_site FROM `t_content` `tc` LEFT JOIN `t_kanal` `tk` ON `tk`.`id` = `tc`.`id_kanal` LEFT JOIN `t_site` `ts` ON `ts`.`id_site` = `tc`.`site_id` WHERE `tc`.`publish` = 'Y' AND `tc`.`hapus` = 'N' AND `tc`.`site_id` = 1 AND `tc`.`id` <> 5916 AND `tc`.`id_kanal` = 65 AND tc.publish_date <= NOW() AND LOWER(tc.tag) LIKE '%bau mulut%' ESCAPE '!' ORDER BY `tc`.`publish_date` DESC LIMIT 4
|
| 0.0013 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT tc.*, CONCAT(tk.kanal_name, '|', tk.surel) AS kanal, CONCAT(ts.site_name, '|', ts.url) AS main_site FROM `t_content` `tc` LEFT JOIN `t_kanal` `tk` ON `tk`.`id` = `tc`.`id_kanal` LEFT JOIN `t_site` `ts` ON `ts`.`id_site` = `tc`.`site_id` WHERE `tc`.`publish` = 'Y' AND `tc`.`hapus` = 'N' AND `tc`.`site_id` = 1 AND `tc`.`id` <> 5916 AND `tc`.`id_kanal` = 65 AND tc.publish_date <= NOW() AND LOWER(tc.tag) LIKE '%puasa%' ESCAPE '!' ORDER BY `tc`.`publish_date` DESC LIMIT 4
|
| 0.0010 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */
INSERT INTO t_content_counter (content_id, d)
VALUES (5916, 1)
ON DUPLICATE KEY UPDATE d = d + 1
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT folder FROM templates where aktif='Y'
|
| 0.0004 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT folder FROM templates where aktif='Y'
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT folder FROM templates where aktif='Y'
|
| 0.0003 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='home' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='64' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='65' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='68' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='297' AND id_site=1 order by short ASC
|
| 0.0003 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='home' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='64' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='65' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='68' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='297' AND id_site=1 order by short ASC
|
| 0.0001 |
<?php /* Authors : initappz (Rahul Jograna) Website : https://initappz.com/ App Name : ionic 5 groceryee app Created : 10-Sep-2020 This App Template Source code is licensed as per the terms found in the Website https://initappz.com/license Copyright and Good Faith Purchasers © 2020-present initappz. */ SELECT folder FROM templates where aktif='Y'
|